Re: Re: How to set variables in DTS
Never tryed Access.
But look for recent threads related to Access.
In order to use the linked server feature in Sqwl_server you need to enable oledb support in informix. If don't like Oledb, the you could try ODBC.
After that create a linked server in Sql-Server (Tryed: 97/2000) using a data source that points to informix (IDS:9.3, 9.4 HP-UX ; IDS 9.3, 9.4, 10 Windows).
Finally use openquery in sqlserver to use informix tables in Sql_server.
See related threads, specially intructions from Savio Pinto.
J.
-----Original Message-----
From: "Jeroen Wallenburg" <jeroen@wallenburg.demon.nl>
To: "Jean Sagi" <jeansagi@myrealbox.com>
Date: Mon, 1 Aug 2005 21:15:05 +0200
Subject: Re: How to set variables in DTS
mmmmm i never thought of that one. I guess i can try to set one up.. Does it
work the same as linked tables within MSAccess?
----- Original Message -----
From: "Jean Sagi" <jeansagi@myrealbox.com>
To: <jeroen@wallenburg.demon.nl>
Cc: <informix-list@iiug.org>
Sent: Monday, August 01, 2005 5:23 PM
Subject: Re: How to set variables in DTS
Ummm... I don't understand well.
Informix -> SQL-Server (Oracle?)
If you need to insert data in a Sql-Server table from an Informix one, then
you can use the linked server feature of Sql-Server.
J.
-----Original Message-----
From: jeroen@wallenburg.demon.nl
To: informix-list@iiug.org
Date: 1 Aug 2005 06:36:06 -0700
Subject: How to set variables in DTS
I have an informix database from which i need to fill a table in SQL
every half hour. Within SQL I have the following code where hsplit the
local SQL table is:
declare @mytime as datetime
declare @hourtime as varchar(2)
declare @minutetime as varchar(2)
declare @variable as int
set @mytime = dateadd(mi, -30, getdate())
set @hourtime = datepart (hh,@mytime)
set @minutetime = datepart(mi, @mytime)
set @variable = @hourtime + case
when (@minutetime / 30 < 1)
then '00'
else '30'
end
select * from hsplit
where starttime =@variable
When i use the ODBC connection via Openlink to the Oracle dbase i get
syntax errors.....can anyone help me to resolve this?
Jean Sagi
jeansagi@myrealbox.com
jeansagi@gmail.com
Jean Sagi
jeansagi@myrealbox.com
jeansagi@gmail.com
sending to informix-list
i have tried ODBC but no success. in the end i could see the tables, but when trying openquery i got schema errors etc. I guess this is caused by being able to use only Openlink 3.2 for ODBC connectivity to Informaix 7.0. As loading the comlete table takes about 9 minutes i could decide just to refresh the whole table every hour, not a very nice solution.