Re: Does Informix OLEDB support OpenSchema?

Thanks a lot for answering. i have tried your solution, and i'm sorry to tell it didn't help. i'm still getting the same error: "Object or provider is not capable of performing requested operation." anything else? smoeks@yahoo.com (Shawn Moe) wrote in message news:<7df6abab.0306041548.15f674aa@posting.google.com>... > Hi, > > It looks like the connection string is not correct for a connection > using the Informix OLEDB provider. There are some changes required > when switching between the OLEDB provider and the OLEDB bridge for > ODBC. The user should be > mentioned as "User Id = username" and the data source should be > mentioned as "Data Source = dbname@servername". > > With a correct connection string, we are able to see the desired > result, > i.e the list of tables in the current database. Here is the code we > used to verify. > > Private Sub Command1_Click() > Dim cCmd As New ADODB.Command > Dim rsRow As New ADODB.Recordset > Dim cn As New ADODB.Connection > Dim connectstring As String > > connectstring = "Provider=Ifxoledbc; Data > Source=common_db@foo9405; user id=informix;password=abc" > > cn.Open (connectstring) > > Set rsRow = cn.OpenSchema(adSchemaTables) > > rsRow.MoveFirst > While (Not rsRow.EOF) > MsgBox rsRow.Fields(0) + " " + rsRow.Fields(1) + " " + > rsRow.Fields(2) + " " + rsRow.Fields(3) > rsRow.MoveNext > Wend > > End Sub > > > Regards, > > Shawn Moe