Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> HEEELP: ODBC,VB5 and Oracle7
Hi
I have a problem with VB5, ODBC and Oracle7
versions: Oracle7 Server 7.3.3.0.0
SQL*Net Server (and Client) 2.3.3.0.0
Configuration: Protocol: Named Pipes
oracle: public synonyms to tables
Microsoft ODBC for Oracle 2.73.728303 (MSORCL32.DLL from 12.11.97)
Visual Basic Professional Edition 5.0 (SP3) - german version
WINNT 4.0 (SP3) - german version
1.Problem:
Private Sub Command1_Click()
Dim MCDATEN As Database, t As Recordset
DBEngine.DefaultType = dbUseODBC
Set MCDATEN = OpenDatabase("MC_DATEN", dbDriverComplete,False,
"ODBC;UID=medicare;PWD=medicare")
Set t = MCDATEN.OpenRecordset("select * from chidos") REM ERROR
t.Close
MCDATEN.Close
End Sub
MCDATEN: ODBC-Connection to Oracle-Database chidos: public synonym to table medicare.chidos
The program stops in the line ERROR. There comes no message. I must
terminet the program with task-manager end-task. (With an older
ODBC-driver
2.00.006327 I have no problem with this program. But i must use the
newer
ODBC-driver because there are other bugs in the older one.)
2.Problem:
I get a Connection to MC_DATEN and all my tables are listen in the
database-window. I click on the synonym chidos and get this error:
"3078 DAO.Database Das Microsoft Jet-Datenbankmodul findet die
Eingangstabelle oder Abfrage 'CHIDOS' nicht. ...."
If I click on the table medicare.chidos I can see records from the
table,
but the wrong count (I see only 2 records, and there are 51 records in
my
table)
If I write the SQL-Statement 'select * from medicare.chidos' into the
SQL-Window , I get the error : "3024 DAO.parameters DATEI
c:\vb5\medicare.mdb nicht gefunden" - (File c:\vb5\medicare.mdb not
found.)
????? Why look the program for a MS-Access-File ?????
Thanks in advance for any help,
sincerely
Herbert
please write to: e9125433_at_stud2.tuwien.ac.at Received on Thu Jun 04 1998 - 16:36:11 CDT