dbmssocn bug?

sometimes, if I connect DNS name for localhost running sql2000, (go to the
router and back) at a simple "SELECT * FROM table" statament I get a long
delay (application hangs for 10-20 second), and drops the connection.
When I change the datasource to "netbios" name, the same statament works
without trouble.
where is the bug? In dbmssocn? in ADO events (I use them...)?
cursorlocations? Why only sometimes?What did you mean use DNS name and NetBIOS name ?
Are you connecting from a client PC? Does it work with Query Analyser ? Does
it timeout all the time.
"SRINGER Zoltn" <kecskemetisrac@.free-mail.hu> wrote in message
news:O7hVZOiBFHA.3840@.tk2msftngp13.phx.gbl...
> sometimes, if I connect DNS name for localhost running sql2000, (go to the
> router and back) at a simple "SELECT * FROM table" statament I get a long
> delay (application hangs for 10-20 second), and drops the connection.
> When I change the datasource to "netbios" name, the same statament works
> without trouble.
> where is the bug? In dbmssocn? in ADO events (I use them...)?
> cursorlocations? Why only sometimes?
>|||another relevant information:
if I change cursorlocation to adUseClient, works...
... but I need serverside cursor especially via internet!|||From the earlier posts, it sounds like you are could just
have some DNS issues in your network. Have you checked the
event logs for such? Have you tried an alias using the IP
address?
-Sue
On Mon, 31 Jan 2005 16:13:33 +0100, "SRINGER Zoltn"
<kecskemetisrac@.free-mail.hu> wrote:

>another relevant information:
>if I change cursorlocation to adUseClient, works...
>
>... but I need serverside cursor especially via internet!
>