Looks like a SQL JOIN syntax issue. Go to your SQL query and put in the SQL to debug. ASP-db is a pass thru tool. It submit the SQL via the DB Connector. You are using ODBC which is very old, OLEDB is also too old. You should be using native connector like SQLClient.

Frank