ADO.NET Connection fails on Server

#11

Hi Chris

Is your ASE host named mxproddb.mlp.com ?

Then the connection string should be:

connectionString="Data

Quote:

Source='mxproddb.mlp.com';Port='5000';UID='INSTAL' ;PWD='XXX';Database='repproddb'"

I'm saying this cause I assume your ASE is on that host, listening to that
port.
The Provider doesn't use an external API (Open Client) that SQL Advantage
uses
to connect to the ASE, so the host, port combination must match.

You can also try replacing Data Source with Server. (Both should work but
just making sure)

-Paul

"Chris Beels" wrote in message news:494bca6a.35ad.1681692777 (AT) sybase (DOT) com...

Quote:

I am trying to connect to mxproddb.mlp.com from a Win2003
Server using C#. I am using the exact same code that works
on my local XP box. I am able to connect on the server
using SYBASE > SQL Advantage after setting up the resource
in dsedit. There are no resources in dsedit when I first
bring it up, which leads me to believe that the DataSources
have not been properly configured on this box. Any ideas?

The error is

Client unable to establish a connection
at Sybase.Data.AseClient.AseConnection.Open()

and the connection string looks like

add name="REPPRODDB"
providerName="Sybase.Data.AseClient"
connectionString="Data
Source='mxdrdb.mlp.com';Port='5000';UID='INSTAL';P WD='XXX';Database='repproddb'"
/

Thanks,
Chris

#12

Hi Chris

Is your ASE host named mxproddb.mlp.com ?

Then the connection string should be:

connectionString="Data

Quote:

Source='mxproddb.mlp.com';Port='5000';UID='INSTAL' ;PWD='XXX';Database='repproddb'"

I'm saying this cause I assume your ASE is on that host, listening to that
port.
The Provider doesn't use an external API (Open Client) that SQL Advantage
uses
to connect to the ASE, so the host, port combination must match.

You can also try replacing Data Source with Server. (Both should work but
just making sure)

-Paul

"Chris Beels" wrote in message news:494bca6a.35ad.1681692777 (AT) sybase (DOT) com...

Quote:

I am trying to connect to mxproddb.mlp.com from a Win2003
Server using C#. I am using the exact same code that works
on my local XP box. I am able to connect on the server
using SYBASE > SQL Advantage after setting up the resource
in dsedit. There are no resources in dsedit when I first
bring it up, which leads me to believe that the DataSources
have not been properly configured on this box. Any ideas?

The error is

Client unable to establish a connection
at Sybase.Data.AseClient.AseConnection.Open()

and the connection string looks like

add name="REPPRODDB"
providerName="Sybase.Data.AseClient"
connectionString="Data
Source='mxdrdb.mlp.com';Port='5000';UID='INSTAL';P WD='XXX';Database='repproddb'"
/

Thanks,
Chris

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

ADO.NET Connection fails on Server

sybase.public.ase.nt sybase.public.ase.nt

Re: ADO.NET Connection fails on Server - 12-19-2008 , 04:39 PM

Re: ADO.NET Connection fails on Server - 12-19-2008 , 04:39 PM