 ORA-03121 [message #633628] |
Mon, 23 February 2015 06:23  |
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  |
cookiemonster
Messages: 13963
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 |
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 |
cookiemonster
Messages: 13963
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 |
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 |
cookiemonster
Messages: 13963
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 |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
