MySQL Forums
Forum List  »  MySQL for Excel

Re: Connecting to MySQL via Excel problem
Posted by: Marc Wilding
Date: October 19, 2011 10:27AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
4489
October 19, 2011 01:40AM
Re: Connecting to MySQL via Excel problem
2114
October 19, 2011 10:27AM
1955
December 28, 2011 01:26PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.