Venu,
I am not sure why this happens but I can tell you that it just locked up
my workstation, after creating > 250,000 lines in my odbc trace, forcing
a cold-reboot.
Anyway; I commented out these calls to set_dbc_error() and
translate_error() and it seems to work. That is it fails to login and
then returns an error.
You may not be able to reproduce it because the mirror in unixODBC
(which I am using) may be different from what you are trying. Not sure.
I will look into it a bit more before moving on. I will let you know if
I find anything new. Who knows... it could also be a build issue...
threads or something.
Peter
/* socket[0] is always 0 if you are not under UNIX */
printf( "[PAH][%s][%d]\n", __FILE__, __LINE__ );
if (!mysql_real_connect(&dbc->mysql,host,user,passwd[0] ? passwd : 0,
database, port_nr,
socket[0] ? socket: NullS,
(uint) client_flag))
{
printf( "[PAH][%s][%d]\n", __FILE__, __LINE__ );
/*
set_dbc_error(dbc, "S1000", mysql_error(&dbc->mysql),
mysql_errno(&dbc->mysql));
translate_error(dbc->error.sqlstate,"S1000",mysql_errno(&dbc->mysql));
*/
DBUG_RETURN(SQL_ERROR);
}
printf( "[PAH][%s][%d]\n", __FILE__, __LINE__ );
Venu wrote:
> Peter,
>
>
>>-----Original Message-----
>>From: Peter Harvey [mailto:pharvey@stripped]
>>Sent: Friday, February 01, 2002 4:50 PM
>>To: myodbc
>>Subject: SQLConnect
>>
>>
>>Seems the SQLConnect spins when a login fails. I have to assume someone
>>has alreay noted this.
>>
>
> No, I couldn't able see or reproduce it. Could you please
> how to reproduce this ?
>
> Regards, Venu
> --
>
>
>>An ODBC trace shows the DIAG message repeating until the app dies.
>>
>>
>>[ODBC][11941][SQLConnect.c][2390]
>> Entry:
>> Connection = 0x80bd558
>> Server Name = [myodbc3-test][length = 12 (SQL_NTS)]
>> User Name = [pharvey][length = 7 (SQL_NTS)]
>> Authentication = [][length = 0 (SQL_NTS)]
>> DIAG [S1000] [MySQL][ODBC 3.51 Driver]Access denied for
>>user: 'pharvey@stripped' (Using password: NO)
>>
>> DIAG [S1000] [MySQL][ODBC 3.51 Driver]Access denied for
>>user: 'pharvey@stripped' (Using password: NO)
>>
>>
>>
>>* MyODBC 3.5 (as found in unixODBC CVS today).
>>* mysql Ver 11.12 Distrib 3.23.33, for pc-linux-gnu (i686)
>>
>>Peter
>>
>>BTW: The old driver seems to work just fine.
>>
>
>
>
>
