Connecting to Databases

You can add database to the dataPro databases tree view window by clicking on the Add push button or by selecting menu item Add from Database popup menu. Connecting to MySQL database 1. Select MySQL as a Database Type 2. Enter host name or IP address for the computer hosting MySQL databases. 3. Port field will display standart MySQL port. If your database uses different port for client connections you should enter your port number here. If you don't know the port number or you are not sure leave port number unchanged. 4. Enter User Name 5. Enter User Password 6. Click OK Add Database Dialog Box will disappear and if the connection was established you will see a new host icon under the database type. Otherwise you will get an error message explaining why the application was not able to connect. Connecting to Microsoft® Access database 1. Select Microsoft® Access as a Database Type 2. Enter full path to the Microsoft® Access database file in the Host field. (For example "c:\mydirectory\test.mdb"). You can click Browse button to browse for the Access file on the local computer or you can create a new Microsoft Access database file by clicking New button. The rest of the fields are optional. If the database has a user name and a password associated with it, enter the user name and password. Connecting to SqlServer database 1. Select SqlServer as a Database Type 2. Enter the name for the computer hosting SqlServer databases. (For example "MyServer"). For local SqlServer database enter (local). If you want to connect to a "Named Instance" (SQL Server 2000), you must to specify [Servere Name\Instance]. 3. Enter port number if different from standart SqlServer port. Otherwise or if unsure leave this field unchanged. 4. Enter User Name (Leave empty to use Windows authentication). 5. Enter User Password (Leave empty to use Windows authentication). 6. Click OK Connecting to Oracle database 1. Select Oracle as a Database Type 2. For the Host field you can use a short or full description of the Oracle database you want to connect to. If you have set up ora.ini file on your computer you may enter Oracle service name. If you did not have ora.ini set up or you are not sure you may use long form in the format of [IP]:[SERVICE_NAME]:[PORT]. For example: 192.168.0.91:ORCL:2213. If you are using standard Oracle port you can omit port and enter just server IP address and service name, for example 192.168.0.12:MYORCL. 3. Enter port number if different from standart Oracle port (If you have entered port number in the Host field this field will be ignored). Otherwise or if unsure leave this field unchanged. 4. Enter User Name 5. Enter User Password 6. Click OK