Windows and IIs

[rdrunner40]

Hi there

I have an intriquing problem so here it is.

I have a Intranet setup under windows 2003 server.

I have a ASP called Machinery log.asp and i am trying to connect to a ACCESS 2000 Table called Maintenace with a table contained Maintenance.

It used to work on our previous server which was a NT4 SBS Server but now it doesn't.

So any help apprecieated.

Below is the relevant snippets of code.
** ODBC from the ASP page**

OBJdbConnection.Open "Maintenance"
'Create and Open Recordset Object
Set RsMaintenance = Server.CreateObject("ADODB.Recordset&quot
RsMaintenance.ActiveConnection = OBJdbConnection
RsMaintenance.CursorType = adOpenKeyset
RsMaintenance.LockType = adLockOptimistic
RsMaintenance.Source = "Maintenance"
RsMaintenance.Open(sql)

i have enabled the IIS on the ODBC page in server admin and created a SYSTEM DSN in the name of Maintenance as above

at this stage it doesn't see the page

any help appreciated

murray

 

[Dogers]

if youre in the same bind as me, i'll bet that the access database youre trying to access is on another machine?

if so, then its something to do with file/user permissions - iis6 runs as a different user to previous versions, so needs setting up on the remote machine properly.. problem is, im not sure which user it actually runs as!

 

[Mighty]

I'm having the same problem as you guys. Did either of you managed to get this sorted. I am trying to access a database on a remote machine. I have set up the website to use a certain account and have given the account access on the remote machine.

Lost at the moment. Getting the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

/absenteereport.asp, line 37


Mighty

 

[Dogers]

Sort of..
I've set IIS to run as a user i've added to our domain

If you go into IIS Manager, expand Application Pools, go to properties of DefaultAppPool (or whichever one your site runs as if anythings changed it), then go to the identity tab.

I've set ours to configurable and set the domain account with a password in there.

I believe by default it runs with a local computer account, which I can only assume is why it cant access shares..

I'm sure theres better/proper ways of solving this, but i got fed up messing around!

 

[Mighty]

Thanks for that but no joy for me. I was getting different erros - Service Unavailable and Server Temporarily Overloaded - once I changed to a domain account.

So I will have to look elsewhere for a solution. Thanks for posting though.

Mighty