FreeTDS Development Group

[anwill - Andy Williams <ANWILL AT acxiom.co.uk>]

Hi once again.

I now have my system set up correctly, I think
However, now when I try to connect I get the following errors:

Unknown marker: 0!!

This happens during the connect method.
This is my code:

        use DBI;

        my $dsn = "dbi:Sybase:server=myDB;database=myDB";
        my $user    = "user";
        my $pass    = "pass";

        my $dbh = DBI->connect($dsn,$user,$pass) or die "$DBI::errstr()";

        print "Connected\n";

Here's my interface file:

        JDBC
        query tcp ether 192.138.151.39 4444
        master tcp ether 192.138.151.39 4444

        myDB
          query tcp ether 10.150.3.210 1433
          master tcp ether 10.150.3.210 1433

If I telnet to 10.150.3.210 on port 1433 it seems to connect.
I can connect to the same server via ODBC and DBI::ProxyServer so I don't
think its the database.
I have no clue what is going on.

Any ideas?

TIA

Andy

-----Original Message-----
From: Geoff Winkless [mailto:geoff AT farmline.com]
Sent: Thursday, October 12, 2000 12:48 PM
To: TDS Development Group
Subject: [freetds] Re: DBD::Sybase FreeTDS connection problems to MS S
QLServer 6.5


X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400

"Andy" <anwill AT acxiom.co.uk> writes:
> Looks like the following:
>
> JDBC
>         query tcp ether 192.138.151.39 4444
>         master tcp ether 192.138.151.39 4444
>
> myserver
>         query tcp ether 127.0.0.1 4000
>         master tcp ether 127.0.0.1 4000
>
> myserver2
>         query tcp ether 127.0.0.1 4001
>         master tcp ether 127.0.0.1 4001

By default SQL Server runs on port 1433...

you should set up this file to have an entry

machinename
    query tcp ether 10.150.3.210 1433
    master tcp ether 10.150.3.210 1433

Of course, replace machinename with whatever you want to use, and then
reference -that- name in the perl code:

my $dsn = "dbi:Sybase:database=myDB;server=machinename";

Geoff



---
You are currently subscribed to freetds as: [anwill AT acxiom.co.uk]
To unsubscribe, forward this message to
$subst('Email.Unsub')


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.