UNIVERSE 7.4 and Visual Basic 3 & 6
Posted in 2004
Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Security, Permissions & Auditing
Hello there,
I'm looking for informations in order to solve a problem about an ODBC
connexion between :
- a UNIVERSE 7.4 database installed on Windows 2000 Server
- some client Windows 98 and XP machines.
After installing an old Hyperstar ODBC Driver, I created with success
an ODBC datasource as a System DSN on every client Windows machine,
and the "test" button says the connection is OK.
Then, I have to use an old Visual Basic 3 application which don't work
correctly onto the client machines.
When I give my login/password in order to connecting to the Universe
database, I have this error message :
[VMARK][STAR/ODBC FP 32][1401032] Error ID : 27 Severy: ERROR
Faclity:DBCAPERR - SQL statement referenced a nonexistent table or
view.
Erreur native : 950390
SELECT COUNT(*) FROM MYBASE.GEST WHERE NOM='LOGINTEST';
It is very strange because I'm using another Visual Basic 6
application which run without any problem with the same ODBC connexion
to this UNIVERSE 7.4 database.
It seems that there is something that has to be done on the server
side to allow an ODBC driver permission to work with Visual Basic 3
AND Visual Basic 6.
But may be I'm wrong, so, any help will be appreciated.
Very thanks in advance.
Philippe
P.S. : sorry for my "bad" english language.