ODBC error when connecting to SQL 7.0 from Access database

Hi:

I restored a SQL database to a new server and changed ODBC connection on the
clients' machine. After that, users can login to the Access database which
connect to the SQL server via ODBC. But when they try to click on some
queries or open other forms, the login window apear again and won't accept
any login info. the error message is [ODBC SQL Server
driver][NETDBLIB]ConnectionOpen[connect()),Connection failed...., I can open
any linked tables in the Access database, just not certain forms, why?

Would someone please help????
.

Relevant Pages

  • Re: this combo: php in a windows2003 + msaccess in a samba unix sh
    ... SQL Server i have installed on the web server?, ... its to have a faster querying of the MS access database without ... compromising the performance of Our SQL Server database application. ... ODBC is much faster than any Access database I've seen. ...
    (microsoft.public.windows.server.networking)
  • DNS-less Connections
    ... connection on a windows 2000 server running IIS and ODBC 4.0 driver. ... The Access database was made using Access 2002. ... code works if I set up a DNS on the server under the ODBC drivers. ...
    (microsoft.public.inetserver.asp.general)
  • ODBC between Access XP/Server 2003 & Citrix
    ... There is an access database that uses ODBC to connect to ... the server database, which is a Pervasive SQL system. ...
    (microsoft.public.access.externaldata)
  • gdm hangs
    ... gdm will hang 9 of 10 times when logging out. ... with or without the client having been connected to the Server. ... # Timed login, useful for kiosks. ... Must output the chosen host on stdout, ...
    (Debian-User)
  • Re: Word 2000/2002 - Proper Mail Merge steps for ODBC?
    ... > Document to connect to a Secured Access Database, ... using the ODBC provider for OLEDB. ... they have a .dsn extension. ... directly (in the Open/Select Data Source dialog box). ...
    (microsoft.public.word.mailmerge.fields)
Loading