Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> HEEELP: ODBC,VB5 and Oracle7

HEEELP: ODBC,VB5 and Oracle7

From: Herbert Haas <e9125433_at_stud2.tuwien.ac.at>
Date: Thu, 04 Jun 1998 21:36:11 +0000
Message-ID: <3577134B.A860127C@stud2.tuwien.ac.at>


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:



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

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US