Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re^3: Cannot connect to SQL Server 2000 using DBI

by bart (Canon)
on Jul 04, 2004 at 10:39 UTC ( [id://371697]=note: print w/replies, xml ) Need Help??


in reply to Re^2: Cannot connect to SQL Server 2000 using DBI
in thread Cannot connect to SQL Server 2000 using DBI

The AM is right, you should have a DBD driver defined between the first and the second colon.

Assuming your perl code runs on Windows... I think the easiest way is to use the DBD::ODBC driver. Make a System-DSN to your database, with the "32-bit ODBC data sources" control panel from Windows, and use the name you gave it there, as the third part for your connect string. If that name was "Foo" (just a silly example :-) ), the connect string can then look like:

"DBI:ODBC:Foo"

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://371697]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others musing on the Monastery: (2)
As of 2024-04-19 19:38 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found