Oracle 8i connection using OLEDB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I am trying to connect to oracle 8i using OLEDB data provider for oracle using vb.net on a standalone pc. When I try to connect through Server explorer and enter following informatio
data source = empty (because there isn't any server
userid=scot
password=tige
and press button of test connection, I received message sayin
"Test connection failed because of an error in initializing provider. Oracle error occured, but error message could not be retrieved from oracle

What should I do?
 
What do you mean by no server?

You need to have a server before you can connect to a DB.
 
I mean by no server that I am using Oracle 8i and visual
studio.net on a single computer and there isn't any
network.
when I start SQL I only give username and password, host
string is left empty and sql works fine.
But when making a connection with oledb it doesn't work.\
what should I enter in data source, I have tryied my
computer name and I have left empty this field but
doesn't work same error occurs.
 
Well I know that with SQL Server, you use (local), with the brackets, Have
you tried that?

I know that PL/SQL in Oracle knows about the servers on the local machine
already but VS doesn't.

Can you see it in Server Explorer?
 
No sir,
(local) didn't work either.
There is my machine name is server explorer and I have
tried it as a server name too but the result isn't
different.
Thanks for your attention.
 
Create an alias in your TNSNames and then reference that alias in your
connection string.

Or

Go to your ODBC administrator and create a data source for the database

Provider=MSDAORA.1;Data Source=yourodbcdatasourcename;User
ID=youruserid;Password=yourpassword;
 
Back
Top