Linking Access7.0 to MS SQL Server 4.21 via ODBC

Article View: comp.databases.ms-sqlserver

Article #35

Back to comp.databases.ms-sqlserver Previous Next

#35

From: Ricky Rodriguez
Date: Wed, 24 Apr 1996 00:00

16 lines
1426 bytes

I am trying to link from an Access7.0 database via ODBC to a Microsoft 
SQL Server 4.21 on a Banyan Vines network. When I try to connect, I 
always seem to get the same error:

Connection failed:
SQLState:'S1000'
SQL Server Error: 1157
[Microsoft][ODBC SQL Server Driver]Unable to load communication module. 
Driver has not been correctly installed.
Connection failed:
SQLState:'08001'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Unable to connect to data source

Does anybody know how I can resolve this dilema? Is it even 
possible? Please respond to rrodriguez@nordson.com. Thanks in advance.

Technical Details

Message-ID: <317E3E47.12C3@nordson.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 108a70,483325c15377dd11,start
X-Google-Attributes: gid108a70,public
X-Google-Thread: f6611,483325c15377dd11,start
X-Google-Attributes: gidf6611,public
X-Google-Thread: 104de1,483325c15377dd11,start
X-Google-Attributes: gid104de1,public
From: Ricky Rodriguez <rrodriguez@nordson.com>
Subject: Linking Access7.0 to MS SQL Server 4.21 via ODBC
Date: 1996/04/24
Message-ID: <317E3E47.12C3@nordson.com>
X-Deja-AN: 151238732
cc: rrodriguez@nordson.com
content-type: text/plain; charset=us-ascii
organization: Netcom
x-netcom-date: Wed Apr 24  9:43:02 AM CDT 1996
mime-version: 1.0
newsgroups: comp.databases.ms-sqlserver,comp.databases.ms-sqlserver,bit.databases.mssql-l,comp.databases.sybase
x-mailer: Mozilla 2.0GoldB2 (Win95; I)