VB Forum / Database Access / February 2007

I need to have a program I am writing in Visual Basic 6.0 define a "cursor"
(sorry for using Oracle terms.) then open a database, open a table, read a
few records, and then close the table and database.  The MSDN Library is a
little confusing, and my VB 6.0 in 21 Days book isn't ...

Please any body , could you tell me how to get list of all database and
table Properties in Oracle database,
under which table they cantain all inforation about database or table that
every user can access....

Please any body , could you tell me how to get list of all database and
table Properties in Oracle database,
under which table they cantain all inforation about database or table that
every user can access....

I have 2 SQL Express 2005 Databases with a table that I want to synchronise
between them.
The rows will be minimal.
I want to know the best way to do it. I am devolopiing in .NET as well.

I have created an ocx/activex control which I am using in a vb6 form.
Sometimes when I try to show this form, I am getting a run-time error
'3420': Object is no longer valid.  The Err.Source is ADODB.Field.
When I click debug and try to run through the routine again to see

I have 2 DBF files that look very similar. One of these I can read just fine
using the latest OLEDB driver and the other can only be read with the ODBC
driver.
If I attempt to read the second file using the OLEDB driver I get and

I get an unrecogized databse format when I try to use the data control in VB
6.0 pro.
How do I fix this?