I have a small sample program written in Visual Basic which accesses an Oracle database using the scott/tiger schema.
It's Visual Basic 6 Pro, Service Pack 5 and Personal Oracle8i, both of which are running on Windows 2000 Professional.
Also, I understand Visual Basic better than I do Oracle, whatever flavor.
When I compile this program and run it as a standalone executable app, it runs fine.
But, it needed to be included into a larger VB application. So, it was added in.
I compiled the whole thing and when I clicked on the menu choice to launch it, it worked fine there too.
Now, I decide to try to package this larger app into something someone could install on their own PC.
Well, now, after I've run the Setup.exe for this and installed it (a sort of practice run) on my PC, I click on the portion of the VB app which accesses the Oracle database. I NOW receive this error message:
"Data Source name not found and no default driver specified. Run-time error -2147467259" Click 'OK'.
"Oracle client and networking components are supplied by Oracle Corporation and are part of the Oracle
version 7.3.3 or later client software installation. Provider is unable to function until these components
Would anyone have any thoughts as to what drivers or library files need to be added to the package? Should I merely copy every driver file/dependency/ library file from my Oracle\bin folder? Or, should I abandon the attempt to put this into the Visual Basic application altogether?