Contact the vendor of the ODBC driver you are using for tech support.  That was a big help for me with the Oracle/Rdb driver and I had a similar problem...

Rdb linked servers here have "data access" and "remote collation" properties checked in the linked server def.  In the ODBC properties, "cursor=nohold" is used.

Jeff

Is your ODBC data source for an Rdb database? 

If so:

(1) Have you tried the 2.X (preferable) and 3.X versions of the Rdb/ODBC driver?

(2) Do you have columns of type...

The above solution is the best for the long term, but if you have hundreds of pkgs to quickly edit try the following VBScript task.  It will need to be...

Try: lazydba.com (great name), dba-village.com, technet.oracle.com, metalink.oracle.com (if you have the support agreement).  There's lots more.  I used metalink the most in the past.  I'm going in the opposite direction...

A u.d.f. is nondeterministic if it invokes anything nondeterministic (an extended stored procedure or a nondeterministic u.d.f.).

Here is an example of a nondeterministic u.d.f. (TestNonDetUDF1) which invokes a nondeterministic u.d.f....

A user-defined functioned can invoke a nondeterministic user-defined function but it cannot invoke a built-in nondeterministic function (e.g., GETDATE). 

Jeff B.

Here are the best books I have used on Active X in DTS:

(1) VBScript Programmer's Refererence by Clark, Donatis, et al (Wrox Press)

(2) VBScript Pocket Reference by Childs, Lomax, and...

REDGate SQL Data Compare is great, but if you are budget constrained and can't procure that use the built-in BINARY_CHECKSUM function:

DECLARE @BC1 INT, @BC2 INT

SELECT @BC1=BINARY_CHECKSUM(*) FROM <table> WHERE <clause to...

I'm a registered fool now!

My office (across the river from you in Wash. DC) is also looking for a SQL DBA but as...

Not sure exactly what you are attempting, but maybe word <AddLedger> needs single quotes around it?

Jeff

Here are some other things to try that we have done to get around problems in nonSQL ODBC access:

(1) Also, if you have not done so already, remove any constraints/indexes...

Suggestion:

If it's possible, the link should be changed to one that does not require "registering" and providing personal info to get to the job listing.

Jeff

You did not mention the nonSQL db you were accessing.  Also, how long is it hanging?  Have you tried setting/varying parameter "fetch buffer size"?  Have you tried splitting the data...

That's my major beef with UDF's.

The other is that input parameters can be specied with default values, but they are really all required!  And you can't use GETDATE() without going...