FreeTDS Development Group

["baeck1957" <baeck1957 AT hotmail.com>]

I tried workaround you mentioned in the reply to Stefan and I got the same
results.  I changed both the [global] section and the section I created for
the specific server with the SQL 2005 database.

[global]
       # TDS protocol version
       tds version = 7.0

# TBW Configuration
[TBWSS]
       host = dal4tbw.vs.lmco.com
       port = 1433
       tds version = 7.0

Thanks for the help,
Brent

----- Original Message ----- 
From: "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Sent: Tuesday, March 21, 2006 3:29 AM
Subject: Re: [freetds] Problem with RPC against SQL server 2005


> Hi Brent,
>
> we worked around this last time by making sure that FreeTDS used version
> 7.0 of the protocol rather than 8.0 .
> It appears MS have changed that part of the 8.0 protocol with SQL 2005,
> without implementing a new version number of the protocol.
> edit the freetds.conf entry for that server so that tds version = 7.0
>
> Bill
>
> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of baeck1957
> Sent: 21 March 2006 07:07
> To: freetds AT lists.ibiblio.org
> Subject: Re: [freetds] Problem with RPC against SQL server 2005
>
>
> Stefan Ille wrote:
>
> > Hello,
> >
> > nobody out there having the same trouble as me, with sql2k5?
> >
> > Stefan
>
> Stefan,
>
> I have the same problem trying to access a SQL Server 2005 from Oracle.
> I have FreeTDS working on a Solaris 9 / Oracle 9.2.0.7 (well, at least,
> the unixODBC and FreeTDS stuff maybe).
>
> The tsql connection works great--
>
> dal3argus:oragpd 1% tsql -H dal4tbw -p 1433 -U 'acct02\eckhout'
> locale is "C"
> locale charset is "646"
> Password:
> 1> select count(*) from sysobjects
> 2> go
>
> 1836
> 1>
>
> However, configuring Oracle hsodbc and the appropriate Net8 settings, I
> don't get the same results in sqlplus--
>
> dal3argus:oragpd 2% sqlplus sapread
>
> SQL*Plus: Release 9.2.0.7.0 - Production on Tue Mar 21 00:43:33 2006
>
> Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
>
> Enter password:
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.7.0 - Production
>
> SQL> select count(*) from sysobjects@hsodbc;
> select count(*) from sysobjects@hsodbc
>                     *
> ERROR at line 1:
> ORA-00942: table or view does not exist
> [Generic Connectivity Using ODBC][unixODBC][FreeTDS][SQL Server]The
> incoming
> tabular data stream (TDS) remote procedure call (RPC) protocol stream is
> incorrect. Parameter 4 (""): Data type 0x38 is unknown. (SQL State:
> 00000; SQL
> Code: 8009)
> ORA-02063: preceding 2 lines from HSODBC
>
> I may have to qualify the table name with a MS schema or database name
> (still learning the syntax for SS).  However, the second part of the
> error message is pointing to something else besides my lack of
> understanding on the proper syntax.
>
> Any help would be appreciated,
> Brent
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> --------------------------------------------------------
>
> If you are not an intended recipient of this e-mail, please notify the
> sender, delete it and do not read, act upon, print, disclose, copy, retain
> or redistribute it. Click here for important additional terms relating to
> this e-mail.     http://www.ml.com/email_terms/
> --------------------------------------------------------
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds