Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Somewhere on my company's network there's a (Oracle) MySQL server named FOO. I see FOO reference in SAS code written by my team's analysts, who use SAS's PROC SQL command to connect to it using ODBC.

I need to connect to FOO in a MySQL client rather than SAS. Unfortunately for me, I'm not able to figure out how to do so using Oracle's MySQL Workbench, Microsoft SQL Server Management Studio (if even possible with Oracle rather than MS SQL), or SQL Workbench J using an Oracle driver.

The information required by Oracle's MySQL Workbench and others seems to go beyond the information that's available in Windows' ODBC Administrator profile for FOO (or any other ODBC DSN). The New Connection wizards request an IP address and port number, whereas the information I have on the ODBC connection is just:

  1. DSN: FOO
  2. User: Username
  3. Password: Somepassword
  4. Schema: Schemaname
  5. Type/driver: Oracle
  6. TNS Service Name: Somename

I downloaded and installed MySQL Connector/ODBC, but it seems that's mainly for creating ODBC connections rather than using them. I did figure out how to use ODBC to migrate a server in MySQL Workbench, but that's not what I want to do -- I just want to query the server.

How can I connect a SQL client (ideally MySQL Workbench, but I'm flexible) using only this ODBC connection/information?

share|improve this question
    
If it's asking for a TNS service name, you're incorrectly trying to setup an Oracle Database connection (IE, the oracle RDBMS, not the company) rather than a MySQL database connection. –  Phil May 5 '14 at 17:33

1 Answer 1

Is FOO a DSN or a server name? on workbench you need the server name, mysql username and the mysql password. Thats all you need to connect to your mysql server using mysql workbench.

share|improve this answer
    
FOO is a DSN name, yes. Whatever version of MySQL Workbench and driver I'm dealing with was requiring more than just that -- an IP address and port, which I didn't have. This question was from a year ago and my SQL server has been migrated anyway, but I'll see if I can still show a screenshot of it when I get to work. –  Hack-R May 18 at 11:33

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.