in reply to Problems connecting to MS SQL 6.5 server
Where NAME is the name of the ODBC database. Also, make sure you have an entry for the database in ODBC on each pc you use it on (Start->Settings->Control Panel->ODBC Data Sources and put your entry under the System DSN tab). If you still have problems, post more of your code so we can see what is going on. I also found this in the README.adabas that comes with DBD::ODBCuse DBI; my $dbh = DBI->connect('DBI:ODBC:NAME','user','pass') || die $!;
I'd be happy to leave this away and use the dsn dbi:ODBC:servernode=192.168.1.2;serverdb=MYDB or something similar, but I didn't get this working. Perhaps someone a +t SAG can help?
|
|---|