Unix Technical Forum

ODBC error when connecting to SQL 7.0 from Access database

This is a discussion on ODBC error when connecting to SQL 7.0 from Access database within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Hi: I restored a SQL database to a new server and changed ODBC connection on the clients' machine. After ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 08:44 PM
=?Utf-8?B?RW5qb3k5ODg=?=
 
Posts: n/a
Default 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????
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:08 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com