Sybase ASE 12.5 - ODBC connection with http:// web address

[javierlepiscopo]

Hello,

We are making some upgrade for our PBX software and they
company change the way they connect to the tables.

Before we have a WIN application with an IP address with the
5000 port, but now we change to a Web based application that
connect with an http:// address.

I need to know how to configure the ODBC connection thru an
http:// address instead of an IP address.

Please if anyone know I will be very glad.

Thank you in advance and regards.

[Ro...@robinstclair.com]

Hi

This is what I do.

On my workstation I go into control panel, open
administrative tools and select ODBC drivers. I then add an
entry for Sybase ASE XX.xx.
then I fill in the information required as follows

Datasource name - LinuxASEServer or whatever
Description - whatever you want to see in this field
Server name (ASE Host name) -
either enter the IP address as in 127.0.0.1 (if it
doesn't change)
or myservername.miniserver.com
Server Port - 5000 (or whatever port is used)
Database Name - MyDatabase02 (or whatever the database is
called)
Login ID - sa (or whater you wish to use)

there is a test button for you to try this.

If this isn't what you want, check the entries you have in
DSEdit and work with them, the principle is similar -

set the server address as -

NLWNSCK - myservername.miniserver.com,5000

HTH

Robin

or the

[annamalailakshmanan]

Somachi,

When you are connecting to your Sybase database from a Web
front end, there are different options that are available,
namely ODBC, OLE-DB and ADO .Net . I am assuming that you
are trying to connect thru' ODBC driver only at this point.

When you connect thru' ODBC, you need to have the following
done,

1. Install Sybae ODBC driver from the Windows Client CD (
assuming your platform is windows ) on your web server.
2. Your Sybase server need to be included in the sql.ini
file in your Sybase installtion. If an entry is not found,
you need to add an entry using DSEDIT utility. You need to
know your Sybase server's IP address or Network name and the
port #.
3. Create a ODBC Data Source ( DSN ) using ODBC data source
administrator from the administrative tools group in control
panel. This data source will be using the Sybase servername
you had just created in the sql.ini file.
4. In your web application's connection string, refer the
ODBC DSN just created and use the credentials to log in to
the application.