Page 1 of 1

ColumnNames, SQL Compact and Vista

Posted: Fri 07 Dec 2007 20:11
by Hoken
Hi!

There is some problem with SQLCompact in Vista (Works in XP). Opening any SCHEMA_INFORMATION view results in a dataset without columnnames (only Column1, Column2... is displayed). The same happens with calculated fields ( "SUM(TableName.Fieldname) AS TheSum" results in a correct value but with Columnname Column1).

Posted: Mon 10 Dec 2007 09:48
by Antaeus
Does the problem persists only under Vista?
Also supply me the following information:
- exact version of SDAC. You can see it in the About sheet of TMSConnection Editor;
- exact version of your IDE;
- exact version of SQL Server Compact Edition. You can see it in the Info sheet of TMSConnection Editor.

Posted: Mon 10 Dec 2007 19:09
by Hoken
Antaeus wrote:Does the problem persists only under Vista?
Also supply me the following information:
- exact version of SDAC. You can see it in the About sheet of TMSConnection Editor;
- exact version of your IDE;
- exact version of SQL Server Compact Edition. You can see it in the Info sheet of TMSConnection Editor.
SDAC version = 4.30.0.13 for C++ Builder 6
IDE = C++ Builder 6
SQL Server Compact version, reported as 03.00.0000 by TMSConnection Editor

Yes, I only have this problem in Vista. Same database, same program in XP works fine

Posted: Wed 12 Dec 2007 17:29
by Antaeus
Thank you for information. We have reproduced the problem. The investigation of the problem is in progress. As soon as we solve the problem we will let you know.

Posted: Wed 19 Dec 2007 16:13
by Antaeus
We have fixed this problem this fix will be included in the next SDAC build. Please watch for announcements at the forum.

Posted: Tue 01 Jan 2008 12:57
by Hoken
Wonderful!!!

And please hurry! ;)