DBD::SQL

[disord3r]

I've installed ActivePerl on a Windows2000 Advanved Server box, and perl itself seems to be working well. I'm working with a perl file that needs to communicate with a SQL database on a different server, and ODBC just isn't working for some reason. On a suggestion, I decided to try out DBI instead of Win32::ODBC.

I've installed DBI, but I can't get a driver for SQL. When I try to make a connection to the database, even though the SQL driver isn't there, it's telling me specifically that I need to install DBD:SQL, because I've specified my database connection as "DBI:SQL:[database name]". I'd download it direct from the web and put all the files where they need to go, but for the life of me I can't find a single site that has this available for a regular http or ftp download.

"install DBI" from PPM worked, but "install DBD::SQL" says it cant find anything. CPAN is a bit more of a headache than I'm willing to deal with at the moment. Anyone know how to install the SQL driver?

 

[Jsd02]

You should type the database type in BDB, so if you want to use mysql database type in PPM "install DBD::mysql" or if oracle database then type in PPM "install DBD:racle". As I understood you'll work with MS SQL databases, I never worked with them but as I remember to support them you should type in PPM "install DBD::mssql" mybe I'm mistaken, try to look for it on CPAN, just type DBD in search box and you'll see all the databases

 

[MikeLacey]

Hmmm, unfortunately there isn't a native DBD driver for MsSQL; no idea why.

Some people have used DBD::Sybase with some success (goBoating I think) but most (me anyway) use DBD::ODBC. Mike
________________________________________________________________________________

"Experience is the comb that Nature gives us, after we are bald."

Is that a haiku?
I never could get the hang
of writing those things.