topic Re: ODBC between oracle DB and Ms SQL in Operating System - HP-UX

ODBC between oracle DB and Ms SQL

tom quach_1 — Fri, 02 May 2008 15:49:31 GMT

Dear all,

hope that someone has experience with the connection between oracle database accesses Ms SQL using ODBC.
i did download a trial version of ODBC from datadirect.com installed on HPUX 11.11 and connect to MS SQL server. the connection is fine. i can retrieve data on MS SQL server from HPUX.
But it does not return all columns in a table because of the data type. It can only see INT, CHAR, DATETIME. It could not see VARCHAR, NCHAR...
Would you please help me on data conversion or point me to document regarding this issue.

Thanks in advance.
Regards-Tom

Re: ODBC between oracle DB and Ms SQL

Yogeeraj_1 — Tue, 06 May 2008 12:56:31 GMT

hi,

did you have a look the thread we had recently on something similar?

http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1227388

hope this helps!
kind regards
yogeeraj

Re: ODBC between oracle DB and Ms SQL

tom quach_1 — Tue, 06 May 2008 14:51:02 GMT

Thanks yogeeraj,

i've looked at that thread.

Thanks again
Tom

Re: ODBC between oracle DB and Ms SQL

TwoProc — Tue, 06 May 2008 15:00:03 GMT

Tom,

If you get tired of trying ODBC, I believe that Oracle sells a SQLServer gateway product to get you from an Oracle connection to SQLServer hosted data. I've no experience in using it however.