Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: SQL Server connect from Linux to Windows 2008

by Anonymous Monk
on Jan 26, 2012 at 16:01 UTC ( #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";


Comment on Re: SQL Server connect from Linux to Windows 2008
Select or Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (10)
As of 2014-12-29 12:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (187 votes), past polls