Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2003
    Location
    india
    Posts
    4

    Unanswered: dbnetlib problem when connecting to sql server through vb6

    hi,

    I am getting this error message when trying to connect to sql server through vb-sqldmo

    -2147467259 (80004005)
    DEBNETLIB connection open connect() sql server not found.

    please help me out of this problem.

    vinod.

  2. #2
    Join Date
    Oct 2003
    Location
    Manila, Philippines
    Posts
    20
    Can u post your connection string here?

  3. #3
    Join Date
    Dec 2003
    Location
    india
    Posts
    4

    connection string

    this is the connection string:
    note: this was working alright till yesterday since last two years.

    ConStr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Pharma;Data Source=" & lServerName & ";Connect Timeout=15"

  4. #4
    Join Date
    Dec 2003
    Location
    india
    Posts
    4

    dbnetlib error

    Originally posted by bvmantos
    Can u post your connection string here?
    this is it:

    ConStr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Pharma;Data Source=" & lServerName & ";Connect Timeout=15"

  5. #5
    Join Date
    Sep 2003
    Posts
    522
    have you tried both network libraries in your connection string?

  6. #6
    Join Date
    Dec 2003
    Location
    india
    Posts
    4
    Originally posted by ms_sql_dba
    have you tried both network libraries in your connection string?
    please explain which libraries u r refererring to, i am using sqldmo.dll

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •