[dbnmpntw]ConnectionOpen (CreateFile()). Error

[dbnmpntw]ConnectionOpen (CreateFile()). Error

Post by Simon Gladwel » Sat, 18 Oct 1997 04:00:00



I am running IIS 3.0 and when I access my datasource through an idc file, I
get the following error:

?[State=08001][Error=1385][Microsoft][ODBC SQL Server
Driver][dbnmpntw]ConnectionOpen (CreateFile()).
?[State=01000][Error=1385][Microsoft][ODBC SQL Server
Driver][dbnmpntw]ConnectionOpen (CreateFile()).

(I am running SQL 6.5 on the same machine as IIS)

The IDC file is as follows:

Datasource: Guest (Note: This dsn works via MS Query so that's set up OK)
Username: sa
Password:
Expires: 2
Template: view.htx
SQLStatement:
+SELECT DISTINCT Counter, FirstName, LastName, Company, Email, Homepage,
Comment
+FROM Guests
+ORDER BY Guests.Counter DESC;

I presume there is some sort of permission or user name problem between IIS
and SQL, but I haven't had any luck finding exactly what. Any ideas?