System DSN Odbc only works for admin accounts. Group policy?

situation1, server 1 SBS2000,access data base. Server2 iis, running
asp page that connects to access data using ODBC. I am using a system
DSN odbc connection. The page works wonderfull as long as I am loged
into server 2 as ADMIN. if I log off web site still runs but get a
data error on asp page, cannot connect. Log on as standard user on
Server2 and web page still does not work, Standard user can see the
Dataconnection in SystemDSN, but when you goto configer and try to
compact database it will tell you connection is not vaild.

Situation 2, same machines as above. Server1 sbs2000, sql2000,
running sql reporting services. Have built a dataconnection in report
services using odbc to access data base that is also on server1, built
report that pulls data over the odbc connection. This works well when
signed on as administrator, I can be signed on as administrator on any
machine in the network and goto http:/server1/reports and run the
report.
Problem is that none of my users can run this report, they can pull up
the website, server1/reports and can see the report but when the
report runs they get errors, data connection not found.

I think the above problems are interelated, as standard users cant use
the odbc connection. seams that Server2 cant use the odbc even as a
system connection and needs the admin signed on.

The System DSN is acting the way I would expect a USER Dsn to act.

Thank You very much for your time.

dbyrd
Wed May 05 00:04:48 CDT 2004

Found the fix, For the report server problem, the Temp file under
Iwam_server must have its permissions set on the server so the users
you are wanting to run the report can read and write to it. I finally
broke out Filemon to find this.

The iss problem I was having I went into the reg and changed the path
on the System DSN under odbc.ini to a UNC name, where when i built the
odbc connection I used a mapped drive letter.

thanks for those that thought about an answer on these problems.


dbyrd@parsonsdispatch.com (David) wrote in message news:<78784abc.0404302227.5bac5ae4@posting.google.com>...
> situation1, server 1 SBS2000,access data base. Server2 iis, running
> asp page that connects to access data using ODBC. I am using a system
> DSN odbc connection. The page works wonderfull as long as I am loged
> into server 2 as ADMIN. if I log off web site still runs but get a
> data error on asp page, cannot connect. Log on as standard user on
> Server2 and web page still does not work, Standard user can see the
> Dataconnection in SystemDSN, but when you goto configer and try to
> compact database it will tell you connection is not vaild.
>
> Situation 2, same machines as above. Server1 sbs2000, sql2000,
> running sql reporting services. Have built a dataconnection in report
> services using odbc to access data base that is also on server1, built
> report that pulls data over the odbc connection. This works well when
> signed on as administrator, I can be signed on as administrator on any
> machine in the network and goto http:/server1/reports and run the
> report.
> Problem is that none of my users can run this report, they can pull up
> the website, server1/reports and can see the report but when the
> report runs they get errors, data connection not found.
>
> I think the above problems are interelated, as standard users cant use
> the odbc connection. seams that Server2 cant use the odbc even as a
> system connection and needs the admin signed on.
>
> The System DSN is acting the way I would expect a USER Dsn to act.
>
> Thank You very much for your time.