Installing OLE DB support in IDS 9.4
Hi all,
Following a thread between M.Kovacic & Sunny:
> I tried that but from dbaccess said that the
> table to be created in coledbp.sql was already
> created. I am setting up the Informix for
> Window, so there is no cdotnet.sql , I guess.
I try to find these scripts but I couldn't. I searched the files coledbp.sql
and cdotnet.sql under the $INFORMIXDIR hierarchy for the files _coledbp.sql_
and _cdotnet.sql_, but I didn't found them.
I searched on :
I-IDS Ver. 9.40.TC5TL on Windows XP Pro-SP2
I-IDS Ver. 9.40.FC4 on HP-UX B.11.11
But I found anything ole / dotnet related.
In fact I tried this on sysmaster;
select tabid, tabname[1,30]
from systables
where tabid > 99
and (tabname matches '*ole*' or tabname matches '*net*')
order by 1, 2;
0 rows!
So where are these files?.
Do I'm missing something?
Do I need to install something aditional?
Any help would be appreciated
J.
PD: I'm tryin to enable OLE-DB support in IDS in order to add a linked server
in Sql-Server so that IDS tables are available to Sql-Server.
Jean Sagi
jeansagi@myrealbox.com
jeansagi@yahoo.com
--0__=08BBE539DF137CF48f9e8a93df938690918c08BBE539DF137CF4
Content-type: multipart/alternative;
Boundary="1__=08BBE539DF137CF48f9e8a93df938690918c08BBE539DF137CF4"
--1__=08BBE539DF137CF48f9e8a93df938690918c08BBE539DF137CF4
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable
Hi
The IBM Informix OLE DB driver has been shipped with Client SDK and
IConnect.
Make sure either of this component has installed on that computer.
The following SQL files will be available at $INFORMIXDIR\\\\etc
coledbp.sql
cdotnet.sql
(In this case $INFORMIXDIR is the directory location where the Client S=
DK
or IConnect installed)
Regards,
Satyan
Software Engineer
R&D - IBM Information Management Division
11200 Lakeview, Lenexa, KS 66219
Tel: 913 599 8792 (T/L: 337-8792)
=
"Jean Sagi" =
<jeansagi@myrealb =
ox.com> =
To
Sent by: ids@iiug.org =
forum.subscriber@ =
cc
iiug.org =
Subj=
ect
Installing OLE DB support in IDS=
02/16/2005 03:38 9.4 [4276] =
PM =
=
=
=
=
=
Hi all,
Following a thread between M.Kovacic & Sunny:
> I tried that but from dbaccess said that the
> table to be created in coledbp.sql was already
> created. I am setting up the Informix for
> Window, so there is no cdotnet.sql , I guess.
I try to find these scripts but I couldn't. I searched the files
coledbp.sql and cdotnet.sql under the $INFORMIXDIR hierarchy for the fi=
les
_coledbp.sql_ and _cdotnet.sql_, but I didn't found them.
I searched on :
I-IDS Ver. 9.40.TC5TL on Windows XP Pro-SP2
I-IDS Ver. 9.40.FC4 on HP-UX B.11.11
But I found anything ole / dotnet related.
In fact I tried this on sysmaster;
select tabid, tabname[1,30]
from systables
where tabid > 99
and (tabname matches '*ole*' or tabname matches '*net*')
order by 1, 2;
0 rows!
So where are these files?.
Do I'm missing something?
Do I need to install something aditional?
Any help would be appreciated
J.
PD: I'm tryin to enable OLE-DB support in IDS in order to add a linked
server in Sql-Server so that IDS tables are available to Sql-Server.
Jean Sagi
jeansagi@myrealbox.com
jeansagi@yahoo.com
=
--1__=08BBE539DF137CF48f9e8a93df938690918c08BBE539DF137CF4
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>Hi<br>
<br>
The IBM Informix OLE DB driver has been shipped with Client SDK and ICo=
nnect.<br>
Make sure either of this component has installed on that computer.<br>
<br>
The following SQL files will be available at $INFORMIXDIR\\\\etc <br>
coledbp.sql<br>
cdotnet.sql<br>
<br>
(In this case $INFORMIXDIR is the directory location where the Client S=
DK or IConnect installed)<br>
<br>
Regards, <br>
Satyan<br>
<br>
Software Engineer<br>
R&D - IBM Information Management Division<br>
11200 Lakeview, Lenexa, KS 66219<br>
Tel: 913 599 8792 (T/L: 337-8792)<br>
<br>
<img src=3D"cid:10__=3D08BBE539DF137CF48f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for "Jean Sagi&quo=
t; <jeansagi@myrealbox.com>">"Jean Sagi" <jeansagi@m=
yrealbox.com><br>
<br>
<br>
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D08BBE53=
9DF137CF48f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid=
th=3D"40%">
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">"Jean Sagi" <jeansagi@myrealbox.co=
m></font></b><font size=3D"2"> </font><br>
<font size=3D"2">Sent by: forum.subscriber@iiug.org</font>
<p><font size=3D"2">02/16/2005 03:38 PM</font></ul>
</ul>
</ul>
</ul>
</td><td width=3D"60%">
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D08BBE539DF137CF48f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D08BBE539DF137CF48f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">ids@iiug.org</font></td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D08BBE539DF137CF48f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D08BBE539DF137CF48f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
</td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D08BBE539DF137CF48f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt=
h=3D"100%"><img src=3D"cid:30__=3D08BBE539DF137CF48f9e8a93df938@us.ibm.=
com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">Installing OLE DB support in IDS 9.4 [4276]</font></td=
></tr>
</table>
<table border=3D"0" cellspacing=3D"0" cellpadding=3D"0">
<tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D08BBE539DF13=
7CF48f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=
=3D""></td><td width=3D"336"><img src=3D"cid:30__=3D08BBE539DF137CF48f9=
e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><=
/td></tr>
</table>
</td></tr>
</table>
<br>
<tt>Hi all,<br>
</tt><br>
<tt>Following a thread between M.Kovacic & Sunny:<br>
</tt><br>
<tt>> I tried that but from dbaccess said that the<br>
> table to be created in coledbp.sql was already<br>
> created. I am setting up the Informix for<br>
> Window, so there is no cdotnet.sql , I guess.<br>
</tt><br>
<tt>I try to find these scripts but I couldn't. I searched the files co=
ledbp.sql and cdotnet.sql under the $INFORMIXDIR hierarchy for the file=
s _coledbp.sql_ and _cdotnet.sql_, but I didn't found them.<br>
</tt><br>
<tt>I searched on :<br>
I-IDS Ver. 9.
Ummm...
That $INFORMIXDIR, I tought it was the $INFORMIXDIR engine...
I found these files on my Win KP, where I have installed The I-IC-SDK 2.81 TC2
04/04/2003 15:28 28.534 coledbp.sql
17/05/2003 01:26 8.498 cregress.sql
17/05/2003 01:26 10.118 cregressud.sql
04/04/2003 15:28 1.563 doledbp.sql
11/08/1999 00:32 5.295 uoledbp2021.sql
18/01/2000 19:07 3.978 uoledbp2125.sql
But no cdotnet.sql
So I have to run coledbp.sql against sysmaster.
But some questions come to my mind:
- Could I use this script against an Unix IDS?
- What's the purpose cregress.sql (no header) ADO?
- DO I have to run uoledbp2021.sql and uoledbp2125.sql
after I ran coledbp.sql?
- Where do I get cdotnet.sql? (not need it, just to
know.
J.
-----Original Message-----
From: Sathyanesh Krishnan <satyan@us.ibm.com>
To: "Jean Sagi" <jeansagi@myrealbox.com>
Date: Wed, 16 Feb 2005 17:30:34 -0600
Subject: Re: Installing OLE DB support in IDS 9.4 [4276]
Hi
The IBM Informix OLE DB driver has been shipped with Client SDK and
IConnect.
Make sure either of this component has installed on that computer.
The following SQL files will be available at $INFORMIXDIR\\\\etc
coledbp.sql
cdotnet.sql
(In this case $INFORMIXDIR is the directory location where the Client SDK
or IConnect installed)
Regards,
Satyan
Software Engineer
R&D - IBM Information Management Division
11200 Lakeview, Lenexa, KS 66219
Tel: 913 599 8792 (T/L: 337-8792)
"Jean Sagi"
<jeansagi@myrealb
ox.com> To
Sent by: ids@iiug.org
forum.subscriber@ cc
iiug.org
Subject
Installing OLE DB support in IDS
02/16/2005 03:38 9.4 [4276]
PM
Hi all,
Following a thread between M.Kovacic & Sunny:
> I tried that but from dbaccess said that the
> table to be created in coledbp.sql was already
> created. I am setting up the Informix for
> Window, so there is no cdotnet.sql , I guess.
I try to find these scripts but I couldn't. I searched the files
coledbp.sql and cdotnet.sql under the $INFORMIXDIR hierarchy for the files
_coledbp.sql_ and _cdotnet.sql_, but I didn't found them.
I searched on :
I-IDS Ver. 9.40.TC5TL on Windows XP Pro-SP2
I-IDS Ver. 9.40.FC4 on HP-UX B.11.11
But I found anything ole / dotnet related.
In fact I tried this on sysmaster;
select tabid, tabname[1,30]
from systables
where tabid > 99
and (tabname matches '*ole*' or tabname matches '*net*')
order by 1, 2;
0 rows!
So where are these files?.
Do I'm missing something?
Do I need to install something aditional?
Any help would be appreciated
J.
PD: I'm tryin to enable OLE-DB support in IDS in order to add a linked
server in Sql-Server so that IDS tables are available to Sql-Server.
Jean Sagi
jeansagi@myrealbox.com
jeansagi@yahoo.com
Jean Sagi
jeansagi@myrealbox.com
jeansagi@yahoo.com
--0__=08BBE538DF9474398f9e8a93df938690918c08BBE538DF947439
Content-type: multipart/alternative;
Boundary="1__=08BBE538DF9474398f9e8a93df938690918c08BBE538DF947439"
--1__=08BBE538DF9474398f9e8a93df938690918c08BBE538DF947439
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable
Hi Jean Sagi,
IBM Informix server allows the server and client installed at same or
different locations.
If server and client installed at the same location the INFORMIXDIR is =
same
for both.
If it is installed at different location, the term "INFORMIXDIR" needs =
to
be considered based on the contest.
That is why I mentioned in the previous mail "In this case" when I refe=
r
INFORMIXDIR
"(In this case $INFORMIXDIR is the directory location where the Client =
SDK
or IConnect installed)"
To get full functionality by using IBM Informix OLE DB provider we shou=
ld
execute
coledbp.sql against sysmaster database regardless of the platform serve=
r
has installed.
If you have DBACCESS available on NT box you can still use that utility=
and
connect to the server (tha has installed on any platform) and execute t=
he
coledbp.sql
The alternative option is to FTP coledbp.sql to the computer where the
server has installed and run it by using DBACCESS.
Only user "informix" has the permission to modify the sysmaster databas=
e,
Make sure you are connecting to sysmaster database as user "informix".=
We need to run only coledbp.sql to get OLE DB provider work.
OLE DB doesn't use any other SQL file including cregress.sql,
uoledbp2021.sql and uoledbp2125.sql
In case if you want to revert the changes (done by coledbp.sql) we can =
run
doledbp.sql against sysmaster database as user informix.
The cdotnet.sql will get installed as part of IBM Informix .NET Data
Provider.
The .NET driver is being shipped with IBM Informix I-Connect and Client=
SDK
2.81 TC3 or later.
.NET Data Provider will get install only if the computer has Microsoft
Framework SDK version 1.1 installed.
Feel free to use this alias whenever you need any help related to IBM
Informix products.
Regards,
Satyan
Software Engineer
R&D - IBM Information Management Division
11200 Lakeview, Lenexa, KS 66219
Tel: 913 599 8792 (T/L: 337-8792)
=
"Jean Sagi" =
<jeansagi@myrealb =
ox.com> =
To
Sent by: ids@iiug.org =
forum.subscriber@ =
cc
iiug.org =
Subj=
ect
Re: Re: Installing OLE DB suppor=
t
02/16/2005 05:57 in IDS 9.4 [4278] =
PM =
=
=
=
=
=
Ummm...
That $INFORMIXDIR, I tought it was the $INFORMIXDIR engine...
I found these files on my Win KP, where I have installed The I-IC-SDK 2=
.81
TC2
04/04/2003 15:28 28.534 coledbp.sql
17/05/2003 01:26 8.498 cregress.sql
17/05/2003 01:26 10.118 cregressud.sql
04/04/2003 15:28 1.563 doledbp.sql
11/08/1999 00:32 5.295 uoledbp2021.sql
18/01/2000 19:07 3.978 uoledbp2125.sql
But no cdotnet.sql
So I have to run coledbp.sql against sysmaster.
But some questions come to my mind:
- Could I use this script against an Unix IDS?
- What's the purpose cregress.sql (no header) ADO?
- DO I have to run uoledbp2021.sql and uoledbp2125.sql
after I ran coledbp.sql?
- Where do I get cdotnet.sql? (not need it, just to
know.
J.
-----Original Message-----
From: Sathyanesh Krishnan <satyan@us.ibm.com>
To: "Jean Sagi" <jeansagi@myrealbox.com>
Date: Wed, 16 Feb 2005 17:30:34 -0600
Subject: Re: Installing OLE DB support in IDS 9.4 [4276]
Hi
The IBM Informix OLE DB driver has been shipped with Client SDK and
IConnect.
Make sure either of this component has installed on that computer.
The following SQL files will be available at $INFORMIXDIR\\\\etc
coledbp.sql
cdotnet.sql
(In this case $INFORMIXDIR is the directory location where the Client S=
DK
or IConnect installed)
Regards,
Satyan
Software Engineer
R&D - IBM Information Management Division
11200 Lakeview, Lenexa, KS 66219
Tel: 913 599 8792 (T/L: 337-8792)
"Jean Sagi"
<jeansagi@myrealb
ox.com> =
To
Sent by: ids@iiug.org
forum.subscriber@ =
cc
iiug.org
Subj=
ect
Installing OLE DB support in IDS=
02/16/2005 03:38 9.4 [4276]
PM
Hi all,
Following a thread between M.Kovacic & Sunny:
> I tried that but from dbaccess said that the
> table to be created in coledbp.sql was already
> created. I am setting up the Informix for
> Window, so there is no cdotnet.sql , I guess.
I try to find these scripts but I couldn't. I searched the files
coledbp.sql and cdotnet.sql under the $INFORMIXDIR hierarchy for the fi=
les
_coledbp.sql_ and _cdotnet.sql_, but I didn't found them.
I searched on :
I-IDS Ver. 9.40.TC5TL on Windows XP Pro-SP2
I-IDS Ver. 9.40.FC4 on HP-UX B.11.11
But I found anything ole / dotnet related.
In fact I tried this on sysmaster;
select tabid, tabname[1,30]
from systables
where tabid > 99
and (tabname matches '*ole*' or tabname matches '*net*')
order by 1, 2;
0 rows!
So where are these files?.
Do I'm missing something?
Do I need to install something aditional?
Any help would be appreciated
J.
PD: I'm tryin to enable OLE-DB support in IDS in order to add a linked
server in Sql-Server so that IDS tables are available to Sql-Server.
Jean Sagi
jeansagi@myrealbox.com
jeansagi@yahoo.com
Jean Sagi
jeansagi@myrealbox.com
jeansagi@yahoo.com
=
--1__=08BBE538DF9474398f9e8a93df938690918c08BBE538DF947439
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>Hi Jean Sagi,<br>
<br>
IBM Informix server allows the server and client installed at same or d=
ifferent locations.<br>
If server and client installed at the same location the INFORMIXDIR is =
same for both. <br>
<br>
If it is installed at different location, the term "INFORMIXDIR&qu=
ot; needs to be considered based on the contest.<br>
<br>
That is why I mentioned in the previous mail "In this case" w=
hen I refer INFORMIXDIR<br>
"(In this case $INFORMIXDIR is the directory location where the Cl=
ient SDK<br>
or IConnect installed)"<br>
<br>
To get full functionality by using IBM Informix OLE DB provider we shou=
ld execute <br>
coledbp.sql against sysmaster<b> </b>database regardless of the platfor=
m server has installed. <br>
<br>
If you have DBACCESS available on NT box you can still use that utility=
and connect to the server (tha has installed on any platform) and exec=
ute the coledbp.sql <br>
The alternative option is to FTP coledbp.sql to the computer where the =
server has installed and run it by using DBACCESS.<br>
Only user "informix" has the permission to m