Hi,
I am trying to connect to SQL Server 2005 on a windows 64bit
machine from the same machine. And I get this error message:
DBI connect(xxxsql01,'sa',...) failed: [Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified (SQL-IM002)
at a.pl line 10
Can't connect to dbi:ODBC:xxxsql01: [Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified (SQL-IM002)
at a.pl line 10.
The Perl script is:
#=======================================================
use strict;
use DBI;
my $data_source = q/dbi:ODBC:xxxsql01/;
my $user = q/sa/;
my $password = q/xxxxxx/;
# Connect to the data source and get a handle for that connection.
my $dbh = DBI->connect($data_source, $user, $password)
or die "Can't connect to $data_source: $DBI::errstr";
#=========================================================
If I run this script from a 32-bit windows machine, it is
able to connect successfully.
I applied the latest DBD-ODBC 1.15 version (Martin J Evans)
and it still is a problem. Is there any fix or work around for this
issue?
Appreciate your time,
Thanks,
Ramakrishna Raju ( "Raju" )
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
DISCLAIMER: NOTICE REGARDING PRIVACY AND CONFIDENTIALITY
This e-mail, and any attachments thereto, is intended only for use by the
addressee(s) named herein and may contain legally privileged and/or
confidential information. If you are not the intended recipient of this e-mail,
you are hereby notified that any dissemination, distribution or copying of this
e-mail, and any attachments thereto, is strictly prohibited. If you have
received this e-mail in error, please immediately notify me and permanently
delete the original and any copy of any e-mail and any printout thereof. E-mail
transmission cannot be guaranteed to be secure or error-free. The sender
therefore does not accept liability for any errors or omissions in the contents
of this message which arise as a result of e-mail transmission. TJM Proprietary
Trading, LLC ("TJMPT") may, at its discretion, monitor and review the content
of all e-mail communications. TJMPT is a registered joint back office broker
dealer with the Chicago Board of Options Exchange "CBOE". TJMPT's office is
located at 318 W. Adams Floor 9, Chicago, IL 60606. For more information about
TJMPT, please call us at (312)-432- 5100 or fax (312)-432-4498.
