General discussion

Locked

ODBC

By David Shang ·
after I create an ODBC with my database (Access-.mdb and SQL-.mdf) that linked with IIS4, I can use IE to retrive data from Access (ASP page created by FrontPage), but I can not retrive from SQL Server(ASP page created by FrontPage - error message "Login failed for user 'SERVER\IUER_SERVER'), and SQL (html page created by Access - error message 'Safety settings on this computer prohibit accessing a data source on another domain")
does anyone know what worng, thanks.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

ODBC

by donq In reply to ODBC

My aren't we generous with our points? Are ALL of your machines running the same security "Workgroup"?

Collapse -

ODBC

by David Shang In reply to ODBC

Poster rated this answer

Collapse -

ODBC

by Kevin Brown In reply to ODBC

You are not passing logon credentials with the ODBC connection. Either add appropiate access in SQL for public role, or add account for IUSER. You could also pass login information with the ODBC connection setup in ASP.

Collapse -

ODBC

by David Shang In reply to ODBC

Poster rated this answer

Collapse -

ODBC

by David Shang In reply to ODBC

This question was closed by the author

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums