Home » Developer & Programmer » Warehouse Builder » OWB Message: API4020: The database link type is not consistent with the module type
OWB Message: API4020: The database link type is not consistent with the module type [message #158407] Fri, 10 February 2006 10:46 Go to next message
jabs12
Messages: 5
Registered: February 2006
Location: Cleveland
Junior Member
Hi all,

I'm trying to create a source module on OWB10g (10.1) that connects to SQL Server. I have a database link that works in SQL, but I get the following API error when I try to select a database link for the module.

API4020: The database link type is not consistent with the module type

I'm at a loss and there is very little info out there to help with this.

Specs:
OWB10g release 1 (v10.1)
Oracle DB: 9.2
SQL Server DB: 2000
my OS: XP Pro

Thanks for any help - and let me know if you need more info.

Joe.
Re: OWB Message: API4020: The database link type is not consistent with the module type [message #159169 is a reply to message #158407] Thu, 16 February 2006 08:36 Go to previous messageGo to next message
jabs12
Messages: 5
Registered: February 2006
Location: Cleveland
Junior Member
For future reference - The problem I had in creating this data source was that I was trying to use the source named 'SQL Server'. The solution was to use the ODBC source, since I was connecting via ODBC, and not use SQL Server. Problem solved.

Thanks,
Joe.
Re: OWB Message: API4020: The database link type is not consistent with the module type [message #165034 is a reply to message #158407] Tue, 28 March 2006 02:11 Go to previous messageGo to next message
mrcool
Messages: 6
Registered: March 2006
Junior Member
Hi..I got the same error as u got..plz can u tell me the steps in detail...

1ST Step: I created new datasoure...In that I selected SQL server driver.
2 Step:I gave one name and selected the server..

I configured listner and TNSnames.ora...and tested the link its working fine...Please help me where its going wrong....I have to use any other drivers?
In OWB iam creating new source for SQL server...

Thanks in advance...
Re: OWB Message: API4020: The database link type is not consistent with the module type [message #165077 is a reply to message #159169] Tue, 28 March 2006 04:46 Go to previous messageGo to next message
mrcool
Messages: 6
Registered: March 2006
Junior Member
Thanks jabs ur posting helped me a lot....But a small doubt what's the use of SQL Server data source....?


THanks,
Mrcool
Re: OWB Message: API4020: The database link type is not consistent with the module type [message #165133 is a reply to message #165077] Tue, 28 March 2006 07:45 Go to previous messageGo to next message
jabs12
Messages: 5
Registered: February 2006
Location: Cleveland
Junior Member
>what's the use of SQL Server data source....?

good question - It does seem irrelevent if we need to connect via ODBC.
Re: OWB Message: API4020: The database link type is not consistent with the module type [message #165291 is a reply to message #158407] Wed, 29 March 2006 04:54 Go to previous message
mrcool
Messages: 6
Registered: March 2006
Junior Member
IS there any other way to connect to SQL server otherthan ODBC? I mean to use SQl Server DataSource directly instead of ODBC....
Previous Topic: Problem in Deploying Target Schema
Next Topic: ORA-31466: no publications found
Goto Forum:
  


Current Time: Sun Dec 21 07:35:31 CST 2014

Total time taken to generate the page: 0.07913 seconds