Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re: SQL Server connect from Linux to Windows 2008

by Anonymous Monk
on Jan 26, 2012 at 16:01 UTC ( [id://950145]=note: print w/replies, xml ) Need Help??


in reply to SQL Server connect from Linux to Windows 2008

FWIW, the DBD::Driver and the database-server-docs usually contain details for constructing a DSN :) Hope this helps

SQL Server 2008 Connection String Samples - ConnectionStrings.com

Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password +=myPassword;Trusted_Connection=False; Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Secu +rity=SSPI;

http://search.cpan.org/dist/DBD-ODBC/FAQ

my $DSN = 'driver={SQL Server};Server=server_name;database=database_na +me;uid=user;pwd=password;'; my $dbh = DBI->connect("dbi:ODBC:$DSN") or die "$DBI::errstr\n";

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others contemplating the Monastery: (3)
As of 2024-04-25 06:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found