Home: Perl Programming Help: DBI:
DBI and MS Access, basic questions



INS
New User

Aug 28, 2002, 7:58 PM


Views: 7052
DBI and MS Access, basic questions

I've started writting an app that will write and read data from a DB, via a web interface. Currently it is MS Access, I chose DBI in hopes that when/if this app grows I will easily migrate to SQL, Oracle, mySQL, etc.



The problem I fought for awhile was that if I had more than 12 colums in a table of the DB that the interface would lockup, when trying to write data to the DB. Is this just part of using Access, or can I expect this in the other DB's as well?



Having finally gotten data written to the DB I will now be writting the code to read, etc.


thebitch
User

Aug 28, 2002, 11:54 PM


Views: 7051
Re: [INS] DBI and MS Access, basic questions

This is not a basic question, and it's practically impossible
to answer.
I don't believe there is an issue with 12 columns,
as I have successfully used 12 columns
with DBI and Access, and I believe
that most likely this is a problem with your code,
or maybe you have a corrupt version of the
DBD driver, or even MSAccess.

Each DBD is its own entity, but generally
they work fine.


INS
New User

Aug 29, 2002, 5:44 AM


Views: 7048
Re: [thebitch] DBI and MS Access, basic questions

How is it practically impossible to answer?


Quote


I don't believe there is an issue with 12 columns,
as I have successfully used 12 columns
with DBI and Access,



Answered my question!

As far as it most likely being a problem with my code, It would not supprise me, as I will even mention I am still new to Perl.



Thank you for the response.

INS

aka Henry