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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Set Datasource Location Automation

Status
Not open for further replies.
ithelpme

ithelpme

Programmer
Jul 28, 2003
1
AU
Hi World,

I have a VB6 app with Crystal 9 and Oracle 8.1.7, we are using the embeded reports within VB for reporting.

My problem comes as we have multiple instances of databases on the one server. The user selects which database to loginto within the application.

I can't figure out how to set the Service name in the report at runtime.

Ideally I want to let the report handle all the connection details...

I have played around with "SetDatascource" and "LogOn Server" and various other things but nothing seems to work.

I can do it manually through Database>Set Datascource Location..." but that is no good to my users!

Please Help! Thanks :-(
 
Status
Not open for further replies.

Similar threads

BradCustom
  • Locked
  • Question
Need help with setting a value to 0
Replies
0
Views
164
BradCustom
BradCustom
Jillp
  • Locked
  • Question
Period / Year selection criteria for Automation
Replies
3
Views
149
lbass
lbass
1tufgt
  • Locked
  • Question
Using formula to set decimal place
Replies
2
Views
161
lbass
lbass
tdrBates
  • Locked
  • Question
Highlight any record in data-set in which several fields within the record is duplicated 1
Replies
12
Views
130
tdrBates
tdrBates
kc27
  • Locked
  • Question
Want to Set Up Parameter to Filter for A String
Replies
14
Views
405
kc27
kc27

Part and Inventory Search

Sponsor

Back
Top