Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_TopicIcon
Error in SQL connector
sp_NewPost Add Reply sp_NewTopic Add Topic
December 17, 2014
10:36 am
Henk Helmantel
Admin
Forum Posts: 552
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Arash,

It is best to select 'Microsoft SQL Server' if you set up the SQL Connector in Diafaan SMS Server and not the ODBC or OLE DB drivers. The ODBC or OLE DB will work but the native Microsoft SQL Server driver is more reliable and easier to set up. If you have to use the ODBC driver it is important to know that Diafaan SMS Server is a 32-bit program and you have to use the 32-bit version of the ODBC driver and Windows ODBC manager (located at '%systemdrive%\Windows\SysWoW64\Odbcad32.exe').

From your description, I get the impression that the native Microsoft SQL Server driver for .NET might be damaged. The best try is probably to re-install the SQL Server native client for SQL Server 2008 on the computer that runs Diafaan SMS Server and then set up a new SQL Connector in Diafaan SMS Server.

Regards, Henk

December 16, 2014
9:32 pm
Arash
Guest
Guests

Hello
I had SQL SERVER 2000
After it, I use SQL SERVER 2005 in same pc
And now uninstall SQL SERVER 2005 from it
Now I have 3 driver in ODBC for SQL SERVER
- SQL SERVER (for SQL SERVER 2000)
- SQL NATIVE CLIENT (for SQL SERVER 2005)
- SQL SERVER NATIVE CLIENT 10 (for SQL SERVER 2008 R2)

Now I can't connect to my SQL SERVER 2008 DB by any method (OLEdb - SQL sonnwction -ODBC)
By same connection string, I can connect to db in web page on IIS.
Why?

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
9 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 364

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 532

Posts: 1845

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 552