|
|
sybperl-l Archive
Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: RE: Sybperl to MS SQL Server help
Date: Jul 2 2002 9:09PM
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 the
> 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) ORIGIN
> = (3) SEVERITY = (5) NUMBER = (6)
> Message String: ct_connect(): network packet layer: internal net library
> 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
(not tli):
JOBS
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.
Michael
> >-----Original Message-----
> >From: Michael Peppler [mailto:mpeppler@peppler.org]
> >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 connect
> to
> >> a MS SQL server using Sybperl. I can get the FreeTDS stuff to work as
> >> far as the make check passing the login & logout, & change db tests,
> but
> >> I'm lost after that. After not getting that to work, I tried to get
> >> unixODBC drivers to work. I've gone thru all the FAQs and keep
> getting
> >> deeper and deeper into this hole. Am I making this more complicated
> than
> >> 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 DBD::Sybase,
> >and use that with FreeTDS. I believe that this works reasonably well.
> >
> >Michael
> >--
> >Michael Peppler / mpeppler@peppler.org / http://www.mbay.net/~mpeppler
> >mpeppler@zetatools.com / ZetaTools, Inc / http://www.zetatools.com
> >ZetaTools: Call perl functions as Sybase stored procedures!
>
--
Michael Peppler / mpeppler@peppler.org / http://www.mbay.net/~mpeppler
mpeppler@zetatools.com / ZetaTools, Inc / http://www.zetatools.com
ZetaTools: Call perl functions as Sybase stored procedures!
|
