Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 Microsoft OLE DB Provider for ODBC Drivers error		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

skyhawks
Junior Member

USA
125 Posts
Posted - 14 June 2001 :  10:36:04  Show Profile  Visit skyhawks's Homepage
I am getting this error message on default.asp. Can anyone help me out please


Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access 97 Driver] Operation must use an updatable query.

/forum/inc_functions.asp, line 644

-----


'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"

'## Make sure to uncomment one of the strConnString lines!

strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\WebSites\skyhawks\fpdb\snitz_forums_2000.mdb" '## MS Access 97

'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/fpdb/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path

'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\WebSites\skyhawks\fpdb\snitz_forums_2000.mdb;" '## MS Access 2000

'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=SQL_USER;pwd=PASSWORD;database=DATABASE_NAME" '## MS SQL Server 7

'strConnString = "driver=MySQL;server=SERVER_NAME;uid=MYSQL_USER;pwd=PARRWORD;database=DATABASE_NAME" '## MySQL

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 14 June 2001 :  11:10:04  Show Profile  Visit HuwR's Homepage
The directory containing your db does not have the correct access permissions
Go to Top of Page

skyhawks
Junior Member

USA
125 Posts
Posted - 14 June 2001 :  11:23:52  Show Profile  Visit skyhawks's Homepage
So i guess I have to ask my IT department to give read & write permissions on my db folder (which is fpdb) correct?
Go to Top of Page

Deleted
deleted

4116 Posts
Posted - 14 June 2001 :  12:32:34  Show Profile
quote:

So i guess I have to ask my IT department to give read & write permissions on my db folder (which is fpdb) correct?



Yes, must include "file create" permissions for the .ldb file.

Think Pink
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.21 seconds. Powered By: Snitz Forums 2000 Version 3.4.07