Hi,
This forum is used for ASE related ODBC questions. For ASA you should try
sybase.public.sqlanywhere.general
-Paul
<shouri.cirigiri@gmail.com> wrote in message
news:fae58c3a-1e5c-45f8-b49d-1413586ce097@i39g2000yqm.googlegroups.com...
> 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
>
>
>
>
>
|