|
| [WD18] - Oracle connection |
| Iniciado por guest, 25,mar. 2015 09:31 - 2 respuestas |
| |
| | | |
|
| |
| Publicado el 25,marzo 2015 - 09:31 |
Hi 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
Marius |
| |
| |
| | | |
|
| | |
| |
| Publicado el 25,marzo 2015 - 11:21 |
Marius
Check it out as below link
http://help.windev.com/en-US/…
and it's for native drivers only ie you have to buy or use ODBC connection instead,
see below link and this is free to use:
<a class="ExternalLink" rel="nofollow" target="_blank" href="http://help.windev.com/en-US/?3072005&name=SQLConnect">http://help.windev.com/en-US/…</a>
HTH
King |
| |
| |
| | | |
|
| | |
| |
| Publicado el 26,marzo 2015 - 11:50 |
Thanks King
Will now look into ODBC
Regards
Marius |
| |
| |
| | | |
|
| | | | |
| | |
|