MS SQL Server ODBC - SQL-Server Functions return NULL

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQL-Server Functions return NULL

Pierre Albisser

2006-02-09, 3:23 am

Hello Newsgroup,

i've got a strange problem with SQL-Server Functions called via ODBC:
(MSSQL 2000, SP1 - SP 4, MDAC 2.6 - 2.8, VFP as Client)
I've integrated more and more SQL-Server Functions into my queries.
Now, every now and then, suddenly ALL of my functions return the value
of NULL. I cannot find any reason at all for that. Once i close my
connection and reconnect, everything works fine, but it's a rather
nasty workaround.

Anyone any clue?

--
Pierre

Sponsored Links