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:28:55 -0600

For freddy77--

Unfortunately, I don't have a SQL 2005 DB out in a DMZ. I'll have to check with some of my colleagues. Are there any changes you would like me to try in the source?

Regards,
Brent

----- Original Message ----- From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Sent: Tuesday, March 21, 2006 3:54 AM
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

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