connectivity error using sql server

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • muskan
    New Member
    • Nov 2006
    • 35

    connectivity error using sql server

    hello

    I have written:

    conn.connection string= "data source=VTECHS;d atabase=abc;uid =hkjhkj;passwor d=***;"
    conn.open
    But this line creating error .
    Error is "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
    ".

    Please tell me how to remove the error.
  • jai80
    New Member
    • Nov 2006
    • 30

    #2
    Originally posted by muskan
    hello

    I have written:

    conn.connection string= "data source=VTECHS;d atabase=abc;uid =hkjhkj;passwor d=***;"
    conn.open
    But this line creating error .
    Error is "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
    ".

    Please tell me how to remove the error.
    hi muskan,

    conn.connection string= "data source=VTECHS;PROVIDER=SQLOLE DB;database=abc;u id=hkjhkj;passw ord=***;"
    conn.open

    you wil have to specify the appropriate provider name. the above line uses sqloledb provider, and it says that sql server is the backend that will be used for the application. Use specific provider name according to the rdbms/dbms you will be using for your application (sql server,ms-access...)

    gud luck!

    cheers,
    jai

    Comment

    • muskan
      New Member
      • Nov 2006
      • 35

      #3
      hello,

      Thanks for reply.

      But still connection is not established
      It giving the same error
      I have written as:
      conn.connection string="PROVIDE R=SQLOLEDB;Data Source=VTECHS;d atabase=abc;Use r ID=fggh;Passwor d=*****;"


      tell how to remove.
      Thanks.

      Originally posted by jai80
      hi muskan,

      conn.connection string= "data source=VTECHS;PROVIDER=SQLOLE DB;database=abc;u id=hkjhkj;passw ord=***;"
      conn.open

      you wil have to specify the appropriate provider name. the above line uses sqloledb provider, and it says that sql server is the backend that will be used for the application. Use specific provider name according to the rdbms/dbms you will be using for your application (sql server,ms-access...)

      gud luck!

      cheers,
      jai

      Comment

      Working...