by Alle » Fri, 21 Jun 2002 05:19:34
Thanks for your advise.
by T Bank » Fri, 21 Jun 2002 06:27:28
Sounds to me like you found your problem. Is there a reason you can notQuote:> Front end Access 97 application to access SQL Server
> 2000(SP2) via ODBC connection. The test of ODBC is
> successfully but the Access 97 application is unable
> to access the SQL Server database if the MDAC version
> is 2.5 or less. There is no problem for those machines
> installed with MDAC 2.6 above. Anyone has ideas?
by Alle » Fri, 21 Jun 2002 23:22:49
Quote:>-----Original Message-----
>> Front end Access 97 application to access SQL Server
>> 2000(SP2) via ODBC connection. The test of ODBC is
>> successfully but the Access 97 application is unable
>> to access the SQL Server database if the MDAC version
>> is 2.5 or less. There is no problem for those machines
>> installed with MDAC 2.6 above. Anyone has ideas?
>Sounds to me like you found your problem. Is there a
reason you can not
>update the MDAC on the machines that do not function?
>.
1. MS Internet Server can't connect to SQL Server ODBC source
Absolutely. Been there, bitten by that. Burried somewhere in the docs
(and I wish I could find it again) is the information that you have to
use SYSDSNs not the other kind of ODBC sources. Create a SYSDSN with
the same name and that way either access will work fine.
-----Burton
3. Old ODBC drivers when connecting to SQL server 2000 from Developer 2000 apps
5. Can't I.P. connect to DB2 server on Linux but OK on WinNT
6. Execute an Access macro from a DTS package ?
7. Can't connect tables in SQL Server via ODBC
8. Windows 95 B, Setup Wizard Issues Setup.EXE on Windows 95 A
9. Can't connect to SQL Server 6.5 through ODBC
10. Can't connect VB 3 program to SQL Server 7.0 through ODBC
11. Can't connect to SQL Server w/32 bit ODBC
12. Can't connect to a MS SQL-Server via ODBC
13. bcp canned app