ADODB 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 and with no related code change the connection to the database takes 10-15 seconds. It used to take no longer than 1-2 seconds. The application is MDI and essentially allocates space for a new ADODB.Connection object with every form. Thus, 10-15 seconds for each form to load is unacceptable performance.
Has anyone experienced such problems. How can I troubleshoot this? Any suggestions?
thx, in advance
George Papadopoulos
ADODB 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
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
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
service pack 2{resolved} -
I installed service pack 2 about a couple of days ago. It has made my computer extremely slow, especially at startup. It now takes forever to run a program: Like when I click on a program it takes a while to bring it up and then it still runs pretty slow. I was wondering if anyone
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
Connection to Database with Password *resolved* -
Hi,
I'm new to VB... and need to connect to an Access database file. I've found these codes in another thread here:
Dim objDB as ADODB.Connection
Set objDB = New ADODB.Connection
objDB.Open "provider=microsoft.jet.oledb.4.0;data source=<Path to your database file>
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
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
Resolved - SQL and VB -
Still having problems with getting my SQL code to look up the employee number and give me the employee name.
My problem now is that when i try to get the text box to fill i get an error message that says:
"Invalid Use of Property"
here's the code i'm using
intSupv
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.
First connection of day takes forever -
We just set up a server running Microsoft Search Server Express 2008. Everything is working fine except we have noticed the following. When users come in in the morning the first person to connect to the search site (which is an aspx page built by microsoft that the install sets up)
Type ADODB.Connection is not defined -
Hi all. Im a Delphi programmer by trade but I recently got a copy of Visual Studio 2005 so I could write some applications for PDAs.
Anyway, Im trying to connect to a MS SQL Server with ADO, and all the help Ive read tells me to do something like this :
Public Class Form1
Di
ADO Recordset object usage (RESOLVED) -
Hello everybody
I am trying to use the ADO Recordset object to enter a new record in a table. I have used code as shown below :
Dim rsTexnikos As ADODB.Recordset
Set rsTexnikos = New ADODB.Recordset
rsTexnikos.ActiveConnection = connbio_tech
rsTexnikos.AddNew
rsTexnikos.Fie
Best way to organize ADO objects in my program -
I have a VB6 program with about 25 forms that manipulates data in an ACCESS database via ADO.
Originally I had the bright idea to establish a data connection ONCE using a global ADODB.Connection object variable, and then create, open, and close ADODB.Recordsets in each form as requ
Add/remove programs spped up -
I have one PC that takes forever when you load the add/remove programs list.
How can I speed this up?
It takes a good 3 -4 minutes it seems.
THANKS !
passing connection to usercontrol *Resolved* -
hi all,
I m creating a user control and i need to pass an adodb connection object to that control.
Now i need to set that at designtime.
is it possible and if yes how shud i do that?
VB -->ADODB-->Access -
I have all my fields populted.
On to the next part.
How do I move around from record to record?
This is what I have so far for the record connection.
Private cn As ADODB.Connection
Private rs As ADODB.Recordset
Private Sub Form_Load()
Set cn = New ADODB.Con
Why have 30 minute Connection Timeout -
OK I ran accross the following tidbit from Jhausman:
'Either your command (most likely) or your connection is timing out. Luckily, you can set both:
'Dim g_Db As New ADODB.Connection
'g_Db.CommandTimeout = 1800 'about 30 mins
'g_Db.ConnectionTimeout = 1800
My question is, usin
computer porblem -
I have a gateway g6-233M, 233 mHz Intel II, 30 gigs, 96 RAM. Whenever my computer goes through loops that look at the computer information, such as when you add components to a vb project and it gets all .ocx's and .dll's, it takes a lonngggggggg time. Also when I click open with..., i
Help if connection error pls(RESOLVED) -
Hi,
I have problem with code like this:
vb code:
_______________________________________________________________
Option Explicit
Dim objConnection As ADODB.Connection
Dim objRS As ADODB.Recordset
Set objConnection = New ADODB.Connection
objConnection.ConnectionString = &q
.refresh (query) question -
When I run a query from Excel pocedure which connects to the internet, sometimes the 'connect to web' takes forever and eventually times out, causing the procedure to abort. Can anybody tell me a way to either abort the wait and return control to the procedure, or speed up the connect
Declare Connection Once for All -
I notice that i have to use these codes below very often. I would like to declare Once in the Module and call from other forms.
Dim adoConnection As ADODB.Connection
Dim adoRecordset As ADODB.Recordset
Dim ConnectString As String
'Create a new Connection
Set adoConnection =
New adodb.connection -
Hello everybody,
could anyone tell me the difference between
Set Rs = new adodb.connection
or
Set Rs = adodb.connection
Thanks
Bjorn
Transaction Processing -
Hi Everyone,
I just need some information about Transactions in VB 6.0, so here we go.
Sub Test1()
Dim connA as ADODB.Connection
Set connA = New ADODB.Connection
connA.BeginTrans
....
Code Here
.....
Call Test2
'If no problems then Commit
connA.CommiTrans
'
"Simple" problem with ADO -
I'm working on making the connection between VB and and access database using ADO. For some reason, everytime I run the program, I get a compile error right from the start on the declaration of the ADODB.Connection, ADODB.Command, or ADODB.Recordset.
Dim objConn As ADODB.Command
D
connection got error -
im using ms access as my database, adodb connection..
the error is : is not a valid path?
here is the code.
[code]
public cn as new adodb.connection
public sub connection()
set cn = new adodb.connection
cn.connectionstring = "Provider = Microsoft.Jet.OLEDB.4.0;Data
**RESOLVED** Keep setup from rebuilding every time I Start -
Hi All,
I'm at the deployment stage of my app and I've stumbled across an annoyance.
Whenever I Start(F5) my program in .NET 2003 it builds the app and then it goes through and builds the entire Setup project. This takes forever because I have Crystal Reports merge modules and a n