Comment

Above in this comment thread: New Zope ODBC Database Adapter »

problem connecting to mssqm

Posted by: igpf at 2005-11-02

I keep trying to connect to a local mssql database, and it just doesn't seem to work. any ideas, please help.

Invalid Connection string "Driver={SQL Server};Server=(local)\skytec;Database=skytecdb;Uid=sa;Pwd=dev111;"

-ivan

Posted by: lukasz1 at 2005-11-23

Add System DSN in Control Panel>Administrative tools>Data Sources (ODBC). Write your System DSN name in connection string field and thats all.

Łukasz