I created a whole new project with 1 window and 1 pushbutton. The
action event for the pushbutton executes:
DIM SuperAceDB AS ODBCDatabase
SuperAceDB = NEW ODBCDatabase
SuperAceDB.DataSource = ""
IF SuperAceDB.Connect THEN
MsgBox "we are connected to SuperAce"
ELSE
MsgBox "we are not connected"
END IF
and I still get the "we are not connected" message rather than a DSN
window. Is there more than one plugin necessary? TJH
On Feb 8, 2006, at 1:29 PM, Sean Arney wrote:
DIM App.SuperAceDB AS ODBCDatabase // declared in App
App.SuperAceDB = NEW ODBCDatabase
App.SuperAceDB.DataSource = "" // this line
should request an open file dialog box
IF App.SuperAceDB.Connect THEN
MsgBox "we are connected to SuperAce"
ELSE
MsgBox "we are not connected"
END IF
As I read the LR, the third line should generate an open file dialog
box for the user to specify the Access database file's location.
Nothing happens and control falls through to the "we are not
connected" message.
The ODBC plugin is working, else it would not have recognized the
ODBCDatabase class. The Connect returns FALSE, probably since there
is nothing to connect to.
What am I missing? Thank you, TJH
It works for me. It opens the DSN window for you to pick one. Try
taking
out your App. References and running it, then reassign the variable
if it
works. There must be something funky going on.
HTH,
-seanA
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
