Hi ppl,
I've got this really big problem, where I can't get my Perl script to connect to a MS Access File Database via Win32::ODBC. Basically it doesn't give any error messages but still dies. The code that is most relevant to this problem is:
# Start building the SQL query:
$query = "INSERT INTO MAIN (category, subcategory, url, user) VALUES ($fields{'SelectPrimary'},
$fields{'SelectSecondary'}, $fields{'url'}, $fields{'name'})";
$conn = new Win32::ODBC("website");
if (!$conn) {
die "ODBC DSN error: [$!].\n";
}
Since I'm using Windows 2000 Server, I have managed to capture the SQL transaction details:
submit2 67c-804 ENTER SQLAllocEnv
HENV * 10017E08
submit2 67c-804 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x10017E08 ( 0x01ba14f0)
submit2 67c-804 ENTER SQLAllocConnect
HENV 01BA14F0
HDBC * 015D4678
submit2 67c-804 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 01BA14F0
HDBC * 0x015D4678 ( 0x01ba1598)
submit2 67c-804 ENTER SQLDriverConnectW
HDBC 01BA1598
HWND 00000000
WCHAR * 0x1F7D8BF8 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8BF8
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
submit2 67c-804 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 01BA1598
HWND 00000000
WCHAR * 0x1F7D8BF8 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8BF8
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
DIAG [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0)
submit2 67c-804 ENTER SQLErrorW
HENV 01BA14F0
HDBC 01BA1598
HSTMT 00000000
WCHAR * 0x0140F474 (NYI)
SDWORD * 0x015D9258
WCHAR * 0x0140F074
SWORD 512
SWORD * 0x0140F4BC
submit2 67c-804 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 01BA14F0
HDBC 01BA1598
HSTMT 00000000
WCHAR * 0x0140F474 (NYI)
SDWORD * 0x015D9258 (0)
WCHAR * 0x0140F074 [ 91] "[Microsoft][ODBC Driver Manager] Data source "
SWORD 512
SWORD * 0x0140F4BC (91)
submit2 67c-804 ENTER SQLFreeConnect
HDBC 01BA1598
submit2 67c-804 EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 01BA1598
submit2 6cc-6d4 ENTER SQLAllocEnv
HENV * 10017E08
submit2 6cc-6d4 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x10017E08 ( 0x01ba14f0)
submit2 6cc-6d4 ENTER SQLAllocConnect
HENV 01BA14F0
HDBC * 015D4678
submit2 6cc-6d4 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 01BA14F0
HDBC * 0x015D4678 ( 0x01ba1598)
The thing says I've got an error, but I've checked and I don't know what its saying!
Thanks!
I've got this really big problem, where I can't get my Perl script to connect to a MS Access File Database via Win32::ODBC. Basically it doesn't give any error messages but still dies. The code that is most relevant to this problem is:
# Start building the SQL query:
$query = "INSERT INTO MAIN (category, subcategory, url, user) VALUES ($fields{'SelectPrimary'},
$fields{'SelectSecondary'}, $fields{'url'}, $fields{'name'})";
$conn = new Win32::ODBC("website");
if (!$conn) {
die "ODBC DSN error: [$!].\n";
}
Since I'm using Windows 2000 Server, I have managed to capture the SQL transaction details:
submit2 67c-804 ENTER SQLAllocEnv
HENV * 10017E08
submit2 67c-804 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x10017E08 ( 0x01ba14f0)
submit2 67c-804 ENTER SQLAllocConnect
HENV 01BA14F0
HDBC * 015D4678
submit2 67c-804 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 01BA14F0
HDBC * 0x015D4678 ( 0x01ba1598)
submit2 67c-804 ENTER SQLDriverConnectW
HDBC 01BA1598
HWND 00000000
WCHAR * 0x1F7D8BF8 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8BF8
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
submit2 67c-804 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 01BA1598
HWND 00000000
WCHAR * 0x1F7D8BF8 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8BF8
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
DIAG [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0)
submit2 67c-804 ENTER SQLErrorW
HENV 01BA14F0
HDBC 01BA1598
HSTMT 00000000
WCHAR * 0x0140F474 (NYI)
SDWORD * 0x015D9258
WCHAR * 0x0140F074
SWORD 512
SWORD * 0x0140F4BC
submit2 67c-804 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 01BA14F0
HDBC 01BA1598
HSTMT 00000000
WCHAR * 0x0140F474 (NYI)
SDWORD * 0x015D9258 (0)
WCHAR * 0x0140F074 [ 91] "[Microsoft][ODBC Driver Manager] Data source "
SWORD 512
SWORD * 0x0140F4BC (91)
submit2 67c-804 ENTER SQLFreeConnect
HDBC 01BA1598
submit2 67c-804 EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 01BA1598
submit2 6cc-6d4 ENTER SQLAllocEnv
HENV * 10017E08
submit2 6cc-6d4 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x10017E08 ( 0x01ba14f0)
submit2 6cc-6d4 ENTER SQLAllocConnect
HENV 01BA14F0
HDBC * 015D4678
submit2 6cc-6d4 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 01BA14F0
HDBC * 0x015D4678 ( 0x01ba1598)
The thing says I've got an error, but I've checked and I don't know what its saying!
Thanks!