
ODBC call failed....caused by too many controls????
Has anyone experienced this problem and come up with a solution.
I am using VB4.0 16 bit, with an Oracle 7 database. In code I am
attaching an Oracle table to an Access 2.0 database. The ODBC driver
is from Oracle and version 7.3.
I have created a new project with only one form and one command button
on that form. In the "on click" event I am attaching an Oracle table
to the
mdb. This works fine at this level. However, if I add a lot of
Controls to the toolbox (all of the controls are Microsoft or 3rd
party that come with VB) I get a failure to connect with a reported
error of ODBC--call failed.
The strange thing is that I am not actually using any of the added
controls in the project, I have just added them to the toolbox.
If I compile this simple project then it
again works. There is not any single control that "breaks" the
application as I have tried various combinations. It seems that it is
just a threshold that gets exceeded.
Obviously, you don't want to distribute an application with unused
controls in the toolbox, the reason for this was to start immitating
my real application that does not work and does use several controls.
Has anyone run into anything like this. The Knowledge base didn't
have anything and Microsoft Support said they have had reports of this
but have never been able to duplicate it against their SQL Server.
Thanks in advance.
Duane