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.
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.
Most Users Ever Online: 494
Currently Online: Henk Helmantel
Currently Browsing this Page:
Guest Posters: 396
Newest Members:, Henk Helmantel
Administrators: Henk Helmantel: 618