Very Computer

I developed a simple Access 95 database to copy some data from a SQL
server 6.5 to a local Access database. It worked well. It also worked
with the WINAT scheduling program. However, when I tried to schedule it
in another SQL server 6.5, it never finished. (These two SQL servers are
installed on two NT servers in the same domain.) I did some ODBC tracing
and found the error occured at SQLDriverConnectW call. I checked the
server error log and found there was no login attempt which normally
occurred. The SQLError call followed the failure showed the following
message:

....(function parameters here)
[Microsoft][ODBC SQL Server Driver][dbnmpntw]ConnectionOpen
(CreateFile()).
....(function parameters here)

I am just curious about what went wrong, why it did not work within SQL
Enterprise Manager? If anyone has an answer or solution to this problem,
please let me. Thanks.

Zhiming Xue

Forgive me if you are way, way past this, which you might be, but...

Do you have identical ODBC DSNs defined on both machines?  And are both the
SQL and Access DSNs on the failing machine pointing to valid databases?

--
Chris Leonard
SQL Server / Windows NT MCP