Re: Retrieving Mulitiple Databases when Connecting to Informix
Hi Andrew. Here is my source. RDO Dim Connect As String Dim rdoEnv As rdoEnvironment Dim ConnRDO As rdoConnection Connect = "DSN=cspc08test_db; UID=informix; PWD=01informix; PRO=onsoctcp; Database=test_db;" Set rdoEnv = rdoEnvironments(0) Set ConnRDO = rdoEnv.OpenConnection("", rdDriverComplete, False, Connect) ADO Dim ConnADO As ADODB.Connection Dim ConnString As String Set ConnADO = CreateObject("ADODB.Connection") ConnADO.Open "DSN=cspc08_testdb;UID=informix;PWD=informix;" But I have not tested in ADO. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "Andrew" <amacdonald@whitehilltech.com> >Reply-To: "Andrew" <amacdonald@whitehilltech.com> >To: informix-list@iiug.org >Subject: Retrieving Mulitiple Databases when Connecting to Informix >Date: Mon, 23 Jun 2003 18:14:33 GMT > >This is a multi-part message in MIME format. > >------=_NextPart_000_000F_01C3399A.3C569580 >Content-Type: text/plain; > charset="iso-8859-1" >Content-Transfer-Encoding: quoted-printable > >I have a simple informix connection string that I want to modify to = >retrieve multiple databases when connecting. I know when I use SQL = >Server I can just use a connection string with the database name =3D = >'master', but that doesn't seem to work for informix. Is what I want to = >do possible, if so, how do I go about doing it? > ><add key=3D"DatabaseConnectionString" = >value=3D"Dsn=3DProforma;Driver=3D{IBM INFORMIX 3.80 32 = >BIT};Host=3DAEGTEST1;Server=3DInformix7;Service=3D2000;Protocol=3Dolsoctc= >p;Database=3Dproforma;UID=3Dinformix;PWD=3Dinformix"/>=20 > >Thanks, >Andrew MacDonald > >------=_NextPart_000_000F_01C3399A.3C569580 >Content-Type: text/html; > charset="iso-8859-1" >Content-Transfer-Encoding: quoted-printable > ><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> ><HTML><HEAD> ><META http-equiv=3DContent-Type content=3D"text/html; = >charset=3Diso-8859-1"> ><META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR> ><STYLE></STYLE> ></HEAD> ><BODY> ><DIV><FONT color=3D#008000 size=3D2> ><P><FONT face=3DArial color=3D#000000>I have a simple informix = >connection string=20 >that I want to modify to retrieve multiple databases when = >connecting. I=20 >know when I use SQL Server I can just use a connection string with the = >database=20 >name =3D 'master', but that doesn't seem to work for informix. Is = >what I=20 >want to do possible, if so, how do I go about doing it?</FONT></P> ><P><FONT color=3D#000000><add key=3D"DatabaseConnectionString"=20 >value=3D"Dsn=3DProforma;Driver=3D{IBM INFORMIX 3.80 32=20 >BIT};Host=3DAEGTEST1;Server=3DInformix7;Service=3D2000;Protocol=3Dolsoctc= >p;<FONT=20 >color=3D#0000ff>Database=3Dproforma</FONT>;UID=3Dinformix;PWD=3Dinformix"= >/></FONT>=20 ></P> ><P><FONT face=3DArial color=3D#000000>Thanks,<BR>Andrew=20 >MacDonald</FONT></P></FONT></DIV></BODY></HTML> > >------=_NextPart_000_000F_01C3399A.3C569580-- > _________________________________________________________________ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 sending to informix-list