Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Problem with connection FDTable to MS SQLServer in XE8


This question is answered.


Permlink Replies: 2 - Last Post: Apr 24, 2015 7:09 AM Last Post By: Frantisek Kvicala
Frantisek Kvicala

Posts: 4
Registered: 12/14/02
Problem with connection FDTable to MS SQLServer in XE8  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Apr 22, 2015 9:23 AM
Hi,
I try in XE8 connect MSSQL dababase using FireDAC.

When I try
FDConnection -> FDQuery -> DataSource -> DBGrid
Everything works correct.

But when I try
FDConnection -> FDTable
it raise error [FireDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt.

On embarcadero docwiki i found solution for similar problem -
Set FDConnection parameter MARS=TRUE, or parametr ODBCAdvanced MARS_Connection=YES.
But in this case both doesn't work.

Does anyone have any idea?
Thanks.
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: Problem with connection FDTable to MS SQLServer in XE8
Correct
Click to report abuse...   Click to reply to this thread Reply
  Posted: Apr 22, 2015 9:45 PM   in response to: Frantisek Kvicala in response to: Frantisek Kvicala
You should install SQL Server Native Client
http://docwiki.embarcadero.com/RADStudio/XE8/en/Connect_to_Microsoft_SQL_Server_(FireDAC)

--
With best regards,
Dmitry Arefiev / FireDAC Architect
Frantisek Kvicala

Posts: 4
Registered: 12/14/02
Re: Problem with connection FDTable to MS SQLServer in XE8  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Apr 24, 2015 7:09 AM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
Thnaks!

Solution with SQL Server Native client works correctly.

Exactly as is written in embardacero docwiki, I'll try search there better next time.

Thank you very much for the advice.

Frantisek
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02