Author |
Topic  |
paarlberg
New Member

74 Posts |
Posted - 08 July 2002 : 15:07:06
|
I have received several file already in use errors when trying to open a topic. The error was ODBC based and referred to link.asp.
How can I prevent this?
thxs
|
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 08 July 2002 : 15:36:46
|
Switch to an OLEDB driver may help a bit. Use one of the connection strings with Jet 4.0 in it. Try that and let me know. It's also possible that this results from too many simultaneous users. If it persists after you change the driver, maybe it's time to start thinking about upgrading to SQL Server.
------------------------------------------------- Installation Guide | Do's and Dont's | MODs |
 |
|
Doug G
Support Moderator
    
USA
6493 Posts |
|
paarlberg
New Member

74 Posts |
Posted - 08 July 2002 : 19:48:24
|
quote:
Switch to an OLEDB driver may help a bit. Use one of the connection strings with Jet 4.0 in it. Try that and let me know. It's also possible that this results from too many simultaneous users. If it persists after you change the driver, maybe it's time to start thinking about upgrading to SQL Server.
Here is the driver I am using now! strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=x:\forums.mdb" ' MS Access 2000
Thanks
|
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 08 July 2002 : 20:06:08
|
That looks like the correct one, but I don't see how you could get ODBC error messages with that driver...
------------------------------------------------- Installation Guide | Do's and Dont's | MODs |
 |
|
paarlberg
New Member

74 Posts |
Posted - 12 July 2002 : 10:10:55
|
quote:
That looks like the correct one, but I don't see how you could get ODBC error messages with that driver...
I meant OLEDB... sorry. I am still getting it with 2 users connected. It isn't all the time, but enough to be a pain. I have another forum on the same machine that is empty and no users... got it there as well.
Maybe I need to do a complete reconfig from scratch on my forum. I think I may have screwed something up early in the original install of a mod. I may have copied one of the mod files over the existing file. OOOPS! |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 12 July 2002 : 12:44:55
|
Are you still using the Snitz original database file? If so, convert it to Access 2000 or 2002. I don't know what else to suggest.
Maybe it's also a driver/server problem. Try to download the latest Jet service pack and see if it helps.
------------------------------------------------- Installation Guide | Do's and Dont's | MODs |
 |
|
paarlberg
New Member

74 Posts |
Posted - 13 July 2002 : 12:19:43
|
quote:
Are you still using the Snitz original database file? If so, convert it to Access 2000 or 2002. I don't know what else to suggest.
Maybe it's also a driver/server problem. Try to download the latest Jet service pack and see if it helps.
I have upgraded to Access 2000, driver ahs been updated along with the lastest Jet SP.
Here is the error I am getting..
Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.
/link.asp, line 47
DE
|
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
paarlberg
New Member

74 Posts |
Posted - 13 July 2002 : 13:30:50
|
quote:
This Microsoft support link seems to indicate this may be a permissions problem. Try to apply the recommendations there.
I don't believe it is a permissions problem. If I refresh the screen 1 or 2 times it will go away!
It doesn't happen very often. A few times a day.
Thanks
DE
|
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
paarlberg
New Member

74 Posts |
Posted - 13 July 2002 : 14:16:17
|
quote:
Well, I don't know what else to do, sorry.
------------------------------------------------- Installation Guide | Do's and Dont's | MODs
makes 2 of us...
hmmmmm....
thanks
|
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 13 July 2002 : 14:23:45
|
I gather that you're using this in your computer? Do you have any other apps accessing the database?
------------------------------------------------- Installation Guide | Do's and Dont's | MODs |
 |
|
Doug G
Support Moderator
    
USA
6493 Posts |
Posted - 13 July 2002 : 20:35:10
|
If you haven't, make sure the MDAC data drivers are current on your server. You can get the latest at www.microsoft.com/data
====== Doug G ====== |
 |
|
paarlberg
New Member

74 Posts |
Posted - 13 July 2002 : 21:53:44
|
quote:
I gather that you're using this in your computer? Do you have any other apps accessing the database?
It is on a webserver at my facility. There are no other apps accessing the db.
you can see it at http://forum.baspnet.net. It has been pretty busy for a forum that has only been up for 10 days.
It isn't that critical of any error at the moment as much of the clients are in South Africa with slow connections that seem to time out a lot. However, I am on a 1.5M connection and it still happens.
Thanks,
DE
|
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 13 July 2002 : 22:13:09
|
Well 256 posts in 10 days gives an average of 25,6 posts per day. It looks like something Access can handle pretty easy. Anyway, maybe you just have many concurrent users in a given period. Does this happen regardless of how many members you have online?
------------------------------------------------- Installation Guide | Do's and Dont's | MODs |
 |
|
Topic  |
|