Jump to content
The Uniform Server Community

Need help getting excell to connect to sql server on another machine.


rforeman
 Share

Recommended Posts

I am using Uniformserver 4 and I am trying to set up an ODBC connection so I can import the data to Excel. I have downloaded and installed the Mysql ODBC 5.1 driver but when I try to add the connection it give me an error "Connection Failed: [HY000][MySQL][ODBC 5.1 Driver]Host Games' is not allowed to connect to this MySQL server". I have an older version ov excel running on the computer running uniformserver 4 but I have MS Office Home & Student edition on my game machine. How can fix this?

 

Thanks.

Link to comment
Share on other sites

It looks as if your set-up is OK! You receive a response from the server.

 

User root has been locked down for local access only, if you are not connected to the Internet set root privilege using phpMyAdmin to have a “Host” of any.

 

Preferably create a new user with restricted privileges and to have a “Host” (note set this when setting name and password) of any. Set this user to have access to the database you wish to use.

 

Check out this Wiki page (7.1 Add new user) page for details.

 

All the best

Ric :unsure:

Link to comment
Share on other sites

Thanks Ric I will give that a try.

 

That worked great

 

Thanks again. :unsure:

 

 

It looks as if your set-up is OK! You receive a response from the server.

 

User root has been locked down for local access only, if you are not connected to the Internet set root privilege using phpMyAdmin to have a “Host” of any.

 

Preferably create a new user with restricted privileges and to have a “Host” (note set this when setting name and password) of any. Set this user to have access to the database you wish to use.

 

Check out this Wiki page (7.1 Add new user) page for details.

 

All the best

Ric :)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...