If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
If its SQL Server 2k then you might want to make sure that the SQL Server
driver version starts with 2000. mine is 2000.81.9042.00 Get this by installing mdac_typ26.exe ie, ver 2.6 at least. Check the faulty machines to see if the driver is below this. "Ivan Starr" wrote in message ... Hello and thank you for helping. I have written a SQL Server database front end for a mixed win98/winXP/win2K Office97/2K environment. The error only happens on some machines of varying office software and OS. I fixed one win98/office97 machine with the MDAC_TYP.EXE file when I saw there was no version number on the SQL Server driver listed in the ODBC Data Sources program under the drivers tab. However, that did not fix the same problem on other machines. I know all the machines can ping the SQL server in qn. What is the correct version number for the driver? Is the MDAC_TYP.EXE file OK to run on any machine? There are so many similar entries in the MS 'knowledgebase' about this it is very hard to know what to do. What else needs to be in place in order to assure the ability to connect to an SQL Server? What's missing here? Thanks, Ivan |
#2
|
|||
|
|||
"ODBC - connection to 'SQL Server A.B.C.D' failed" error on many machines
Hello and thank you for helping.
I have written a SQL Server database front end for a mixed win98/winXP/win2K Office97/2K environment. The error only happens on some machines of varying office software and OS. I fixed one win98/office97 machine with the MDAC_TYP.EXE file when I saw there was no version number on the SQL Server driver listed in the ODBC Data Sources program under the drivers tab. However, that did not fix the same problem on other machines. I know all the machines can ping the SQL server in qn. What is the correct version number for the driver? Is the MDAC_TYP.EXE file OK to run on any machine? There are so many similar entries in the MS 'knowledgebase' about this it is very hard to know what to do. What else needs to be in place in order to assure the ability to connect to an SQL Server? What's missing here? Thanks, Ivan |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Server Connection Failed | Dave Lee | Outlook Express | 3 | August 18th, 2004 07:55 AM |
THE CONNECTION TO THE SERVER HAS FAILED. | BIGman952 | Outlook Express | 2 | August 7th, 2004 08:52 PM |
Function isn't available in expressions in query expression | Reiner Harmgardt | General Discussion | 4 | July 21st, 2004 09:30 AM |
Slow connection to SQL Server from Microsoft Word XP | Gerald Vogt | Mailmerge | 4 | June 13th, 2004 01:35 PM |
Help with connection to SQL Server | Uri Dimant | General Discussion | 1 | June 10th, 2004 12:01 AM |