Page 1 of 1
tmsconnect wsock32.dll error
Posted: Thu 22 Oct 2009 01:07
by HeleneC
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.
Posted: Thu 22 Oct 2009 15:23
by HeleneC
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!
Posted: Fri 23 Oct 2009 07:42
by Challenger
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.