problems with port in connections (in ASP)

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

    problems with port in connections (in ASP)

    Hi all

    i'm new to this, your assistence will be greatly appriated :-)

    i have a connection string (this all in asp )

    tCSCst = Provider=SQLOLE DB;Data Source=test02x2 ;Port=1444;Init ial
    Catalog=<catalo ge>;User ID=<id>;Passwor d=<password>

    Set testCaseServerC onn = Server.CreateOb ject("ADODB.Con nection")
    testCaseServerC onn.Open tCSCstr

    but i get the following error

    An error occured:-2147467259 - Invalid connection string attribute

    the problem seems to be the port itself, if i use 1433 then it works
    fine.

    Tags: None
    • Ray Costanzo [MVP]
      #2
      Re: problems with port in connections (in ASP)

      Can you post your actual code? It appears you retyped it since your string
      doesn't have quotes around it, and your variable names differ. Also, what
      version of MDAC?

      Ray at work

      "Kavi" <Kavita.K.Singh @gmail.comwrote in message
      news:1158817836 .211485.204380@ h48g2000cwc.goo glegroups.com.. .
      Hi all
      >
      i'm new to this, your assistence will be greatly appriated :-)
      >
      i have a connection string (this all in asp )
      >
      tCSCst = Provider=SQLOLE DB;Data Source=test02x2 ;Port=1444;Init ial
      Catalog=<catalo ge>;User ID=<id>;Passwor d=<password>
      >
      Set testCaseServerC onn = Server.CreateOb ject("ADODB.Con nection")
      testCaseServerC onn.Open tCSCstr
      >
      but i get the following error
      >
      An error occured:-2147467259 - Invalid connection string attribute
      >
      the problem seems to be the port itself, if i use 1433 then it works
      fine.
      >

        Comment

        • Kyle Peterson
          #3
          Re: problems with port in connections (in ASP)

          try data source, then a comma, port number

          that is how I do it

          get rid of the port= stuff




          "Kavi" <Kavita.K.Singh @gmail.comwrote in message
          news:1158817836 .211485.204380@ h48g2000cwc.goo glegroups.com.. .
          Hi all
          >
          i'm new to this, your assistence will be greatly appriated :-)
          >
          i have a connection string (this all in asp )
          >
          tCSCst = Provider=SQLOLE DB;Data Source=test02x2 ;Port=1444;Init ial
          Catalog=<catalo ge>;User ID=<id>;Passwor d=<password>
          >
          Set testCaseServerC onn = Server.CreateOb ject("ADODB.Con nection")
          testCaseServerC onn.Open tCSCstr
          >
          but i get the following error
          >
          An error occured:-2147467259 - Invalid connection string attribute
          >
          the problem seems to be the port itself, if i use 1433 then it works
          fine.
          >

            Comment

            Previous template Next
            Working...