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
connect to an mssql server (2005)
Moderators: gto, cipto_kh, EgonHugeist
-
vincentfranssen
- Fresh Boarder
- Posts: 3
- Joined: 08.09.2005, 09:57
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!
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!
