ODBC between oracle DB and Ms SQL

[tom quach_1]

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

[Yogeeraj_1]

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

[tom quach_1]

Thanks yogeeraj,

i've looked at that thread.

Thanks again
Tom

[TwoProc]

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.