OraFAQ Forum: Data Integration » OWB Message: API4020: The database link type is not consistent with the module type

Home » Developer & Programmer » Data Integration » OWB Message: API4020: The database link type is not consistent with the module type

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

OWB Message: API4020: The database link type is not consistent with the module type [message #158407]

Fri, 10 February 2006 10:46

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.

Report message to a moderator

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

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.

Report message to a moderator

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

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...

Report message to a moderator

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

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

Report message to a moderator

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

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.

Report message to a moderator

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

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....

Report message to a moderator

Previous Topic:	Problem in Deploying Target Schema
Next Topic:	ORA-31466: no publications found

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 28 01:39:16 CST 2024