FreeTDS Development Group

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

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