Home » RDBMS Server » Networking and Gateways » ODBC connection to SQL Server 2008 (Oracle, 10.2.0.4, Linux i386)
icon4.gif  ODBC connection to SQL Server 2008 [message #423282] Wed, 23 September 2009 03:50 Go to next message
WillIm
Messages: 13
Registered: June 2008
Location: Kyrgyzstan, Bishkek
Junior Member
Hello!
I faced the following issue the other day:
I made an ODBC connection between Oracle 10.2.0.4( on Linux 32 bit) and SQL Server 2008 on Windows Server 2008 (32 bit). It works if only i have not more than 100 records in my table, otherwise I have:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
Transparent gateway for MSSQLDRV_Execute: MicrosoftODBC SQL Server DriverConnection is busy with results for another hstmt (SQL State: S1000; SQL Code: 0)
What could be the reason and how to bring this issue to a close?
Thank you in advance!
Re: ODBC connection to SQL Server 2008 [message #423965 is a reply to message #423282] Tue, 29 September 2009 08:51 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

What's the value of QuotedId in your odbc.ini ?

What's the value of HS_FDS_SUPPORT_STATISTICS in your initodbc_SQLSERVER.ora ?
Re: ODBC connection to SQL Server 2008 [message #424075 is a reply to message #423965] Wed, 30 September 2009 03:28 Go to previous messageGo to next message
WillIm
Messages: 13
Registered: June 2008
Location: Kyrgyzstan, Bishkek
Junior Member
Hello, tahpush.
Thank you for your reply.

I couldn't find location oа odbc.ini Where is it situated?

And here is what I have in initodbc_SQLSERVER.ora:

# This is a sample agent init file that contains the HS parameters that are needed for an ODBC Agent.
#
# HS init parameters
#
HS_FDS_CONNECT_INFO = MYODBC
HS_FDS_TRACE_LEVEL = OFF


Re: ODBC connection to SQL Server 2008 [message #424106 is a reply to message #424075] Wed, 30 September 2009 04:44 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

You have some good step-by-step here

[Updated on: Wed, 30 September 2009 05:19]

Report message to a moderator

Re: ODBC connection to SQL Server 2008 [message #424206 is a reply to message #423282] Wed, 30 September 2009 13:27 Go to previous messageGo to next message
daveaakanksha
Messages: 3
Registered: September 2009
Location: DELHI
Junior Member
i want to connect ascess 2007 to oracle 8 can u tell me how can i do that please help
Re: ODBC connection to SQL Server 2008 [message #424208 is a reply to message #424206] Wed, 30 September 2009 13:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.lmgtfy.com/?q=access+oracle+connection

Regards
Michel
Re: ODBC connection to SQL Server 2008 [message #424209 is a reply to message #424208] Wed, 30 September 2009 13:38 Go to previous messageGo to next message
daveaakanksha
Messages: 3
Registered: September 2009
Location: DELHI
Junior Member
i am not getting the proper ans
Re: ODBC connection to SQL Server 2008 [message #424210 is a reply to message #424206] Wed, 30 September 2009 13:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>i want to connect ascess 2007 to oracle 8 can u tell me how can i do that please help

ACCESS 2007 can use ODBC to connect to Oracle
Re: ODBC connection to SQL Server 2008 [message #424211 is a reply to message #424209] Wed, 30 September 2009 13:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
daveaakanksha wrote on Wed, 30 September 2009 20:38
i am not getting the proper ans

You have to make a little effort and read the links.

Regards
Michel

Re: ODBC connection to SQL Server 2008 [message #424214 is a reply to message #424210] Wed, 30 September 2009 14:29 Go to previous messageGo to next message
daveaakanksha
Messages: 3
Registered: September 2009
Location: DELHI
Junior Member
please tell me how as i am new to oracle
Re: ODBC connection to SQL Server 2008 [message #424215 is a reply to message #424214] Wed, 30 September 2009 14:35 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>please tell me how as i am new to oracle
The solution has NOTHING to do with Oracle & everything to do with Micro$oft.

Oracle will accept connection from any properly configured client.

Your challenge is to configure ACCESS so that it can get to Oracle's listener.

Posting Guidelines state you should SEARCH this forum.
Now proceed to do so!

http://www.orafaq.com/wiki/ODBC_FAQ

be WARNED that you'll face CaSeSenSitiVity issues between Access & Oracle


[Updated on: Wed, 30 September 2009 15:12]

Report message to a moderator

Re: ODBC connection to SQL Server 2008 [message #424436 is a reply to message #424106] Fri, 02 October 2009 06:51 Go to previous message
WillIm
Messages: 13
Registered: June 2008
Location: Kyrgyzstan, Bishkek
Junior Member
Hello, tahpush.
Thank you again for your reply.
I've read the steps of configuring init file in the link you sent me. I'm using MS SQL Server 2008 so MARS feature is provided. But I couldn't make it work. It says "To enable MARS for your DG4ODBC/SQL Server connection, add the following setting to your SQL Server ODBC driver data source in /etc/odbc.ini". But I have Oracle installed on Win Server, and I couldn't find odbc.ini file there. So how could I make it work in that case?

P.S. I also added "HS_FDS_SUPPORT_STATISTICS = FALSE" in my initodbc_SQLSERVER.ora, but no luck, I got the same message "SQL Server DriverConnection is busy with results for another hstmt"

[Updated on: Fri, 02 October 2009 06:58]

Report message to a moderator

Previous Topic: Databae connection failed
Next Topic: ORA-12514 dblink as non oracle user
Goto Forum:
  


Current Time: Fri Mar 29 05:24:52 CDT 2024