mssql and perl

Does anyone know if it is possible to have perl connect to a mssql database. and if so how do you do it.

You might look at the DBD module. I've personally never done it before, but I'm sure it's possiable somehow.

that should be the DBI module, DBD is the database driver, normally mysql.

Mickalo

Well I agree, except for the part it about it being normally for mysql. It is an ODBC driver, which is why I figured he'd have more luck with it. I'm not sure DBI supports msssql.

I missed the mssql ! To used to seeing mysql

My mistake.

Mickalo

Now that I read the docs, you can get a list of db drivers that dbi supports like this:

You can just loop through that to print out a list and see if an mssql driver exists.

Thanks alot guys. I checked it on our system but it doesnt look like it will allow it. They dont have a mssql driver installed for anything. I tried looking in php also and that was a no go. But it gave me what i need to know.

If you go to http://www.zend.com you can look in the manual or go through the functions for PHP. You are going to need to use DBD::ODBC for perl to access a mssql database. You have to install DBI and in your connection string to the database you write

$db = DBI->connect('dbi:ODBC:$hostname:$dsn,$username,$password')

You can also access mysql through DBI. The package is called DBD::Mysql.


There is also a seperate package for mysql.
Mysql is the package name.

Jonathan Donaghe