Access MS-SQL Database Using Perl on Windows

[rdl735]

I'm relatively new programming on Windows. I need some pointers badly. On Unix, Sybase::DBlib has worked fine for me. I tried to use DBI, DBD::ODBC installed on a server, but I get the following error:

DBI connect('DatabaseName','userid',...) failed: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (SQL-IM002)(DBD: db_login/SQLConnect err=-1)

I searched around, but most I've found seem to be about Unix not Windows. It seems ODBC is needed if I want access Sybase database. But I have no idea about accessing MS-SQL database within Windows.

So my question is how do I query SQL database on Windows using perl? Does using DBI, DBD::ODBC make sense? If yes, how do I fix the problem?

Much appreciated!
-Bob

[KevinADC]

You probably want to use Win32::ODBC, I am pretty sure it comes standard with activestate perl if thats what you are using. Open the activestate/activeperl folder on your local PC and read the documentation.

[rdl735]

You probably want to use Win32::ODBC, I am pretty sure it comes standard with activestate perl if thats what you are using. Open the activestate/activeperl folder on your local PC and read the documentation.

Thank you, Kevin.
I tried it out and it sure worked. In the process I read about DSNless connection, and I went back to use DBI DBD::ODBC, it also worked. I prefer DSNless connection, since it does not require to configure a DSN, this is a cleaner solution when the program is released to users.

[KevinADC]

Awesome! Good job!

[osariel]

guys,

I am having same ODBC issues connecting to MSSQL server within perl, i see that you guys got the solution here. Please can you let have the exact syntax for WIN32::ODBC connection string. Very much appreciated

[eWish]

DBD::ODBC documentation
DBI documentation