Home » Developer & Programmer » Forms » ORA-03121
icon5.gif  ORA-03121 [message #633628] Mon, 23 February 2015 06:23 Go to next message
kuwait
Messages: 55
Registered: October 2007
Member
Hi,

I'm Using windows Server 2003 Oracle 9i Trying to link to external MS ACCESS DB (.mdb file)

I created a database link to a dns pointing to MS ACCESS DB I'm able to query my Access DB tables through sql*plus, but when trying to connect to it through oracle forms developer 6i
using:

username/password@ODBC:(my dns name)

it won't connect and gave me the following error

ORA-03121: no interface driver connected - function not performed

Any Clue is appreciated

[Updated on: Mon, 23 February 2015 06:32]

Report message to a moderator

Re: ORA-03121 [message #633632 is a reply to message #633628] Mon, 23 February 2015 07:19 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
There's a big difference between:
creating a database link, logging on as the owner of the link and using it to query tables in the remote DB.
and:
trying to log onto the remote DB directly.

From your description you appear to be doing the later in forms.
You need to log onto the oracle DB as the owner of the DB link.
Re: ORA-03121 [message #633633 is a reply to message #633632] Mon, 23 February 2015 07:57 Go to previous messageGo to next message
kuwait
Messages: 55
Registered: October 2007
Member
Thanks for your reply

Ok you mean in the forms builder 6i I did connect with the owner of the db link but couldn't find anything for my database link I tried form wizard no tables for that MS ACCESS
and tried to make a query to print
message(select <filed> from <table_name>@<my dns name>) but gives error when running
Re: ORA-03121 [message #633639 is a reply to message #633633] Mon, 23 February 2015 10:02 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Well no the wizards will not try and see anything at the other end of the DB link, you can either:
a) skip the wizards and set all block properties manually.
b) create views in the local DB that query the relevant tables in the access DB. The form builder wizards will be able to see the views.
Re: ORA-03121 [message #633669 is a reply to message #633639] Tue, 24 February 2015 03:05 Go to previous messageGo to next message
kuwait
Messages: 55
Registered: October 2007
Member
Thanks for your suggestion,

Problem Partially resolved I've installed ODBC driver for Form 6i and now I'm able to query my MS ACCESS DB but not able to query all columns it give me error 201 identifier must be declared
and there's columns that can be queried and identified I'll try to search for this and any clue is appreciated

If I don't find any solution I'll try to do your suggestion by creating views

Thanks again
Re: ORA-03121 [message #633671 is a reply to message #633669] Tue, 24 February 2015 03:12 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
The column problem is probably a case issue. Oracle column names are upper case by default, I have no idea what case access names are by default, but if they're not upper case that's most likely the cause.
Re: ORA-03121 [message #633677 is a reply to message #633671] Tue, 24 February 2015 03:52 Go to previous messageGo to next message
kuwait
Messages: 55
Registered: October 2007
Member
Yes you're right I figured out I can query the columns that with upper case, so how can i resolve this without renaming my ACCESS DB columns to upper case
Re: ORA-03121 [message #633683 is a reply to message #633677] Tue, 24 February 2015 04:02 Go to previous messageGo to next message
kuwait
Messages: 55
Registered: October 2007
Member
I tried to use double quotes " and it works for lower case columns name, but for the columns with both upper and lower cases won't identified gives error 201.

[Updated on: Tue, 24 February 2015 04:04]

Report message to a moderator

icon7.gif  Re: ORA-03121 [message #633688 is a reply to message #633683] Tue, 24 February 2015 04:26 Go to previous message
kuwait
Messages: 55
Registered: October 2007
Member
Thanks cookiemonster,

It was my mistake I've to write the column name with exact case between the double quotes now it works fine.

Shokraaan Smile
Previous Topic: Show data from a table in hierarchical way
Next Topic: FRM-47343 - Invalid node ID specified for hierarchical tree item
Goto Forum:
  


Current Time: Fri Mar 29 00:18:49 CDT 2024