Hi,
After struggling and googling a lot, I think now I should knock this door !
My Test Machine :
OS : Windows 7 64 bit Home Premium
Oracle Database : 11.2.0.1 64 bit Server (I don't have installed client software, because I have installed Server version)
Visual Basic : For 32-bit Windows Development
Below Code in AA.VBS Works fine when I runs cmd by saying : Click Start, click Run, type %windir%\SysWoW64\cmd.exe, and then click OK.
and then :
C:\Windows\SysWOW64>Wscript C:\AA.VBS
Private Sub Form_Load()
Dim Cn
Dim constr
Dim rs
Set cn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
constr = "Provider=OraOLEDB.Oracle;Data Source=orcl;User ID=un;Password=pw;"
cn.Open constr
cn.Close
rs.Close
End Sub
It worked. No message nor any error. Ok.
When I says same code in Visual Basic :
I gets :
Run-time error '3706'
Provider cannot be found. It may not be properly installed.
I guess my ADO (VB 32 Bit software part) is not able to see / access the 64 bit OraOLEDB.Oracle provider. I have tried many other providers and many other codes (by googling "Provider cannot be found. It may not be properly installed.") which are mentioned in the different internet sources, but issue is 32 Bit ADO is not able to work with 64 bit Provider and thats seems me a basic problem. I am fully convinced that Oracle 11.2.0.1 is not certified for Windows 7 and when we works with uncertified environment, there are and "should" issues, but at the same time, if anyone can help me to get it resolved or any clue because when I have 64 bit OS and 64 bit database software then issue remains only for 32 bit software's (VB6) ADO capability to work with 64 bit provider and/or ODBC; which seems me not a big deal, but yes at this time it is big for me though...
@ Moderator :
I know this is not correct forum; I should write in , but that seems me less activity over there, so I am trying to get help here.
Regards
Girish Sharma