Perl database connection prob

[Simonliu]

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!

 

[David Lindon]

What shows up in your server error log?