Link to home
Start Free TrialLog in
Avatar of 9660kel
9660kelFlag for United States of America

asked on

Can not remove system DSN for ODBC connecter

I'm trying to deal with a multi-layer website, and I have less than properly seasoned techs working on the server as well.

I'm not very well versed in this particular aspect of the database topology, and another user created a DSN for an ODBC system DSN, and it is pear shaped.

How do I remove it, when the ODBC data sources GUI does not respond?
ASKER CERTIFIED SOLUTION
Avatar of selva_kongu
selva_kongu
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 9660kel

ASKER

I'm checking this now
Avatar of 9660kel

ASKER

Okay, that seems to have cleared it, now I have a secondary problem


Connection failed: [HY000] [mysql][ODBC 5.1 Driver] Access denied

Any ideas?
Have you granted the host you are connecting from access to MySQL?

If you have added a user account it could have been added as 'user'@'localhost' which would mean that you could only connect to MySQL using this username from the server running MySQL.
Avatar of 9660kel

ASKER

Thanks for the timely assist.
Avatar of 9660kel

ASKER

The error is the same as the live server that I'm tasked with emulating.

The user in question is MS SQL, not windows, so it is not a local server question.
MySQL has a table of IP addresses that are allowed to access the database. It's a security feature. You will need to edit that table and either add your IP address or allow all IP addresses to access the MySQL server.
Avatar of 9660kel

ASKER

We already have the iptables settings in place, but I'll forward the info.
Not iptables, that is the firewall.  MySQL has its own table that holds a list of IP addresses that are allowed to access the MySQL database server.  You may need to add the IP address you are connecting from to this list before you will be allowed to connect.
Avatar of 9660kel

ASKER

Yeah, I got that, the dev team says they have it configured.

Hopefully they actually got that part right.