LONG strings - Heterogeneous Connectivity

Using generic connectivity from 8.1.7 to SQL Server I'm getting the follwoing error from an insert. Is the limit of 350 due to the ODBC driver or the HS agent?
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][A05B] The string is too long. Maximal length
is 350. ('

Fraser,
I not aware of such a limit with Generic Connectivity.
Please turn tracing on for both Heterogeneous Services and the ODBC driver and take a look where the error is occurring.
If the error is in the ODBC trace file. It must be a limitation of the ODBC driver.
If not please contact Oracle support.
Vira

Related

ERROR while connecting to Netezza Database from oracle 10g via dblink.

Gurus,
We are trying to connect to Netezza DB from oracle 10g DB.. We successfully establised ODBC connection but unable to retrieve data over the dblink connected from oracle to Netezza. We get this error.. Please HELP ASAP!!!!!!!!
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
Server and/or port attributes are empty {HY000,NativeErr = 33} 
This is not oracle support and all the threads are alike here. So don't mention ASAP with your threads.
For your issue, a quick Google search came up with this, have a look and see if it helps.
http://www.dsxchange.com/viewtopic.php?p=302200&sid=0f0a68fabb76dc5c230bc39f10ff4136
Aman.... 
It seems you're in the wrong forum and should move the post to: {forum:id=63}.
Also follow up on the non-Oracle message as it indicates a problem with data source setup for ODBC agent. 
Manik wrote:
We are trying to connect to Netezza DB from oracle 10g DB.. We successfully establised ODBC connection but unable to retrieve data over the dblink connected from oracle to Netezza. We get this error.. Please HELP ASAP!!!!!!!!
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
Server and/or port attributes are empty {HY000,NativeErr = 33}Always test ODBC client connectivity on the Oracle server to the remote and foreign database, first. Use the isql ODBC client command line interface (as the oracle or grid o/s user).
If this does not work, then Oracle HSO will also not work.
Once you have confirmed that this is working, then configure the HSO service for Oracle.
If that fails, enables ODBC client tracing for that HSO service (in the init file for that service) to see exactly what ODBC calls Oracle is making and which of these are failing. 
Manik, with how many zeroes after the dollar sign do you spell "ASAP"? I will gladly work with you for $80/hr, in which case you can ask for urgency. As for the rest, you got the native error code. Please check what does this error code say. Second, is yor ODBC driver ODBC 3.5 compatible? Does isql work? Can you connect and do "select * from emp"?

Access Sybase data

I am trying to access sysbase database from oracle through HS ODBC Services, I have taken all necessary actions regarding setting HS environment, my Sybase database is on remote location and Oracle 9i server is on my machine. Anyone can guide me: the following is the error I received when I try to get data from Sybase:
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][MERANT][ODBC Sybase ASE driver]Login Failed, Check for vaild us
ID, server name and password (SQL State: HY000; SQL Code: 0)
ORA-02063: preceding 2 lines from ACCESS_DB
Regards, 
This seems to indicate that something isn't configured properly. The user ID, server name, or password have been specified incorrectly.
If Sybase user names and passwords are case-sensitive, you may need to put double-quotes around them when you create the database link. That's a relatively common stumbling block.
Also, note that there is a Heterogeneous Connectivity forum here on OTN. You may want to post this sort of question over there...
Justin

ADO Error: [Microsoft][ODBC driver for Oracle]Driver not capable

I'm getting the following error trying to connect to an oracle database via ADO from an MTS COM object:
ADO Error: [Microsoft][ODBC driver for Oracle]Driver not capable
I have confirmed that the ODBC drivers are correct, and have updated the MTS registry keys to use the correct dlls. I can connect via sqlplus so I think this may be an ADO issue.
Anyone have any clue why this is happening? 
It seems you are using MS ODBC driver, try ODBS driver for Oracle from Oracle, you will not get this error
null

"SQLAllocHandle on SQL_HANDLE_ENV" error connecting to a DB2

Hi all,
I'm running a datawarehouse using oracle version 9.0.1.4.0 on a Win2000 machine.
Currently, I access, without problems, different data sources, including MSSQL Server, MSAccess and MySQL, using ODBC and HS .
Now, I must connect to a DB2 database.
I've installed a IBM DB2 ODBC Driver, version 8.01.14.202
Then,I've configured the %ORAHOME%/HS/ADMIN/initDB2SOURCE.ora, as usual
HS_FDS_CONNECT_INFO = DB2SOURCE
HS_FDS_TRACE_LEVEL=1
HS_FDS_FILE_NAME=hsDB2SOURCE.trc
After updating my tnsnames.ora and listener.ora, I've created the dblink and tried to view DB2 data
At first, I received a "specified driver could not be loaded due to system error 5 (IBM DB2 ODBC DRIVER)" error messages, that, after some investigations, I fixed by giving full permissions to DB2 ODBC driver ( in C:\Program Files\IBM\SQLLIB)
But now I'm blocked on the following error
select * from TableName#DB2SOURCE
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed (SQL State: IM004; SQL Code: 0)
ORA-02063: preceding 2 lines from DB2SOURCE
Can someone help me?
Thanks
Massimo 
After many attemps, solved by setting the oracle service logon, originally set as a domain user, to LocalSystem.account.

Connection to Pervasive SQL 2000i

I am trying to make a generic hs odbc connection to a non-oracle database. My Oracle is 9.2.0.6 and The database to connect to is Pervasive SQL 2000i. However, after all the setups I thought I needed I get an error:
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC]Specified driver could not be loaded due to
system error 1114 (Pervasive ODBC Client Interface). (SQL State: 00000; SQL
Code: 160)
ORA-02063: preceding 2 lines from TEST
I believe I have set up everything needed: listener.ora, tnsnames.ora, have init<sid>.ora file etc. I actually have created one database link successfully to SQL Server 2000 right before this so the environment should be close to correct.
What could cause that kind of an error? What driver to use? The error is not that specific... The ODBC I have set up functions properly and test passes OK.
Any help would be great! Thanks, mp 
the error message you get is ODBC driver VENDOR specific. You should enable ODBC tracing and get in touch with the ODBC driver vendor to follow it up.

Categories

Resources