Up Prev Next
From: Lee Wenzler <Lee dot Wenzler at Roanoke dot com>
Subject: RE: Sybperl to MS SQL Server help
Date: Jul 3 2002 12:51PM
Thanks Michael. That's what it took! Because my unix login has
environment variables set for Sybase 12, it was messing up the FreeTDS
stuff. After re-installing the DBD::Sybase with the env SYBASE set to
/usr/local/freetds and unsetting the OCS-12_0 envs it works fine.
Do you see any problems using connections to both Sybase 12 and MS SQL
living in the same program? I need to transfer some data back and forth.
Publishing Systems Manager
The Roanoke Times
>From: Michael Peppler [mailto:firstname.lastname@example.org]
>Sent: Tuesday, July 02, 2002 5:10 PM
>To: SybPerl Discussion List
>Subject: RE: Sybperl to MS SQL Server help
>On Tue, 2002-07-02 at 13:45, Lee Wenzler wrote:
>> I built the DBD::Sybase and tried it. I can connect ok with a sybase
>> server, but when I put in the server name of the MS SQL server (with
>> interface file set to TLI TCP transport for the JOBS server name.
>> $dbh = DBI->connect("dbi:Sybase:server=JOBS", $user, $password);
>> I get this error:
>> DBI->connect(server=JOBS) failed: OpenClient message: LAYER = (5)
>> = (3) SEVERITY = (5) NUMBER = (6)
>> Message String: ct_connect(): network packet layer: internal net
>> error: Net-Library operation terminated due to disconnect
>> at ./jobs.pl line 761
>> I'm not sure how the FreeTDS gets pulled into all this.
>Well - you have to build DBD::Sybase with the FreeTDS libs (i.e. point
>the SYBASE env variable at the FreeTDS installation when you build, and
>when you run a script).
>Then you need to create an interfaces file entry in the "old" format
> query tcp ether hostname port
>This *should* work correctly.
>If you have a recent SP of MS-SQL 7 then the Sybase libs should work as
>well - but they won't work with MS-SQL 2000.
>> >-----Original Message-----
>> >From: Michael Peppler [mailto:email@example.com]
>> >Sent: Tuesday, July 02, 2002 4:02 PM
>> >To: SybPerl Discussion List
>> >Subject: Re: Sybperl to MS SQL Server help
>> >On Tue, 2002-07-02 at 12:53, Lee Wenzler wrote:
>> >> Dang, this is way too hard. This all started when I tried to
>> >> a MS SQL server using Sybperl. I can get the FreeTDS stuff to work
>> >> far as the make check passing the login & logout, & change db
>> >> I'm lost after that. After not getting that to work, I tried to
>> >> unixODBC drivers to work. I've gone thru all the FAQs and keep
>> >> deeper and deeper into this hole. Am I making this more
>> >> it needs to be (please say yes)??
>> >I think so - though I'm no specialist on this.
>> >I suggest that you forget about ODBC. Instead try building
>> >and use that with FreeTDS. I believe that this works reasonably
>> >Michael Peppler / firstname.lastname@example.org /
>> >email@example.com / ZetaTools, Inc / http://www.zetatools.com
>> >ZetaTools: Call perl functions as Sybase stored procedures!
>Michael Peppler / firstname.lastname@example.org / http://www.mbay.net/~mpeppler
>email@example.com / ZetaTools, Inc / http://www.zetatools.com
>ZetaTools: Call perl functions as Sybase stored procedures!