|
| Iniciado por vpereyra, 05,dic. 2014 20:12 - No hay respuesta |
| |
| | | |
|
| |
| Publicado el 05,diciembre 2014 - 20:12 |
hello
Someone is using informix with windev 18 INFORMIX Native Driver?
My problem is this:
We need to connect to the database with different user name according to the
application that is running.
The problem is when windev Analysis Validates the structure (previously
imported as user "INFORMIX") against engine
the requirement that the OWNER is the same user is added, with the OWNER is
INFORMIX. Error causing native access
when I want to use Hxxxxxx
Only works when I use direct consultation with sql eg
// Describe the connection
HDescribeConnection ("MyConnection", "file", "20140911", "beyond",
"db_allende" hNativeAccessInformix)
HOpenConnection ("MyConnection")
HChangeConnection ("*", "MyConnection")
QRY is Data Source
// HERE WORKS PERFECTLY
HExecuteSQLQuery (QRY, "select * from tabla03")
HReadFirst (QRY)
IF NOT Hout (QRY) THEN
FileToMemoryTable (TABLE_NoName1, QRY)
END
// HERE IS WHERE THE ERROR BECAUSE DA VALID USER INFORMIX OWNER
IF HReadSeek (TABLA03, recno, 1) = false THEN
Info ("ERROR") // SIGN IN NATIVE ACCESS DEBUG ERROR OCCURS BECAUSE THIS
WAS IMPORTING FROM ANALISYS AS OWNER informix, using another user fails.
END
HCloseConnection ("MyConnection")
aahhh ... tried to do it from MYSQL runs smoothly taking different users
Connection.
Any suggestions?
Victor
Víctor H. Pereyra
M.P. 2595
Departamento de Informática
Sucursal Nva . Cba .: Hipólito Yrigoyen 384
5000 Córdoba, Capital
Tel.: (0351) 426 9200 int :1234
e-mail: vpereyra@sanatorioallende.com
www.sanatorioallende.com.ar |
| |
| |
| | | |
|
| | | | |
| | |
|