Edit & Change

Top  Previous  Next

Click on the "Edit" button in the MAIN FRAME once in the ODBC module to Edit any record or simply do a double-click on the Record you want to edit

 

Depending on the ODBC Type you will be offered either screen

 

Access & Excel

 

dmc_odbc_create_excel

You can change the DSN by a simple Double-Click on any line of the List .....

If it is an Excel connection do not forget to change also the Worksheet name !

 

SQL

 

dmc_odbc_create_mssql4

 

 

 

You can change for example the server name to change IP's if you need to or any other field for that matter

Do not forget to press "TAB" after each modification for it to be shown in the connection string.

 

You can use the above connection string and details to connect to our MySQL version 5 TEST SERVER

Server : 72.167.62.74

User : dmc_test

Pwd : dmc_demo_test

DB : dmc_test

 

You can use the above connection string and details to connect to our MsSQL 2005 TEST SERVER

Server : 72.167.62.74\DMCSQL

User : dmc_test

Pwd : dmc_demo_test

DB : dmc_test

 

you can add any tables in these test DB's - please consider you maybe are not alone to use them ....

 

DMC ships with these two predefined ODBC connections for you to 'play' with if you need to do so