URGENT!!! How to switch DB with VB6 and CR8.5?
Posted on 2003-12-12
We have 2 environments : Development and Live, and reports are being moved from one to another.
Problem is that the reports point to different db's on different servers.
I want to make the db switch from a VB6 application (or VB.NET) so that there is no manual action needed.
The DB is a SQL Server 2000 and the connection in the reports is defined as OLEDB for SQL Server.