Re: [Iodbc-macosx] Avoiding login-Dialog

[Yvo V. W. <y.v...@ra...>]

At 10:53 Uhr +0100 24.11.2006, iODBC Maintainer wrote:
>HI Yvo,
>
>>I can't find a way to avoid the login-Dialog when connecting to a 
>>DSN with the latest iODBC components (3.52.4). Though UID and PWD 
>>are specified in the DSN, the login-Dialog is always shown (empty). 
>>I seem to recall that this was not the case with previous versions.
>
>Depends on how you call SQLDriverConnect. The last parameter 
>fDriverCompletion gives driver manager and driver a hint whether 
>additional information can be asked or not:
>
>#define SQL_DRIVER_NOPROMPT                     0
>#define SQL_DRIVER_COMPLETE                     1
>#define SQL_DRIVER_PROMPT                       2
>#define SQL_DRIVER_COMPLETE_REQUIRED            3
>
>If set to SQL_DRIVER_NOPROMPT, the driver in principal should not 
>ask anything, and just return a SQL_ERROR when there is not enough 
>information in the DSN to connect.
>
>Can you tell me which driver you are connecting with and the program 
>you are using to connect?

The driver is the MySQL ODBC Driver and the program is an add-on to 
our own programm, RagTime. So it would be easy to change parameters 
to 'SQLDriverConnect', but we don't want this behavior in general, 
just for the examples we provide, i.e. when we install our add-on we 
also create an appropriate DSN. When the user now plays with our 
examples we would like to avoid the login dialog, as everything is 
already set-up in the DSN. But as soon as the user starts to create 
own documents with their own DSN it might well be necessary to 
provide a login dialog. On Windows the login dialog is not shown if 
all information is already in DSN. I noticed in the meantime that 
even if you don't enter ANY information in the login dialog the 
connection works, so obviously the information inside the DSN is 
used. Besides, the behavior is exactly the same when using the "Test" 
button of the "OpenLink ODBC Administrator".

Best regards

Yvo

>
>You can turn on Tracing in iODBC to see exactly what calls the 
>application is making to the driver manager. If you want you can 
>send me this information on mailto:io...@op... privately.
>
>
>Best regards,
>
>Patrick
>
>Patrick
>--
>Patrick van Kleef            Email : <io...@op...>
>Maintainer iODBC             Web   : <http://www.iodbc.org>
>OpenLink Software
>
>Universal Data Access & Data Integration Technology Providers


-- 
-------------------------------------------------------------------
Dipl.-Inform. Yvo Van Wezemael        Head of Software Development

RagTime GmbH                          Tel: [49] (2103) 9657-0
Neustrasse 69                         Fax: [49] (2103) 9657-96
D-40721 Hilden                        y.v...@ra...
Germany                 	      http://www.ragtime-online.com