Printable View
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
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?
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
"Microsoft OLE DB Provider for Oracle: Tips Tricks And Traps"
Where i will get the above mentioned book.
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).]