880676 wrote:Yes. The bit-ness of the application and the Oracle client need to match. If the application is in 32 bit mode (which it is), you need a 32 bit Oracle client.
Yes, I already have installed the 64 bits Oracle Client.
Yes, the IIS application pool for that page set to have 32 bit mode enabled.
Do you recomend me to install the 32 bits Oracle Client too ?
Must I to delete the 64 bits Oracle Client first, or both Oracle Clients can live together in the same Windows Server ?It's not necessary to delete the 64 bit version. That said, if nothing else is using it I would remove it. It's a good idea to only install what you need. (If you do have both of them, install the 32 bit Oracle client into a different location.)
880676 wrote:Neither of those works with the 32 bit driver? What about this one:
'cnn.ConnectionString = "Provider=OraOLEDB.Oracle.1;Data Source=orcl64;Persist Security Info=False;User ID=scott;Password=creative;"
'cnn.ConnectionString = "Provider=msdaora;Data Source=orcl64;User ID=scott;Password=creative;"
Dim cnn2 As OracleConnection = New OracleConnection()This one should work if "orcl64" is defined in your tnsnames.ora file, in the 32 bit Oracle driver's network\admin folder.
'cnn2.ConnectionString = "Data Source=orcl64;Integrated Security=yes;"
cnn2.ConnectionString = "Data Source=orcl64;User Id=scott;Password=creative;Integrated Security=no;"