If you go to http://www.microsoft.com/data/download.htm you can get the latest MDAC and a component checker that will tell you the version.
Peter Speden -----Original Message----- From: Eion McIntosh (Christchurch) [mailto:[EMAIL PROTECTED]] Sent: Monday, 3 February 2003 12:30 p.m. To: Multiple recipients of list delphi 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/
