Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: Problems connecting to MS SQL 6.5 server

by c-era (Curate)
on Nov 08, 2000 at 18:28 UTC ( [id://40527]=note: print w/replies, xml ) Need Help??


in reply to Problems connecting to MS SQL 6.5 server

When using ODBC I usually use this
use DBI; my $dbh = DBI->connect('DBI:ODBC:NAME','user','pass') || die $!;
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::ODBC
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?

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://40527]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others exploiting the Monastery: (5)
As of 2024-04-23 07:19 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found