I have never been able to use that method when connecting to an ODBC
database.
I use SQL 7 and merant drivers, all i do is add the database using the
dialog box into my project and MAKE SURE TO CHECK OFF "USE TRUSTED
CONNECTION" then it will prompt you for your username and ID and then that
is it... just make sure on the client computers to recreate the entry in
their driver manager exactly or it wont work.
that was my solution to the problem... i am fairly positive i am not using
it correctly though.. but if worse comes to worse you can use that method...
it never shows a dialog box after you do that :)
> From: Donald Myers <mylists2 at mac dot com>
> Reply-To: "REALbasic Developer Releases"<realbasic-dr at lists dot
> realsoftware dot com>
> Date: Tue, 30 Jul 2002 10:00:40 -0400
> To: RealBasic DR2 List <realbasic-dr at lists dot realsoftware dot com>
> Subject: How do you get ride of ODBC select DB dialog?
>
> 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
>
>
> ---
> Subscribe to the digest:
> <mailto:realbasic-dr-digest at lists dot realsoftware dot com>
> Unsubscribe:
> <mailto:realbasic-dr-off at lists dot realsoftware dot com>
>
|