TempTables in Storeprocedures

[ofahed]

Hi All,

I was wondering if anybody else has experience this behaivor and if there is a solution to this problem.

Since we have switched to Win7 64bit, SQL2008R2, LV2011 we don't receive any returns from the storeprocedures using TempTables.(Works fine executing Procedure on Server)

Switching back to WinXP 32bit, SQL2008R2, LV2011 everything works fine again.

This will create a real pain, if we can't use temp tables working with LV and Win7.

Hopefully there is a solution without creating x.tables to try to process the returns of the storeprocedures.

Attached: Simple Storeprocedure, Return Data from TempTable

Thanks in advance,

Olli

[ofahed]

I guess it might be a bug, since Set values in a IF Cases will not be returned either when calling a storeprocedure 😞

[ofahed]

well if works but not if an Update is executed. Something like that.

the IF Condition doesn't really makes sense, but it is just to prove a point ;). If the UPDATE-Command is commented, Labview will return the expected 1

IF (1 = 1)
BEGIN
SET @Display = '1'
UPDATE dbo.T_blllahhbllahh SET LastLogin = GETDATE()
WHERE Username= @UserName
END

SELECT @Display

[ofahed]

I guess a workaround is using DSN-configuration instead of the UDL-configuration, under one aspect.

Creating the DSN connection with the ODBC-Tool from following folder.

C:\Windows\SysWOW64\odbcad32.exe

C:\Windows\System32\odbcad32.exe

Same name but different returns.

So now there is just one more thing to do, try to connect and get returns using udls.

cheers olli

[ofahed]

So i guess i got it solved:

I've replaced the udls, using connectionstrings.

link

works like a charm.

regards Olli

[Duffy2007]

Hi ofahed,

the database connectivity toolkit is only supported for 32 bit systems, this could be the problem.

Under this Minimum Version Requirements for Microsoft Windows 7 you can you can find the information.

[ofahed]

Hi Alex,

thank you for your reply and for the link. Good to know. 🙂

But i guess i forgot to meantion i am running LabView 2011SP1 32bit on a Win7 64bit machine. And after the table this should be supported since LV2009.

Everything is working like a charm now, just not using udl. As well I do like the alternative even more using the Connectionstrings. Setting up the DNS would work as well but maintance is more time extensive if there would be a change.

regards,

Olli