Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re: Cannot connect to SQL Server 2000 using DBI

by Anonymous Monk
on Jul 04, 2004 at 03:22 UTC ( [id://371652]=note: print w/replies, xml ) Need Help??


in reply to Cannot connect to SQL Server 2000 using DBI

my $data_source = "dbi::SQL Server:Interfaces";
dbi::?
  • Comment on Re: Cannot connect to SQL Server 2000 using DBI

Replies are listed 'Best First'.
Re^2: Cannot connect to SQL Server 2000 using DBI
by Anonymous Monk on Jul 04, 2004 at 03:41 UTC
    do you have any sample on how to best connect to SQL Server 2000 uisng 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://371652]
help
Chatterbox?
and the web crawler heard nothing...

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

    No recent polls found