Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Transparent Gateway for MSSQL not working

Transparent Gateway for MSSQL not working

From: Aragon, Gabriel (GE Commercial Finance) <gabriel.aragon_at_ge.com>
Date: Thu, 7 Apr 2005 13:07:12 -0400
Message-ID: <84B673E70D068347A2F54A51457E5C27CB72E1@CINMLVEM05.e2k.ad.ge.com>


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-l
Received on Thu Apr 07 2005 - 13:11:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US