User Profile

Mishika9486 · Sep 18 '07, 06:59 AM

Hi,

I configured the net config client and gave the server name as well as the host name but in vain. the oracle connection is giving the same eror.

"Error in initializing provider. we cannot retrieve error report from oracle."

Also, the EXP command on SQL prompt is giving the following error SP2-0734.
It says statement not completed.
i wrote
sql> exp;
sql>...

Mishika9486 · Sep 15 '07, 12:31 PM

Hi,

I configured the net config client and gave the server name as well as the host name but in vain. the oracle connection is giving the same eror.

"Error in initializing provider. we cannot retrieve error report from oracle."

Also, the EXP command on SQL prompt is giving the following error SP2-0734.
It says statement not completed.
i wrote
sql> exp;
sql>...

Mishika9486 · Sep 11 '07, 07:42 AM

hi,

Thanks a ton...will try n tell u.

Mishika9486 · Sep 10 '07, 08:07 AM

Hi,
I had given the gds name as oracle9i at the time of installation.
I dont use the server name while logging on, i directly logon with user/pwd.
I had given oracle9i while connectivity before alos but it is not working.

kindly suggest..

Also, how can i import a set of tables from one schema to another?

Giving the privilege for all table is not serving the purpose.

...

Mishika9486 · Sep 8 '07, 08:03 AM

hi,
how do i find what is my net config client name?

Mishika9486 · Sep 7 '07, 07:04 AM

Hi,

Thanks a lot. I could achieve it through ODBC driver .But the application has become really slow. it nearly hangs while fetching the data.

Also the problem still persists when i use " microsoft oledb provider for oracle".
the steps i follow are as below:
1. set the ado data control on form, click to set the properties of Adodc.
2. Choose build for conn str, microsoft ole db for oracle....

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

unable to connect oracle9i with vb6