By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,558 Members | 1,399 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,558 IT Pros & Developers. It's quick & easy.

unable to connect oracle9i with vb6

P: 7
Hi pals..

i hav developed an application in vb nd am tryin to connect using oracle..

it gives the following error using ADODC and ODBC

"test connection failure because of an error in initializing provider.[microsoft][odbc]driver for oracle]"

please help..
Sep 5 '07 #1
Share this Question
Share on Google+
11 Replies


debasisdas
Expert 5K+
P: 8,127
kindly post your connection string for my reference.
Sep 5 '07 #2

QVeen72
Expert 100+
P: 1,445
Hi,

Use this Connection string :

Expand|Select|Wrap|Line Numbers
  1. ConnStr = "UID=username;PWD=password;" _
  2.         & "Server=OSName;Driver={Microsoft ODBC For Oracle}" _
  3.         & ";DSN = ''"
  4.  
OSName in the above is the Oracle Client's Net Configuration Name...
First u have to configure the Client..

Regards
Veena
Sep 5 '07 #3

P: 7
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.
3. the next click asks for the server name, the user name and pwd.
4. testing connection after feeding "scott/tiger", gives error, it says "Connection fails.error while initializing provider, the error could not be recovered from oracle".
5. Even if i set the server name to oracle9i , it doesnt work giving the same error.

Thanks a lot for devoting time to my problems.
Sep 7 '07 #4

QVeen72
Expert 100+
P: 1,445
hI,

U HAVE TO GIVE "Server Name" as the NetConfig Client Name. And Why use Scott/Tiger..? Create a User /pwd in Oracle for ur Schema and give that..

REgards
Veena
Sep 7 '07 #5

P: 7
hi,
how do i find what is my net config client name?
Sep 8 '07 #6

QVeen72
Expert 100+
P: 1,445
Hi,

After Installing the Oracle Client, u have to do configure the Client using the "Net Configuration Assistant", by giving the Global Database name and option "Local Net Service Name Configuration" and Give the Host Name.
At the end of it, it will ask the Name, there provide some name. So whenevr u connect to oracle, u have to Refer that as ServerName...


REgards
Veena
Sep 8 '07 #7

P: 7
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.

thanks & regards
Mishika
Sep 10 '07 #8

QVeen72
Expert 100+
P: 1,445
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.

thanks & regards
Mishika
Hi,

Did u configure the Local Net Name using the "Net Configuration Assistant"...?
First u have to do that.. see my previous post how to create it..
To Export, use "Exp" in command prompt, and follow the Instructions on the screen, and Export the Tables to a Dump File.
And to Import those tables, use "Imp" at the command prompt.

One more way of creating tables from one schema to another is run this SQL Statement (provided u have Priviliges to Create Table)

Create Table NewSchema.MyTableName As Select * From OldSchema.MyTableName

If the table being created is already present in the NewSchema, u will get an Error, Probably u may have to drop the Table before creating it...

Regards
Veena
Sep 10 '07 #9

P: 7
hi,

Thanks a ton...will try n tell u.
Sep 11 '07 #10

P: 7
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> exp table_name to A;

none of them worked also i tried
sql> help exp;
which said no help available..

the project deadline is approaching...kindly help..
Sep 15 '07 #11

P: 7
Hi,

Did u configure the Local Net Name using the "Net Configuration Assistant"...?
First u have to do that.. see my previous post how to create it..
To Export, use "Exp" in command prompt, and follow the Instructions on the screen, and Export the Tables to a Dump File.
And to Import those tables, use "Imp" at the command prompt.

One more way of creating tables from one schema to another is run this SQL Statement (provided u have Priviliges to Create Table)

Create Table NewSchema.MyTableName As Select * From OldSchema.MyTableName

If the table being created is already present in the NewSchema, u will get an Error, Probably u may have to drop the Table before creating it...

Regards
Veena




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> exp table_name to A;

none of them worked also i tried
sql> help exp;
which said no help available..

the project deadline is approaching...kindly help..
Sep 18 '07 #12

Post your reply

Sign in to post your reply or Sign up for a free account.