Re: Connecting to MySQL via Excel problem

[Marc Wilding]

Thanks Peter,

That is exactly where I am up to now today. Trying to set up the DSN. I just cannot connect to my database.

I have managed to connect on the PC where the database is stored via local host, but can't connect from my 2nd (work) PC. Both PC's are on the same network, but I just cannot make the connection to the database. I keep getting the message - Connection Failed: [HY000][MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on localhost (10061)

I have tried setting the server name to the internal IP address of the PC with the data on it. Note this PC is NOT a server, just a PC with Xampp installed. not sure if this is the issue. My Brother-in-law recons it should not matter within the same network. (he is on holdiay now so I can't follow up with him)

Wo in the server box I have tried

\\DAD-PC
\\DAD-PC\localhost
DAD-PC
DAD-PC\localhost
192.168.1.8
\\192.168.1.8
192.168.1.8\localhost

Problem is I don't know the correct formatting of the server. is it the IP address? is it the PC name. Does it require localhost, does it require \\

Or is it none of the above and I am just being mad!

Again any help is MUCH appreciated, before I become bald!!

PS I have installed all the Drivers and version 5.1 as it seems to be the latest.