Solved

WINSQL connecting to a MYSQL database

Posted on 2013-02-01
4
1,024 Views
Last Modified: 2013-03-20
Hello,
I am a complete novice to WINSQL and MYSQL. I have created a database using MYSQL and now I want to connect to this via WINSQL - however I am not sure how to do this. When I click on ODBC manager it shows user data sources of DBASE files, EXCEL & ACCESS but no reference to MYSQL.  When I click on Drivers I can see that I have WinSQL  Wire protocol driver installed. However I am being asked for Data source, Host name, port and dbname. The database and WINSQL are both on the same PC. If anyone can give me simple directions about how to set up a connection I would be very grateful.

MYSQL workbench 5.2
WINSQL trial edition 9.0.107.624
Windows 7

regards
Pat
0
Comment
Question by:pclarke7
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 38846079
WinSQL appears to be for Microsoft SQL Servers, not MySQL.  They are two different database servers.  I don't think that will work for you.

http://www.winsql.com/2011/07/25/database-version-edition-and-compatibility/
0
 

Accepted Solution

by:
pclarke7 earned 0 total points
ID: 38846721
WinSQL works with MYSQL and multiple other databases
0
 

Author Comment

by:pclarke7
ID: 38990274
Moved from MYSQL to MS SQL
0
 

Author Closing Comment

by:pclarke7
ID: 39002275
Moved to MS SQL database
0

Featured Post

Plug and play, no additional software required!

The ATEN UE3310 USB3.1 Gen1 Extender Cable allows users to extend the distance between the computer and USB devices up to 10 m (33 ft). The UE3310 is a high-quality, cost-effective solution for professional environments such as hospitals, factories and business facilities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A small collection of useful tips and tricks for Windows 10 users that I decided to write as a result of recent questions that were asked and answered at Experts Exchange. Two short video tutorials included. Enjoy..
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

631 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question