Oracle 8i connection using OLEDB

[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?

 

[Gerry O'Brien [MVP]]

What do you mean by no server?

You need to have a server before you can connect to a DB.

 

[Rao]

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.

 

[Gerry O'Brien [MVP]]

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?

 

[Rao]

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.

 

[Eric]

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;

 

[Rao]

Can you please guide me through to the steps of creating
an alias in TNSNames?