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!
-
Setting SQL Database on the fly in VB
Sorry Folks I cracked it shortly after. Isn't that always the way. The solution for those who need it is CrystalReport1.Connect = "DSN=NewServer; UID=UID; PWD=PWD; DSQ=NewTable;" I thought that DSN= was only for ODBC but it also works with SQL. I hope this helps somebody else...- Rothweld
- Post #2
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Setting SQL Database on the fly in VB
Hi all I have a problem moving reports between servers. I need to be able to tell a report which SQL server and database to log onto through code. I know that I can set the loaction while writing the report but I need to be able to send these reports to people who have absolutely no technical...- Rothweld
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 4 Other topics
