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 |
|
oepirobo
Starting Member
36 Posts |
 Posted - 2004-10-04 : 09:17:45
|
| I have an Access front-end that has a SQL Server back-end. It is installed on 20 PCs in my company. Someone installed some software in one of these PCs and now that particular computer gives me the error when opening the Access front-end.ODBC: error conecting to SQL ServerMyServer |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-10-04 : 09:30:00
|
| Clear your mind, imagine you don't know anything at all about your specific situation, re-read your post, and then decide if you think you've given us enough information to help you ....- Jeff |
 |
|
|
oepirobo
Starting Member
36 Posts |
Posted - 2004-10-04 : 10:00:29
|
| My company has an Access application which is installed in many computers. It works as a front-end for a single database in a single SQL Server. In one of these computers an employee triend to install a GreatPlains client, which works through ODBC, so I guess somehow they messed up the ODBC for SQL Server since GreatPlains also runs with an SQL Server database. That's all the information that I have because I didn't install the other software, I simply came to a computer that gave me the ODBC error. |
|
|
|
oepirobo
Starting Member
36 Posts |
Posted - 2004-10-04 : 10:49:52
|
| Ok, when I look in ODBC settings in Administrative tools on the client computer in the drivers tab I see that there is no driver for SQL Server. There is one in every other client. I installed MDAC 2.7 but that didn't fix it. |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2004-10-04 : 11:45:27
|
| You let users Install unauthorized software to networked PCs? Bad Bad Bad idea!!!Since the PC in question has already been tampered with I would wipe and reinstall the OS to be on the safe side.JimUsers <> Logic |
|
|
|
oepirobo
Starting Member
36 Posts |
Posted - 2004-10-04 : 11:54:13
|
| heheh...I know what you mean but I'm not the network administrator, I'm just support for the Access application. |
|
|
|
Ledell
SQL NASCAR Parsing Chick
107 Posts |
Posted - 2004-10-05 : 13:19:14
|
| Maybe reinstalling Access on that computer? I have had similar experiences and the solutions were to reinstall Access then MDAC and any other drivers that I use (for ex: Oracle). If that doesn't work, then reimaging the machine is what needs to happen.*************************Got some code from Rob. Can anyone help? |
|
|
|
|
|
|
ODBC: error conecting to SQL Server