OLE DB Provider=Ifxoledbc.2 1

[nilin]

Hi friends,
Can somebody send me this oledb provider??

I am having Informix Dynamic Server 7.3 on HpUx10.2 and want to connect it thr. Windows 2000 Vb or Vb.Net application , for that i need this driver.
You can send it as an attachement at nilin.limje@spicaindia.com address.
Thanks in advance.
Nilin

 

[vpshriyan]

Hi,

You may download relevant ODBC driver setup from:

http://www-3.ibm.com/software/data/informix/

This thread may help you in setting up the drivers:
thread876-409375

Regards,
Shriyan

 

[nilin]

Hi,
Sorry , I am unable to find any driver at this given address. There are lot many links on this site which allows you to download documentation and notes , but I didnot find any ODBC driver.
Can anybody directly send me that driver as an attachement at following address nilin.limje@spicaindia.com

Also I would like to ask that Does this driver needs any other software to get connect with the database? Or it simply works like "VB & SqlServer"? Because from above links I think it requires "Client SDK" software, So I am confused.

Thanking You,
Nilin

 

[vpshriyan]

Nilin:

Here is the direct link to the file you needed:

http://www14.software.ibm.com/webap...2002-11-27+12:17:07.563193C&S_TACT=&S_CMP=&s=

IBM Informix Client Software Development Kit (CSDK) for Windows: IBM Informix Client Software Development Kit (CSDK) Bundle contains IBM Informix Client SDK 2.80.TC1,Informix JDBC Driver 1.50.JC1, and JDBC/EMBEDDED SQLJ 2.21.JC3

Platform(s): Windows 2000, Windows 98, Windows NT, Windows XP

Minimum requirements: CSDK must be installed on a machine with a running IBM Informix Dynamic Server or IBM Informix Extended Parallel Server instance.

File Size: 40mb.

Regards,
Shriyan

 

[nilin]

Hi,
I am downloading your given link .
Meantime I would like to ask you one thing, as you mentioned in your "minimum requirements" Do I have to install "IBM Informix Dynamic Server or IBM Informix Extended Parallel Server instance." on my Windows 2000 PC?

Because as I mentioned in my previous question,that, I am already having Informix 7.3 Dynamic Server on Hp Unix Server with Unix10.2, and I want to access this database thr. my Windows machine (win2000) thr. any front end application it can be VB or .net.
Would like to hear comments from you
Thanking you,
Nilin

 

[nilin]

Hi,
Yes I have downloaded this 40MB file on my machine. (win2000)
Now tell me what is next?
nilin

 

[vpshriyan]

Hi,

Extract csdk280_tc1.zip and study documents situated at:
doc\client_install.pdf
doc\odbc*.html
doc\oledb*.html

Run setup and follow the instructions. Go for custom setup type. Opt for IBM Informix ODBC Driver and OLE DB Provider.

After this you may proceed to configure the ODBC Data Sources (32bit).

This thread will help you in setting up the drivers in detail:
thread876-409375

Regards,
Shriyan

"An ounce of example is worth a pound of advice."

 

[nilin]

Hi ,
Extracted the Zip file and gone thr. the documents.
I run the "setup" file and installed "IBM Informix Client SDK 2.80" on my Win2000 machine.
But problem is with ODBC 32 driver.
I went thr. your thread in which you replied to "adalberto", and from this i went to

http://www.informix.com/evaluate/

this link but it takes control to

http://www-3.ibm.com/software/data/informix/

this site, now i didnot found any odbc driver at this link.
Tell me if I went thr. correct procedure or wrong?
Waiting reply
nilin

 

[vpshriyan]

Hi,

You need NOT go in the links:

http://www.informix.com/evaluate/

http://www-3.ibm.com/software/data/informix/

as mentioned in the pretty old thread Thread876-409375.

You have already downloaded required & relevant ODBC drivers for front-end connection. You have to follow the rest of the steps mentioned in the said thread.

If you have already run the setup, your Win2k machine must have the relevant odbc driver installed in the system directory. Now you may proceed to configure the ODBC Data Sources (32bit), and DSN file creation in your local machine. For backend configuration and modification you have to follow the steps mentioned the said thread.

Good Luck!

Regards,
Shriyan

 

[nilin]

Hi,
When i go thr. Start-ControlPanel-ODBC-SystemDsn it shows me entry for "Informix 3.81 32 BIT " and in files column it shows "ICLIT09B.DLL" .
But it is not showing "INFORMIX 2.80" or "INTERSOLV", SO i think i should choose "Informix3.81 32Bit" Is it right?

Thanking you for your time to time help.
Nilin

 

[vpshriyan]

Nilin:

Right. Goahead with "Informix 3.81 32 BIT" routed System DSN creation and try a test connection with Win2k built-in Microsoft Data Link utility or with any other front-end utilities.

Regards,
Shriyan

 

[nilin]

Hi,
I went thr. System Dsn Entry add and gave the following values,
under connection tab :
Server Name : 192.168.1.100 (ip address of my unix server)
Host Name : HP
Services : 4555
Protocol : onsoctcp
DataBaseName: purchase_db
User ID : informix
Password : ****
and said "apply and test connection" but it gives me an error as "Cannot connect to database server HP"
Please tell me if any wrong parameters i gave?

nilin

 

[vpshriyan]

Hi,

All the system dsn specifications refers to back-end parameters configured for the client-server computings. Hence, it means you have to configure your back-end Unix box first.

At your HP server machine check the below:

grep $INFORMIXSERVER $INFORMIXDIR/etc/$ONCONFIG # should return one line
grep $INFORMIXSERVER $INFORMIXDIR/etc/sqlhosts # should return one line

SOCDB=`grep DBSERVERALIASES $INFORMIXDIR/etc/$ONCONFIG | awk '{print $2}'`
SERV=`grep $SOCDB $INFORMIXDIR/etc/sqlhosts | awk '{print $4}'`
grep -i $SERV /etc/services # should return one line

You can varify the service related network information by:
onstat -g ntt
see the thread name and address column & locate thread named soctcplst.

It seems to me that you have supplied certain wrong parameters to the dsn.

Server Name : equivalent to DBSERVERALIASES of $INFORMIXDIR/etc/$ONCONFIG or first field of $INFORMIXDIR/etc/sqlhosts having 3rd field onsoctcp
HostName : /etc/hosts should contain entry basically you HP server IP address.
Services : 4th column parameter of $INFORMIXDIR/etc/sqlhosts having 3rd field onsoctcp or port number under /etc/services
Protocol : onsoctcp

I would request you to study thread thread876-409375 in more detail.

Regards,
Shriyan

"If you have knowledge, let others light their candles with it."

 

[nilin]

Hi Shriyan,

While connecting from Windows 2000 client PC to Informix Server (Informix 7.x with HP-UNIX 10.x) i am getting error number -908 when trying from ILogin
Full error message is like:
Message from ILogin Demo
Database: Sqlcode = -908
Refer to Informix find error utility or
Informix error messages manual for
more detail on the error number

Please guide me in this regard, Is it anything to do regarding Server side setting?

Thanks in advance
Sandeep/Nilin

 

[vpshriyan]

Hi Sandeep/Nilin,

Please provide dump of the blow, to proceed further:

1. grep $INFORMIXSERVER $INFORMIXDIR/etc/$ONCONFIG
2. grep $INFORMIXSERVER $INFORMIXDIR/etc/sqlhosts
3. SOCDB=`grep DBSERVERALIASES $INFORMIXDIR/etc/$ONCONFIG | awk '{print $2}'`
SERV=`grep $SOCDB $INFORMIXDIR/etc/sqlhosts | awk '{print $4}'`
grep -i $SERV /etc/services
4. onstat -g ntt

DSN Parameter listing:
1. Server Name :
2. HostName :
3. Services :
4. Protocol :

Regards,
Shriyan

 

[nilin]

Hi Shriyan,
find bellow the required dump of the commands

1> grep $INFORMIXSERVER $INFORMIXDIR/etc/$ONCONFIG
DBSERVERNAME admnsrv1 # Name of default database server

2> grep $INFORMIXSERVER $INFORMIXDIR/etc/sqlhosts
admnsrv1 onipcshm spica on_admnsrv1
admnsrv1 onsoctcp spica on_admnsrvtcp

3> We don't have DBSERVERALISES , it's blank in ONCONFIG
We have DBSERVERNAME in ONCONFIG as below:
DBSERVERNAME admnsrv1 # Name of default database server
That is why i am not able to run your 3 commands in point-3
SOCDB comes as null

4> onstat -g ntt
Informix Dynamic Server Version 7.31.UC2 -- On-Line -- Up 1 days 04:41:43 -- 30128 Kbytes

global network information:
#netscb connects read write q-free q-limits q-exceed
3/ 4 3 13 13 0/ 0 0/ 0 0/ 0

Individual thread network information (times):
netscb thread name sid open read write address
c7bbf880 sm_discon 5 10:11:24
02/13/04
c7ba4700 sm_listen 3 10:11:24
02/13/04
c7ba35f8 sm_poll 2 10:11:24
02/13/04

DSN Parameter listing:
1. Server Name : admnsrv1
2. HostName : 192.168.1.51
3. Services : on_admnsrvtcp
4. Protocol : onsoctcp

Thanks & waiting for your reply,
Sandeep

 

[vpshriyan]

Hi,

In my view there is still configuration anomaly in the setup resulting in unsuccessful connection to the back-end engine. Do the following changes and retry.

edit $INFORMIXDIR/etc/sqlhosts
admnsrv1 onsoctcp spica on_admnsrvtcp
as
admnsrv1_tcp onsoctcp spica on_admnsrvtcp

edit $INFORMIXDIR/etc/$ONCONFIG
DBSERVERALISES admnsrv1_tcp

After these changes you need to bounce (down & up) the dbserver instance to take the effect.

Regards,
Shriyan

 

[nilin]

Hi Shriyan,

Thanks for reply,
but if i edit this DBSERVERALISES to ONCONFIG and when i do the shutdown of Informix (to bounce back) it is not coming from OFFLINE to ONLINE (since it's not in Quiescent Mode) so Share Memory is not initialized....

can you tell me why is it so?

one more think i need to tell you that while creating System DSN in "Connection" tab, Database Name comobox is there, if i click on combobox i think it tries to connect to Server (takes some time) and throws error "connection to admnsrv1 is failed"

Thanks,
Sandeep

 

[vpshriyan]

Hi Sandeep,

Very strange! that after introduction of serveralises in $ONCONFIG file, the dbserver fails to initialize shared memory.

I would suggest the steps outlined below:

1. Shutdown the database server completely. (onmode -cuky)
2. edit $INFORMIXDIR/etc/$ONCONFIG
DBSERVERALISES admnsrv1_tcp
3. edit $INFORMIXDIR/etc/sqlhosts
admnsrv1_tcp onsoctcp spica on_admnsrvtcp
4. edit /etc/services
on_admnsrvtcp 1526/tcp (or any other port)

start the database engine by oninit -v for verbose listing of backend startup activities. Post the contents to us, if shared memory initialization fails.

Regards,
Shriyan