pcsoft.us.windevCopyright 2026, PC SOFT22 May 2017 19:58:00 Z16 May 2017 15:49:00 ZHi, I need to make a connection with an SQL database to load some data from another software into our Windev application (that is using Hyperfile). I managed to do this by using the SQLConnect() command, SQLFirst(), SQLNext() etc... This is working fine on the server (where the SQL database is located) but not on workstations. I'm using this command : MyConnection is int = SQLConnect("SBS2011\PFD","MyLogin","MyPassword","PFD","OLEDB",hOledbSQLServer) SQL Server 2008 R2 SBS2011 is the name of the server PFD is the name of the database Many thanks, Joris30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60892-wd21-how-connect-with-sql-database-over-network/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60892-wd21-how-connect-with-sql-database-over-network-60976/read.awp22 May 2017 19:58:00 ZI created a little application using hyperfile to store my SQL server DB connections info in (and to encrypt them) and also used…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60892-wd21-how-connect-with-sql-database-over-network-60976/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60892-wd21-how-connect-with-sql-database-over-network-60976/read.awpWD21 : How to connect with MS SQL database over the network?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60892-wd21-how-connect-with-sql-database-over-network-60975/read.awp22 May 2017 11:37:00 ZThank you both for your answers. I am able to connect with the server and get some data with the code below. MyConnection is …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60892-wd21-how-connect-with-sql-database-over-network-60975/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60892-wd21-how-connect-with-sql-database-over-network-60975/read.awpWD21 : How to connect with MS SQL database over the network?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60892-wd21-how-connect-with-sql-database-over-network-60940/read.awp18 May 2017 15:30:00 ZI could connect to any MS Sql Server in my network with the following connection parameters. DataBaseConnection is Connection…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60892-wd21-how-connect-with-sql-database-over-network-60940/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60892-wd21-how-connect-with-sql-database-over-network-60940/read.awpWD21 : How to connect with MS SQL database over the network?walterpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60892-wd21-how-connect-with-sql-database-over-network-60900/read.awp16 May 2017 16:45:19 ZJohn, - In SQL server manager allow remote connections - In SQL configuration manager allow the tcp-ip protocol instead of pip…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60892-wd21-how-connect-with-sql-database-over-network-60900/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60892-wd21-how-connect-with-sql-database-over-network-60900/read.awpWD21 : How to connect with MS SQL database over the network?xofpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60892-wd21-how-connect-with-sql-database-over-network-60899/read.awp16 May 2017 16:38:38 ZHi Joris, is 1433 port open on your SBS2011 ?? -- Christophe Charronhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60892-wd21-how-connect-with-sql-database-over-network-60899/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60892-wd21-how-connect-with-sql-database-over-network-60899/read.awpWD21 : How to connect with MS SQL database over the network?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60892-wd21-how-connect-with-sql-database-over-network-60895/read.awp16 May 2017 16:08:00 ZHi Joris, I'ld use oleDB for SQL Server in this case instead of ODBC... You'll make your life a lot easier. Cheers, Pe…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60892-wd21-how-connect-with-sql-database-over-network-60895/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60892-wd21-how-connect-with-sql-database-over-network-60895/read.awpWD21 : How to connect with MS SQL database over the network?