Hello everybody iam new to .NET and sybase so i need some help on
solving the issue.
My project is to make this web app compatible with vista and windows
7.I have a delphi desktop application running and is connected to
Sybase SQL Anywhere 11 database now iam working on developing .NET web
application which uses a webservice to connect to same database .I am
not trying to open a new connection rather trying to use (share) the
same connection to database opened by delphi desktop application.When
i tried using the webservice to connect to database i got an error in
the browser which is as follows:
ERROR [08001] [Sybase][ODBC Driver][SQL Anywhere]Specified database
file already in use
ODBC Connection Code:
using (OdbcConnection cn = new
OdbcConnection("Dsn=GlobeRelay5;uid=DBA;pwd=SQL"))
{
cn.Open();
const string domainString = "SELECT MailDomainName FROM
DBA.SETTINGS";
using (OdbcCommand cmd = new OdbcCommand(domainString, cn))
{
using (OdbcDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
Settings.MailDomainName = reader.GetString(0);
}
}
int fCount = reader.FieldCount;
}
}
}
Is there anyway i can share the same connection opened by Desktop
application ?.
I even tried opening a new connection which returned same error so
How can i create a new connection to a database which is already
opened by other app whithout shutting down?.
Thank you
Ram Cirigiri
|