Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
idimery
Starting Member
2 Posts |
 Posted - 2002-09-23 : 18:40:15
|
| I searched on the Internet for a solution to this and stumbled on this forum. My question is simply this. We have a SQL 7 backend with Access 97 interface. I had to reinstall on one PC and ever since I restored his mdb file, it wont link back to the database server. Access 97 only comes with SQL 6 drivers and below, how do I get ODBC drivers for SQL Server 7 on a Win 98 machine running Access 97? I have tried this file on a Win 2k machine and did the ODBC installation from Windows 2000 built in ODBC mmc. Win 98 doesnt have this and the installation CD drivers dont seem to help. Is there a way to get ODBC drivers for Access 97 to connect to SQL 7? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-23 : 18:55:52
|
| Get the latest MDAC drivers here:http://www.microsoft.com/data/download.htmGet at least MDAC 2.6, whichever is the latest service pack for it (I think it's up to SP2). That will update all of your Microsoft Data Access components to the latest version. |
 |
|
|
idimery
Starting Member
2 Posts |
Posted - 2002-09-23 : 19:08:15
|
| You know what, after my post I searched the forums for relevant topics. I was thinking of how to install ODBC drivers in Windows 2000. In win 2k, its under Administrative Tools. Well, after stopping to think, I checked the Control Panel in Win 98 and ODBC was right there smack in my face! Doh! I checked it and configured the DSN to connect to the proper server with SQL authentication. Man, I changed it just now and it works fine. I didnt have to download anything. Its one of those Monday things I guess. Hey, sorry for ing not checking all of the obvious before I posted, but I did learn a lot from searching this forum, since it seems to be better than TechNets newsgroups. Thanks a bunch! |
|
|
|
|
|
|
SQL 7 ODBC Driver for Access 97