Page 1 of 1

connect to an mssql server (2005)

Posted: 09.09.2008, 15:09
by vincentfranssen
hi,

do we have tutorials on how to connect to an mssql server (2005). I have no clue on how to do that. Normally I work with postgresql and thats no problem at all.

in .net i use connection strings like this,
"Data Source=(local);Initial Catalog=vitaphone;Integrated Security=SSPI")]

Vincent

Posted: 11.09.2008, 22:49
by Michael
Hi vincentfranssen,

I worked for quite a while with Zeos and MS SQL Server (2000 and 2005) and the most elegant way is to get connected is to choose the ADO-Protocol and then establish you connection to the database by using the connection wizard which opens when you click on the database-proerty (...-Button) in your ZConnection-Comonent. Use the "Microsoft OLE DB Provider for SQL Server".

You do not really have to care about the ADO-connection string.

Best Regards!