Home » RDBMS Server » Networking and Gateways » Configuring Oracle gateway for MS SQL Server
Configuring Oracle gateway for MS SQL Server [message #610806] Mon, 24 March 2014 09:30 Go to next message
Oussama
Messages: 6
Registered: March 2014
Junior Member
Hi everyone,

I have two Windows XP machines connected as a LAN : machine named oracle and another machine named sqlserver (the host name)

I have installed the Oracle database software on the first one (11g R2) and the SQL SERVER 2008 R2 software on the second one

On the SQL Server side I created a database named test with a table named table1 (for testing)

I installed and configured the Oracle gateway software on the oracle machine and created a database link to access the SQL Server data, but I'm getting the following error :


ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Driver][DBNETLIB]Invalid connection.
{08001,NativeErr = 14}[Oracle][ODBC SQL Server
Driver][DBNETLIB]ConnectionOpen (ParseConnectParams()). {01000,NativeErr =
14}[Oracle][ODBC SQL Server Driver]Invalid connection string attribute {01S00}
ORA-02063: preceding 2 lines from DBLINK



my initdg4msql file :


# This is a customized agent init file that contains the HS parameters
# that are needed for the Database Gateway for Microsoft SQL Server

#
# HS init parameters
#
HS_FDS_CONNECT_INFO=[SQLSERVER]/MSSQLSERVER/test
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER


my listener.ora file :


# listener.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(SID_NAME = dg4msql)
(ORACLE_HOME = C:\product\11.2.0\tg_1)
(ENVS = LD_LIBRARY_PATH=C:\product\11.2.0\tg_1\dg4msql\driver\lib:C:\product\11.2.0\tg_1\lib)
(PROGRAM = C:\product\11.2.0\tg_1\bin\dg4msql)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
)
)

ADR_BASE_LISTENER = C:\app\Administrator

my tnsnames.ora file :


# tnsnames.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

dg4msql =
(
DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(CONNECT_DATA = (SID = dg4msql))
(HS = OK)
)


the command I used to create the database link :


create public database link dblink connect to "sa" identified by "mssqlserver" using 'dg4msql';


Thanks in advance for any answer or help
Re: Configuring Oracle gateway for MS SQL Server [message #610807 is a reply to message #610806] Mon, 24 March 2014 09:43 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
Senior Member
http://www.lmgtfy.com/?q=ODBC+SQL+Server+Driver]Invalid+connection+string+attribute+{01S00}
Re: Configuring Oracle gateway for MS SQL Server [message #610809 is a reply to message #610807] Mon, 24 March 2014 10:19 Go to previous message
Oussama
Messages: 6
Registered: March 2014
Junior Member
I searched a lot about this but the solutions found didn't work for me
Previous Topic: Add rule to oracle connection manager
Next Topic: ORA-02062: distributed recovery received DBID
Goto Forum:
  


Current Time: Wed Oct 01 22:06:41 CDT 2014

Total time taken to generate the page: 0.09402 seconds