Results for the ADODB Connection takes foreverADODB Connection takes forever (RESOLVED) -Hello everybody I have been building this VB 6 database application for some time. It uses MySQL as a back end (storage) and VB 6 as a front end. The connection to the MySQL database is done using ADO. Everything was working nice & fast till yesterday. For no apparent reason a Allocation Question - If I allocate an array of objects to the size 1024*1024 - 1048576 my comp gets nice and laggy when loading, takes forever...i mean forever. Simply half of that 512*512 - 262144 and my comp can get it done in the snap of a finger. I know there is almost a 750,000 difference between replying takes forever - sometimes replying to a thread TAKES FOREVER and lately this has been happening a LOT Just Got C# - Hi There! I just downloaded .NET SDK and the free C# IDE and I have a problem with it - it is too slow. The IDE takes forever to load and takes forever to do stuff, especially painting windows. Is there a way to speed all this up? And By the Way, is Java and C# the same speed? good email clients - eudora has seemed to have crapped out on me. takes forever to start. working for a few days. worked great before i formatted..right clicking in IE takes forever also. defagging 5 times didnt help either...soooo whats some good (lightweight) email clients that support POP and IMAP? i Is the Connection closed - Question??? How do I check to see if 1 or the other connection to a database are closed or not? Dim cnnDVD As New ADODB.Connection Dim rstDVD As New ADODB.Recordset Dim rstDVDCheck As New ADODB.Recordset Dim strSQLDVD As String ADODB - Slow update - Greeting, I have 2 adodb.connections, and 1 recordset for each of the connections. Both recordsets open the same ms-access table. while I update changes to one recordset and requery on the other recordset, the changes is not reflected on that other recordset immediately. Only aft ActiveX dll Class & ADODB Connection problem - Howdy, I'm developing an ActiveX dll and having some major problems I want my dll to have basically house functionality to create some reports from a database to a disk file. I have made a class for each report but am having trouble with the database connection in the class object. [2005] adodb.connection is no more - Error 1 'Connection' is ambiguous in the namespace 'ADODB'. dim conn as new adodb.connection conn = new adodb.connection what am i doing wrong here? how do i make a conenction like this and also how do i do it for a recordset? dim rs as new recordset is what i us Slow ADO/ODBC to Oracle - Hi, I have VB6 code here to access Oracle 8i with ADO/ODBC. I found the performance is very bad. If I run the same query from SQLPlus, it only takes a few seconds. But with the program it take a few minutes. The bottle neck is the statement of checking rstSource.EOF. I am using Micros Can't Figure Out Connection String - Hello, I have a ODBC Data Source for a SQL Server. The text connection was good. I am trying to connect with my VB application to the database with ADODB. I get a "Operation is not allowed when object is closed message". Basically, my connection is not open and methods fai VBF REALLY = teh carp - damn it, It takes weeks to view a page, editing posts takes forever. Totally bogus dudes. [2005] Allow User to Filter DataGridView - Ok, having some trouble with this. I want to allow users to filter by any of the columns in a datagridview. I currently have comboboxes for each of the columns. I want the comboboxes to have each of the values, no duplicates, and the first item to be (All), so they can choose Slow Right Clicking and Deleting in Win Explorer - Whenever I right click on a file, no matter which hard drive im using, it takes forever and a day for the little menu with Copy, Cut, Delete, Properties, etc to come up, same goes for when I just click a file and hit delete - it takes forever once again for the confirm delete box to co Checking for NULL ADODB.Connection (RESOLVED) - Hello everybody I have this problem. When a form of my application is closed, it eventually closes the ADODB.Connection to the MySQL database. Unfortunately, on some occasions the reference might not have been set due to an error of some kind. How can I check to see if an ADODB. Multiple Selects(resolved) - If I am populating many different controls all with different tables within the same database do I need to have multiple rs and cn statements ie. Private adoRS As ADODB.Recordset Private cn As ADODB.Connection Private adoRS2 As ADODB.Recordset Private cn2 As ADODB.Connectio ADO problem and DAO question - Can you not open a password protected Acess 2000 database with ADO? I choose Jet 4.0 as the provider, but whenever I test the connection it says workgroup file is missing or the database is locked exclusively. I put the password in but to no avail. I end up using oledb, but it takes ADODB.Connection Issue - hi everyone ... i use adodb.connection and sql db i connect to my db through adodb connection. then i activate my application role with: adoCon.execute "sp_setapprole 'myrole', 'myrolepwd'" first time i open the connection its work fine. then i close the connec Can you convert this code - Can someone help me convert this code from ADO to DAO. I'm getting nowhere. It takes and reads the tbl_Catagories which has two field (containing 48 records - CheckboxID and Description) and populates the Caption of a checkbox array. It works in ADO but the project I need to use it in Regarding ADODB connection - I'm using ADODB connection object in Visual basic to access data from SQL server. Should i close the connection while ending the application? or will the connection automatically closes when closing the application? Thanks for any help. Regards Sujatha. |