Connect to Oracle Database

[ipmurali]

I tried the single line connection code like this
cn.Open "Provider=MSDAORA.1;Data Source=Personal Oracle7;User Id=SCOTT;Password=TIGER;"
but am getting error message like this
"Runtime error - 2147467259(80004005)
ORA-12154-TNS:Could not resolve service name"
I am using Personal Oracle 7.3.4
I think the error is in Data Source string
Please help me
thanks

[Clunietp]

I believe the Data Source is the name of the computer that your DBMS resides on. (for client/server databases anyways)

Is Personal Oracle7 the name of your DB server?

[ipmurali]

My computer name is Lakshmi, which i am given in the Idendification tab of network properties. I replaced Personal Oracle7 with Lakshmi, but still the same problem persists what could be the reason
thanks

[ipmurali]

"Microsoft OLE DB Provider for Oracle: Tips Tricks And Traps"

Where i will get the above mentioned book.

[JHausmann]

According to the MSDN library (the one that ships with VB6), under the topic of "Accessing a Data Source", it indicates (in tabular format) that the value of "Data Source" should be set to "path to server".

You also might want to take a look at:

"Microsoft OLE DB Provider for Oracle: Tips Tricks And Traps"

[This message has been edited by JHausmann (edited 01-12-2000).]