Devart Forums

When will the full installation be supported in VisualStudio 2022?

Hello,
I connect from the client to the Server over a network via VPN.
The ConnectionTimeout is set to 5
For a test I close the VPN and then try to Ping to the Server.

Hi,
how to set connectionTimeout for the Ping method?
I set connectionTimeOut to 5.
But if ping fails it always takes over 45 seconds.
can i change it?

Thanks for help

Hi,
How can I determine if there is a connection to the Oracle server?
If for example the connection is interrupted by a towed network cable.
Is there a function in the ToraSession component?

Thank you for your support

First congratulation for the new Version "the new Version is great".

I have two suggestions:
First:
I saw you use devexpress components for the Version.
with this components it is ease to translate the GUI in different languages.
are there any plans to do this?

secondly:
create a possibility to easily compile all not compiled Objects in a schema.
e.g.
1. klick a Button
2. show all not compiled objects in a Table
3. klick a Button and all objects would be compiled

I hope you can implement this
Thanks
EarlyBird

are there any plans to implement such features.
which features you plan in next releases?
Is there a roadmap?

Thanks for response.
i know the advanced design time support.
(I like all your components)
In Delphi i use FilterSQL support very often at runtime.
This makes my life much more easy.
Now i miss this feature in the SqlDataTable component.

My question is:
What is the best way to change the where clause of select Statment at runtime?

There are many features of the delphi version of the sdac components that make my life as a programmer easier than it was (such as filtersql, filters just to name a few).
How to use the FilterSQL feature in the sqlDirect.net components?
I'm new in the sqldirect.net world.
Thanks for help
EarlyBird

There is no BeforeExecute event in SDAC 4.8 TMSQuery component

can you compile my Demo with Latest Version of SDAC Components an send it Back to me?

I will test your proposal

I've sent you the test project by e-mail

I´ve created a test Project.
I can send it to you if you want.
(Source und EXE)

I am a registerd user of SDAC Version 4.
I can´t get Version 5, only the Trial edition.
I tried to install the latest Trial Edition.(5.00.0.4)
But i get the Message

You are using SDAC Trial edition!
60 day(s) of 60-days trial period left.
You may register SDAC at http://www.devart.com

What can i do now?

Hello,
I have a very strange reproducible problem.
First I describe the system configuration
A PC with Win XP and a SQL 2005 database is installed.
A client PC with Windows Vista
A client PC with Windows XP
All PCs are in a domain network (with an win2008 domain server)
SDAC Version 4.80.0.55
Delphi 2007
Microsoft SQL Server: 09.00.4053
Microsoft OLE DB Provider for SQL Server: 08.00.1132

Now to my problem:
On the WinXP PC my program works fine.
The response times of TMSConnection, TMSQuery and TMSTable components is, as usual, very fast.

But the same program on a Vista PC has, in certain settings, very slow response times.
Every thing is ok if i set Authentication mode to SQL Server.

Authentication = SQLServer
(TMSTable) MST_2.FetchAll := False

MSConn1 open Time: 0,0050759245
MSQ_1 open Time: 0,0797080355 records 300
MST_2 open Time: 0,0046760831 records 100
MST_3 open Time: 0,0069861533 records 0
MST_4 open Time: 0,0053938420 records 8
MST_5 open Time: 0,0056363309 records 0
MST_6 open Time: 0,0173821673 records 3
MST_7 open Time: 0,1172550562 records 7343
-----------------------------------------------------
---SDAC Time total: 0,2862833125 ---------


Authentication = SQLServer
(TMSTable) MST_2.FetchAll := True

MSConn1 open Time: 0,0051203435
MSQ_1 open Time: 0,0706835645 records 300
MST_2 open Time: 0,0205293550 records 2518
MST_3 open Time: 0,0018612701 records 0
MST_4 open Time: 0,0008094604 records 8
MST_5 open Time: 0,0010774414 records 0
MST_6 open Time: 0,0042031878 records 3
MST_7 open Time: 0,1131714366 records 7343
-----------------------------------------------------
---SDAC Time total: 0,2601501029 ---------

But if i set Authentication mode to Windows the connection needs over 3 seconds.
The response times of the tables and queries are OK

Authentication = Windows
(TMSTable) MST_2.FetchAll := True

MSConn1 open Time: 3,0566405786
MSQ_1 open Time: 0,0711551328 records300
MST_2 open Time: 0,0205642058 records2518
MST_3 open Time: 0,0016845018 records0
MST_4 open Time: 0,0008307620 records8
MST_5 open Time: 0,0010441970 records0
MST_6 open Time: 0,0044097783 records3
MST_7 open Time: 0,1121986174 records7343
-----------------------------------------------------
---SDAC Time total: 3,3016606161 ----------

Now i set FetchAll property of the "MST_2" table to False
As you can see, all subsequent queries run much slower.

Authentication = Windows
(TMSTable) MST_2.FetchAll := False

MSConn1 open Time: 3,0548793911
MSQ_1 open Time: 0,0713307837 records300
MST_2 open Time: 0,0045500196 records100
MST_3 open Time: 3,0640945986 records0
MST_4 open Time: 3,0527143115 records8
MST_5 open Time: 3,0539437973 records0
MST_6 open Time: 9,1685981738 records3
MST_7 open Time: 3,1636742938 records7343
-----------------------------------------------------
---SDAC Time total: 24,6932550087 ---------

All settings on both Clientmaschines are the same.
I need the Windows Authentication mode on all Client maschines.
And i need to set FetchAll to False on some Tables and Querys.
What other settings i need on the Vista Maschine?
(I´ve reproduced the same Problem also on Win7 Client PCS)

I hope you can help me
Thanks EarlyBird

Hi,
thanks for quick response.
I tryed your solution.
It works .
But i need a little more information for the User.
Is there a event fired if i try to edit a locked record?
At the moment i get no message.
I only can´t edit the record.
(Thats good)
If the first user has finished editing the record and then i try to edit the record i get a message:"Record was changed by another user."
Is it possible to get my own message for this.
And last: is it possible to refresh only the changed record automaticliy?


Thanks for help