Hi Folks, I have installed MySQL and SBR installed on my windows 7 machine and trying to authenticated using the login credentials stored in MySQL, But somehow unable to test it successfully, Can you please help. I have installed ODBC driver and have tested the connection successfully. I tried multiple ways in [Settings] section of sqlauth.aut, please help in finding the problem. In Mysql, I have a table "auth" having only two fields - name and password sqlauth.aut [Bootstrap] Enable=1 LibraryName=sqlauth.dll InitializationString=SQL [Settings] ;Connect=DSN=<dsn_name_here>;UID=<username_for_dB>;PWD=<password_for_dB> ;SQL=SELECT password, profile FROM userlist WHERE name = %name/40 ;Connect=DSN=SQL;UID=root;PWD=root123 ;Connect=root/
[email protected] Connect=DSN=SQL://192.168.1.50:3306/db_test;UID=root;PWD=root123 SQL=SELECT password FROM auth WHERE name = %name/40 ParameterMarker=? MaxConcurrent=1 ConcurrentTimeout=30 ConnectTimeout=25 QueryTimeout=25 WaitReconnect=2 MaxWaitReconnect=360 PasswordFormat = 0 DefaultResults = 0 ShutdownTimeout = 1 ErrorMap=<mssql.ini|mysql.ini|oracle.ini> LogLevel=0 Thanks in advance
... View more