Industrial Automation
Industrial Automation | Europe

myKnowledge

Main > Product Type > Software > Visualisation
Minimize Text   Default    Enlarge Text
 

Print
E-mail

Database Connection To SQL Database - CX-Supervisor


Introduction
Installation
The following programs / drivers must be installed:
1. The SQL server mysql-3.23.51-win.
2. The ODBC driver for mysql MyODBC 3.51.03.exe. This is the draw
dsn file and is very simple.
3. If no database exists then MySql-Front will be installed. In the program, the databases are created and tested.

 
SQL Server
If the SQL Server is already running then you can see a green traffic light, otherwise it must be started manually (C: \ mysql \ bin WinMysqladmin). The server can also be configured (user) in this program.
Then start MySQL front and a new connection. For a local Database gives you Hostname = localhost, user = root port and 3306th
The connection is via TCP / IP on the local host. The root user is a standard user without a password. To be users and get passwords you have to create and configure the dsn file with these specifications. 
 
my.ini File
WinMysqladmin with the program will include an ini file (tab - Choose Save and modification). In this are the settings of the SQL Server and computer settings. 

Page 1 of 7
Next


Attachments

Akon_Database.pag - Size: 40448
DAS_AnlagenDB.pag - Size: 112640
database.mdb - Size: 679936
daten_sql.frm - Size: 8902
daten_sql.MYD - Size: 104424
daten_sql.MYI - Size: 1024
Datenaustausch.dsn - Size: 127
Datenbank_Seite.pag - Size: 102400
DATENBANK_SQL.CDM - Size: 29184
DATENBANK_SQL.SCS - Size: 98816
DATENBANK_SQL.SR2 - Size: 302080
DATENBANK_SQL.EBK - Size: 8500
DB_SQL_mit_Supervisor.ppt - Size: 223744
DATENBANK_SQL.ELG - Size: 7965
DATENBANK_SQL.rec - Size: 2
Doku_Datenbank.xls - Size: 20992
Test_Access.mdb - Size: 1277952


Comments (View All Comments / Add Comment)

Related Articles
No related articles found.
Created 2009-06-16
Modified 2009-06-18
Views 19

 

You are not logged in.