Re: DBI DBD-ODBC
- From: martin.evans@xxxxxxxxxxxx (Martin Evans)
- Date: Wed, 15 Aug 2007 14:30:39 +0100
robert.v.simmons@xxxxxxxxxxxx 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 <martin.evans@xxxxxxxxxxxx>*.
08/15/2007 03:31 AM
To
dbi-users <dbi-users@xxxxxxxx>
cc
Subject
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
------------------------------------------------------------------------
- References:
- Re: DBI DBD-ODBC
- From: Robert V Simmons
- Re: DBI DBD-ODBC
- Prev by Date: Re: DBI DBD-ODBC
- Next by Date: DBD::Sybase install issue
- Previous by thread: Re: DBI DBD-ODBC
- Next by thread: Multiple statements within one $dbh->do()
- Index(es):
Relevant Pages
|
|
