Microsoft had fun with MDAC at one stage when the behaviour of connections with regards to cursor type on a connection ie you could put lots of forward only cursor connections on one DB connections, but the updates had to have their own connection. Mind you this was all for MDAC 2.3 and 2.4 so I doubt that this is your problem.
Getting the latest MDAC might help your issue though. If it is for reporting - have you thought about building a view on SQL to present all the data in a format that you need - so you only open the one table. Helpful if you have lookups ie client and client type etc. Peter Speden -----Original Message----- From: Eion McIntosh (Christchurch) [mailto:[EMAIL PROTECTED]] Sent: Monday, 3 February 2003 12:45 p.m. To: Multiple recipients of list delphi Subject: RE: [DUG]: SQL Access My PC as 2.52 and both servers have 2.61 > -----Original Message----- > From: James Sugrue [SMTP:[EMAIL PROTECTED]] > Sent: Monday, 3 February 2003 12:42 p.m. > To: Multiple recipients of list delphi > Subject: Re: [DUG]: SQL Access > > Might be a better way, but if you do a search for Mdac in the registry it > comes to version. > > > ----- Original Message ----- > From: Eion McIntosh (Christchurch) <[EMAIL PROTECTED]> > To: Multiple recipients of list delphi <[EMAIL PROTECTED]> > Sent: Monday, February 03, 2003 12:29 PM > Subject: RE: [DUG]: SQL Access > > > > SQL 2000. I have found that running the app on a server with the same > > version of the driver as the server I am having the problem with, is > working > > fine > > > > I can't recall, but where can you check on MDAC? > > > > Eion > > > > > -----Original Message----- > > > From: Peter Speden [SMTP:[EMAIL PROTECTED]] > > > Sent: Monday, 3 February 2003 12:22 p.m. > > > To: Multiple recipients of list delphi > > > Subject: RE: [DUG]: SQL Access > > > > > > Which version of SQL are you using? > > > > > > The BDE SQL Links are not supposed to work very well with SQL 2000 > (read > > > it is unsupported). The ideal is to use the ADO components. > > > > > > Also make sure you have MDAC 2.7. > > > > > > Peter Speden > > > > > > -----Original Message----- > > > From: Eion McIntosh (Christchurch) [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, 3 February 2003 11:25 a.m. > > > To: Multiple recipients of list delphi > > > Subject: [DUG]: SQL Access > > > > > > Hi > > > > > > I hope someone can help, but I have an app which connects via an ODBC > > > connection to an SQL database and the app can work fine. It opens and > > > accesses up to 19 tables, all of which are not open at any one time, > > > probably maximum 9 at any one time. > > > > > > The problem I have is that I am trying to add access to another table > > > for > > > printing of extra information on a report, and after that everytime it > > > is > > > failing to start up properly. I can see it start and memory usage > > > increase, > > > but then is seems to blow itself away. > > > > > > I was opening all the tables at the start of program and it was > blowing > > > itself away on when opening two of the tables for no reason I can see > > > of. I > > > have now changed to only opening the files when I need too. > > > > > > I am setting the tables filenames up at the start of the program, as > the > > > system can access two difference SQL database on two seperate servers > > > depending on a setting in an ini file. > > > > > > If I run the app, with the new table in it, if runs OK on my PC but > will > > > not > > > run on the server. > > > > > > Is there some settings or something that could be that different > between > > > my > > > PC and the Server.? The only thing I have just noticed is that under > the > > > BDE > > > administrator the SQL verison is 4 on My PC and the servers is 5. I > > > would > > > not expect this to have a huge effect. > > > It is an D6 app running on 2000. > > > > > > Can anyone please help? > > > > > > Eion McIntosh > > > PPCS Ltd > > > > > > > > > > ######################################################################## > > > ############# > > > This e-mail message has been scanned and cleared > > > > ######################################################################## > > > ############# > > > > ------------------------------------------------------------------------ > > > --- > > > New Zealand Delphi Users group - Delphi List - > [EMAIL PROTECTED] > > > Website: http://www.delphi.org.nz > > > To UnSub, send email to: [EMAIL PROTECTED] > > > with body of "unsubscribe delphi" > > > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > > > > ------------------------------------------------------------------------ -- > > > - > > > New Zealand Delphi Users group - Delphi List - > [EMAIL PROTECTED] > > > Website: http://www.delphi.org.nz > > > To UnSub, send email to: [EMAIL PROTECTED] > > > with body of "unsubscribe delphi" > > > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > > > > ######################################################################## ## > ## > ######### > > This e-mail message has been scanned and cleared > > > ######################################################################## ## > ## > ######### > > > ------------------------------------------------------------------------ -- > - > > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > > Website: http://www.delphi.org.nz > > To UnSub, send email to: [EMAIL PROTECTED] > > with body of "unsubscribe delphi" > > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > ------------------------------------------------------------------------ -- > - > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > To UnSub, send email to: [EMAIL PROTECTED] > with body of "unsubscribe delphi" > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ ######################################################################## ############# This e-mail message has been scanned and cleared ######################################################################## ############# ------------------------------------------------------------------------ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi" Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi" Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
