[Lazarus] Accessing MS SQLServer database from Lazarus/FPC?

[Bo Berglund]

On Mon, 24 Jan 2011 22:20:38 +0100 (CET), Michael Van Canneyt
<michael at freepascal.org> wrote:

>
>In general RecordCount cannot be trusted; 
>It can be updated as the TDataset fetches records.
>
>In each case: SQLDB relies on ODBC to connect to MS-SQL.
>
>>From testing with MS-Access and MySQL I know that ODBC works fine with other 
>databases, at least for SELECT Statements.
>
>1. Can you test a regular SELECT statement on the same SQL database ?
>    If that doesn't work either, we know the problem is in the ODBC connection component.

See previous reply, I sent it off too soon....

>2. Can you test the same EXEC statement in a Delphi app through ODBC ?
>    If this gives problems, it means the ODBC driver is well - weird.
>    (although this would surprise me)

I will have to check how to use ODBC in Delphi7 first. I only ever
used ADO in Delphi for database work.


>3. If both previous attempts work, there is nothing left but to debug the ODBC connection component.
>    That means stepping through your code with the debugger.
>
>Michael.

This last point I tried to do but when I did "step into" after
stopping at a breakpoint at the query.Open line the complete Open
method executed and I got to the next line in the main procedure....


-- 
Bo Berglund
Developer in Sweden