Data view problem

[mnongkhlaw]

Dear all,

Please do not mind, I didn't get a response from the VI forum, so I'm reposting here :-

Some wierd 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 in Project Explorer. 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, and my ISP does not allow mdb file to be stored in another ddirectory on the 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 with Win98/95 and PWS and tried to run it. It ran fine!

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

TIA
Mark.

 

[Targol]

Do you use ODBC to reach your db and, if yes, did you change your odbc data source tou point to new mdb ?
Another point : you say your connection string is defined in Global.asa. Where exactly ? In Application_OnStart, Session_onStart or ouside any sub ? Water is not bad as long as it stays out human body ;-)

 

[mnongkhlaw]

Thank you. No I used OLEDB connection string. I resolved the problem myself. Right-clicking the connection object-Properties and editing the connection string in the dialog box to point to my new db location did it.

Mark.