Home » Developer & Programmer » Forms » ODBC connection
ODBC connection [message #263179] Wed, 29 August 2007 05:04 Go to next message
ewa4u
Messages: 14
Registered: August 2007
Junior Member
hi all

I use ODBC to open Access data base , so I wrote this code

BEGIN
connection_id := EXEC_SQL.OPEN_CONNECTION('enas/enas@ODBC:odbc_test');
EXCEPTION
WHEN EXEC_SQL.PACKAGE_ERROR
THEN
message(' connection open failed ');
END;

but the connection faild

I use developer6i and Access2003

Can any one help me

Re: ODBC connection [message #263374 is a reply to message #263179] Wed, 29 August 2007 21:21 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have a look at http://www.orafaq.com/forum/m/172737/67467/?srch=odbc+tnsnames#msg_172737

David
Re: ODBC connection [message #264161 is a reply to message #263179] Sat, 01 September 2007 04:52 Go to previous messageGo to next message
ewa4u
Messages: 14
Registered: August 2007
Junior Member
hi all

I used ODBC with EXEC_SQL package

I want only know the reason of this error, why the connection can not open

please help me
Re: ODBC connection [message #264372 is a reply to message #264161] Mon, 03 September 2007 02:31 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Did you define it in the tnsnames.ora?

David
Re: ODBC connection [message #264377 is a reply to message #264372] Mon, 03 September 2007 02:37 Go to previous messageGo to next message
ewa4u
Messages: 14
Registered: August 2007
Junior Member
No
Re: ODBC connection [message #264380 is a reply to message #264377] Mon, 03 September 2007 02:39 Go to previous messageGo to next message
ewa4u
Messages: 14
Registered: August 2007
Junior Member
How I can do that,
please explain it step by step
Re: ODBC connection [message #264675 is a reply to message #264380] Tue, 04 September 2007 02:59 Go to previous messageGo to next message
ewa4u
Messages: 14
Registered: August 2007
Junior Member
hi all

I use Oracle ODBC Test to test the connection
the connection was successful but when I use it in the code (which I mentioned above)the connection can not open

please help me
Re: ODBC connection [message #264959 is a reply to message #264675] Wed, 05 September 2007 02:06 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have a look at the link in my message near the top of this thread. All the information you require is in there.

David
Re: ODBC connection [message #265006 is a reply to message #264959] Wed, 05 September 2007 04:16 Go to previous messageGo to next message
ewa4u
Messages: 14
Registered: August 2007
Junior Member
hi all

thanks David

I do the same thing in the link but the connection still not work although it is work in Oracle ODBC Test

regards
Re: ODBC connection [message #266170 is a reply to message #265006] Mon, 10 September 2007 01:44 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please post the code that you are now using.

David
Re: ODBC connection [message #266767 is a reply to message #266170] Tue, 11 September 2007 10:35 Go to previous messageGo to next message
ewa4u
Messages: 14
Registered: August 2007
Junior Member
Hi all

I still have the problem
this the code I used

BEGIN
connection_id := EXEC_SQL.OPEN_CONNECTION('enas/enas@ODBC:odbc_test');
EXCEPTION
WHEN EXEC_SQL.PACKAGE_ERROR
THEN
message(' connection open failed ');
END;

thanks


Re: ODBC connection [message #267829 is a reply to message #266767] Sat, 15 September 2007 07:54 Go to previous messageGo to next message
ewa4u
Messages: 14
Registered: August 2007
Junior Member
Hi all

Where are you?

I still have the problem

Re: ODBC connection [message #268217 is a reply to message #267829] Tue, 18 September 2007 00:16 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Testing your code is on my 'to do' list. Unfortunately, I have a few other things I have to do before getting to your problem.

David
Re: ODBC connection [message #268467 is a reply to message #268217] Tue, 18 September 2007 15:50 Go to previous message
ewa4u
Messages: 14
Registered: August 2007
Junior Member
thanks David for your interest
Previous Topic: FRM-18122: Form Builder Debugger failed to initialize
Next Topic: Called Form Debugging
Goto Forum:
  


Current Time: Sat Dec 10 14:37:20 CST 2016

Total time taken to generate the page: 0.10827 seconds