Connection String suddenly Stops working

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Shaun
    #1

    Connection String suddenly Stops working

    Hi

    Odd one here, I have a local version of SQL running on my laptop for
    demos, been working fine for years yet yesterday I suddenly get an
    error "Invalid Conection Parameter" running a sproc using the
    following connection string (Its an Access 2002 App to SQL 2000)

    strConnect = "Network=DBMSSO CN;Server=" & DB_Server & ";DRIVER=SQ L
    Server;UID=abc; PWD=def"

    Works fine if I use the server based SQL resource

    So I change it to be the following and it starts working ????

    strConnect = "Server=" & DB_Server & ";DRIVER=SQ L
    Server;UID=abc; PWD=def"

    So it started not liking the 'Network=DBMSSO CN' part but both the
    datbases have TCP/IP and Named Pipes setup as network protocols and
    bot have not chnaged config for years

    I did install SP2 for XP a few weeks ago but I'm sure I have run it
    since (mind you I wish I'd never done SP2 with all the unasked for
    'extras' MS dump on your PC but thats another thread)

    Thanks all
    shaun
    Tags: None
    • Keith Kratochvil
      #2
      Re: Connection String suddenly Stops working

      Strange. It looks that both strings are correct (although I would put the
      network part toward the end as a personal preference).

      I often refer to http://www.connectionstrings.com/ for examples and usage of
      connection strings.

      --
      Keith


      "Shaun" <shaunsizen@msn .com> wrote in message
      news:4a2f9143.0 502030133.5892e e76@posting.goo gle.com...[color=blue]
      > Hi
      >
      > Odd one here, I have a local version of SQL running on my laptop for
      > demos, been working fine for years yet yesterday I suddenly get an
      > error "Invalid Conection Parameter" running a sproc using the
      > following connection string (Its an Access 2002 App to SQL 2000)
      >
      > strConnect = "Network=DBMSSO CN;Server=" & DB_Server & ";DRIVER=SQ L
      > Server;UID=abc; PWD=def"
      >
      > Works fine if I use the server based SQL resource
      >
      > So I change it to be the following and it starts working ????
      >
      > strConnect = "Server=" & DB_Server & ";DRIVER=SQ L
      > Server;UID=abc; PWD=def"
      >
      > So it started not liking the 'Network=DBMSSO CN' part but both the
      > datbases have TCP/IP and Named Pipes setup as network protocols and
      > bot have not chnaged config for years
      >
      > I did install SP2 for XP a few weeks ago but I'm sure I have run it
      > since (mind you I wish I'd never done SP2 with all the unasked for
      > 'extras' MS dump on your PC but thats another thread)
      >
      > Thanks all
      > shaun[/color]

        Comment

        • Shaun
          #3
          Re: Connection String suddenly Stops working

          Thanks for the link Keith

          Yep it is odd as I thought both were fine as well and the one now is
          not working worked fine for months!!!

          Ah well the odditiess of Microsoft

          Cheers
          Shaun

          "Keith Kratochvil" <sqlguy.back2u@ comcast.net> wrote in message news:<uQts2dgCF HA.3908@TK2MSFT NGP12.phx.gbl>. ..[color=blue]
          > Strange. It looks that both strings are correct (although I would put the
          > network part toward the end as a personal preference).
          >
          > I often refer to http://www.connectionstrings.com/ for examples and usage of
          > connection strings.
          >
          > --
          > Keith
          >
          >
          > "Shaun" <shaunsizen@msn .com> wrote in message
          > news:4a2f9143.0 502030133.5892e e76@posting.goo gle.com...[color=green]
          > > Hi
          > >
          > > Odd one here, I have a local version of SQL running on my laptop for
          > > demos, been working fine for years yet yesterday I suddenly get an
          > > error "Invalid Conection Parameter" running a sproc using the
          > > following connection string (Its an Access 2002 App to SQL 2000)
          > >
          > > strConnect = "Network=DBMSSO CN;Server=" & DB_Server & ";DRIVER=SQ L
          > > Server;UID=abc; PWD=def"
          > >
          > > Works fine if I use the server based SQL resource
          > >
          > > So I change it to be the following and it starts working ????
          > >
          > > strConnect = "Server=" & DB_Server & ";DRIVER=SQ L
          > > Server;UID=abc; PWD=def"
          > >
          > > So it started not liking the 'Network=DBMSSO CN' part but both the
          > > datbases have TCP/IP and Named Pipes setup as network protocols and
          > > bot have not chnaged config for years
          > >
          > > I did install SP2 for XP a few weeks ago but I'm sure I have run it
          > > since (mind you I wish I'd never done SP2 with all the unasked for
          > > 'extras' MS dump on your PC but thats another thread)
          > >
          > > Thanks all
          > > shaun[/color][/color]

            Comment

            Previous template Next
            Working...