Unable to build ODBC DSN

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

Unable to build ODBC DSN

Postby tomhirt » 27. April 2006 22:07

Xampp is installed and running. However, I wish to create an ODBC connection from my workstation to the MSsql database. Downloaded 3.51 of the MySql ODBC driver and specifying the following:
Server: 192.168.117.54
user: root
password:

when I try to select the database I get the error: "request returned with SQL_ERROR.

Click on diag and get the following: [MySQL][ODBC 3.51 Driver]Host 'c-0115.companydomain.subcompanydomain.com' is not allowed to connect to this MySQL server

Any suggestion would be helpful. thanks!!
-Tom
tomhirt
 
Posts: 5
Joined: 17. April 2006 04:00

Postby Wiedmann » 27. April 2006 23:18

Xampp is installed and running

Which XAMPP?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby tomhirt » 28. April 2006 15:06

XAMPP for Windows Version 1.5.1
tomhirt
 
Posts: 5
Joined: 17. April 2006 04:00

Postby Wiedmann » 28. April 2006 15:13

You must allow "root" to connect from "%" (all hosts) and not only from "localhost".

You can change this with phpMyAdmin.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby tomhirt » 28. April 2006 17:54

Thank you. Have I mentioned I'm a newbie idiot? I created the user originally straight in the user table. I now found the Privilige form, which allows me to add a new user, and sure enough, spelled out clearly is the option to make the user avail from any host.

Thanks again for the help!!!!
tomhirt
 
Posts: 5
Joined: 17. April 2006 04:00


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 1 guest