Sybase connection form Visual.net C#

[Chris Fox via .NET 247]

I'm trying to access a Sybase database using Visual .net C#
using the code below.
I've added the Sybase data provider to the references (DDTek.Sybase)
and added them to the program usage. Howver it fails to connect and
gives an Unhandled exception of type "DDTek.Sybase.S ybaseException' occured in
ddtek.sybase.dl l
I can connect using the sybase SQL advantage with no problems.

Cheers

CHRIS

SybaseConnectio n Conn=new SybaseConnectio n("host=localho st;port=****;In terfacesFile=SQ LBOX7.ini;Serve r Name=SQLBOX7;Da taBase Name=varis71");

Conn.Open();
try
{
Conn.Open();
Console.WriteLi ne("Connection Successful");
}
catch(SybaseExc eption ex)
{
Console.WriteLi ne(ex.Message);
return;
}
Conn.Close();
--------------------------------
From: Chris Fox

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>1Uhtsa2u6ES NQDOyrMfZ+Q==</Id>

[Nicholas Paldino [.NET/C# MVP]]

Chris,

Are there any other details to the exception? There isn't much to go on
there. Is it calling a piece of native code, and perhaps returning an error
code of some sort in the exception which you can look up?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Chris Fox via .NET 247" <an*******@dotn et247.com> wrote in message
news:uD******** ******@TK2MSFTN GP09.phx.gbl...

I'm trying to access a Sybase database using Visual .net C#
using the code below.
I've added the Sybase data provider to the references (DDTek.Sybase)
and added them to the program usage. Howver it fails to connect and
gives an Unhandled exception of type "DDTek.Sybase.S ybaseException'
occured in
ddtek.sybase.dl l
I can connect using the sybase SQL advantage with no problems.

Cheers

CHRIS

SybaseConnectio n Conn=new
SybaseConnectio n("host=localho st;port=****;In terfacesFile=SQ LBOX7.ini;Serve r
Name=SQLBOX7;Da taBase Name=varis71");

Conn.Open();
try
{
Conn.Open();
Console.WriteLi ne("Connection Successful");
}
catch(SybaseExc eption ex)
{
Console.WriteLi ne(ex.Message);
return;
}
Conn.Close();
--------------------------------
From: Chris Fox

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>1Uhtsa2u6ES NQDOyrMfZ+Q==</Id>

[GG]

If you have Sybase ASE 12.0(12.5 and up preferred) and up and only need
to run your apps in Win then you may be able to get the Sybase .net
provider from Sybase. We run our apps in Win and hit Sybase on Solaris.

This is the documentation from Sybase
http://sybooks.sybase.com/onlinebook...110e/adonet/@G
eneric__BookVie w

Hope it helps

*** Sent via Developersdex http://www.developersdex.com ***

[Frans Bouma [C# MVP]]

Chris Fox via .NET 247 wrote:

I'm trying to access a Sybase database using Visual .net C#
using the code below.
I've added the Sybase data provider to the references (DDTek.Sybase)
and added them to the program usage. Howver it fails to connect and
gives an Unhandled exception of type "DDTek.Sybase.S ybaseException'
occured in ddtek.sybase.dl l
I can connect using the sybase SQL advantage with no problems.
As DataDirect's providers are somewhat expensive, I'd definitely
simply mail them and ask what's the problem. Though the exception might
contain additional information you haven't looked at in the
InnerException. Have you checked that?

Frans

Cheers

CHRIS

SybaseConnectio n Conn=new
SybaseConnectio n("host=localho st;port=****;In terfacesFile=SQ LBOX7.ini;
Server Name=SQLBOX7;Da taBase Name=varis71");

Conn.Open();
try
{
Conn.Open();
Console.WriteLi ne("Connection Successful");
}
catch(SybaseExc eption ex)
{
Console.WriteLi ne(ex.Message);
return;
}
Conn.Close();

--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

[cfox]

I switched of the Debugger and it tells me it cannot find the SQLBOX.in
File
which is on the computer. Where dose it look for this file.
I also appear to have Sybase 11.9.2

Thanks

CHRI

--
cfoxPosted from http://www.pcreview.co.uk/ newsgroup acces