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 AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problem with RPC against SQL server 2005
  • Date: Tue, 21 Mar 2006 01:06:40 -0600

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




Archive powered by MHonArc 2.6.24.

Top of Page