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/

Reply via email to