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
