VB & Database, Accessing Linked Oracle Tables in Access Using ODBC in VB

Accessing Linked Oracle Tables in Access Using ODBC in VB

Author	Message
Vineeta Gangla Prabh #1 / 2	Accessing Linked Oracle Tables in Access Using ODBC in VB We have linked Oracle Tables in the Access DB and have saved the password while linking. While trying to access the data using ODBC calls to the Access DB in the VB code gives an error: S1000 - [Microsoft Access 97 Driver]- ODBC Call Failed. The rdoTables Collection does not even see these linked tables in the Access DB. Does anyone have a solution/workaround for this problem?
Sun, 11 Feb 2001 03:00:00 GMT

Armin Zingle #2 / 2	Accessing Linked Oracle Tables in Access Using ODBC in VB You can check DBEngine.Errors (0 to DBEngine.Errors.Count - 1) to get the full description of the ODBC error. AZ Vineeta Gangla Prabhu schrieb: Quote: > We have linked Oracle Tables in the Access DB and have saved the > password while linking. While trying to access the data using ODBC calls > to the Access DB in the VB code gives an error: S1000 - [Microsoft > Access 97 Driver]- ODBC Call Failed. > The rdoTables Collection does not even see these linked tables in the > Access DB. > Does anyone have a solution/workaround for this problem?
Sun, 18 Feb 2001 03:00:00 GMT

Page 1 of 1

[ 2 post ]