setDatabase: I can^t make it work.
Posted: Sat May 18, 2002 4:52 pm
I^m using the Viewer DLL (SQL Version 9) in VB6 to display a report via the web. I cannot seem to get the setDatabase function to work.____My application has a number of nearly-identical databases for multiple companies. I would like to have just one DSN and be able to redirect a report to a different default database at run time using that DSN.____Using the setDatabase function to change the database gives me a return code of "1", but executing the report fails with error code "R", description "Cannot access master table..."____Database is SQL Server 2000.____Is it possible to do what I want? How?____Thanks in advance,____ -- John