Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister

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 -

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

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?

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

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (3)
As of 2015-07-28 06:03 GMT
Find Nodes?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...

    Results (252 votes), past polls