Problem with MSDE SP3A on XP SP2
- From: "Sascha Bohnenkamp via SQLMonster.com" <forum@xxxxxxxxxxxxxx>
- Date: Wed, 17 Aug 2005 13:36:42 GMT
Hi,
we are using MSDE quite long using ODBC without problems on MS-Windows 2000
(any sp) with MDAC 2.8.
now we try to port our application to XP SP2 and have trouble.
Its only one process connecting to the msde instance on the same system with
only one active sql-statement at any point in time (ie. no concurrency).
after several queries the sql-server does not answer anymore.
after starting our db-interface process of the sql-server it all works again.
Looks like an odbc problem to me ...
We log into the server at startup time and keep this connection for eternity.
After each statement we issue a 'rollback' to have a defined / clean state
for the next query.
(those queries may of course perform a commit to change data etc.)
any idea whats going wrong?
.
- Prev by Date: Re: access db using vbscript?
- Next by Date: Re: Problem with MSDE SP3A on XP SP2
- Previous by thread: access db using vbscript?
- Next by thread: Re: Problem with MSDE SP3A on XP SP2
- Index(es):
Relevant Pages
|
