ODBC call failed....caused by too many controls???? 
Author Message
 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



Fri, 13 Aug 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. ODBC call failed....caused by too many controls????

2. PRB: ODBC -- Call failed (VB5 -- ODBC -- Access97)

3. Actual ODBC error codes rather than 3146 -- ODBC Call failed

4. Actual ODBC error codes rather than 3146 -- ODBC Call failed

5. [ODBC Microsoft Access Driver] ODBC--call failed.

6. [ODBC Microsoft Access Driver] ODBC--call failed.

7. ODBC Call Failed

8. Trapping an ODBC failed call

9. A97-SLQ6.5 ODBC calls failing or terribly slow - newer drivers are worse

10. ODBC call failed using ODBCDirect

11. ODBC call failed on linked table '???'

12. ODBC-call failed error

 

 
Powered by phpBB® Forum Software