pcsoft.us.windevCopyright 2026, PC SOFT26 Mar 2015 11:50:00 Z25 Mar 2015 09:31:00 ZHi Everyone I'm trying to connect to an oracle database and the steps I take are: 1. Connection in Analysis Name: EIWDEV_O_SAS_SB Connection by: OLE DB Provider for Microsoft Directory Services Data Source: hem1-scan:1525 User name: Test Password: Test Pressing the test button show that the connection was successful. If I replace Connection by Oracle (Oracle Provider for OLE DB), then I get an error "unable to connect" 2. The code: bResult is boolean bResult=HOpenConnection("EIWDEV_O_SAS_SB") //True bResult=HChangeConnection("AA", "EIWDEV_O_SAS_SB") //True dsQryTest is Data Source bResult=HExecuteSQLQuery(dsQryTest, "EIWDEV_O_SAS_SB",hQueryDefault,"SELECT * FROM AA")//=False HReadFirst(dsQryTest) The HExecuteSQLQuery fails.... (Am I really connected to the "AA" table?) [EDIT] - Error="Error in the SQL code of query. Unable to initialize the query. AA file unknown" Any examples/tips on how you do it, would be appreciated. Regards Marius30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51159-wd18-oracle-connection/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51159-wd18-oracle-connection-51196/read.awp26 Mar 2015 11:50:00 ZThanks King Will now look into ODBC Regards Mariushttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51159-wd18-oracle-connection-51196/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51159-wd18-oracle-connection-51196/read.awp[WD18] - Oracle connectionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51159-wd18-oracle-connection-51165/read.awp25 Mar 2015 11:21:00 ZMarius Check it out as below link http://help.windev.com/en-US/?3044107&name=HOpenConnection and it's for native driver…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51159-wd18-oracle-connection-51165/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51159-wd18-oracle-connection-51165/read.awp[WD18] - Oracle connection