Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

file locking and ODBC

Status
Not open for further replies.

cloudwalking

Programmer
Feb 25, 2002
1
US
hey... we have a goofy situation. we have an access file, which sits in a CVS repository. this access file is regularly updated by the users here. when this access file changes, users can go to an ASP page which calls a command script. the script grabs the latest version of this access database and then connects to this database via ODBC to regenerate a series of HTML files based on the latest data.

the moral of the story is, i would like some way to "shut down" odbc during this process. we are seeing some funny behavior with the data not updating, and i'm hesitantly attributing it to the odbc / dsn putting some sort of lock on the file. something like, 'net stop odbc'. the server is win2k advanced. thanks for any help :)

john
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top