Found it.
Thanks for the hint.
The trick is this code...
connection.Option("SQL_DRIVER_PROMPT") = hex(Window1.Handle)
connection.Connect(connectionString, UserName, Password,
SQLConnectionMBS.kODBCClient)
You have to pass the Hex of the window handle into the connection object.
connectionString, UserName, Password can all be blank.
Then to get the connection string back for later use just do...
s= connection.Option("DSN")
On Thu, Jun 6, 2013 at 3:43 PM, Dean Davis <[email protected]> wrote:
> Yes, I have been experimenting but I couldn't figure out how to execute
> that connection.Option code.
> I will go try this tonight. Thanks.
>
>
> On Thu, Jun 6, 2013 at 3:30 AM, Christian Schmitz <
> [email protected]> wrote:
>
>>
>> Am 05.06.2013 um 21:19 schrieb Christian Schmitz <
>> [email protected]>:
>>
>> >
>> > Am 05.06.2013 um 18:20 schrieb Dean Davis <[email protected]>:
>> >
>> >>
>> >> Can I and how do I get the same functionality from MB SQL plugin?
>> >>
>> >
>> > I will check. But did you try a few strings already?
>> > Like giving connection string without server?
>>
>>
>> Could you try with setting
>>
>> connection.Option("SQL_DRIVER_PROMPT") = "YES"
>>
>> and see if that does it?
>>
>> Greetings
>> Christian
>>
>> --
>> MBS Xojo Developer Conference 2013
>>
>> More details and registration here:
>> http://www.monkeybreadsoftware.de/realbasic/events/
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> Mbsplugins_monkeybreadsoftware.info mailing list
>> [email protected]
>>
>> https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info
>>
>
>
_______________________________________________
Mbsplugins_monkeybreadsoftware.info mailing list
[email protected]
https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info
