Create an SQL Database from a Clarion Dictionary

[chiting]

I use Synchronize button to create an SQL Database from a Clarion Dictionary, But I cannot connect with SQL Sever. I have checked the dictionary synchronizer register which contains SQL Sever(C60msss.dll). How do I make synchronizer connect with SQL?

Chi

 

[ShankarJ]

Hi Chi,

Are you trying to connect to SQL Server 2005 or 2000? If 2005, do you have the SQL native client installed? From what I have gathered from others who use Synchronizer, it is better to create a DSN to connect to the SQL Server, test it, then use the ODBC driver to use the DSN to connect to the SQL Server and synchronize. After that, change the driver in the Dictionary to MS-SQL.

Regards