Client unable to establish a connection

Question

_{Thursday, November 12, 2009 1:49 AM}

Hi,

I am connecting asp.net application to Sybase database. Below is connection string in web.config

<add key="connectionString" value="Driver={SYBASE SYSTEM 11};Srvr=In100023;Port=28400;Uid=adv;Pwd=123456;Database=utility ;providerName=Sybase.Data.AseClient"/>

 I am getting error "Client unable to establish a connection". Below is code

 AseConnection oCon = new AseConnection();
        oCon.ConnectionString = ConfigurationManager.AppSettings["connectionString"];
        oCon.Open();

 Thnx,

viki

All replies (4)

_{Thursday, November 12, 2009 2:19 AM}

Hi,

http://www.connectionstrings.com/sybase-advantage

http://www.connectionstrings.com/sybase-adaptive

chk the connection string Syntax for Sybase

_{Thursday, November 12, 2009 2:21 AM}

Hi,

Have a look at this page for a tutorial to building your connection string: http://www.connectionstrings.com/sybase-advantage

Hope this helps!

_{Thursday, November 12, 2009 2:37 AM}

I already saw these links, but didn't get solution..... 

_{Thursday, November 12, 2009 2:38 AM}

Hi,

Just check this..

Sybase ODBC Connection String

Driver={SYBASE ASE ODBC Driver};Srvr=myservername;Uid=myusername;Pwd=mypasswd

Sybase OLEDB Connection String

Provider=Sybase.ASEOLEDBProvider;Server Name=myservername,5000;Initial Catalog=mydemodb;User Id=myusername;Password=mypassword

More Information Visit :

http://www.carlprothman.net/Default.aspx?tabid=81

Thanks...