Oninit cdi / Archive
Talk to an expert →

Re: REQ: Feasible Informix OLE DB Connection String

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET, Security, Permissions & Auditing

���� Thenardier — — source: Informix-list mailing list archive (1991-1998)

On Fri, 03 Sep 1999 13:51:19 GMT, Giovani Batoni <gbatoni@mediaone.net> wrote: >Dim cn as New ADODB.connection >cn.Open ("UID=mari;PWD=xxx;DataSource=database@server_name;Provider=ifxoledbc) hi giovani, thanx for ur input. yet i find something interesting. it appears that the informix ole db provider doesn't know UID and PWD in the connection string. it treats these two parameters as "Extended Properties". when i look at the connection string after the connection has been made. it becomes: Provider=ifxoledbc.2;User ID="";Password=""; Extended Properties="UID=mari;PWD=xxx"; Data Source=database@server_name .... etc. i can make the connection now. here comes another more critical problem -- i just can't add/update thru the adodb recordset -- i can't even open a recordset! what should i do? rgds, thenard ------- pls remove pk. in reply, thanx. ¦^ÂЮɽЧâpk. K ±¼, ÁÂÁÂ.

↪ replying to ���� Thenardier
Leopold The Cat — — source: Informix-list mailing list archive (1991-1998)

From what I understand ADO uses User ID= and Password=. UID= and PWD= are passed to ODBC drivers. Leopold '''' Thenardier <Thenardier@pk.POBoxes.com> wrote in message news:37cff0c2.823606@news.netvigator.com... > On Fri, 03 Sep 1999 13:51:19 GMT, Giovani Batoni > <gbatoni@mediaone.net> wrote: > >Dim cn as New ADODB.connection > >cn.Open ("UID=mari;PWD=xxx;DataSource=database@server_name;Provider=ifxoledbc) > > hi giovani, > > thanx for ur input. yet i find something interesting. > it appears that the informix ole db provider doesn't know > UID and PWD in the connection string. it treats these > two parameters as "Extended Properties". when i look > at the connection string after the connection has been > made. it becomes: > > Provider=ifxoledbc.2;User ID="";Password=""; > Extended Properties="UID=mari;PWD=xxx"; > Data Source=database@server_name .... etc. > > i can make the connection now. here comes another > more critical problem -- i just can't add/update > thru the adodb recordset -- i can't even open a > recordset! > > what should i do? > > > rgds, > thenard > ------- > pls remove pk. in reply, thanx. > '^'ЮɽЧ'pk. K '', ''''.