Difficulties with SQL Toolkit and Vista

[Tomsaw]

Hello there.

We are using SQL Toolkit 2.06 now for a long time.

Migrating to VISTA now we came in trouble. Some functions of the SQL Toolkit don't work as expected. It concerns the issue, when a selection of a date value from the database is made. Therefore you must know I'm working on a german system.

Example:  (I don't print the CVI code here because it's in my opinion not the problem)

   SELECT MAX(DATE) FROM TABLE WHERE ... returns  a string like '4'  (it was just the day 4, 4th May)

I wanted to check if the new SQL Toolkit (2.1) reacted the same way and installed the eval version.

Unfortunately though it went better, it also didn't behave the way my program was used from WinXP

   Under WinXP the query returns e.g. '04.05.2009'

   Under Vista it returns  '4.5.09'

The system settings (regional options) on both systems were identical.

After uninstalling SQL Toolkit 2.1 and using my old 2.06 again, curiously I couldn't observe the behaviour as before installing 2.1.

I don't exactly know what best to do now to fix my problems - am I forced to buy the new version and look further ? Can I patch my 2.06 ?

Anyway it seems I have to change my code and this makes me sorrow ...

Best Regards

   Tom

[Marian_O]

Hello Tom,

thank you for posting at our forum.

Windows Vista is supported by the LabWindows/CVI SQL Toolkit starting with version 2.1. Unfortunately, version 2.0.6 used by you is not officially supported.

For upgrading 2.0.6, you have to contact your local National Instruments sales department

Regarding your question about the date format, I have to do some testing here.

Best regards

[Marian_O]

Hi Tom,

you mentioned already, that you checked the regional settings, but please verify the exact format of the date:

 

[Tomsaw]

Hi Marian !

Thank you for the answer. I was not in the Office for some time, so I read the answer at last today.

Unfortunately this doesn't solve the problem, because the settings on my system were exactly as shown in your picture :mansad:

Would be nice if you had any other suggestion.

Best Regards,

   Tom

[Marian_O]

Hi Tom,

I am on vacation now as well. So, what version of the SQL toolkit are you using now with Windows Vista? Is it the one purchased by you (2.0.6) or is it the evaluation copy 2.1?

Best regards from Frankfurt

[Tomsaw]

Hello Marion,

Now I tried them all. On the same system without changing any settings.

Ver. 2.05: Query returns "11.05.2009 10:12:48"

Ver. 2.06: Query returns "11"

Ver. 2.10: Query returns "11.5.09 10:12:48"

The system setting for the date was TT.MM.JJJJ