Re: DBI DBD-ODBC

robert.v.simmons@xxxxxxxxxxxx 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
.

Relevant Pages

  • Re: Access 2002 command line options.
    ... > database Opens the specified database. ... > /excl Opens the specified database for exclusive access. ... > /user user name Starts Microsoft Access using the specified user name. ... To compact to a different name, specify a target ...
    (microsoft.public.access.developers.toolkitode)
  • Re: Cant access code
    ... See http://www.QBuilt.com for all your database needs. ... See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. ... Create a new database file and import all objects except the corrupt form. ... If you have a recent backup, import this form from the backup and check ...
    (microsoft.public.access.modulesdaovba)
  • Re: Communication Log
    ... Tony Toews, Microsoft Access MVP ... May I send you copy of the database that I made? ... Dropdown box (I can select a value to store in the ... The above controls are set up in a page using te tab control. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Advice needed for a growing Access 2000 project
    ... However, it turned out that quite a few of those were "leftovers" from previous releases, no longer accessible from anywhere but the database window, and, thus, no longer used. ... But that certainly isn't the _norm_ -- without any 'heroic' measures, there are routine reports of split Access DBs ... Finally, in my opinion, for "Windows apps", that is, individual-user applications, modest-sized multiuser applications, and client-server applications of any size, Dot Net does NOT "help along" any of these issues. ... The post I reference was in reference its self to the MS Access Help file under "Microsoft Access database general specifications" ...
    (comp.databases.ms-access)
  • RE: error 3011-msaccess
    ... When you open a Microsoft Access version 1.x database in Microsoft Access ... following error message: ... The backquote character, which is ASCII ...
    (microsoft.public.access.gettingstarted)