2. ASPRunnerPro General questions
  3. Moving asprunner application to 64bit
This topic is locked

Moving asprunner application to 64bit

 		5/18/2008 5:55:07 PM
ASPRunnerPro General questions
orit author

When we try to move application that works on windows server 2003 32Bit to windows server 64bit, we get the error:

ADODB.Connection error '800a0ea9'
Provider is not specified and there is no designated default provider.
/Travel/include/dbcommon.asp, line 113
What have to be done in order it will work on 64bit as it worked on 32bit?
Thanks.
Sergey Kornilov admin 5/20/2008

Check connection string in include/dbconnection.asp file and make sure that you have required ODBC driver or OLEDB provider installed on the new box.
orit author 5/22/2008

Can you please specify what are the ODBC driver or the OLEDB provider that should be installed on the new 64bit server, and can you please provide an example how the string in the dbconnection.asp suppose to look like in difference from how it is in the 32bit server?
Thanks
Sergey Kornilov admin 5/22/2008

Post your connection string here.
orit author 5/23/2008

My connection string:

<%

strConnection = "DBQ=" & server.mappath("DB\travel.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;"

%>


Thanks.
Sergey Kornilov admin 5/23/2008

I recommend you to build a test application using the latest version of ASPRunnerPro then copy and paste the connection string to your existing application.
J
 		JOHNF777 9/17/2008

Just in case someone else needs a solution for this.....
It is possible to run IIS in 32 bit mode. So it can use all the database drivers
http://support.microsoft.com/default.aspx?...kb;en-us;894435
This is what I used. We have Windows Server 2003 R2 Standard x64 SP2.
From the command prompt:

cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1
I used this and it is working fine without changing anything.
Maybe we should put this in the tips and tricks....
C
 		CoolSan 12/17/2008

Hey....

thanks... it was useful for me too.......