 |
IDS Forum
Re: Re: Installing OLE DB support in IDS 9.4
Posted By: Sathyanesh Krishnan
Date: Wednesday, 16 February 2005, at 8:38 p.m.
In Response To: Re: Re: Installing OLE DB support in IDS 9.4 (Jean Sagi)
--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 modify the sysmast=
er database, <br>
Make sure you are connecting to sysmaster database as user "infor=
mix".<br>
<br>
We need to run only coledbp.sql to get OLE DB provider work.<br>
OLE DB doesn't use any other SQL file including cregress.sql, uoledbp20=
21.sql and uoledbp2125.sql<br>
In case if you want to revert the changes (done by coledbp.sql) we can =
run doledbp.sql against sysmaster database as user informix.<br>
<br>
The cdotnet.sql will get installed as part of IBM Informix .NET Data Pr=
ovider.<br>
The .NET driver is being shipped with IBM Informix I-Connect and Client=
SDK 2.81 TC3 or later.<br>
.NET Data Provider will get install only if the computer has Microsoft =
Framework SDK version 1.1 installed.<br>
<br>
Feel free to use this alias whenever you need any help related to IBM I=
nformix products. <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__=3D08BBE538DF9474398f9e8a93df938@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=
8DF9474398f9e8a93df938@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 05:57 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__=3D08BBE538DF9474398f9e8a93df938@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__=3D08BBE538DF9474398f9e8a93df938@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__=3D08BBE538DF9474398f9e8a93df938@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__=3D08BBE538DF9474398f9e8a93df938@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__=3D08BBE538DF9474398f9e8a93df938@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__=3D08BBE538DF9474398f9e8a93df938@us.ibm.=
com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">Re: Re: Installing OLE DB support in IDS 9.4 [4278]</=
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__=3D08BBE538DF94=
74398f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=
=3D""></td><td width=3D"336"><img src=3D"cid:30__=3D08BBE538DF9474398f9=
e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><=
/td></tr>
</table>
</td></tr>
</table>
<br>
<tt>Ummm...<br>
</tt><br>
<tt>That $INFORMIXDIR, I tought it was the $INFORMIXDIR engine...<br>
</tt><br>
<tt>I found these files on my Win KP, where I have installed The I-IC-S=
DK 2.81 TC2<br>
</tt><br>
<tt>04/04/2003 15:28 28.=
534 coledbp.sql<br>
17/05/2003 01:26 8.498 =
cregress.sql<br>
17/05/2003 01:26 10.118 =
cregressud.sql<br>
04/04/2003 15:28 1.563 =
doledbp.sql<br>
11/08/1999 00:32 5.295 =
uoledbp2021.sql<br>
18/01/2000 19:07 3.978 =
uoledbp2125.sql<br>
</tt><br>
<tt>But no cdotnet.sql<br>
</tt><br>
<tt>So I have to run coledbp.sql against sysmaster.<br>
</tt><br>
<tt>But some questions come to my mind:<br>
</tt><br>
<tt>- Could I use this script against an Unix IDS?<br>
- What's the purpose cregress.sql (no header) ADO?<br>
- DO I have to run uoledbp2021.sql and uoledbp2125.sql</tt><br>
<tt>after I ran coledbp.sql?<br>
- Where do I get cdotnet.sql? (not need it, just to</tt>
<ul><tt>know.<br>
</tt></ul>
<tt>J.<br>
</tt><br>
<br>
<tt>-----Original Message-----<br>
From: Sathyanesh Krishnan <satyan@us.ibm.com><br>
To: "Jean Sagi" <jeansagi@myrealbox.com><br>
Date: Wed, 16 Feb 2005 17:30:34 -0600<br>
Subject: Re: Installing OLE DB support in IDS 9.4 [4276]<br>
</tt><br>
<br>
<br>
<br>
<br>
<br>
<tt>Hi<br>
</tt><br>
<tt>The IBM Informix OLE DB driver has been shipped with Client SDK and=
<br>
IConnect.<br>
Make sure either of this component has installed on that computer.<br>
</tt><br>
<tt>The following SQL files will be available at $INFORMIXDIR\etc<br>
coledbp.sql<br>
cdotnet.sql<br>
</tt><br>
<tt>(In this case $INFORMIXDIR is the directory location where the Clie=
nt SDK<br>
or IConnect installed)<br>
</tt><br>
<tt>Regards,<br>
Satyan<br>
</tt><br>
<tt>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>
</tt><br>
<br>
<br>
<ul>
<ul>
<ul>
<ul><tt>"Jean Sagi"<br>
<jeansagi@myrealb<br>
ox.com> &nbs=
p;  =
; To<br>
Sent by: =
ids@iiug.org<br>
forum.subscriber@ &nbs=
p;  =
; cc<br>
iiug.org</tt>
<ul>
<ul>
<ul>
<ul>
<ul>
<ul>
<ul>
<ul>
<ul><tt>Subject<br>
Installing OLE DB support in IDS</tt></ul>
</ul>
</ul>
</ul>
</ul>
</ul>
</ul>
</ul>
</ul>
<tt>02/16/2005 03:38 9.4 [4276]<br>
PM</tt><br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
</ul>
</ul>
</ul>
</ul>
<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<br=
>
coledbp.sql and cdotnet.sql under the $INFORMIXDIR hierarchy for the fi=
les<br>
_coledbp.sql_ and _cdotnet.sql_, but I didn't found them.<br>
</tt><br>
<tt>I searched on :<br>
I-IDS Ver. 9.40.TC5TL on Windows XP Pro-SP2<br>
I-IDS Ver. 9.40.FC4 on HP-UX B.11.11<br>
</tt><br>
<tt>But I found anything ole / dotnet related.<br>
</tt><br>
<tt>In fact I tried this on sysmaster;<br>
</tt><br>
<tt>select tabid, tabname[1,30]<br>
from systables<br>
where tabid > 99<br>
and (tabname matches '*ole*' or tabname matches '*net*')<=
br>
order by 1, 2<br>
;<br>
</tt><br>
<tt>0 rows!<br>
</tt><br>
<tt>So where are these files?.<br>
</tt><br>
<tt>Do I'm missing something?<br>
Do I need to install something aditional?<br>
</tt><br>
<br>
<tt>Any help would be appreciated<br>
</tt><br>
<tt>J.<br>
</tt><br>
<tt>PD: I'm tryin to enable OLE-DB support in IDS in order to add a lin=
ked<br>
server in Sql-Server so that IDS tables are available to Sql-Server.<br=
>
</tt><br>
<tt>Jean Sagi<br>
jeansagi@myrealbox.com<br>
jeansagi@yahoo.com<br>
</tt><br>
<br>
<br>
<tt>Jean Sagi<br>
jeansagi@myrealbox.com<br>
jeansagi@yahoo.com<br>
</tt><br>
<br>
</body></html>=
--1__=08BBE538DF9474398f9e8a93df938690918c08BBE538DF947439--
--0__=08BBE538DF9474398f9e8a93df938690918c08BBE538DF947439
Content-type: image/gif;
name="graycol.gif"
Content-Disposition: inline; filename="graycol.gif"
Content-ID: <10__=08BBE538DF9474398f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64
R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu
ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7
--0__=08BBE538DF9474398f9e8a93df938690918c08BBE538DF947439
Content-type: image/gif;
name="pic20813.gif"
Content-Disposition: inline; filename="pic20813.gif"
Content-ID: <20__=08BBE538DF9474398f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64
R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA
AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh
EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZeZgLVA9YVCpnGagVjV171aRVrYR
RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFilKQdI8GA5IcpApeJQt8L09lmgkH
LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3d5VyKtCKW3jfz4uMKmq3xu4N0nK
BVoJQmx2LGVOmrqNjjJf2hHAQo/eDwJGTKhQMcgQEEAnEjFS98+RnW3smGkZU6ncCWav/4wYOnAI
TihRL/4FEwbp28BXMMcoscQCVxlepL4IGDSCyJyVQOu0o7CjmLN50OZlqWmyFy5/6yBBuji0AxFR
M00oQAqNIstqI6qKHUsWRAEAvagsmfUEAImyxgbmUpJk3IklNUtJOUAVLoUr1+wqDGTE4zk+T6FG
uQb3SizBCwatiiUgCBN8vrz+zFjVyQ8FWkOlg4NQiZMB5QS8QO3mpOaKnL0Z2EKvNMSILEThKhCg
zMKPVxYJh23qm9KNW7pArPynMqZDiErsTMqI+LRi3QAgkFUbXpuFKhSYZALd0O5RKa2z9EYKBbpb
qxIKsjUPRgD7I2XYV6wyrOw92ykExP8NW4URhknC5dKGE4v4NENQj2jXjmfNgOZDaXb5glRmXQ33
YEWQYNcZFnrYcIQLNzyTFDQNkXIff0ExVlY4srziQk43inZgL4rwxxINMvpFFAz1KOODHiu+4aEw
NEjFl5B3JIKWKF3k6I9bfUGp5ZZcdunll5IA4cuHvQQJ5gcsoCWOOUwgltIwAKRxJgbIkJAQZEq0
2YliZnpZZ4BH3CnYOXldOUOfQoYDqF1LFHbXCrO8xmRsfoXDXJ6ChjCAH3QlhJcT6VWE6FCkfCco
CgrMFsROrIEX3o2whVjWDjoJccN3LdggSGXLCdLEgHr1lyU3O3QxhgohNKXJCWv8JQr/PDdaqd6w
2rj1inLiGeiCJoDspAoQlYE6QWLSECehcWIYxIQES6zhbn1iImTHEQyqJ4eIxJJoUBc+3CbBuwZE
V5cJPPkIjFDdeEabQbd6WgICTxiiz0f5dBKquXF6k4senwEhYGnKEFJeGrxUZy8dB8gmAXI/sPvH
ESfCwVt5hTgYiqQqtdRNHQIU1PJ33ZqmzgE90OwLaoJcnMop1WiMmgkPHQRIrwgFuNV90A3doNKT
mrKIN07AnGcI9BQjhCBN4RfA1qIZnMqorJCogKfGQnxSCDilTVIA0yl5ciTovgLuBDKFUDE9aQcw
9SA+rjSNf9/M1gxrj6VwDTS0IUSElMzBfsj0NFXR2kwsV1A5IF1grLgLL/r1R40BZEnuBWgmQEyb
jqRwSAt6bqMCOFkvKFN2GPPkUzIm/SCF8z8pVzpbjVnMsy0vOr1hw3SaSRUhpY09v0z0J1FnwzPl
fmh+xl4WtR0zGu24I4KbMQm3lnVu2oNWxI9W/lcyzA+mCKF4DBikxb/+UWtOGRiFP8qEwAayIgIA
Ow==
--0__=08BBE538DF9474398f9e8a93df938690918c08BBE538DF947439
Content-type: image/gif;
name="ecblank.gif"
Content-Disposition: inline; filename="ecblank.gif"
Content-ID: <30__=08BBE538DF9474398f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64
R0lGODlhEAABAIAAAAAAAP///yH5BAEAAAEALAAAAAAQAAEAAAIEjI8ZBQA7
--0__=08BBE538DF9474398f9e8a93df938690918c08BBE538DF947439--
Messages In This Thread
IDS Forum is maintained by Administrator with WebBBS 5.12.
|
|
