RE: SQL Server Connection String

[Jensen, John T]

use MSSQL::DBlib; use MSSQL::Sqllib;   ##################################################### # Set SQL module to login to SQL as NT user that is # # running this script                               # ##################################################### DBSETLSECURE();   $sqlserver="comsql";   ################################################################################## # Login to comsql server ################################################################################## sql_init("$sqlserver","","","\[student records\]");     ################################################################################## # Execute the SQL ################################################################################## @psoft_refs=sql(”select blah blah from blah blah”);   Array of hash references produced. jj John Thayer Jensen, System Administrator Computing Services Unit, School of Business University of Auckland +64 9 373-7599 ext 87543 +64 21 049-7702 (mobile) - QuickDial 60001 +64 9 373-7696 (FAX) http://staff.business.auckland.ac.nz/~j.jensen From: Erich Singer [mailto:[EMAIL PROTECTED] Sent: Saturday, 3 January 2004 09:26 To: [EMAIL PROTECTED] Subject: SQL Server Connection String   Hello and Happy New Year   I  am trying to connect to a remote intranet MS SQL Server database ( say myDatabase) that is part of an SQL Server Group (say myServerGroup) having an IP address (say 123.456.789.012) from my PC having another IP address (say 321.654.987.210)   Not sure how to write the connection string   Any ideas welcome (DBI or ODBC)   Thanks   Erich