Unwanted / unnecessary prompt connecting to DB

[Richard Clarke]

Hi

My code is as follows:

retcode = SQLConnect (lDBC, szDataSource, SQL_NTS, (unsigned char
*)szUserName, SQL_NTS, (unsigned char *)szPassword, SQL_NTS);

As I am providing the username and password I don't expect to see the
prompt for them, but it is appearing. I am attempting to connect to an
AS/400 database through ODBC using the IBM client access driver.

Is there an SQLSetConnectOption
similar to this one SQLSetConnectOption(m_hDbc, SQL_LOGIN_TIMEOUT, 5);
that will set the prompt to off? Or is it my casting from CString to
unsigned char * that is causing the problem?

Many thanks

--

Rich (change nospam to mlu035 to reply direct)

[John Harrison]

"Richard Clarke" <no****@mlu035.freeserve.co.uk> wrote in message
news:f5**************************@posting.google.c om...

Hi

My code is as follows:

retcode = SQLConnect (lDBC, szDataSource, SQL_NTS, (unsigned char
*)szUserName, SQL_NTS, (unsigned char *)szPassword, SQL_NTS);

As I am providing the username and password I don't expect to see the
prompt for them, but it is appearing. I am attempting to connect to an
AS/400 database through ODBC using the IBM client access driver.

Is there an SQLSetConnectOption
similar to this one SQLSetConnectOption(m_hDbc, SQL_LOGIN_TIMEOUT, 5);
that will set the prompt to off? Or is it my casting from CString to
unsigned char * that is causing the problem?

OK, this is a question about a SQL API, but this group is about the C++
language. You need to take this somewhere where it is topical. A Windows
programming group or a database programming group would seem to be better
places.

How about news:microsoft.public.vc.database?

john

[Bob Hairgrove]

On 18 Oct 2004 02:07:12 -0700, no****@mlu035.freeserve.co.uk (Richard
Clarke) wrote:

Hi

My code is as follows:

retcode = SQLConnect (lDBC, szDataSource, SQL_NTS, (unsigned char
*)szUserName, SQL_NTS, (unsigned char *)szPassword, SQL_NTS);

As I am providing the username and password I don't expect to see the
prompt for them, but it is appearing. I am attempting to connect to an
AS/400 database through ODBC using the IBM client access driver.

Is there an SQLSetConnectOption
similar to this one SQLSetConnectOption(m_hDbc, SQL_LOGIN_TIMEOUT, 5);
that will set the prompt to off? Or is it my casting from CString to
unsigned char * that is causing the problem?

I suggest you post this question to:

comp.databases.ibm-db2

Also, try using SQLDriverConnect() with the switch
SQL_DRIVER_COMPLETE_REQUIRED or SQL_DRIVER_NOPROMPT instead of
SQLConnect().

--
Bob Hairgrove
No**********@Home.com