Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADO connection issues....

Status
Not open for further replies.

PogoWolf

Programmer
Mar 2, 2001
351
US
Hello all! =)

I'm hoping this is an easy question..
I'm working in VB 6.0 (sp5) trying to connect to a Oracle server with ADO.

The issue is that the connection must DSN-Less for I'm trying to create a totally stand-alone EXE.

the current connection I'm useing is:
Conn.Open "Provider=msdaora;Data Source=Server;User Id=User;Password=PassWord;"

it seems that the 'server' var though is figureing out where the machine is though our TNSNAMES.ora file.
(installed with an Oracle Client) and what I'm trying to do is bypass this client...

any ideas? suggestions?

Thank you all!


******
Darkness... Bleakness...
and Plastic forks...
--The PogoWolf
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top