Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?

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";

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 pondering the Monastery: (6)
As of 2016-10-22 13:54 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (294 votes). Check out past polls.