Hello,

I recently upgraded to Windows 64. I installed asp 1.1 and followed the Microsoft patch to run it under 32 bit mode. I'm also using IIS.

I have a site running on asp using ms sql server 2000 as the db. I've set up the server added the ODBC entries for the datasource that I use (although interesting I only had the sql server connector not the whole list of connectors (access etc ) that I had under win 2000). I then run the asp site using my IIS localhost. The static site pages work fine but and dynamic page throws the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified



Now I have checked all of the DNS entries for spelling mistakes etc and they are fine. So I'm stuck as to why I can't connect to the db! By the way after I set up the ODBC entries if I test the connection it connects correctly.



Any help? Anyone else had similar probs?



Many thanks

Sonic.

P.S I am running the following connection sub:

Sub OpenWebSiteDSN()
Set websiteConn = Server.CreateObject("ADODB.Connection")
websiteConnection="DSN=MydatabaseConn;Database=Myd atabase;UID=webuser;PW=;"
websiteConn.Open websiteConnection
End Sub

does the IUSR_ account have permissions to SQL server?

Hi Chris,

Thanks for the reply. I've checked the IUSR_ account settings in IIS, how do I enable permissions to the SQL server?

Sonic

is SQL server is running on the same box ?

You can add the user account to;
a usergroup that has permissions to SQL (though not a group that has admin permission to the server)
the SQL login list in Enterprise Manager

have you tested the connection with a DSNLess connection string ?

We have the same problem. Have you found a solution to it?

Ingmar

Hello all,

I am having the same problem as mentioned above, but will provide a few more details. I am migrating an ASP web app to a machine runnning Windows 2003 64 bit (IIS6). The application is accessing a MS SQL Server on a different machine. The app worked fine on the Windows 2003 32 bit (IIS6) machine, but will not work on the new machine. I have tested the ODBC for connectivity and it works fine. I also tried changing the connection in the app to a DSN-less connection string rather than a DSN connection and it worked fine.

I would like to use the DSN connection method so I am trying to figure out how to make it work.

Any help is greatly appreciated.

Thanks

Try this connection method

Set conn = Server.CreateObject("ADODB.Connection")
Set rs_conn = Server.CreateObject("ADODB.recordset")
conn.CursorLocation = 3
conn.IsolationLevel = 4096
conn.CommandTimeout = 60
conn.ConnectionTimeout = 30
call conn.Open("Provider=SQLOLEDB;SERVER=SERVERNAME;DAT ABASE=YOURDATABASENAME;UID=USERNAME;PWD=PASSWORD;N etwork=DBMSSOCN.DLL","USERNAME","PASSWORD")

You can replace servername with
Local IP Address
Remote IP Address
or the server name.

In your connect string I don't see how you are defining what server to connect to.

Actually, you'll have this problem no matter what you do.

I also have Windows XP 64-bit edition and the problem is that there are no native 64-bit Jet ODBC drivers for it.

Your solution is to flip IIS into 32-bit mode. See this support article:

http://support.microsoft.com/?id=894435

An additional item to look for is make sure you are using the 32 bit version of the ODBC Data Source Administrator located in:
\windows\syswow64\odbcad32.exe

For further information view the following link:
http://www.64advantage.com/blog/blog...64-bit+Windows