please, help with ODBC/DNS
Alexey Shevchukevich needed to create an ODBC DSN for Informix on WinNT to use from Perl and asked for example values for the Informix 2.80 driver setup. allenj explained the fields: database, server name, host, service and protocol such as onsoctcp. Imran Hussain and Steven Wilcoxon advised first setting up CLI with SetNet32 and testing with IloginDemo. No outcome reported.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi All, I'm extremely needed to create DSN in order to connect to Informix via ODBC driver from Perl. What I did: in ControlPanel (by the way I didn't mentioned that I'm using Informix on WinNT) I'm choosing ODBC, next SystemDSN. Then I'm pressing 'Add' button . Create New Data Source dialog is appeared. I'm choosing 'Informix 2.80 32 BIT' driver and click finish button. Then it's appeared the INFORMIX-CLI DSN Setup. Can anyone send me example of the filled fields in this dialog especially of the first part of this one ? Thank you Alexey.
hhmmm........I always use the "User DSN" tab - I don't know what the difference is. As for the Setup Screen: Data Source Name: This is arbitrary. Just let your app know what you choose. Database: The informix database name you want to connect to with this data source. Server: Whats the name of your informix server? (ala onconfig INFORMIXSERVER) Host: Whats the name of the box that the informix database lives on? Make sure its represented in your local hosts file. Service: Whats the name of the service to use when using the database? It should be in your local services file with the port number. Protocol: Check your Informix manuals on this one. I use onsoctcp. HTH allen Alexey Shevchukevich wrote: > > Hi All, > > I'm extremely needed to create DSN in order to > connect to Informix via ODBC driver from Perl. > What I did: in ControlPanel (by the way I didn't > mentioned that I'm using Informix on WinNT) I'm > choosing ODBC, next SystemDSN. Then I'm pressing > 'Add' button . Create New Data Source dialog is appeared. > I'm choosing 'Informix 2.80 32 BIT' driver and click finish > button. Then it's appeared the INFORMIX-CLI DSN Setup. > Can anyone send me example of the filled fields in this dialog > especially of the first part of this one ? > > Thank you > Alexey.
Hello Alexey, Before can use the ODBC driver, you must setup the CLI client. Run the CLI Demo program to see if you can connect to the server. I don't know if it will be helpful or not, but I have written a small document that explains how to setup ODBC. It is not specific to Informix but it is worth looking at. The address is http://www.imranweb.com/freesoft and read the document for WinSQL. Thanks, Imran. ===================================================================== Imran Hussain imranh@imranweb.com For FREE Software visit http://www.imranweb.com/freesoft ===================================================================== allenj wrote: > hhmmm........I always use the "User DSN" tab - I don't know what the > difference is. > > As for the Setup Screen: > > Data Source Name: This is arbitrary. Just let your app know what you > choose. > > Database: The informix database name you want to connect to with this > data source. > > Server: Whats the name of your informix server? (ala onconfig > INFORMIXSERVER) > > Host: Whats the name of the box that the informix database lives on? > Make sure its represented in your local hosts file. > > Service: Whats the name of the service to use when using the database? > It should be in your local services file with the port number. > > Protocol: Check your Informix manuals on this one. I use onsoctcp. > > HTH > > allen > > Alexey Shevchukevich wrote: > > > > Hi All, > > > > I'm extremely needed to create DSN in order to > > connect to Informix via ODBC driver from Perl. > > What I did: in ControlPanel (by the way I didn't > > mentioned that I'm using Informix on WinNT) I'm > > choosing ODBC, next SystemDSN. Then I'm pressing > > 'Add' button . Create New Data Source dialog is appeared. > > I'm choosing 'Informix 2.80 32 BIT' driver and click finish > > button. Then it's appeared the INFORMIX-CLI DSN Setup. > > Can anyone send me example of the filled fields in this dialog > > especially of the first part of this one ? > > > > Thank you > > Alexey. -- ===================================================================== Imran Hussain imranh@imranweb.com For FREE Software visit http://www.imranweb.com/freesoft =====================================================================
That is, setup CLI using SetNet32 (in the Informix directory) and use IloginDemo for testing. Once you have everything running there you move to the ODBC on the control panel. S.W. Imran Hussain <imranh@imranweb.com> wrote in message news:37DD11D8.56EAC2B8@imranweb.com... > Hello Alexey, > Before can use the ODBC driver, you must setup the CLI client. Run the CLI > Demo program to see if you can connect to the server. > > I don't know if it will be helpful or not, but I have written a small > document that explains how to setup ODBC. It is not specific to Informix > but it is worth looking at. The address is http://www.imranweb.com/freesoft > and read the document for WinSQL. > > Thanks, > Imran. > > ===================================================================== > Imran Hussain > imranh@imranweb.com > > For FREE Software visit > http://www.imranweb.com/freesoft > ===================================================================== > > > allenj wrote: > > > hhmmm........I always use the "User DSN" tab - I don't know what the > > difference is. > > > > As for the Setup Screen: > > > > Data Source Name: This is arbitrary. Just let your app know what you > > choose. > > > > Database: The informix database name you want to connect to with this > > data source. > > > > Server: Whats the name of your informix server? (ala onconfig > > INFORMIXSERVER) > > > > Host: Whats the name of the box that the informix database lives on? > > Make sure its represented in your local hosts file. > > > > Service: Whats the name of the service to use when using the database? > > It should be in your local services file with the port number. > > > > Protocol: Check your Informix manuals on this one. I use onsoctcp. > > > > HTH > > > > allen > > > > Alexey Shevchukevich wrote: > > > > > > Hi All, > > > > > > I'm extremely needed to create DSN in order to > > > connect to Informix via ODBC driver from Perl. > > > What I did: in ControlPanel (by the way I didn't > > > mentioned that I'm using Informix on WinNT) I'm > > > choosing ODBC, next SystemDSN. Then I'm pressing > > > 'Add' button . Create New Data Source dialog is appeared. > > > I'm choosing 'Informix 2.80 32 BIT' driver and click finish > > > button. Then it's appeared the INFORMIX-CLI DSN Setup. > > > Can anyone send me example of the filled fields in this dialog > > > especially of the first part of this one ? > > > > > > Thank you > > > Alexey. > > -- > ===================================================================== > Imran Hussain > imranh@imranweb.com > > For FREE Software visit > http://www.imranweb.com/freesoft > ===================================================================== >