Hello, I have a problem with executing the statement below in VB5:
Set rstOracle = dbaCdaOracle.OpenRecordset("select * from query_object")
It always returs error 3078: "...cannot find the input table or query 'CDA.QUERY_OBJECT'...",
which exists since the previous lines executed were:
strSQL = "DELETE FROM QUERY_OBJECT" dbaCdaOracle.Execute strSQL, dbSQLPassThrough
best regards, Ulf
Sat, 04 Dec 1999 03:00:00 GMT
Helmut Ke #2 / 2
Connecting to Oracle using ODBC and DAO
Quote:
> = > Hello, > I have a problem with executing the statement below in VB5: > = > Set rstOracle =3D dbaCdaOracle.OpenRecordset("select * from query_obj= ect") > = > It always returs error 3078: > "...cannot find the input table or query 'CDA.QUERY_OBJECT'...", > = > which exists since the previous lines executed were: > = > strSQL =3D "DELETE FROM QUERY_OBJECT" > dbaCdaOracle.Execute strSQL, dbSQLPassThrough > = > best regards, Ulf
with sql-server it worked with =
Set rstOracle =3D dbaCdaOracle.OpenRecordset("select * from CDA.query_object")
Connecting to Oracle using ODBC and DAO