RE: Transparent Gateway for MSSQL not working
- From: "Fatoric, Patricia" <FATORIP@xxxxxxxx>
- To: <gabriel.aragon@xxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 7 Apr 2005 13:41:23 -0400
Hi Gabriel,
From Metalink 231997.1
Try:
HS_FDS_CONNECT_INFO=3D"SQLSERVER\\instance2.Northwind"=20
HTH
Patricia
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Aragon, Gabriel (GE
Commercial Finance)
Sent: Thursday, April 07, 2005 1:07 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Transparent Gateway for MSSQL not working
Hi list,
I was using TG from 9.2 Win2k to SQL2k w/o problems, in the =3D
initmssql.ora file located on oracle_home\TG4MSQL, the configuration =3D
was:=3D20
HS_FDS_CONNECT_INFO=3D3D"SERVER=3D3DXX1;DATABASE=3D3DORACLEDB"
but the original xx1 sql db was recreated as xx1\xx1:
HS_FDS_CONNECT_INFO=3D3D"SERVER=3D3DXX1\XX1;DATABASE=3D3DORACLE_GATEWAY"
but this is not working, checking metalink docs says that for =3D
server/instance syntaxis you have to use: <server>.<dbname>, but I also =
=3D
tried replacing "/" with dot "." and still not working. If someone has =
=3D
some experiencie specifying sql db's using this syntaxis or has some =3D
suggestion, pls share it. The rest of the configuration is the same as =
=3D
the original one.
TIA
Gabriel
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
