Connection problems with dbexpsda.dll

jeroenc · Post by **jeroenc** » Tue 23 Nov 2010 15:57

We have an application here which uses dbxexpsda for connection to SQL server. In the past we used version 4.10 with succes. We have recently upgraded to version 4.75 because it fixed DEP problems for us.

The problem is now that when we install our program on a virtual machine or on an empty machine, that our program hangs when the connection to SQL server is made. We've checked it with DBMonitor, no connection is being made, it just hangs on 'pending..'

When we replace the dll with the old version, everything starts working again, but then we have DEP problems again, of course.

I have no idea where to start looking for the cause of this problem. Is there anyone at devart that can help us?

AndreyZ · Post by **AndreyZ** » Wed 24 Nov 2010 12:38

Hello,

I cannot reproduce the problem. Please try using SQL Native Client provider. For that set the VendorLib property of the TCRSQLConnection component to sqIncli.dll.

jeroenc · Post by **jeroenc** » Wed 24 Nov 2010 12:56

Hello Andrey,

Thanks very much for the response. Setting it to sqlincli.dll solved our problem. So again, thanks.

AndreyZ · Post by **AndreyZ** » Wed 24 Nov 2010 13:06

It is good to see that this problem was solved. If any other questions come up, please contact us.

jeroenc · Post by **jeroenc** » Wed 24 Nov 2010 15:09

Hello Andrey,

I'm sorry to say we've come up with another issue. We have replaced the vendorlib with sqlncli.dll, as you suggested. That solved the connection problems for us, but now we have problems with reading in memo fields. A field, defined as text in SQL server 2005, is cut to 4040 characters, while the real length is along 32 K.

AndreyZ · Post by **AndreyZ** » Thu 25 Nov 2010 09:22

I cannot reproduce the problem. Please try composing a small sample to demonstrate the problem and send it to andreyz*devart*com.