related sites: <FREE Help> <ASP> <Asp.net> <worldwide> feedback: <lovethat> <hatethat> <thanks> <credits> <contact us>
[aspsybase] Listserv
Sybase FAQ #1: Steps to Get Sybase connected via Asp by Joseph Jagrup <Joseph.Jagrup@valueoptions.com>
Here are the steps I took in getting mine to work ...
I'll try to explain the steps I took in getting the Sybase Server to talk to IIS (which they both run on NT)
Step 1: Write ASP Code
<% Dim strSQL Dim Conn Dim rsSQL
'Write Query strSQL = "Select * From xx"
'Connect to Sybase via ADODB Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "Driver={Sybase System 11}; Srvr=xxx; Db=xx; Uid=xx; Pwd=xx;"
'Execute Query Set rsSQL = Server.CreateObject("ADODB.recordset") rsSql.Open strSQL, Conn, 3 %>
Step 2: Verify Server Settings
In order for ASP to query Sybase, the IIS box must first have the ability to query Sybase. either through SQL Advantage or isql from DOS
Make sure the sql.ini file (located in \Sybase\ini directory) uses TCP protocols settings. If the sql.ini file uses "NLMSNMP,\\boston_pcc\pipe\sybase\query" then it wouldn't work
Here's a copy of the sql.ini file from the IIS box
sql.ini ---------------------------------
[xxx_1] master=TCP,161.125.206.8,5000 query=TCP,161.125.206.8,5000
[xxx_2] master=TCP,161.125.206.26,5000 query=TCP,161.125.206.26,5000
[xxx_3] master=TCP,161.125.206.10,5000 query=TCP,161.125.206.10,5000
Step 3: Updates
Update the IIS Server to Microsoft Data Access Component version 2.5 (MDAC 2.5) from: http://www.microsoft.com/data
Step 4: Change IUSR Account
What this does, is to not prompt for a password when Sybase is sitting on another platform (I think)
If you open IIS Management Console on the web server locate the virtual directory that you created,
The Enable Automatic Password Sync does not work when a database is on another platform like UNIX.