Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
sql tareas
Jose_Luis_Villa
Member
07-18-2007 11:30 PM
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report to a Moderator
muy buenas noches
estoy trabajando con base de datos... estoy utilizando la herramienta gratuita labsql.... hice un programa para atravez de comandos leer y escribir datos en la database
tambien tengo otro programa para atravez de botones navegar por las pestañas de un tab control
el problema es cuando pego el codigo que maneja la base de datos dentro el un while que es el que maneja las pestañas del tab me sale el siguiente error...
Exception occured in Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][Controlador ODBC Microsoft Access] Demasiadas tareas de cliente. in ADO Connection Open.vi->Panel Principal.vi
No se si tenga algo que ver que el codigo que maneja la base de datos este dentro del while... intente sacarlo pero no fui capaz....
el codigo del error es 2147217843
adjunto unas imagenes del codigo
de ante mano muchas gracias
07-18-2007 11:43 PM
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report to a Moderator
Efectivamente el error nace cuando meto el codigo que maneja la base de datos dentro de un while....
ahora entonces la pregunta seria como hago para que se ejecute el codigo que maneja la base de datos por fuera del while que controla las pestañas del tab control....
adjunto unas imagenes para que les sirva de guia..
muchas gracias..
Oliveira, Murilo
Member
07-27-2007 09:49 AM
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report to a Moderator
Here's a place to start the troubleshooting:
- Open the UDL itself by double clicking it. It should open to the Connection tab.
- Click on the Provider tab and make sure that Oracle Provider for OLE DB is selected.
- Return to the Connection tab and make sure the value in the Data Source field is the name of a valid TNSNAMES file entry.
- Make sure your user name is in the User name field
- If it's blank, enter your password into the Password field
- Click the Test Connection button
- If this fails (and from what you said it should) call your Oracle support folks - until this works LV's connection won't work.
- If this works, make sure that LV is pointing to the correct UDL
- If testing the UDL works (step 6), and LV is pointed to the right UDL and it STILL doesn't work, let me know and I'll post some simplifed test code.
