Hi Donald,
I just checked it as well. It is busted (when using the spiffy new
'ODBCDatabase' object). Unfortunately the new connect method doesn't
seem to work at all in 4.5.
I can get the older method to work (using a 'Database' object) by
using the new plugin but using the older OpenODBCDatabase method, ie:
ODBCdb=OpenODBCDatabase("DSN=" + CurrentDSN + ";UID="+ CurrentUser
+";PWD="+ CurrentPassword,0,"")
Notice the trailing 0 and blank string. These should be optional but
they aren't with the new 4.5 plugins.
I haven't realbugged it.
I have the following code
dim db1 as ODBCdatabase
db1 = new ODBCDatabase
db1.Host = "201.68.121.17"
db1.DatabaseName = "orders"
db1.UserName = "user"
db1.Password = "1234"
db1.DataSource = "orderdb"
if not db1.connect then
msgbox "Couldn't open database"
return
end if
When it hits the if not... It brings up the "select ODBC database dialog"
Why isn't it going automatically??
BTW after I select the database everything works fine.
Don Myers
--
Cheers,
Dr Gerard Hammond
Bioinformatic Analyst
Garvan Institute of Medical Research, Sydney, Australia.
Arachnoleptic fit (n.) The frantic dance performed just after
you've accidentally walked through a spider web.
|