OraFAQ Forum: Forms » ODBC connection

Home » Developer & Programmer » Forms » ODBC connection

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

ODBC connection [message #263179]

Wed, 29 August 2007 05:04

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

Report message to a moderator

Re: ODBC connection [message #263374 is a reply to message #263179]

Wed, 29 August 2007 21:21

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have a look at http://www.orafaq.com/forum/m/172737/67467/?srch=odbc+tnsnames#msg_172737

David

Report message to a moderator

Re: ODBC connection [message #264161 is a reply to message #263179]

Sat, 01 September 2007 04:52

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

Report message to a moderator

Re: ODBC connection [message #264372 is a reply to message #264161]

Mon, 03 September 2007 02:31

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Did you define it in the tnsnames.ora?

David

Report message to a moderator

Re: ODBC connection [message #264377 is a reply to message #264372]

Mon, 03 September 2007 02:37

ewa4u
Messages: 14
Registered: August 2007

Junior Member

Report message to a moderator

Re: ODBC connection [message #264380 is a reply to message #264377]

Mon, 03 September 2007 02:39

ewa4u
Messages: 14
Registered: August 2007

Junior Member

How I can do that,
please explain it step by step

Report message to a moderator

Re: ODBC connection [message #264675 is a reply to message #264380]

Tue, 04 September 2007 02:59

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

Report message to a moderator

Re: ODBC connection [message #264959 is a reply to message #264675]

Wed, 05 September 2007 02:06

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: ODBC connection [message #265006 is a reply to message #264959]

Wed, 05 September 2007 04:16

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

Report message to a moderator

Re: ODBC connection [message #266170 is a reply to message #265006]

Mon, 10 September 2007 01:44

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please post the code that you are now using.

David

Report message to a moderator

Re: ODBC connection [message #266767 is a reply to message #266170]

Tue, 11 September 2007 10:35

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

Report message to a moderator