I have searched this forum for a possible solution but in vain. My System Stats are:
Windows XP Pro
Oracle 8i installation
Visual Basic 6
Problem:
I am trying to connect to my oracle database from Visual Basic 6.0 through the connection string as follows:
DbHairDresser.Open "Provider=msdaora.1; user id= " & UserID & "; password= " & Password & ";"
This doesn't for some reason and gives me the above error.
When I try the following connection string, it works. QUILON is my Machine name.
DbHairDresser.Open "Provider=msdaora.1; data source=quilon; user id= " & UserID & "; password= " & Password & ";"
I used to be able to work with the first method when I had my Windows 2000 OS. What could be the problem I am facing ?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Also I would like to know how do I connect to my database remotely. I have configured the TNS Listener through Net8 Configuration Wizard and tested it using Net8 Assistant. It comes with the following result:
Initializing first test to use userid: scott, password: tiger
Attempting to connect using userid: scott
The connection test was successful.
That mean my TNS Listener works fine.
Can any one[i]
Long postings are being truncated to ~1 kB at this time.