Help - Trying to connect to Oracle 7 with VB
Date: Sat, 11 Mar 1995 23:46:00 MST
Message-ID: <dburell.6.004FA8D6_at_primenet.com>
I am new to using VB and am having some difficulty connecting to Oracle7. I
seem to making the connection, but when I try to create a dynaset or snapshot
of a table, I get errors telling me that the object does not exist. I have
connected via Access 2.0 and SQLplus and verified the table names and their
syntax. Initially I thought that it may be timing out on the query since
there are a large number of tables in the database, I increased the
QueryTimeout variable to two minutes and I still get the same error. Am I
missing something? I did verify the connect strings and the syntax of the
OpenDatabase() commands and they seem to look ok.
Any suggestions or code samples would be greatly appreciated.
Thanks in advance for your help.
Dean Burell