Connect to database over internet

[earlrainer]

Is it possible to connect a client application to a database running on a machine over the internet.
I know the IP address of the machine where the database server is running, can you tell me how can I create the ODBC to connect to the database.

 

[JeanNiBee]

Hi

When you setup an ODBC connection one of the questions is the 'Network Address'. This is where you specifiy the ip address and port of the sybase machine.

Also, you enter these values as

'199.1.1.1, 3048' OR 'mymachineName, 3048'

(IP/machine name, port). Don't forget the comma.

Note: Don't confuse the regular network address for the 'HA (High Availability) Network Address'.


-=-=-=-=-=-=-=-=-
For ease of reading, any posted CODE should be wrapped by [ignore][COLOR] and

[/ignore] tags.

Ex:

SELECT 1 from sysobjects

 

[earlrainer]

I go to control panel and ODBC.
here i try to make a new DSN

I get pop up window with 5 tabs-ODBC,LOGIN,DATABASE,NETWORK and ADVANCED

in which tab do i put the computer ip address ?
because in netwrok tab there is no edit box to put IP ADDRESS

also how do i know which IP address is sybase running?

 

[earlrainer]

sorry I meant how to find which PORT is sybase running

 

[sybaseguru]

In order to set up ODBC you need to know the IP address and Port No that Sybase is running as pointed out. You need to ask your DBA which PORT Sybase <ASE_NAME> is running on. Also tell him the name or IP address of the host. You can normally do &quot;nslookup <IP Address> Or nslookup <HOST_NAME> to find out the name or IP address of the host respectively as long as you know one of them. The PORT No needs to be supplied to you by the DBA. This is the easiest way to get the PORT No. Otherwise you can look at the sql.ini file for this ASE (on UNIX the interfaces file). If you can telnet or ssh to the host where ASE is running you can do a &quot;netstat -a&quot; on the host to get the the Port no. However, this is more like a detective work!