Home » Developer & Programmer » Data Integration » Connecting to Sql Server
Connecting to Sql Server [message #158639] Mon, 13 February 2006 13:04 Go to next message
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.
Re: Connecting to Sql Server [message #158725 is a reply to message #158639] Tue, 14 February 2006 01:50 Go to previous messageGo to next message
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:
  1. Create a system ODBC data link to the SQL Server
  2. Create an entry in the TNSNAMES.ORA
  3. Create an entry in the LISTENER.ORA
  4. 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 Go to previous messageGo to next message
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.
Re: Connecting to Sql Server [message #436801 is a reply to message #421636] Mon, 28 December 2009 07:10 Go to previous messageGo to next message
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?
Re: Connecting to Sql Server [message #447459 is a reply to message #436801] Mon, 15 March 2010 06:23 Go to previous message
gustavo.perez
Messages: 2
Registered: March 2010
Location: Barcelona
Junior Member
Hi have the same problem.

Any one know the solution?

Thanks!
Previous Topic: OWB environment setup
Next Topic: SQL Server source connection to OWB
Goto Forum:
  


Current Time: Thu Mar 28 03:37:27 CDT 2024