UBB.Developers Forums Community Development Programming PHP and Server-side Scripting CGI & Databases

I wouldn't say I'm a complete beginner to Perl, I've made extensive changes to my UBB, but I still have some trouble getting my head round databases.

Does anyone know of a good tutorial site which explains, very simply, the code I need to add, delete, and query records in a SQL or Access database?

All I'm looking for is something very simple to get me started, then I can make some sense of the explanations in my book

Thanks for any help you can give me!



[ June 16, 2001 02:14 PM: Message edited by: SF Mara ]

Thanks!

OK, I've got the hang of it now, I think... but can anyone help me with this one more thing:

I have a Microsoft Access database on a Windows web server. I do not have physical access to the server to manually create ODBC connections. Is there ANY way I can use a CGI script to connect to the database without having to phone the server admin?

I've been working on it for 8 hours, and I can't get it to work...

Thanks for any help you can give me!

Is the CGI script running on the same server as Access?

Affirmative

If it's on the same sever, you should be able to install DBI and DBD::oDBC (or an Access specific one if there is one) and connect to the database, just like you would with MySQL

--mark

OK, I got it working, but after a lot of experimenting have run into a problem.

I cannot create tables with a large number of large fields.

For example, the command:


works, but


doesn't. I mean, it just doesn't create the table. No error message, nothing.

Is there some limit to the number of fields/size of fields that can be created in one table?