I have a Windows 2000 vb6 and Crystal Reports XI development environment. I need to deploy to Windows XP (version 5.1 build 2600.xpsp_sp3_gdr.101209-1647 : Service pack 3).
I am using Visual Studio Installer process to create a Project.msi file that I run as administrator on the XP box and which installs the Project successfully.
I recieve the error(in title) when I try to run the project - first thing in the project is to open database access using the code
strcn = "ODBC;DSN=LocalServer;UID=sa;PWD='pallas';DATABASE=Miners Live Database"
Set myworkspace = DBEngine.CreateWorkspace("ODBCWorkspace", "", "", dbUseODBC)
Set Dbgeneral = myworkspace.OpenConnection("", dbDriverNoPrompt, False, strcn)
Dbgeneral.QueryTimeout = 120 'Default 30 secs may not be enough
This code certainly woks for Windows 2000 environment.