Support forum

Home Support forum Using Diafaan SMS Server Error in SQL connector

Error in SQL connector

Add Reply

Add Topic

December 17, 2014
10:36 am

Henk Helmantel

Admin

Forum Posts: 1488

Member Since:
May 28, 2013

Offline

Quote

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

Quote

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?

Add Reply

Add Topic

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
18 Guest(s)

Currently Browsing this Page:
1 Guest(s)