 ODBC connection to SQL Server 2008 [message #423282] |
Wed, 23 September 2009 03:50  |
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 #424075 is a reply to message #423965] |
Wed, 30 September 2009 03:28  |
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 #424215 is a reply to message #424214] |
Wed, 30 September 2009 14:35 |
 |
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 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
