What can be wrong with this DNSless connection. Can't UPDATE/INSERT

[joffer]

I use this strings to connect to a DNSless access file:

Set Conn = Server.Createobject("ADODB.Connection&quot
Conn.Connectionstring = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/&quot & "database.mbd"
Conn.Open

When i try to do a INSERT/UPDATE/DELETE i always get:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/asp/update.asp, line 50

--> [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

I am able to do a SELECT * FROM myTable with the same connection string.


Any suggestions what can be wrong?

 

[sorinadrian]

click right on the .mdb file, then properties, security, then... allow write

 

[Lpic]

I hope that was a typo, but your database should be named database.MDB...not mbd...

 

[Nahom]

strconn = "Driver={SQL Server};Description=sqldemo;SERVER=127.0.0.1;UID=LoginID;PWD=Password;DATABASE=Database_Name
set conn = server.createobject("adodb.connection&quot
conn.open strconn

 

[HectorTheDog]

Joffer - can you confirm that the query causing this error can be run from within Access itself (ie. you can paste the SQL into the query designer SQL window and not get the same error). It doesn't sound like a DNS problem to me.

 

[joffer]

Lpic - yes a typo

HectorTheDog - yes, all code works fine on my two development computers (winnt4/pws and Win2k/pws) but when i upload to the server i get this.

I'm all about to find me another isp/host.

I've sometimes gotten an error like this:

Error desc. -> [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

 

[3d1tund0]

Hey...I use a DSN-less connection with mine...and I get the same error..I was pointed to this microsoft site:

http://support.microsoft.com/support/kb/articles/Q175/1/68.ASP

I don't know if it will help..it didn't help me any...I still am having the same problem...

 

[SYZYGY]

I use TableWiz for creating connections and basic table production. It has worked every time.

 

[Ayac]

I think your problem roots in your file security settings.
The IUSR_servername property should be enabled to write
into the database from an other page using a client browser
by somebody from outside.

Go to Internet Information Services on your web server, and
select your database, then choose properties/File Security.
Choose Edit at "Anonymus access...", and simply enable
anonymus access. This should help...

Ayac

 

[3d1tund0]

I'm not using PWS and I can not get a reasonable answer by anyone on how to fix this problem if I am using ws_ftp to connect to a remote server...please help...thanx

 

[Deadline]

Hi

Check this site out and let us know if this helped.

http://coveryourasp.com/ADo4.asp

RR.

 

[TimLarkin]

EXACTLY HOW are you trying to do update, etc?? Post code.