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!

Pro*C Connection error

Status
Not open for further replies.

joeGrammar

Programmer
Jun 4, 2001
162
CA
Hey guys,

I'm having a problem connection to my database with Pro*C. I have some code which requires me to include SQLCHECK=SEMANTICS and with that the code tried to connect to the database to verify datastructures... When I try to connect in Pro*C I put my username/password which works for me in SQL*PLUS, but it doesn't seem to work for Pro*C, do I need to know the connect string for Pro*C? If so where do I find that? Anyhoo, the sqlnet.log that spits out when I try to connect seems to be grabbing some environment variables to log in, how can I override this?

Thanks
 
This is just a guess, but I would try logging in to Pro*C with username/password@sid, where "sid" is the host string that you see on the SQL*Plus login screen.

If that doesn't work, please post the error message that you are getting, and the entry from the sqlnet.log.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top