RE: Informix ODBC problem when on 1 PC

Posted in 2004

Sheshnarayan Agrawal — Thu, 24 Jun 2004 12:06:10 -0500 — source: Usenet: comp.databases.informix

--0__=08BBE42EDFCF28FF8f9e8a93df938690918c08BBE42EDFCF28FF Content-type: multipart/alternative; Boundary="1__=08BBE42EDFCF28FF8f9e8a93df938690918c08BBE42EDFCF28FF" --1__=08BBE42EDFCF28FF8f9e8a93df938690918c08BBE42EDFCF28FF Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable Hi, You might want to report this problem to your IBM Informix Technical Support. However I am still not able to reproduce the problem which you= are talking about. Currently I am using CSDK 2.90 Beta ( ODBC 2.90 ) on= Windows 2000 SP3. As you said you are using CSDK 2.81.TC2 and I am not aware of such problems even in CSDK 2.81.TC2 , I also tried CS= KD 2.81.TC1 and still I am not able to reproduce the problem. I did create two System DSNs changed the server name in one DSN and checked b= ack the same in the other DSN, the other DSN was still holding its original server name and vice versa. You might also want to check the values of various fields in the regist= ry "My Computer\\HKEY_LOCALE_MACHINE\\SOFTWARE\\ODBC\\ODBC.INI\\<your dsn names>" to make sure it does indeed changes. Again, pl. report this= problem in detail to your IBM Informix Technical Support. Thanks -Shesh = "Dirk Moolman" = <DirkM@mxgroup.co To: Sheshnarayan A= grawal/Lenexa/IBM@IBMUS .za> cc: <informix-list= @iiug.org>, <owner-informix-list@iiug.org> Sent by: Subject: RE: Informix O= DBC problem when on 1 PC owner-informix-li = st@iiug.org = = = 06/24/2004 09:07 = AM = = Windows 2000 He says he creates SYSTEM DSN's, but he also says that in the older versions he could change a SYSTEM DSN on a PC, and not affect the other= DSN's on the same PC. In the new version the change is global, all DSN's on the same PC are affected. Dirk -----Original Message----- From: Sheshnarayan Agrawal [mailto:shesh@us.ibm.com] Sent: Tuesday, June 22, 2004 6:49 PM To: Dirk Moolman Cc: informix-list@iiug.org; owner-informix-list@iiug.org Subject: Re: Informix ODBC problem when on 1 PC Some more information would help : - What type of DSNs (i.e USER, SYSTEM or FILE) you are talking about? - What is your Windows OS version ( i.e NT, 2000 etc ) ? I am not aware of such problems reported earlier. Thanks & Regards -Shesh "Dirk Moolman" <DirkM@mxgroup.co.za> Sent by: owner-informix-list@iiug.org 06/22/2004 09:25 AM To: <informix-list@iiug.org> cc: Subject: Informix ODBC problem when on 1 PC Our Java / VB developer has a problem with our new ODBC drivers. He tel= ls me that from version 3.31 onwards (I installed CSDK2.81 TC2 for Windows= ), he configures multiple "data source names" (multiple odbc's) on the sam= e PC, BUT - when he changes the attribute of one data source name (odbc), the= attributes for the other sources on the same PC also changes. For examp= le if he changes the INFORMIXSERVER for the one, it changes for the others= too. Does anyone have any tips / suggestions for this problem ? |----------------------------------------------------------------------= ----| | = | | << ella for Spam Control >> has removed 2331 Spam messages and set= | | aside 832 Newsletters for me = | | You can use it too - and it's FREE! www.ellaforspam.com = | | = | |----------------------------------------------------------------------= ----| = --1__=08BBE42EDFCF28FF8f9e8a93df938690918c08BBE42EDFCF28FF Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> Hi, You might want to report this problem to your IBM Informix Technical Su= pport. However I am still not able to reproduce the problem which you<b= r> are talking about. Currently I am using CSDK 2.90 Beta ( ODBC 2.90 ) on= Windows 2000 SP3. As you said you are using CSDK 2.81.TC2 and I am not aware of such problems even in CSDK 2.81.TC2 , I also tried CS= KD 2.81.TC1 and still I am not able to reproduce the problem. I did = create two System DSNs changed the server name in one DSN and checked b= ack the same in the other DSN, the other DSN was still holding its original server name and vice versa. You might also want to check the values of various fields in the regist= ry "My Computer\\HKEY_LOCALE_MACHINE\\SOFTWARE\\ODBC\\ODBC.INI\\<you= r dsn names>" to make sure it does indeed changes. Again, pl. rep= ort this problem in detail to your IBM Informix Technical Support. Thanks -Shesh <img src=3D"cid:10__=3D08BBE42EDFCF28FF8f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for "Dirk Moolman&= quot; <DirkM@mxgroup.co.za>">"Dirk Moolman" <DirkM@m= xgroup.co.za> <table V5DOTBL=3Dtrue width=3D"100%" border=3D"0" cellspacing=3D"0" cel= lpadding=3D"0"> <tr valign=3D"top"><td width=3D"1%"><img src=3D"cid:20__=3D08BBE42EDFCF= 28FF8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"72" al= t=3D""> </td><td style=3D"background-image:url(cid:30__=3D08BBE42EDFCF28FF8f9e8= a93df938@us.ibm.com); background-repeat: no-repeat; " width=3D"1%"><img= src=3D"cid:20__=3D08BBE42EDFCF28FF8f9e8a93df938@us.ibm.com" border=3D"= 0" height=3D"1" width=3D"225" alt=3D""> <ul> <ul> <ul> <ul>"Dirk Moolman" <DirkM@mxgroup.co.z= a> Sent by: owner-informix-list@iiug.org 06/24/2004 09:07 AM</ul> </ul> </ul> </ul> </td><td width=3D"100%"><img src=3D"cid:20__=3D08BBE42EDFCF28FF8f9e8a93= df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""> To: <font size=3D