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;"
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
Update the IIS Server to Microsoft Data Access Component version 2.5 (MDAC 2.5) from:
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,
right click choose properties, choose the Directory Security tab, click Edit Anonymous ake sure Allow Anonymous is checked click Edit, make sure the Enable Automatic Password Sync is NOT checked, click OK, click OK, click OK, close IIS manager and try again. The Enable Automatic Password Sync does not work when a database is on another platform like UNIX.
