After selecting the correct version, click the OK button: Now let’s add a couple of additional controls to the project. Close End If Else int Result = Msg Box("Could not connect to the database.I first started using the Microsoft Grid Control in Visual Basic 2.0, so for old time’s sake let’s add that control to the project. Check your user name and password." & vb Cr Lf & Error(Err), 16, "Oracle Connection Demo") End If db Database.As I mentioned, Visual Basic 6 is not officially compatible with Windows 7, and the fact that it is a 32 bit application running on a 64 bit Windows computer means that the 32 bit Oracle Client must also be installed on the computer.
First, we need to add a reference to allow the project to use ADO and the Oracle Provider for OLE DB that was installed with the Oracle Client.
From the Project menu, select References…: Next, we need to add the most recent version of the Microsoft Active X Data Objects Library, version 6.1 for Windows 7 and Windows 8, version 6.0 for Vista, or version 2.8 for Windows XP.
Several people offered very good advice to guide the OP.
The OP eventually asked how to connect Visual Basic 6 to Oracle Database Personal Edition running on the same Windows 7 Pro 64 bit computer.
First, when installing Visual Basic 6, you may want to install and register a couple of additional uncommonly used controls.