Ramakrishna Raju wrote:
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 o
ffice 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.
Are you sure you have created a 64bit data source called xxxsql01. In
Windows 64 there are 2 odbc driver managers - one for 32bit and one for
64bit. If you Perl is 64bit you'll need to create a 64bit ODBC data
source and if you Perl is 32bit you'll need to create a 32bit data source.
Of course, it may just be you created a user DSN and you are not logged
in as that user.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
