Go with ADO. BDE via ODBC is OK, but stay away from SQLLinks.
> The BDE doesn't seem to connect while SQL Server is running. Keeps telling
> me the file is in use, or the parameter is incorrect.
The only way to connect to SQL server is when it is running! Perhaps you
have your database in single user mode? IN any case it ought not to report
that a file in use. Are you sure you've got all the BDE settings correct?
You are not trying to connect to the SQL Server database directly, are you?
Regards,
Dennis.
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 8 June 2001 09:49
> To: Multiple recipients of list delphi
> Subject: [DUG]: SQL Server 7
>
>
> Hi all,
> I need to connect to an SQL server(7)database. First time for me.
> Delphi 5 pro.
>
> What is the best method?
> I have ODBC98 components. These seem quite slow.
> The BDE doesn't seem to connect while SQL Server is running. Keeps telling
> me the file is in use, or the parameter is incorrect.
>
> Dave.
> ------------------------------------------------------------------
> ---------
> 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"
---------------------------------------------------------------------------
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"
