How to Connect to CDL SQL Server Database via Internet
There are several different methods available for connecting to the CDL SQL Server. Microsoft Windows has built in tools that are very easy to implement because they have been integrated with ODBC or OLE DB Provider SQL Server drivers, and you don’t need to install anything. Depending on the application you are trying to connect to the database you may need to set up a 32-bit or 64-bit driver – see the notes for each method to ensure you are using the correct version.
The SQL Server instance is “Catalyst”, and internally we use port 1433 to connect to the SQL Server. Externally via the internet, we use port 34505 to connect to 66.46.104.13. Microsoft uses the format “66.46.104.13:34505\Catalyst”, and now transfers to “66.46.104.13,34505\Catalyst”. 1. Using an ODBC
First, you need configure an ODBC DSN name. In ODBC Administrator, there are two different kinds of DSN names; user DSN and system DSN. User DSNs are for regular applications while System DSNs are for web applications. In the Windows control panel, within the Administrative tools group, you can find the “data Sources (ODBC)” shortcut. It is a 32 bit driver administrator referring to Windows\system32, so it can only create a 32 bit driver DSN. Mostly we use this to create DSN.
The only difference here is that native clients can use the alias name you configured in SQL Server client in the Server field.
If you use FileMaker (64 bit) to connect to CDL SQL Server through your ODBC, you will need to configure a 64 bit DSN. The administrative tool (odbcad32.exe) is located in
“c:\windows\sysWOW64”. It is also a 32 bit tool but can manage 64 bit drivers. If you create a DSN that is the same as a 32 bit DSN, it will overwrite it without notice. We recommend you include “32” or “64” at the end of the DSN name ex. “CDL_SQL32” or “CDL_SQL64”.
After you create an ODBC DSN, you can use it in other applications.
2. Using Excel
By choosing “From SQL Server”, you will see the whole table data with no choices. However, from Microsoft Query through ODBC, you can choose columns, set conditions and sort data.
The wizard will let you choose the DSN (32 or 64 depends on your excel edition), enter a username and password, choose table and columns, set conditions, and select the data layout. See above.
3. Using Access
4. Using SpotFire
SpotFire can be connected to CDL SQL server as Data Tables. Go to FileAdd Data Tables. In the ‘Add Data Tables’ windows, click ‘Add’ button and scroll down to ‘Microsoft SQL Server’.
5. Using SQL Server and SQL Server Linked Server
Using this method, the linked server name is the same as the SQL Server alias name.
