Using DSN to access SQLBase "kills" the mouse
Posted on 1997-12-20
Environment: VB 4.0 (16-bit), MS-Access 2.0,
ODBC GPGUP06, Intersolv 2.00.0000)
I have to combine some information stored in an SQLBase-
Database with some Access 2.0 Data.
My attempt to link to the SQLBase table in VB:
Set tdef = CreateTableDef("AnyTable"....)
tdef.Attributes = db_AttachODBC
tdef.SourceTabelName = "SQLBaseTable"
tdef.Connect = "ODBC;DSN=MyDSN......"
Now, this works properly in Access Basic.
When I use the same code in VB 4.0 the following
Appending the SQLBase-table opens the "LOGON TO SQLBASE" modal dialog.
From now on, the mouse is "out of order".
It seems, as if there is an unvisible modal dialog.
A click anywhere on the screen results in
a beep. However, the keyboard is stil working.
The programm is stil running. MS-Query works well
with the GUPTA SQLBase Driver.
The problem doesn't appear in VB 3.0!!
Is this a VB bug?? Is it a GUPTA bug??
Or what am I doing wrong?????
Really in need of help