OraFAQ Forum: Data Integration » Connecting to Sql Server

Home » Developer & Programmer » Data Integration » Connecting to Sql Server

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connecting to Sql Server [message #158639]

Mon, 13 February 2006 13:04

jabs12
Messages: 5
Registered: February 2006
Location: Cleveland

Junior Member

Hello -

Has anyone successfully connected to Sql Server as a source with OWB 10G? I'm having some trouble, as explained in an earlier forum query, and I want to make sure that there are successes out there already.

Thanks in advance,

Joe.

Report message to a moderator

Re: Connecting to Sql Server [message #158725 is a reply to message #158639]

Tue, 14 February 2006 01:50

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Isn't SQL Server natively supported? If not, you could add a System DSN (ODBC data source) on the OWB machine and create a HS service. That's how we connect to Progress and Sybase here. It has its limits but seems to work.

Do it as follows:

Create a system ODBC data link to the SQL Server
Create an entry in the TNSNAMES.ORA
Create an entry in the LISTENER.ORA
Create an INITyourODBCSID.ORA in the HS directory of your Oracle Home.

Afterwards, you can create a database link in OWB.

MHE

[Updated on: Tue, 14 February 2006 01:57]

Report message to a moderator

Re: Connecting to Sql Server [message #421636 is a reply to message #158639]

Wed, 09 September 2009 10:17

palazzi
Messages: 11
Registered: June 2009
Location: Toluca

Junior Member

Hi.

In fact there is a complete Oracle's guide.

Please read from page 9-6 of the Oracle Warehouse Builder User's Guide 11g release 1, "Using SQL Server as a Source".

This is for 11g.

You can download this PDF from oracle's site.

Report message to a moderator

Re: Connecting to Sql Server [message #436801 is a reply to message #421636]

Mon, 28 December 2009 07:10

edumelo
Messages: 1
Registered: December 2009
Location: São Paulo, Brazil

Junior Member

palazzi wrote on Wed, 09 September 2009 12:17

Hi.

In fact there is a complete Oracle's guide.

Please read from page 9-6 of the Oracle Warehouse Builder User's Guide 11g release 1, "Using SQL Server as a Source".

This is for 11g.

You can download this PDF from oracle's site.

Hello all,

I've read the OWB User's guide and tried to connect to the SQL Server source, but it's not working. I've made the configuration exactly as shown in "Using SQL Server as a Source", and I'm facing the following error:

ORA-28545: erro diagnosticado pelo Net8 ao conectar com um agente (Error found by Net8 when connecting to an agent).
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: precedendo 2 lines a partir de OWB_88

My ODBC connection is working.

Does anyone know how to fix this error?

Report message to a moderator

Re: Connecting to Sql Server [message #447459 is a reply to message #436801]

Mon, 15 March 2010 06:23

gustavo.perez
Messages: 2
Registered: March 2010
Location: Barcelona

Junior Member

Hi have the same problem.

Any one know the solution?

Thanks!

Report message to a moderator

Previous Topic:	OWB environment setup
Next Topic:	SQL Server source connection to OWB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 11:14:18 CST 2024