Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Posts
    2

    Unanswered: oledb connect string

    HI
    THis is my connection string in VB6.0
    but i get a error while open connection
    anything should i add in the string?
    "
    Dim oleconn As New ADODB.Connection

    sCNString = "Provider=Ifxoledbc.2;password=Pwd;User ID=myid;
    Data Source=call@ispc9db;Persist Security Info=true;
    informixsqlhost=111.222.2222.222"

    oleconn.Open sCNString
    "
    ERR no:-2147217887

    Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

    informix CSDK 2.81
    informix 7.30.U

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    I am not familiar with VB, but I think that the value of your informixsqlhosts is not correct.
    rws

  3. #3
    Join Date
    Apr 2003
    Posts
    2
    HI

    the informixsqlhosts is in my internal LAN
    it is a 192.168.X.X IP

    sorry make a mistake

  4. #4
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Hi,

    did you try tracing the connection?
    It might be interesting to check the informix error messages behind all the microsoft stuff.
    rws

Posting Permissions

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