Why it's not working?! A simple SQL...

[weee]

Set rs = Server.CreateObject("ADODB.RecordSet")
SQL = "SELECT id FROM usrsTBL WHERE memid=" & request.querystring ("companyId")
rs.Open SQL,DSN,3,1
id = rs("id")
rs.close

The error:
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x7e8 Thread 0xd08 DBC 0xbfea4dc Jet'.

Thanks!

[buntine]

This is because you dont have read/write permissions in the IUSR account. Contact your host. Or set them locally if you are testing.

Regards.

[weee]

That's very Odd!

I'm doing manipulations on the database for the last 3 months.
I don't have this problem and that's for sure - it's gotta be something else.

[buntine]

Have you always used that DSN? Have you altered it lately?

[weee]

Oh,you were right buntine...

I did something wrong with the DSN.

Thanks!

[buntine]

No worries. ;)