OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
RE: How do I write my connection string to avoid ODBC connection prompting

Stephane.Bredyesker.fr
Date: Mon May 03 2004 - 09:56:36 CDT


If you are using SQLDriverConnect, the last SQLSMALLINT parameter can get
the value SQL_DRIVER_NOPROMPT.

refer to ODBC Programmer's reference for more information.

Stéphane Brédy

-----Message d'origine-----
De : H [mailto:m_sauga100yahoo.ca]
Envoyé : lundi 3 mai 2004 16:25
À : maxdblists.mysql.com
Objet : Re: How do I write my connection string to avoid ODBC connection
prompting

re: ConnectString='DSN=contact';uid='mylogid';pwd='mypass'

I am sorry but I can't relate your Linux Alias solution to my windows
environment..
 
Surely there is a parameter like "no_prompt" or something similar I can use
in my DSN... I get this prompt when using Access and ODBC-linking a table.
 
Any other help much appreciated.
 
 
 

Jean-Michel OLTRA <jm.oltraespinasse.net> wrote:
Le vendredi 30 avril 2004, H a écrit...

bonjour,

> This is my connection string ....

> ConnectString='DSN=contact';uid='mylogid';pwd='mypass'

> What do I need to add to it to avoid getting the ODBC prompt (the same
dialog one uses to define the DSN in the first place).

Linux box ? I define an alias:
alias odbcdatabase='uniread /usr/local/iodbc/bin/odbctest ConnectString'

--
jm

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=m_sauga100yahoo.ca

---------------------------------
Post your free ad now! Yahoo! Canada Personals

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb