CPU goes up to 90% when selecting a SQLCommand on a Component

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Microsoft SQL Server
Post Reply
Dees

CPU goes up to 90% when selecting a SQLCommand on a Component

Post by Dees » Fri 27 Jul 2007 13:26

Hello,

I downloaded and installed SQLDirect.NET for Delphi.

After creaing a new ASP.NET project, i created a Component for Windows Forms.

This component is responsible for the connection to my database. The owner of my SQLConnection and SQLCommands. These are dropped on the component.

When selecting a SQLCommand the process BDS.EXE takes 90% of CPU usage.

Does anyone recognize this problem or has a solution?

My Configuration is:
Windows XP Pro
Delphi 2006 up to Hotfix 10

TIA, regards,
Dees

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 27 Jul 2007 14:16

What do you mean by "selecting a SQLCommand on a Component"? Please describe in detail.
What is your hardware architecture?

Dees

Post by Dees » Fri 27 Jul 2007 14:37

Hy Alexey,

When selecting the SQLCommand, I just click it once. So I can change properties like Connection and CommandText in the Object Inspector.

But after this click the CPU goes up to 90% and i can't change anything in the Object Inspector.

The hardware specs laptop:

HP Compac NC6120

Intel Pentium M 2.0 Ghz (Centrino)
1,5 GB of memory.
80GB harddisk
Win XP Pro Service Pack 2.

See also the screenshot:..

Thanks for helping so far, regards
Dees

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 27 Jul 2007 14:52

So, if I got you right, after the click your laptop hangs on?

Dees

Post by Dees » Fri 27 Jul 2007 14:55

Yes, that's what happens.

Only the SQLCommand gives this problem. The SQLConnection works fine.

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 27 Jul 2007 15:11

OK, I will try to reproduce this problem.
What are the version and edition of your SQLDirect .NET?

Dees

Post by Dees » Fri 27 Jul 2007 15:16

Hi,

sqlnet.exe file version 1.0.2.0
Description: Core Lab SQLDirect .NET Data Provider Trial Setup

in Delphi 2005 i'm having the same problem.

TIA, regards
Dees

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 27 Jul 2007 15:43

Could you send me your project? Because I can't reproduce the problem with me simple app.
Use e-mail address provided in the Readme file.

Dees

Post by Dees » Fri 27 Jul 2007 15:54

Demo app, send by email.

Success, i hope you can find anything.

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Mon 30 Jul 2007 08:00

I've reproduced the problem. Now we are investigating it. Look forward to hearing from me again.

Post Reply