Sybase Connection with ASP

tdaustin · September 12th, 2005, 09:03 PM

Hi All,

Im having problems with a application i was sent from someone.

I know it works as ive seen it running on a test server but i cannot get the connection to the sybase database with asp. Im not familur with sybase and im not sure if i may need another odbc driver.

I can get it working through SQL central (Sybase SQL Anywhere 5.0) and a custom software application.

The error i get is;

Code:

Sybase][ODBC Driver]Unable to connect to database server: invalid database engine command line
/admin/aspscripts/conn.asp, line 7

WHAT I HAVE DONE.
1. installed sql anywhere 5.0
2. Set System DSN correctly
3. Changed the db location in conn.asp to where the database is located on my machine.

Code:

set cn=server.CreateObject("adodb.connection")
Cn.ConnectionString = "DSN=ankcvic;uid=melbourne;pwd=melbourne"
strConn="ODBC; Driver=Sybase SQL Anywhere 5.0; DefaultDir=c:\dbfolder\;Dbf=D:\ANKC\ankcvic.db;Uid=xxxx;Pwd=xxxx;Dsn=""Ankcvic"""

Am i missing something?

Any help from a sybase guru would be much appreciated.

Thanks

Tim

TDA