I would definitely upgrade to Mdac 2.7 on all then. Apparently the ODBC driver only works correctly under MDAC 2.7
----- Original Message ----- From: Eion McIntosh (Christchurch) <[EMAIL PROTECTED]> To: Multiple recipients of list delphi <[EMAIL PROTECTED]> Sent: Monday, February 03, 2003 12:44 PM 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/
