Re: Connecting to MySQL via Excel problem
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.
Subject
Views
Written By
Posted
4689
October 19, 2011 01:40AM
2253
October 19, 2011 10:12AM
Re: Connecting to MySQL via Excel problem
2234
October 19, 2011 10:27AM
1880
October 19, 2011 12:59PM
2014
October 20, 2011 12:59AM
4145
October 20, 2011 11:54AM
2326
October 20, 2011 03:40PM
2054
October 22, 2011 12:26AM
2071
December 13, 2011 06:44PM
2053
December 28, 2011 01:26PM
2291
March 26, 2012 06:09AM
2001
March 26, 2012 06:11AM
1675
October 20, 2011 10:20AM
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.