Data view problem

[mnongkhlaw]

Dear all,

Some wiered thing happened. I have a Visual Interdev 6 Enterprise app using a data connection to a database file (mdb). The app was running fine and the data view showed the correct database. Initially, I used an easy-to-guess name for the database and it was located in another folder (not the application's root). Since the site was to be deployed in a production server, I changed that name to another (supposedly harder to guess) one and also stored the mdb file in the application's root directory. I changed the connection object to point to this new name and directory, but surprise of surprises, the Data view still showed my old database name and old location, although global.asa's connection string now points to the new name and new location.

More surprises was in store: I copied the site to another machine and tried to run it. It ran fine!

Now what's this going on? And how can I resolve it?

TIA
Mark.

 

[MerlinB]

The DataView stores the connection details in global.asa AND in _private/dataEnvironment/dataEnvironment.asa. This can only be edited via the pop-up dialog boxes.

If you only use the Application("cn_...&quot settings in your code, and place SQL directly into the recordsetDTC - and do not use DataEnvironment commands (right-click on a connection in the global.asa file to add them), then this DataEnvironment.asa copy is only used at design-time.

http://www.corporateinternet.com

 

[mnongkhlaw]

Thanks MerlinB. The connection string in the command object was the culprit; I observed that it was not updated to reflect the new connection. After I corrected it, it ran without a hitch.

Mark Nongkhlaw