INFX to M$ SQL migration - perform functionality ?
rob_hardman
Hello experts,
An unfortunate client has decided to ditch the legacy Unix platform in
favour
of M$ SQL 2000 server and requested the Informix database be replicated
there for access to historical data... I am relatively new to M$ SQL server
but have successfully migrated the database from Informix SE to M$ SQL
server
using DTS import via ODBC.
Now I have the database in M$ SQL I need to produce a query form on a
particular table, which can be accessed by many Win9x users in the local
network to view the historical data. This is an "urgent" requirement.
On the Unix platform, I could produce and deploy this query form in a matter
of minutes, using the 'generate form' option in Informix SQL. This would
create a form containing all the fields in the table by default which could
then be quickly edited to re-arrange the layout or remove unwanted fields,
etc.
The resultant form allowing a query to be performed on all the rows, being
filtered if required, by simply placing matching strings in any the
displayed
form fields. How can I achieve the same result within M$ SQL server ?
It is not obvious to me how to go about this and further how to make it
available to all the Win9x clients in the local network. The M$ SQL docs
don't mention interactive query forms anywhere that I can find.
Any advice or help would be greatly appreciated.
Btw: I did my best to talk them out of the move, but there were adamant from
a Board decision to "standardise" on M$ as company policy. Only consolation
is the M$ server has crashed 11 times already in as many weeks whereas the
Unix system is still online, as it has been consistently, 24/7 for the last
6
years...maybe they will return once their business has suffered enough
outage.
Many thanks in advance,
Rob Hardman
hype
MS-ACCESS, then
generate the form based on the table.
Use a Data Form in MS-WORD 2000.
MS-ACCESS can also generate webp ages which are rendered in a browser.
You get a browser based form generated automatically.
Post in the appropriate newsgroups, you might get relevant answers and
save yourself the ranting about MS-SQL server.
HTH,
Hype.
"rob_hardman" <rob_h...@hotmail.com> wrote in message news:<a7uhfs$6bs$1...@news.xmission.com>...