Strange ADO Problem

[RushiShroff]

My application is running well on Access 97.
In fact I have Access 2000 here but on the production server it is Access 97 so I have to convert it into Access 97.

Now I have added few pages for administration.
Surpricingly I am not able to insert records or update records from this pages.I can only view records from this pages.

Are there any rights problem ? Other part of application is working fine.

Rushi Shroff Rushi@emqube.com
"Life is beautiful."

 

[link9]

It's more than likely a permissions issue on the directory where the database is.

Most times, the the IUSR_machinename account that needs write permissions on the directory, but not always. If you give that account permissions, and it still doesn't work, try the 'network' and/or 'system' account. Permissions is probably one of my biggest pains. I never can seem to get it right the first time.


paul

 

[RushiShroff]

Dear Paul,
I have a connection file which I include on every page..

Sub OpenConnection	
	Set objConn = Server.CreateObject("ADODB.Connection")
	'Open Connection to database using Drivers-ODBC
	objConnString="DRIVER={Microsoft Access Driver (*.mdb)};"
	objConnString=objConnString & "DBQ=" & Server.MapPath("SFA")
	
	'Open Connection to database using Provider-OLEDB
	objConnString1="PROVIDER=MICROSOFT.JET.OLEDB.4.0;"
	objConnString1=objConnString1 & "DATA SOURCE=" & Server.MapPath("SFA.mdb")
	objConn.Open objConnString
End Sub

You see by now I ad been using objConnString1 as Microsoft also strongly suggest to use native OLEDB providers rather than ODBC drivers for OLEDB providers.

When I changed objConnString1 to objConnString, the pages
started working.

Why ?? Rushi Shroff Rushi@emqube.com
"Life is beautiful."

 

[derren]

Yes, some webservers do not support the Jet drivers, especially with Access 97. I tend to do an initial driver test to see if I can get away with Jet, but unfortunately I noramlly have to go back to the standard ODBC.

You are not alone! Derren
[Mediocre talent - spread really thin]