DBI Connect Failed?

[JRyanCon]

I am trying to use Perl to connect to a MS SQL 2000 Server. I Installed DBI, DBD::ODBC and am using iODBC. When I try and connect I get:

[root@localhost mSQL]# perl connect.pl
DBI connect('dsnName','userName',...) failed: [iODBC][Driver
Manager]Data source name not found and no default driver specified. Driver could not be loaded (SQL-IM002)(DBD: db_login/SQLConnect err=-1) at connect.pl line 14

Should the default driver be set in the odbc.ini? If so can you give me a sample of what the odbc.ini would look like for MS SQL 2000 Server?

Ryan

 

[k5tm]

You seem to be running perl on a *nix machine. MS SQL Server 2000 presumably is on a Windows machine. Please describe your network connection more thoroughly.

Tom Morrison

http://www.liant.com