Sybase 7.0 & IIS 5.0

[Anon...@sybase.com]

I need help, I am trying to make a connection using a DSN to my sybase
database within Visual Interdev or FrontPage 2000. I currently have
a DSN configured and can access this through Crystal reports with
no problem. My problem comes in when I enter:

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "testdsn"

testdsn being the DSN name. When I execute the asp page I get the
following error.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified.

Has anyone encountered this error before? Both the IIS and Sybase
are on the same machine.

Please help!

Sandy - ba...@coj.net

[Anthony Mandic]

Anon...@sybase.com wrote:
>
> I need help, I am trying to make a connection using a DSN to my sybase
> database within Visual Interdev or FrontPage 2000. I currently have
> a DSN configured and can access this through Crystal reports with
> no problem. My problem comes in when I enter:
>
> Set oConn = Server.CreateObject("ADODB.Connection")
> oConn.Open "testdsn"
>
> testdsn being the DSN name. When I execute the asp page I get the
> following error.
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC Driver Manager] Data source name not found and no
> default driver specified.

I don't really know anything about the products you mention,
but the "no default driver specified" seems to be the clue.
You need to use a driver under ODBC in order to access Sybase.
In this case it would be Sybase's Open Client. This is installed
with the server and is probably configured. You would just need
to set up ODBC to use it to access Sybase.

-am

[Anon...@sybase.com]

I created an ODBC connection under system dsn. Under the Database tab I
entered the service name and the database. When I selected the test
connection it was successful. I have even put in the start line:
"C:\Program Files\Sybase\SQL Anywhere 7\win32\dbsrv7.exe". I was not sure
if this was what was needed or not. I have left this off and added the
full path name to the database (even though I don't think this is
necessary) and it still will not work. Any other suggestions?

Thanks

Sandy