Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Transparent Gateway for MSSQL not working
Hi list,
I was using TG from 9.2 Win2k to SQL2k w/o problems, in the = initmssql.ora file located on oracle_home\TG4MSQL, the configuration = was:=20
HS_FDS_CONNECT_INFO=3D"SERVER=3DXX1;DATABASE=3DORACLEDB" but the original xx1 sql db was recreated as xx1\xx1:
HS_FDS_CONNECT_INFO=3D"SERVER=3DXX1\XX1;DATABASE=3DORACLE_GATEWAY" but this is not working, checking metalink docs says that for = server/instance syntaxis you have to use: <server>.<dbname>, but I also = tried replacing "/" with dot "." and still not working. If someone has = some experiencie specifying sql db's using this syntaxis or has some = suggestion, pls share it. The rest of the configuration is the same as = the original one.
TIA
Gabriel
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 07 2005 - 13:11:53 CDT
![]() |
![]() |