Hi,
While running 32 bit IIS application on Windows 64 bit got below error.
ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
Then I followed some steps below but still no success.
1. Executed below pre-requisite script to run 32 bit app on 64 bit and I got an error “Service Unavailable” . On setting it to false, revert back to same ADODB.Connection error.
"cscript.exe adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 true"
2. In 32 bit server I used below connection string in asp forms which works fine. (Data Source= orcllive – System Data Source created using Microsoft ODBC Driver after installing Oracle 10g Client 32-Bit)
data_source = "Provider=MSDAORA.1;User ID=username;Password=password;Data Source=orcllive;Persist Security Info=False"
3. In 64 bit server I used the same connection string as above to connect to oracle database but it gives me ADODB.Connection error. So, then I used the below connection string which helps to connect to database.
(Data Source= orcllive – System Data Source created using Oracle ODBC Driver after installing Oracle 10g Client 64-Bit)
data_source = "Provider= OraOLEDB.Oracle;User ID=username;Password=password;Data Source=orcllive;Persist Security Info=False"
After connection issue got resolved, now the issue with all the dropdownlist controls on the form which is not displaying all the records, fixed to the first value instead of displaying all the records from the table.
Form.asp
<%@ language="VBScript"%>
<%
Dim sUsername
sUsername = Session("Username")
If sUsername = "" Then
Response.Redirect("itformslogin.asp")
end if
Dim rs, rs1, rs2,rs3,rs4,rs5,rs6, data_source, no, sName, sSQL, sSQL1, sSQL2, sSQL3, sSQL4,sSQL5,sSQL6
data_source = "Provider=OraOLEDB.Oracle;User ID=owf_mgr;Password=mcmswf85;Data Source=orcllive; Persist Security Info=False "
sSQL3 = "select * from owf_mgr.branch order by 2” -- Table Branch with two columns Branch_Code and E_Branch_Name
'For Branch
Set rs3 = Server.CreateObject("ADODB.Recordset")
rs3.Open sSQL3 , data_source
%>
<html>
Under html tags I am using dropdownlist control to display all the branch names.
<td>Branch</td>
<td >
<%
response.write "<select name='lstBranch' id='lstBranch' style='width:201px'>"
response.write "<option value='Please select branch'>Please select branch</option>"
while not rs3.eof
response.write "<option value='" & rs3("e_branch_name")& "'>" & rs3("e_branch_name") & "</option>"
rs3.movenext
wend
response.write "</select>"
%>
</html>
On Form Under Branch dropdownlist it shows only first record from the table i.e. only one branch name.
Any help will be highly appreciated.
Thanks & Regards