Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: Cannot connect to SQL Server 2000 using DBI

by WhiteBird (Hermit)
on Jul 04, 2004 at 03:35 UTC ( #371654=note: print w/replies, xml ) Need Help??


in reply to Cannot connect to SQL Server 2000 using DBI

Have you confirmed that DBI is loaded on your system? (What platform? What version of Perl?)

You also should add a DBD module. When connecting to a SQL Server I tend to use DBD::ODBC. Look into the documentation. Do a super search on DBI and DBD::ODBC.

  • 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:43 UTC
    I thought in the connection string, you need to specify the driver of connecting database??? Why do I need to add DBD???
      I suppose the simpliest way to say it is that the DBD is the driver to the database. If I understand the process correctly, the DBD contains the specifics for the particular database that you are trying to connect to. You need to understand both DBI and your chosen driver. I haven't pursued the "why" as much as the "how". You just need all the correct pieces or the connection isn't going to work. Have you looked at the DBI site? You can download a DBD there and get more information.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (1)
As of 2022-05-22 02:24 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you prefer to work remotely?



    Results (78 votes). Check out past polls.

    Notices?