Hi Erik,
I think you should be okay - pooling is only for when the applicatiuon uses
the same exact conn string over and over again.
In your case, I think the connection should remain. DO some testing and if
things aren't quite working out log a tech support case with Sybase and we
can investigate it further.
-Paul
"Erik Franssen" <erik.franssen@advalvas.be> wrote in message
news:470be3b1$1@forums-1-dub...
> Paul,
>
> thanks for your answer; for the #1, I tried for hours but now I'm sure its
> not my fault.
> I will make a formal request as you suggest.
>
>
> For #2: I have a list of username/passwrod values in my DB and I
> definitely want to be sure that, for each user that goes through my
> 'logon' page, I can keep a link between each Sybase connection (@@spid)
> and that correspondig user. If I have for instance 50 users logged in,
> meaning 50 sessions, each session should be bound to its particular DB
> connection.
>
> I found a solution, similar to what I did in PowerDynamo: in my
> 'validatelogon' page, I create a new AseConnection, connect to it, and
> after succesful connect (and after adding some values in sysprocesses, in
> fact my internal DB user_id), I simply write the connection object in the
> session state; something like SessionState["MyConn"] = conn;
>
> In later pages, on Page_Load event, I get the connection back from the
> SessionState and it works correctly, I have the corresponding @@spid for
> that particular session, thus for that particular user that logged in. I
> don't have to reconnect, it is still connected.
>
> But if I do understand your answer, I make it far too complex. I will try
> what you say, but as far as I thought, WWW uses stateless connections thus
> in my opinion if I don't Close(), I can't refer to that specific
> 'connection' on a next page call.
>
> Best regards,
> Erik
>
> "Paul" <Paul@sybase.com> wrote in message news:470b88e9$1@forums-1-dub...
>> Hi Erik,
>>
>> #1 is not in the GA release of the 2.0 Provider. At this point I believe
>> the
>> functionality is scheduled for a future release. I would suggest you
>> open a Tech Support case to make a formal request
>> for this feature so it can be expedited.
>>
>> For #2 - I'm not sure I totally understand. For one thing you can turn
>> the pooling off by
>> setting pooling=false. As for the persistence, if you're doing the
>> conn.Open() and then
>> don't close or dispose of the connection, it should remain connected to
>> the ASE. Just
>> keep the pooling to false.
>>
>> If my answer doesn't make sense explain in more detail the #2.
>>
>> Best Regards,
>>
>> -Paul
>>
>> "Erik Franssen" <erik.franssen@advalvas.be> wrote in message
>> news:470677de$1@forums-1-dub...
>>> Hi,
>>>
>>> 1) I am new to ASP.NET and ADO.NET
>>> In Visual Studio, one can add a data connection using the server
>>> explorer, or directly in a page using for instance a
>>> <asp:SqlDataSource>.
>>> I can choose Microsoft SQL server or Oracle but not Sybase.
>>> I read somewhere that the ADO.NET 2.0 would solve the problem but I've
>>> installed it via the SDK and the EBF aftewards, but Sybase still not
>>> shows upas data provider.
>>>
>>> For test, I've added a fixed connection string in web.config and I can
>>> use it in my SqlDataSource; but when I want to configure the data
>>> source, I can't use the Query builder. I entered an SQL statement for
>>> test and the 'test query' fails, but when I map the 'BoundField' columns
>>> by myself, everything works correctly.
>>>
>>> Any idea how to use Sybase ASE the same way as MS or Oracle ?
>>>
>>> 2) Furthermore, I would like to use persistent connections through a
>>> session. I mean that every session needs its onwn Sybase connection. I
>>> know that there are a lot of discussions about performance and whether
>>> to use connection pooling or not.
>>> But for my application, I definitely need to have one connection per
>>> session. The performance is not so critical but the back office stored
>>> procedures rely on certain columns in sysprocesses thus I definitely
>>> need to have one 'spid' per session.
>>> Does anyone now if this can be done and what would be the easiest way ?
>>>
>>> Thanks,
>>> Erik Franssen
>>>
>>>
>>
>>
>
>
|