Almost solved : MySQL to MS SQL Server

2004-08-20 Thread Joel West
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',

Re: Almost solved : MySQL to MS SQL Server

2004-08-20 Thread Joel West
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;

Re: Almost solved : MySQL to MS SQL Server

2004-08-20 Thread Eric Bohlman
[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

Re: MySQL to MS SQL Server

2004-08-19 Thread Joel West
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

Re: MySQL to MS SQL Server

2004-08-19 Thread amonotod
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

RE: MySQL to MS SQL Server

2004-08-19 Thread Jeff Urlwin
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:

RE: MySQL to MS SQL Server

2004-08-19 Thread Joel West
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

MySQL to MS SQL Server

2004-08-18 Thread Joel West
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

Re: MySQL to MS SQL Server

2004-08-18 Thread amonotod
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 -- `\|||/

Re: MySQL to MS SQL Server

2004-08-18 Thread Joel West
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