mORMot Open Source

p.s.t.

Member

Registered: 2012-12-20

Posts: 9

TOleDBODBCSQLConnectionProperties without DSN

I need to connect to MSSQL server via ODBC but without creating a DSN. As stated in Microsoft documentation it is possible to set Connection String without DSN:

"[Provider=MSDASQL;] DRIVER=driver; SERVER=server;
DATABASE=database; UID=MyUserID; PWD=MyPassword"

http://msdn.microsoft.com/en-us/library … 85%29.aspx
But I haven'y any idea how to use TOleDBODBCSQLConnectionProperties constructor to achieve that. Itried to modify connection string by without result.

Kind Regards