Well, did not know it logged to there. Below is the log entries. What is strange is that if I use an ODBC connection to SQL Server 2000, it works just fine. But with MySql it does not. These errors occur when I create a new domain name called testing.com as a virtual server using the DSN for the ODBC of MySQL. I am also attaching screen shots of the ODBC and Config of external to look at to make sure I am not missing anything. Screen shots are too big to attach, therefore can not attached as of the limit on this list. If anyone wants to see them let me know and I will forward it to them directly. 03:22 09:31 ODBC(093126081) (Table: (null)) Initialize:SQLDriverConnect (Check userid and password on server.) 03:22 09:31 ODBC(093126081) (Table: (null)) Initialize:SQLDriverConnect (Check userid and password on server.) 03:22 09:31 ODBC(093126081) (Table: (null)) Initialize:SQLDriverConnect (Check userid and password on server.) 03:22 09:31 ODBC(093126081) (Table: testing_com) IsValidTable:SQLAllocHandle-hStmt 03:22 09:31 ODBC(093126081) (Table: testing_com) CreateTable ERROR SQLAllocHandle 03:22 09:31 ODBC(093127081) (Table: (null)) Initialize:SQLDriverConnect (Check userid and password on server.) 03:22 09:31 ODBC(093142081) (Table: (null)) Initialize:SQLDriverConnect (Check userid and password on server.) 03:22 09:31 ODBC(093146081) (Table: (null)) Initialize:SQLDriverConnect (Check userid and password on server.) 03:22 09:31 ODBC(093146081) (Table: (null)) Initialize:SQLDriverConnect (Check userid and password on server.) 03:22 09:31 ODBC(093148081) (Table: (null)) Initialize:SQLDriverConnect (Check userid and password on server.) 03:22 09:31 ODBC(093148081) (Table: (null)) Initialize:SQLDriverConnect (Check userid and password on server.) 03:22 09:31 ODBC(093148081) (Table: testing_com) IsValidTable:SQLAllocHandle-hStmt 03:22 09:31 ODBC(093148081) (Table: testing_com) CreateTable ERROR SQLAllocHandle 03:22 09:31 ODBC(093148081) (Table: (null)) Initialize:SQLDriverConnect (Check userid and password on server.) 03:22 09:31 ODBC(093148081) (Table: testing_com) IsValidTable:SQLAllocHandle-hStmt 03:22 09:31 ODBC(093148081) (Table: testing_com) CreateTable ERROR SQLAllocHandle 03:22 09:31 ODBC(093148081) (Table: (null)) Initialize:SQLDriverConnect (Check userid and password on server.) 03:22 09:31 ODBC(093149081) (Table: (null)) Initialize:SQLDriverConnect (Check userid and password on server.) 03:22 09:31 ODBC(093149081) (Table: (null)) Initialize:SQLDriverConnect (Check userid and password on server.) 03:22 09:31 ODBC(093149081) (Table: (null)) Initialize:SQLDriverConnect (Check userid and password on server.) 03:22 09:31 ODBC(093149081) (Table: (null)) Initialize:SQLDriverConnect (Check userid and password on server.) 03:22 09:31 ODBC(093149081) (Table: (null)) Initialize:SQLDriverConnect (Check userid and password on server.) 03:22 09:31 ODBC(093149081) (Table: (null)) Initialize:SQLDriverConnect (Check userid and password on server.) 03:22 09:31 ODBC(093154081) (Table: (null)) Initialize:SQLDriverConnect (Check userid and password on server.)
Thanks, Grant Griffith EI8HT LEGS, A Division of ETC (877)483-3393 (812)933-5390 ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of E. Shanbrom (Ipswitch) Sent: Tuesday, March 22, 2005 8:42 AM To: [email protected] Subject: Re: [IMail Forum] Imail 8.15 HF1 and MySQL Are you seeing any ODBC errors in the sysmmdd log? Eric S To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
