[freetds] Problem with RPC against SQL server 2005
baeck1957
baeck1957 at hotmail.com
Tue Mar 21 23:22:15 EST 2006
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 at hsodbc;
> select count(*) from sysobjects at 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
>
More information about the FreeTDS
mailing list