Re: accessing database via network using DBI

2002-06-13 Thread learn perl
Hi Jenda, Thanks for your info~ it wasn't on the book any where? =) as for DSN lookup I have my own code to search for available drivers ^^ Eric #begin code #!d:\perl\bin\perl.exe -w #This tool is used to check for connection strings to the #avai

Re: accessing database via network using DBI

2002-06-13 Thread Jenda Krynicky
From: learn perl <[EMAIL PROTECTED]> > Thanks, that's what I thought of doing. But is there a way to connect > to the remote database (MS SQL server) w/o going thru DSN? $db = DBI->connect( 'DBI:ODBC:Driver=SQL Server; Server=The_name_or_IP_of_Server; Database=D

Re: accessing database via network using DBI

2002-06-13 Thread learn perl
Thanks, that's what I thought of doing. But is there a way to connect to the remote database (MS SQL server) w/o going thru DSN? Thanks Eric On Thu, 13 Jun 2002, Jenda Krynicky wrote: > From: learn perl <[EMAIL PROTECTED]> > > > Hi folks, need some help in accessing a ODBC database (SQL serve

Re: accessing database via network using DBI

2002-06-13 Thread Jenda Krynicky
From: learn perl <[EMAIL PROTECTED]> > Hi folks, need some help in accessing a ODBC database (SQL server) > using DBI via the nextwork. > > usually, if the database is on local machine, I just use the > datasource $dbh=DBI->connect("DBI:ODBC:databasename",$username, > $password, %attr); > > but

accessing database via network using DBI

2002-06-13 Thread learn perl
Hi folks, need some help in accessing a ODBC database (SQL server) using DBI via the nextwork. usually, if the database is on local machine, I just use the datasource $dbh=DBI->connect("DBI:ODBC:databasename",$username, $password, %attr); but how do I complete this connection if the database is