Networks

General discussion

Gravatar
Locked

Sql and Remotes

By donclick ·
I have a sql database w/access 97 front end. Loacal users are working fine - its the remotes, that cant work. I have tested the connectivity to sql w/isql, and seems good, but when they launch the front end, they are prompted for a password. They enter a KNOWN working password and get "ODBC -Connection to "database" failed." - thats it, no other messages. Anyone have any clues about this?
Thanks!

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
+ Follow this Discussion ·
| Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

Sql and Remotes

by erikdr In reply to Sql and Remotes

Sorry, only a partial answer.
In the ODBC data sources part of the Control Panel, there are also settings for tracing all ODBC traffic. Additionally, there are freeware utils with more extensive tracing.
One of the things going wrong often in thisarea is that for accessing a SQL system with Access, not only individual tables but also certain catalog tables need to be accessed. So the userid also needs authorisations for that; in that sense Access does more than the simple isql call you tested. The trace file will show exactly where things go wrong...

Hope this helps,

<Erik> / The Netherlands

gravatar
Collapse -

Sql and Remotes

by donclick In reply to Sql and Remotes
gravatar
Collapse -

Sql and Remotes

by Gh0stMaker In reply to Sql and Remotes

Restart the service on the sql server.

gravatar
Collapse -

Sql and Remotes

by donclick In reply to Sql and Remotes
Back to Networks Forum
4 total posts (Page 1 of 1)  

Start or search

Related Discussions

Related Forums