Connecting Omnis Classic to MSSQL 2005

Question

Years ago I did this but for the life of me I can't remember how to do it from Omnis Classic. I KNOW it can be done but can't find a single example anywhere. Any help would be appreciated.

THX

joeb

Answer 1

Hi Joeb,

For this issue, I would like recommend you to post this thread to Omnis Classic forum. Since not all of the communities in this forum are the experts on Omnis classice, so I think you will get more support on related forum.

On SQL Server side, there are some configuration to allow SQL Server to be remote connected you need to be noticed, please see the following references:

http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx

http://support.microsoft.com/kb/914277

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.