Sir

I am facing a problem regarding ASP database. I am using MS Access 2000

as database. My project works nicely on PWS server but when i shift it to

IIS4 it gives an error



Microsoft OLE DB Provider for ODBC drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Not a valid password.

then line no.



It also gives the same error if i runs it on PWS server but connect it to

the database on IIS4. The password is correct, I checked it. 

The code of that line in which it tells the error is as follows



con.open "DSN=move;UID=admin;PWD=info1234"



I have discussed this problems to many others programmers also but they are

unable to rectify it.

Please help me in finding a solution to this problem.



Thanks in advance.

Akshay Sharma 

Hi,



Well i think PWS and IIS4 use different MDAC components, I think, not for 

definate, that could cause a prob maybe,



Also, you shouldnt be using a DSN connections, they are very slow and not 

worth while, you should use a OLEDB connection as shown below



--------

Dim DATAPATH,CONNUSERNAME,CONNPASSWORD

DATAPATH = "C:/path to database"

CONNUSERNAME = "your username"

CONNPASSWORD = "your password"





		Set GWRS = Server.CreateObject("ADODB.Recordset")

		Set GWDB= Server.CreateObject("ADODB.Connection")

		GWDB.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" 

& DATAPATH & ";UID=" & CONNUSERNAME & ";PWD=" & CONNPASSWORD



---------



That should work for you, Also make sure you use the user=Admin and set up 

the group admin in the database, if you havent, that may be causing a 

problem for you.........



Regards,

Spoon

hi  Akshay Sharma 

i think u have to rebuilt  the DB because access is too sensetive ,try and tell me

regards

fadi