pcsoft.us.windevCopyright 2026, PC SOFT18 Dec 2017 11:04:28 Z18 Dec 2017 11:04:28 ZWe have got an HFSQL server where we created a small database with couple of tables. IP: 192.168.xx.xx Port :4900 Database :MyDB username :admin password:admin I need to create an application which executes custom SQL queries on this database. We don't want to create any analysis because the database can be configured. We opened a connection from the windev using the following code block : [code:wl] cntDatabase is Connection cntDatabase..Provider = hAccessHFClientServer cntDatabase..Server = IP + ":" + Port cntDatabase..Database = MyDB cntDatabase..User = username cntDatabase..Password =password // Connection to the database IF HOpenConnection(cntDatabase) = False THEN Error(HErrorInfo()) RETURN END [/code] We are able to open the connection as HOpenConnection returns true. Following the opening of the connection we are not able to execute the SQL statements . [code:wl] IF HExecuteSQLQuery("SQLResult",cntDatabase,hQueryWithoutHFCorrection,"SELECT * from Persons")= False THEN Error(HErrorInfo()) RETURN ELSE SQLInfo("QUERY") END [/code] We are getting the following error : Error returned by <192.168.xx.xx :4900> server: No analysis opened: <Persons> file not described. We are not sure what exactly is the problem. We are just trying to query a HFSQL database remotely using the windev application without analysis being used. Not sure whether there are more settings or whether we are doing something wrong. It would be helpful if someone can share some information on this .30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63707-not-able-execute-sql-statements-after-opening-connection/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)