Re: HEEELP: ODBC,VB5 and Oracle7

From: Vladimir A. Zaikin <vlad_at_hammer.ryazan.su>
Date: 5 Jun 1998 14:23:15 +0400
Message-ID: <AA21xEvi0J@hammer.ryazan.su>

>Set MCDATEN = OpenDatabase("MC_DATEN", dbDriverComplete,False,
>"ODBC;UID=medicare;PWD=medicare")

---

Hi, Herbert
Try "ODBC;DSN=YourODBCDataSourceName;UID=medicare;PWD=medicare" Dsn from ODBC Administrator
2nd problem looks like mysterios, may be try another vendor

>If I write the SQL-Statement 'select * from medicare.chidos' into the

---

>SQL-Window , I get the error : "3024 ...

It is right Oracle SQL syntax, but Access has own SQL, You should write Access table name from tables window - may be medicare_chidos

Vladimir Zaikin Received on Fri Jun 05 1998 - 05:23:15 CDT