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: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.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 10:54:05 +0100

>
> 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

I think I understood the problem however I'm unable to test it (I don't
have a mssql 2005 machine and I'm unable to install an Express version
even on my machine). Someone can give me an account to test with ?

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page