Hellow monks
i'm getting a similar problem with SQL Server ( I'm on windows )
use DBI;
my $user = "rodrigo";
my $pass = "123456";
my $server = "localhost\\WHATSUP:3477";
my $database_name = "equip";
my $DSN = "driver={SQL Server};server=$server;database=$database_name;
+uid=$user;pwd=$pass";
my $DBH = DBI->connect("DBI:ODBC:$DSN") or die "Couldn't open database
+: $DBI::errstr\n";
But i'm getting the following error:
DBI connect('driver={SQL Server};server=localhost\WHATSUP:3477;databas
+e=equip;uid=rodrigo;pwd=123456','',...) failed: [Microsoft][ODBC SQL
+Server Driver][DBNETLIB]Invalid connection. (SQL-08001) [st
ate was 08001 now 01000]
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (ParseConn
+ectParams()). (SQL-01000) at C
:\fsecali\connectDB.pl line 9
Couldn't open database: [Microsoft][ODBC SQL Server Driver][DBNETLIB]I
+nvalid connection. (SQL-08001)
[state was 08001 now 01000]
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (ParseConn
+ectParams()). (SQL-01000)
I have no idea what should i do. Thanks in advanced
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|