SQL 2000, ADO and XP

From: Simon Bowyer (Simon-Bowyer@Abaris-uk.com)
Date: 07/19/02 

From: "Simon Bowyer" <Simon-Bowyer@Abaris-uk.com>
Date: Fri, 19 Jul 2002 09:58:23 +0100

I have an application written in D5 Pro that uses ADO Express to connect to
a SQL 2000 DB. The SQL 2000 server is a 2000 server. All the NT 4 and 2000
Pro workstations work fine but we are having problems with XP Pro
workstations.

Everything works fine logged on as administrator but if you log in as any
other user we get timeout problems when trying to connect to SQL.

I tried setting up a .udl file to test the connection and this also gets a
timeout but only the first time I try it. If I load the Data Link properties
window and click test connection it times out after quite a while. If I then
immediately click the test connection button again it works instantly from
then on. If I close and open again, it goes back to timeout the first time
and then works. All this is fine when logged on as administrator - it works
first time everytime.

I havn't been able to try it but I suspect that if I try to connect in my
app twice the second time would work. As it is now, it times out, raises an
exception and my app then closes. I have found that if I make the user a
member of administrators (on the work station not the domain) it works but
any other security level exhibits this problem.

Has anyone else had this problem? I am guessing it is somthing to do with
security but I'm stumped as to what given that it will connect eventually.

Thanks for any help
Simon

Relevant Pages

  • Re: so why do pros have to defend themselves
    ... I understand.-I shit my pants when I heard Teen Town for the first time too. ... retired pro. ... promoted shows, managed bands, recorded radio commercials, blah blah ... explain why you don't need to rehearse to get paid - fine with me. ...
    (alt.guitar.bass)
  • Re: Delphi 4 Pro vs Standard
    ... However, when I ran the program, it threw an exception, but it was only a misread of data from the serial port and otherwise the program seemed to run normally. ... Another weird thing is that the first time through, the debugger showed the contents of the received file, but on the second pass, where it failed, the debugger seemed not to work. ... Of course, I could just install my D4 Pro on their computer and I'm sure the Borland cops won't suddenly appear with search warrants and Uzis, but it would be nice to have the ability to maintain this application, using their computer and software. ...
    (comp.lang.pascal.delphi.misc)
  • Re: Delphi 4 Pro vs Standard
    ... Another weird thing is that the first time through, the debugger showed the contents of the received file, but on the second pass, where it failed, the debugger seemed not to work. ... Of course, I could just install my D4 Pro on their computer and I'm sure the Borland cops won't suddenly appear with search warrants and Uzis, but it would be nice to have the ability to maintain this application, using their computer and software. ... Also, if you are dealing with an active serial port that is calling that procedure, it maybe wise to put a busy variable or something in there so that you don't get wached while you're stepping through it.. ...
    (comp.lang.pascal.delphi.misc)
  • Re: Delphi 4 Pro vs Standard
    ... Another weird thing is that the first time through, the debugger showed the contents of the received file, but on the second pass, where it failed, the debugger seemed not to work. ... Of course, I could just install my D4 Pro on their computer and I'm sure the Borland cops won't suddenly appear with search warrants and Uzis, but it would be nice to have the ability to maintain this application, using their computer and software. ...
    (comp.lang.pascal.delphi.misc)
  • Re: Cant type in IE 6 or OE on Win XP Home PC
    ... >> Spybot, CWShredder, Virus Scan, Hijack This, etc. ... I even did the mshtmler.dll replacement. ... >> clear that it didn't work the first time. ... running all kinds of stuff on my machine since the day I installed XP Pro ...
    (microsoft.public.windows.inetexplorer.ie6.browser)