Description:
I use VB6.0 / Mysql Server 3.23.55 / Windows 2000
I have this sql statement.
SELECT
CASE WHEN isnull( se_ist ) THEN 0 ELSE 1 END
FROM bet_jahr_daten
And my connection strings:
for oledb driver:
conn.Open "Provider=MySqlProv.3.0;Data Source=snoopy;User ID=root;Location=localhost;"
for odbc driver:
conn.Provider = "MySQLProv"
conn.Properties("Data Source") = "DSN=test"
If I m connect sgl statement with mysql database on odbc driver it works.
But if I connect on ole db driver it works with an error. It should just show
the values 0 which are helps to make the condition, but it shows all 0.
I m using version 3 of mysql ole db driver.
Table :
bet_jahr_daten
--------------
se_ist | 1
se_ist | 2
se_ist | 3
se_ist | NULL
se_ist | 3
se_ist | 4
se_ist | NULL
How to repeat:
for oledb driver:
conn.Open "Provider=MySqlProv.3.0;Data Source=snoopy;User ID=root;Location=localhost;"
for odbc driver:
conn.Provider = "MySQLProv"
conn.Properties("Data Source") = "DSN=test"
If I m connect sgl statement with mysql database on odbc driver it works.
But if I connect on ole db driver it works with an error. It should just show
the values 0 which are helps to make the condition, but it shows all 0.
I m using version 3 of mysql ole db driver.
Table :
bet_jahr_daten
--------------
se_ist | 1
se_ist | 2
se_ist | 3
se_ist | NULL
se_ist | 3
se_ist | 4
se_ist | NULL
Description: I use VB6.0 / Mysql Server 3.23.55 / Windows 2000 I have this sql statement. SELECT CASE WHEN isnull( se_ist ) THEN 0 ELSE 1 END FROM bet_jahr_daten And my connection strings: for oledb driver: conn.Open "Provider=MySqlProv.3.0;Data Source=snoopy;User ID=root;Location=localhost;" for odbc driver: conn.Provider = "MySQLProv" conn.Properties("Data Source") = "DSN=test" If I m connect sgl statement with mysql database on odbc driver it works. But if I connect on ole db driver it works with an error. It should just show the values 0 which are helps to make the condition, but it shows all 0. I m using version 3 of mysql ole db driver. Table : bet_jahr_daten -------------- se_ist | 1 se_ist | 2 se_ist | 3 se_ist | NULL se_ist | 3 se_ist | 4 se_ist | NULL How to repeat: for oledb driver: conn.Open "Provider=MySqlProv.3.0;Data Source=snoopy;User ID=root;Location=localhost;" for odbc driver: conn.Provider = "MySQLProv" conn.Properties("Data Source") = "DSN=test" If I m connect sgl statement with mysql database on odbc driver it works. But if I connect on ole db driver it works with an error. It should just show the values 0 which are helps to make the condition, but it shows all 0. I m using version 3 of mysql ole db driver. Table : bet_jahr_daten -------------- se_ist | 1 se_ist | 2 se_ist | 3 se_ist | NULL se_ist | 3 se_ist | 4 se_ist | NULL