Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ASP => Access => SQL Server
The design may be awful, but that's what I have to live with here. No direct access to the SS is allowed, and the to$$er who owns the Access DB refuses to change it. No, he's not a programmer - he's a 'manager'.- Sc0uSe
- Post #7
- Forum: Microsoft: ASP (Active Server Pages)
-
ASP => Access => SQL Server
but I'm not trying to access the SS directly - I'm running a query on the access DB which returns a resultset ... but the access DB links to the SS db. If I run the query from access, it asks me to log on to SS and then runs. If I run the query from ASP, it fails ...- Sc0uSe
- Post #5
- Forum: Microsoft: ASP (Active Server Pages)
-
ASP => Access => SQL Server
The ASP is still accessing the Access DB, but the access DB now runs qeries against the SS db, and to run those queries, it needs to log on to the SS db ...- Sc0uSe
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
ASP => Access => SQL Server
Hi, I have a manager who's rewritten the Access database that my ASP queries (successfully) so that it now runs queries against a SQL Server database. The problem I'm getting is when I try to do the recordset open, it's giving me an ODBC "connection to <dsn> failed". When running...- Sc0uSe
- Thread
- Replies: 8
- Forum: Microsoft: ASP (Active Server Pages)
