ColumnNames, SQL Compact and Vista

Hoken · Post by **Hoken** » Fri 07 Dec 2007 20:11

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).

Antaeus · Post by **Antaeus** » Mon 10 Dec 2007 09:48

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.

Hoken · Post by **Hoken** » Mon 10 Dec 2007 19:09

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

Antaeus · Post by **Antaeus** » Wed 12 Dec 2007 17:29

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.

Antaeus · Post by **Antaeus** » Wed 19 Dec 2007 16:13

We have fixed this problem this fix will be included in the next SDAC build. Please watch for announcements at the forum.

Hoken · Post by **Hoken** » Tue 01 Jan 2008 12:57

Wonderful!!!

And please hurry!