IIS and ODBC

[Brandon Slezak]

All,
I have a specific question for anyone that feels up to it! :)
I have a SQL server and am trying to get Internet Information Server to
talk to it. When I click on my ahref or form submit button I get this
message:

Error Performing Query

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

httpodbc.dll is running properly in the system registry, I have used the
system DSN to set up the SQL server. As far as I can tell I am doing
everything right. I can access my tables with programs like dbWEB or
the SQL client utilities, but everytime I'm in I - net explorer and
click "submit" I get this message. Any help would be appreciated.

-Thanks in Advance

Brandon Slezak
slezakb%p...@mhs.elan.af.mil
TYBRIN Corporation

[Sameer Padhye]

I think I got this error when I was not giving the correct
uid/password combination. [then again, it could've given me a
different error message, anyway check that out.] Also, are you the
same NT user when you define the system DSN and when you try the
web/odbc connection? Is the WebServer/html on a different machine
than the SQL server machine? check if you have an ipc$ connection
(net use) to the sql server machine as the NT user which the html
code is being executed as.

Ofcourse, you may have already tried all these things, in which case
you could send me the code sample and exact h/w s/w setup.

Ciao
Sameer

[Tom Vande-Stouwe]

In inetsrv\server\ directory there are 2 files:
odbcint.dll and odbccp32.dll. Move them elsewhere (doesn't
matter where !). In \winnt35\system32\ there are other copies of these
files you must stop and restart WWW Service after that operation.

--
+++++++++++++++++++++++++++++++++++++++++++
+ Tom Vande-Stouwe To...@Conpro.org+
+ ConPro, Inc. http://www.conpro.org+
+ Microsoft Solutions Provider Internet Specialist +
+ 1-800-ConPro-2 1-803-345-0101 fax +
+ Web Hosting & Design - MS Front Page Enabled+
++++++++++++++++++++++++++++++++++++++++++++

> Sameer Padhye <sam...@nisa.compuserve.com> wrote in article
<31EE4D...@nisa.compuserve.com>...