Hi,
Most of the Tables I have were imported from an access database and it seems
that these ones give the most trouble so perhaps I need to re-create the
database from a script properly. ADO works much better than the ODBC
connection I just tried it. yes I have SP2 installed but MS Access 97 can
link to the SQL database (ODBC) ok but Delphi cannot (via ODBC).
Thanks
Jason
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Myles Penlington
> Sent: Sunday, August 06, 2000 9:24 PM
> To: Multiple recipients of list database
> Subject: RE: [DUG-DB]: Delphi5 ro MSSQL 7
>
>
> We use ADO and it works fine (except for ADO/SQL server bugs we
> have to work
> around).
> Have you the latest service pack for SQL7 - Sp2 was the last one we
> installed.
> ODBC works fine also.
>
> Sounds like your DB may already be corrupt ... Welcome to MSSQL7
>
> Myles.
>
> > -----Original Message-----
> > From: Jason Webb [SMTP:[EMAIL PROTECTED]]
> > Sent: Sunday, August 06, 2000 10:15 AM
> > To: Multiple recipients of list database
> > Subject: [DUG-DB]: Delphi5 ro MSSQL 7
> >
> > Can someone please suggest the best way to connect Delphi 5 Ent to MSSQL
> > 7.
> > I've tried ODBC but I continually get "List index out of bounds(x)"
> > errors.
> > ADO seems to be a little bit better but still errors.
> >
> > I did see a note on the Inprise site to day that Delphi did not support
> > MSSQL 7 yet. But then another note to say you needed BDE v5.1 to connect
> > to
> > MSSQL.
> >
> > Any comments would be appreciated.
> >
> >
> > Thanks
> > Jason
> >
> >
> --------------------------------------------------------------------------
> > -
> > New Zealand Delphi Users group - Database List -
> [EMAIL PROTECTED]
> > Website: http://www.delphi.org.nz
> ------------------------------------------------------------------
> ---------
> New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
