tmsconnect wsock32.dll error

HeleneC · Post by **HeleneC** » Thu 22 Oct 2009 01:07

Hi, i use CodeGear RAD studio 2007 on Vista home edition premium and i begin a new project with only a tmsconnection on it. When I try the 'server' properties in design mode, (to retreive my SQL server 2008) i get a access violation error in module wsock32.dll

Can you help me.

The same project work fine on my XP computer with the same CodeGear RAD Studio.

HeleneC · Post by **HeleneC** » Thu 22 Oct 2009 15:23

Hello,

I seem to have found a solution.

In the Provider properties of my TMSConnection I changed prSQL to prNativeClient and the connection was then working.

I have two questions now.

What do I need to install on my Vista computer so that if I would be in prSQL it would work?

What of prSQL or prNativeClient should I use to connect to sql server 2008?

Thanks!

Challenger · Post by **Challenger** » Fri 23 Oct 2009 07:42

When Provider is prSQL, SDAC uses OLEDB Provider for SQL Server, when it is prNativeClient, SDAC uses SQL Server Native Client. Native Client is preferable.
Please try to connect with ADO components. If the problem persists this might be a problem the in configuration of your system.