I am much closer than before:
I compiled FreeTDS from source.
tsql connects no problems
DBD::Sybase compiles no problem and no longer causes errors.
BUT
#!/usr/local/perl
#
use DBI;
use DBD::Sybase;
my $server=192.168.100.2;
my $uid=ss_userid;
my $dbh = DBI-connect(dbi:Sybase:$server, '$uid',
I found it..duh!
On Fri, 20 Aug 2004, Joel West wrote:
I am much closer than before:
I compiled FreeTDS from source.
tsql connects no problems
DBD::Sybase compiles no problem and no longer causes errors.
BUT
#!/usr/local/perl
#
use DBI;
use DBD::Sybase;
my $server=192.168.100.2;
my $uid=ss_userid;
[EMAIL PROTECTED] (Joel West) wrote in
news:[EMAIL PROTECTED]:
my $dbh = DBI-connect(dbi:Sybase:$server, '$uid', '$uid');
Gives the error:
DBI connect('192.168.100.2','$uid',...) failed: Server message
number=18456 severity=14 state=1 line=0 text=Login failed for user
'$uid'.OpenClient
I tried the below on the RedHat box I am on and got a different error:
DBI connect('driver={SQL
Server};Server=ipaddress ;database=databasename','userid',...) failed: [unixODBC][Driver Manager]
Data source name not found, and no default driver specified (SQL-IM002)(DBD: db_login/SQLConnect
From: Joel West [EMAIL PROTECTED]
Date: 2004/08/19 Thu PM 12:24:30 GMT
Server};Server=ipaddress ;database=databasename','userid',...) failed:
[unixODBC][Driver Manager]
Data source name not found, and no default driver specified (SQL-IM002)(DBD:
db_login/SQLConnect err=-1) at
dump1.pl
I tried the below on the RedHat box I am on and got a different error:
DBI connect('driver={SQL
Server};Server=ipaddress
;database=databasename','userid',...) failed:
[unixODBC][Driver Manager] Data source name not found, and no
default driver specified (SQL-IM002)(DBD:
So
I compiled FreeTDS from souce.
tsql - The FreeTDS utility connects okay.
unixODBC would not compile so I am using iODBC
DBD::Sybase compiles lovely and gives the following error if used:
[EMAIL PROTECTED] joelonx]# perl -w
use DBD::Sybase;
Can't load
Greetings,
I've read what I can so far about the topic and have resisted posting but
I am at a dead end.
I need to move data from a mysql server to an MS SQL server on another
machine. Retrieving the data from the mysql server is easy. I had that
done in a few minutes using DBI.
Now I am
From: Joel West [EMAIL PROTECTED]
Date: 2004/08/18 Wed PM 05:33:54 GMT
my $dsn = DBI:ODBC:databasename:ipaddress;
(Assuming you're on Windows...)
my $dsn = DBI:ODBC:driver={SQL Server};Server=ipaddress;database=databasename;;
Joel (Yossel) West
HTH,
amonotod
--
`\|||/
Actually I'm on Linux.
- Original Message -
From: amonotod [EMAIL PROTECTED]
To: Joel West [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, August 18, 2004 5:42 PM
Subject: Re: MySQL to MS SQL Server
From: Joel West [EMAIL PROTECTED]
Date: 2004/08/18 Wed PM 05:33:54 GMT
10 matches
Mail list logo