Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Carlos Alloatti
  Where is Carlos Alloatti?
 
 Argentina
 Carlos Alloatti
 To: Lyrad Bangoy
  Where is Lyrad Bangoy?
 Koronadal City
 Philippines
 Lyrad Bangoy
 Tags
Subject: RE: Suppressing MyODBC Display Login
Thread ID: 174721 Message ID: 175151 # Views: 35 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: ODBC, ADO and OLEDB
Date: Tuesday, May 27, 2008 2:11:02 AM         
   


> Hellow Foxite members;
>
> I want to suppress the Display Log-in of MyODBC, I search Foxite and found this thread Message ID: 68573 which is applicable only I think for windows based OBCD.
> Somehow I tried it and it did not work.
> I have this code:
>
x = SQLSetprop(0,'DispLogin',3) && To Prevent Display Log-in window
> lnHandle = SQLConnect("MyConn") && To connect to MySQL DB using MyODBC.

> Is there anyway around to suppress the Display Log-in of MyODBC?
>
> PS: It does not display when the connection is available (failed or not), somehow we do not want to show this to our user when we are implementing it to a new computer that the MyODBC connection is not yet set/avaible.

Your code works as intendend in my machine, I don“t have an ODBC connection named "MyConn" and no Dialog pop ups, lnHandle is -1

By the way, if the "MyConn" System/User/File dsn does not exist, how does VFP/Windows decides to pop up the MySql ODBC connector screen?

Or is "MyConn" a connection stored in a VFP database? If that is the case, what are the properties of "MyConn"?

If "MyConn" is a VFP connection stored in a DBC, then:

DBSetProp("MyConn", "Connection", "DispLogin", 3)
lnHandle = SQLConnect("MyConn")


But still I am not shure what you are trying to do and why.

Carlos Alloatti



COMPLETE THREAD
Suppressing MyODBC Display Login Posted by Lyrad Bangoy @ 5/24/2008 8:36:32 AM
RE: Suppressing MyODBC Display Login Posted by Anders Altberg @ 5/24/2008 9:39:22 AM
RE: Suppressing MyODBC Display Login Posted by Lyrad Bangoy @ 5/24/2008 9:52:44 AM
RE: Suppressing MyODBC Display Login Posted by Anders Altberg @ 5/24/2008 10:10:06 AM
RE: Suppressing MyODBC Display Login Posted by Lyrad Bangoy @ 5/24/2008 10:17:41 AM
RE: Suppressing MyODBC Display Login Posted by tushar @ 5/24/2008 11:34:05 AM
RE: Suppressing MyODBC Display Login Posted by Lyrad Bangoy @ 5/26/2008 1:47:33 AM
RE: Suppressing MyODBC Display Login Posted by Erik Gomez @ 5/26/2008 1:00:42 PM
RE: Suppressing MyODBC Display Login Posted by Lyrad Bangoy @ 5/27/2008 1:58:42 AM
RE: Suppressing MyODBC Display Login Posted by Carlos Alloatti @ 5/27/2008 2:11:02 AM
RE: Suppressing MyODBC Display Login Posted by Lyrad Bangoy @ 5/27/2008 2:53:17 AM
RE: Suppressing MyODBC Display Login Posted by Carlos Alloatti @ 5/27/2008 3:08:10 AM
RE: Suppressing MyODBC Display Login Posted by Lyrad Bangoy @ 5/27/2008 3:31:33 AM