2. ASPRunnerPro General questions
  3. [SOLVED]  deployment to 64-bit server
This topic is locked
[SOLVED]

 deployment to 64-bit server

 		11/20/2006 7:58:50 AM
ASPRunnerPro General questions
M
 maurello author

Hi,
I use ASP Runner 4.1 on my 32-bit workstation and use a 64-bit server with SQL Server 2005 as production environment.
However, I had to run IIS in emulated 32-bit mode in order to deploy the website generated ASP Runner 4.1. I tried to run it natively in 64-bit, but there was a problem with the driver for the connection to the database. Is there any way to deploy native 64-bit applications with ASP Runner?
M
 		maurello author 11/22/2006

Any suggestion here?
My users deal with a lot of data and it's a pity to use IIS 32-bit emulated on a native 64-bit machine. Specially because most of the time IIS is the bottleneck.
Sergey Kornilov admin 11/22/2006

ASP application itself don't know anything hardware and should run exactly the same way in both modes.
What is the error message that you getting?
M
 		maurello author 11/23/2006

When I run IIS in native 64-bit I get the following error:
Error number: 3753

Error description: Provider is not specified and there is no designated default provider.

Solution: (empty)
I think the problem is with the driver to connect to SQL Server. I thought that ASP Runner generated the pages using the 32-bit version of the SQL Server Native Client, since my workstation is 32-bit. That is why the error pops up only when I try to open a table, i.e. establish a connection to the database, and not at the login page or menu page.
Sergey Kornilov admin 11/23/2006

I found a couple of likns related to this issue:
http://www.codingforums.com/archive/index.php?t-66468.html

http://www.calcaria.net/ASP/2006/04/provid...here-is-no.html
It appears that connection string needs to be modified to avoid using ODBC drivers (that only run in 32-bit mode).
Use the following connection string (include/dbconnection.asp file)

strConnection = "Provider=SQLOLEDB;UserID=MyUser;Password=MyPassword;Database=MyDatabase"
M
 		maurello author 11/27/2006

I finally solved the problem. Now I can run IIS in 64-bit mode. The correct connection string is:

strConnection = "Provider=sqloledb;Data Source=SQLServerName;Initial Catalog=DBaseName;User Id=sa;Password=password;"


It would be good to have an option for this string in the ASP Runner database selection page for SQL Server.
D
 		dcihon 12/29/2007

I need a connection string for using with Access. I have the same problem.

Here is my current Connection string:
strConnection = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("db/Transp.mdb") & ";UID=;PWD="

I finally solved the problem. Now I can run IIS in 64-bit mode. The correct connection string is:

It would be good to have an option for this string in the ASP Runner database selection page for SQL Server.
Sergey Kornilov admin 12/29/2007

I recommend to start a new thread posting exact error message.