I am using BDE currently, have not looked much into ADO. As mention 3 or 4 other report are using the same table and there fine. The other strange things is that it all works fine off my PC and on our development server. It's only our live server which is causing the problem.
Eion > -----Original Message----- > From: vss [SMTP:[EMAIL PROTECTED]] > Sent: Monday, 4 November 2002 1:06 p.m. > To: Multiple recipients of list delphi > Subject: Re: [DUG]: SQL Access error > > Are you using the BDE to connect to the SQL Server? > If so, why not use ADO? > Also, its not a permissions problem on the table thats causing error? > You have checked its not trying to access a field that is misspelt or > something? > > Jeremy > > -----Original Message----- > From: "Eion McIntosh (Christchurch)" <[EMAIL PROTECTED]> > To: Multiple recipients of list delphi <[EMAIL PROTECTED]> > Date: Mon, 4 Nov 2002 12:33:46 +1300 > Subject: [DUG]: SQL Access error > > > Hi > > > > I have an app which connects via ODBC to an SQL database on a WIN2k > > server, > > which depending on the 4 parameters passed, automatically starts, runs > > and > > prints 1 of 7 reports. > > One of the reports is creating an access violation against IDAPI32.dll > > when > > opening one of the tables. > > If the program is run manually, ie a form appears to put in the > > parameters, > > it works fine. The same table is used in most of the other reports and > > they > > all run automatically ok. It's just this one which does not. > > I've checked the assignment of the tablename and index, and they appear > > ok. > > The permission against the tables are all ok, so I'm unsure what to try > > an > > check next. > > > > Any ideas please? > > > > 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/
