Using SQLStringConnect() or SQLConnect() has not returned any popup message for me when I use it. My examples are:
lnHandle = sqlconnect('DSN=SDWIS/Fed;UID=xmx;PWD=wrong;SERVER=sdwisfed;')
lnHandle = sqlstringconnect('Driver=Microsoft ODBC for Oracle;ConnectString=reg6;UID=npdes;PWD=wrong;')
Both returned -1 with no messagebox. Both returned a valid connection when I used the correct password.
>I need to confirm the userid/password of an odbc connection.
>I know one way to test an odbc connection is to use SQLCONNECT(). However, if you pass in the wrong userid/password you not only get the -1 return which I want, but you also get a popup error message. I don't want the popup. Does anyone know how to turn this off or another way to test the odbc conncection silently?
>
>Thanks,
>-Isaac
Mark McCasland
Midlothian, TX USA