Attach MS SQL tables via ODBC
Tony,
I suggest you turn on the spying utillity that comes with the ODBC SDK.
You will then be able to track down the problem using the log. If you
don't
have a copy of SPY, you can buy one for $49.00 from my company, SYWARE.
Details at http://www.syware.com
Best Regards,
Frank Yacano
Quote:
> I am trying to attach an MS SQL Server database table within MS Access,
> ver. 2.0, on an NEC Intel P100 PC under Windows 95 via ODBC. The MS SQL
> Server, ver. 6.50, is located on an Intel P166 PC running NT Server Ver.
> 3.51. This is running on TCP/IP base with DEC Pathworks license manager.
> The appropriate ODBC driver has been installed and a data source has been
> setup using the NT Servers IP address to avoid server name errors.
> When connecting with the SQL Server Login dialogue box, I get the following
> error -
> "Connection failed:
> SQLState: '01000'
> SQL Server Error: 13
> [Microsoft][ODBC SQL Server Driver][dbnmp3]ConnectionOpen (sopen()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 0
> [Microsoft][ODBC SQL Server Driver] Unable to connectto data source"
> When using an Intel Pentium running NT Client, we can connect via ODBC with
> no problems.
> Any advice/suggestions would be welcome.
> --
--
.__________________________________________________________.
| |
| Frank Yacano |
| http://www.syware.com |
| |
| SYWARE, Inc. P.O. Box 91 Kendall, Cambridge, MA 02142 ( \
/ ) Phone:617-497-1375 Fax:617-497-8729 \ \
( (|__________________________________________________________|) )
(((\ \) /,) / ) / //))
(\\\\ \_/ / \ \_/ /////
\ / \ /
\ _/ \_ /
