Yes I was pointing to the filename. Silly eh? But I couldn't get the BDE to
connect anyway. Some parameter problem. I have decided to dump a lot of the
existing code for Access (Opus Directaccess) and rewrite for SQL.
Seems to be going OK at the moment.
Dave.
----- Original Message -----
From: "Dennis Chuah" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Friday, June 08, 2001 11:53 AM
Subject: RE: [DUG]: SQL Server 7
>
> 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"
>
---------------------------------------------------------------------------
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"
