Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

ODBC between oracle DB and Ms SQL

tom quach_1
Super Advisor

ODBC between oracle DB and Ms SQL

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


3 REPLIES
Yogeeraj_1
Honored Contributor

Re: ODBC between oracle DB and Ms SQL

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
tom quach_1
Super Advisor

Re: ODBC between oracle DB and Ms SQL

Thanks yogeeraj,

i've looked at that thread.

Thanks again
Tom
TwoProc
Honored Contributor

Re: ODBC between oracle DB and Ms SQL

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.
We are the people our parents warned us about --Jimmy Buffett