Npgsql problem

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • mr.Hyde

    Npgsql problem

    Hi,
    Did enybody know what happens?
    My ASP application works fine until today. I didnt change anything
    in iis or code or postgresql. The efect is:
    - veery slow executesqlcomma nd
    - after sqlcommand IE hangs for 2 minuts then returns no error

    I haven't idea. Please Help
    mr. Hyde



    I'm protected by SpamBrave



  • JeffP@Work

    #2
    Re: Npgsql problem

    You may have a lock or block in the database, down & dirty, stop IIS,
    restart the SQL service or reboot the box where the database is hosted.


    "mr.Hyde" <galileon@poczt a.onet.plwrote in message
    news:ee9693$4aq $1@news.onet.pl ...
    Hi,
    Did enybody know what happens?
    My ASP application works fine until today. I didnt change anything
    in iis or code or postgresql. The efect is:
    - veery slow executesqlcomma nd
    - after sqlcommand IE hangs for 2 minuts then returns no error
    >
    I haven't idea. Please Help
    mr. Hyde
    >
    >
    >
    I'm protected by SpamBrave

    >
    >

    Comment

    • mr.Hyde

      #3
      Re: Npgsql problem


      U¿ytkownik "JeffP@Work " <jpgmt_at_sbcgl obal_dot_netnap isa³ w wiadomo¶ci
      news:uHgAn701GH A.1292@TK2MSFTN GP03.phx.gbl...
      You may have a lock or block in the database, down & dirty, stop IIS,
      restart the SQL service or reboot the box where the database is hosted.
      >
      Hi,
      I have tried to restart also reinstall IIS,
      it doesnt help, now i will try to reinstall postgres and regiis

      Thanx
      Rafal



      I'm protected by SpamBrave



      Comment

      • Bart

        #4
        Re: Npgsql problem

        In my experience, the ODBC driver for Postgres works best, consider giving
        that a try.


        "mr.Hyde" <galileon@poczt a.onet.plwrote in message
        news:ee9693$4aq $1@news.onet.pl ...
        Hi,
        Did enybody know what happens?
        My ASP application works fine until today. I didnt change anything
        in iis or code or postgresql. The efect is:
        - veery slow executesqlcomma nd
        - after sqlcommand IE hangs for 2 minuts then returns no error
        >
        I haven't idea. Please Help
        mr. Hyde
        >
        >
        >
        I'm protected by SpamBrave

        >
        >

        Comment

        Working...