Hi. I'm trying work out how to find the primary and foreign keys of an access database but using php's odbc_primarykeys jobby keeps giving me SQL error 00000. I did a quick sql log and it pumped out this for the command
php fff5592d-fff558ad ENTER SQLPrimaryKeysW
HSTMT 00D70768
WCHAR 0x00D70B58 [ -3] "c:\databases"
SWORD -3
WCHAR 0x00E6FC00 [ -3] ""
SWORD -3
WCHAR * 0x00D70630 [ -3] "Categ"
SWORD -3
php fff5592d-fff558ad EXIT SQLPrimaryKeysW with return code -1 (SQL_ERROR)
HSTMT 00D70768
WCHAR 0x00D70B58 [ -3] "c:\databases"
SWORD -3
WCHAR 0x00E6FC00 [ -3] ""
SWORD -3
WCHAR * 0x00D70630 [ -3] "Categ"
SWORD -3
DIAG [IM001] [Microsoft][ODBC Driver Manager] Driver does not support this function (0)
php fff5592d-fff558ad ENTER SQLErrorW
HENV 00E6FF00
HDBC 00E6FFA0
HSTMT 00000000
WCHAR 0x0063F350 (NYI)
SDWORD 0x0063F398
WCHAR 0x0063EF50
SWORD 511
SWORD 0x0063F396
php fff5592d-fff558ad EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
So basically it looks like the Access driver doesn't support the command. I'm running Windows 98se, the driver is odbcjt32.dll version. Any idea if there's any drivers that do support this there functions, or an alternative route. Unfortuanately for the job I'm trying to win using MySQL isn't an option as all the data from the company is in mdbs. Unsurprisingly I knew nothing about databases or PhP until a week ago but love it coming from a C++ background.
Hail Ming...
