Re: Can't open recordset on Oracle 7.1 db using ODBC
From: Bo Lu <bo.lu_at_hsc.utah.edu>
Date: 1996/07/21
Message-ID: <4sts6b$395_at_news.cc.utah.edu>#1/1
Date: 1996/07/21
Message-ID: <4sts6b$395_at_news.cc.utah.edu>#1/1
Johnathan,
The trick is to put the dbSQLPASSTHROUGH in the openrecordset statement as:
Set UserProfile = GetProfile.OpenRecordset(dbOpenSnapshot, dbReadOnly, dbSQLPassthrough))
Otherwise VB 4.0 tries to locate your table in a local Access database, which does'nt have the table. To me it seems a VB bug.
Hope this helps
Bo Lu
Programmer/Analyst
U. of Utah Hospital
801-581-5964
Received on Sun Jul 21 1996 - 00:00:00 CEST