I am using VB6 and ADO in conjunction with ODBC inorder to connect to a
MySQL database.
This is seems to be considerably slowing down my application.
Is there anyother mode of connecting besides ODBC - does anybody have any
experience with MyVBQL.dll or MYOLEDB - if so, please share your
experi
r MS Access, it is definitely
failing on the performance front and thats a shame.
I am also going to try your modified query and will post the results of the
EXPLAIN soon.
Thanks a lot for all your help;
Greg
From: [EMAIL PROTECTED]
To: "Greg Zimmermack" <[EMAIL PROTECTED]>
Su
should be looking at?
The error handler in in VB could not handle the error.
Is there some ODBC setting I need to optimize?
Any help will be appreciated.
Thanks
Greg
From: Victor Pendleton <[EMAIL PROTECTED]>
To: 'Greg Zimmermack ' <[EMAIL PROTECTED]>,"'[EMAIL PROT
I have an SQL which looks something like:
SELECT S.FirstName, T.CreateDateTime, T.TranDateTime, P.FirstName,
P.LastName, D.DiagnosisIDString, T.CheckNumber, T.StmtDesc,
T.ServPayAdjIDString, T.PatientAmt, T.InsuranceAmt, T.ClaimID,
T.AuditDateTime, T.TransactionType, T.ProviderID, PR.FirstName,
