Skip to Content.
Sympa Menu

freetds - Re: [freetds] Problem with RPC against SQL server 2005

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "baeck1957" <baeck1957 AT hotmail.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problem with RPC against SQL server 2005
  • Date: Tue, 21 Mar 2006 22:22:15 -0600

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





Archive powered by MHonArc 2.6.24.

Top of Page