vb5, odbc, oracle7

I have a problem with VB5, ODBC and Oracle7

versionen:
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:

this is my code in VB5:

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 use the program visdata.vbp (sample in VB5).

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 ?????

I hope you can help me !!

Thanks Klaus

email:klaus_at_cso.at or

          rz-info_at_rz-wrn.co.at to Mr. Klaus Ströbinger Received on Thu Jun 04 1998 - 14:49:46 CDT