When I ran into that issue, I came up with a temp table on the MySQL server that I would populate w/ records using an insert or select into and...

Sorry that it has been so long since I updated. Alot has happened over the last few weeks and I have made some progress with this.

Here's the current situation:

The...

I haven't checked the MySQL Server. I had a pretty hot incident come through and had to put that on the back burner.

When I get back to it, I'll...

I tried updating the HOST to '%' but it still reported the same error message. Also, where in the SQL SAC do you enable oledbconnection ? I looked...

I created the DSN using ODBC administrator from Windows Server Admin console. When I tested the DSN named 'DENSONAIL' on port 3306 in the ODBC administrator it tested successfully....

Yes, it does look similiar to that. At first the product name was different than the DSN so I deleted the linked server and created a new one. ...

Thanks for your help. I really appreciate you taking some time to help me troubleshoot.

I removed all of the 'mapped' accounts, selected the bottom radion that you suggested and...

Ok. That's what I thought that I had done.

Under LocalLogin, I chose 'sa' which is the account used to connect to the MS SQL Database. I left Impersonate...

First time post here and I pray that you guys can help.

I am using SQL Server 2005 32 bit on Windows server 2003 32 bit machine. I have installed...