Avatar of 9660kel
9660kel
Flag 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?
ASP.NETMicrosoft SQL Server 2008Windows Server 2008

Avatar of undefined
Last Comment
9660kel

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
selva_kongu

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
checkara

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
9660kel

ASKER
I'm checking this now
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?
checkara

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.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
9660kel

ASKER
Thanks for the timely assist.
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.
checkara

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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
9660kel

ASKER
We already have the iptables settings in place, but I'll forward the info.
checkara

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.
9660kel

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

Hopefully they actually got that part right.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck