Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC fails on Win NT.Works fine on Win 2000

Status
Not open for further replies.

ctudose

Programmer
Nov 22, 2001
33
0
0
CA
I have an application with front-end Access 2000 and back-end SQL Server.
I am using linked tables through ODBC.
I've created a simple select query(qry1) based on 2 linked tables.
It worked fine on both system(Win 2k and Win NT)
Now if I tried to create another select query based on qry1 and a linked table , on Win2k it runs OK, but on Win NT I've got ODBC fails (error #107)

I am using the last MDAC.

Any suggestion would be much appreciated.

Thx,
Cris
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top