CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: Win32 Programming Help: Re: [wayko621] dbi error: Edit Log



fashimpaur
User

May 17, 2002, 8:18 AM


Views: 17943
Re: [wayko621] dbi error

Well, again I still think your Definition of $DSN is wrong. It should not be:

Code
  my $DSN = "driver=Driver do Microsoft Access (*.mdb);dbq=\\c$\\Inetpub\\wwwroot\\test.mdb";  

It should be:

Code
  my $DSN = "driver= Microsoft Access Driver(*.mdb);dbq=\\c$\\Inetpub\\wwwroot\\test.mdb";  


As for the connect call, it should use your user name and password like this:


Code
  my $dbh = DBI->connect("dbi:ODBC:$DSN", "admin", "wayko621");  

Your trace should not, I am pretty sure, contain the line:


Quote
-> connect for DBD::ODBC::dr (DBI::dr=HASH(0x18070ec)~0x17b5ce4 'driver=Driver do Microsoft Access (*.mdb);
dbq=\c$\Inetpub\wwwroot\test.mdb' '' **** HASH(0x182ed84))



Make sure you have the dsn and connect statement as shown above.

Run the trace again and see what you get.
Dennis

$a="c323745335d3221214b364d545".
"a362532582521254c3640504c3729".
"2f493759214b3635554c3040606a0",
print unpack"u*",pack "h*",$a,"\n\n";


(This post was edited by fashimpaur on May 17, 2002, 8:19 AM)


Edit Log:
Post edited by fashimpaur (User) on May 17, 2002, 8:19 AM


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives