DMC User Interface > Setup Menu > ODBC Connections

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 see a different screen

DSN - HyperFile

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

SQL

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 text box.

Access and Excel : you can change the MDB or XLX/XLSX file to point to a different file.

Testing on our SQL test servers

►	You can use our test SQL servers to test your clones & data transfers

►	When cloning to our SQL test servers the evaluation limitations are NOT used (ie clones are NOT accounted for).

►	Remember you are maybe not alone to use these test servers, so avoid deleting existing tables!.

SQL Test servers are available for

►	MsSQL Express version 2005.

►	MySQL version 5

►	PostGre SQL version 8.4

►	Oracle (xe)

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

Server : 213.251.168.51

User : dmc_demo

Pwd : Dmc#Demo

DB : dmc_demo

Driver=MySQL ODBC 3.51 Driver;server=213.251.168.51;user=dmc_demo;pwd=Dmc#Demo;database=dmc_demo;port=3306;

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

Server : 213.251.168.51\SQLExpress2005

User : dmc_demo

Pwd : Dmc#Demo

DB : dmc_demo_2005

Driver=SQL Server;server=213.251.168.51\SQLExpress2005;uid=dmc_demo;pwd=Dmc#Demo;database=dmc_demo_2005;

You can use this connection string and details to connect to our PostGre SQL TEST SERVER

Driver : PostgreSQL Unicode

Server : 213.251.168.51

User : dmc_demo

Pwd : Dmc#Demo

DB : dmc_demo

Driver=PostgreSQL Unicode;server=213.251.168.51;UID=dmc_demo;PWD=Dmc#Demo;database=dmc_demo;PORT=5432;

You can use this connection string and details to connect to our ORACLE TEST SERVER

Driver : Oracle in XEClient

User : dmc_demo

Pwd : Dmc#Demo

DB : 213.251.168.51/XE

Driver=Oracle in XEClient;UID=dmc_demo;PWD=Dmc#Demo;DBQ=213.251.168.51/XE;

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