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/
