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!

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

Oracle VB6 connection

Status
Not open for further replies.
amandaps

amandaps

Programmer
Jan 4, 2001
1
AU
Through VB6 I am opening a crystal 6 report using the oracle native driver psdora7.dll.
My connect string in VB is:
cry1.connect = "UID = username;PWD=password;DRIVER={Oracle 7.x}; Server=ntwork1;"
This works fine when I am connecting to the server that the report was based on. When I am using a different server and passing the new server name through VB code I get the following error "Error in generating report 20599 Cannot find sql server".
Please help.
 
Status
Not open for further replies.

Similar threads

IanWaterman
  • Locked
  • Question
Oracle Commands and String Parameters 1
Replies
2
Views
116
IanWaterman
IanWaterman
Gerard70
  • Locked
  • Question
Connection to Cognos
Replies
0
Views
64
Gerard70
Gerard70
hmax
  • Locked
  • Question
Crystal Reports 2013, Oracle 11g, Command Parameters for same field, wildcard and existing results
Replies
4
Views
82
tomcat24
tomcat24
VissuPangam
  • Locked
  • Question
Crystal reports JNDI connection
Replies
0
Views
52
VissuPangam
VissuPangam
tav1035
  • Locked
  • Question
Calendar Style Report for oracle
Replies
0
Views
51
tav1035
tav1035

Part and Inventory Search

Sponsor

Back
Top