[EMAIL PROTECTED] wrote:
Yes that is the statement I am using in my PERL script. Robert V Simmons
Can you run your script with DBI_TRACE set to a number >= 10 e.g. set DBI_TRACE=10=x.log myperlscript then send me the x.log file. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com
*Martin Evans <[EMAIL PROTECTED]>* 08/15/2007 03:31 AM To dbi-users <dbi-users@perl.org> cc Subject Re: DBI DBD-ODBC [EMAIL PROTECTED] wrote: > I created an MSACCESS Database on my Windows XP O/S, set up the System > Name in the DATA SOURCES panel associating the "Microsoft Access > Driver(*.mdb) with my database name (db1). I installed the DBI Module > and DBD-ODBC and I still get the following error when I run my PERL > script.. > > Could not make a connection to the database: [Microsoft][ODBC Microsoft > Access D > river]General error Not enough information to connect to this DSN with > SQLConnec> t. Use SQLDriverConnect. (SQL-HY000)(DBD: db_login/SQLConnect err=-1) at> C:\Do > cuments and Settings\O015181\Desktop\Edit1.pl line 8. > > > If anyone knows the reason for this error and how I can fix it, I would > appreciate it very much. I am sending this email as a last resort as I > have exhausted > all of my resources. > > Regards, > > Robert V Simmons > Did you use: DBI->connect('dbi:ODBC:mydsn'); or DBI->connect('dbi:ODBC:DSN=mydsn'); I would try the latter. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com ------------------------------------------------------------------------
