Bob,
Yes, we're doing it (went live to Production last week, actually, but
it's been in Test for 3 months)
We're running UV10.0.15 on Windows 2003 Server - you don't mention your
UV host platform.
For a Windows host, you don't need any 'extra' software, you just use
the MS SQL Server driver.
The documentation on BCI is not the best and the 'SQLBCIDEMO' example
programming awful.
Ray Wurlod pointed me (via this list) to the CONNECT program [source
code also in the BP of the UV account] which is much, much better. It's
perhaps instructive that when IBM (well, Ardent, actually) needed to
write a useful, working, program, they used [almost] none of the code
from the 'demo' program they provide and use as examples in the manual
:-(
There are some more, well-written, examples for you that might help,
available from the U2 Knowledge Base. They were written by Paul Chang,
who is IBM's BCI expert in Denver. Here are the U2 Knowledge Base
article numbers:
Q00178, Q00179, Q00180, Q00182, Q00183, Q00184, Q00185, Q00186 &
Q00187
Hope this helps
Mike
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney
Sent: Thursday, 7 October 2004 02:53
To: [EMAIL PROTECTED]
Subject: [U2] ODBC from Universe to Microsoft SQLServer Databases
Hi:
I have been investigating the possiblility (using the BASIC SQLInterface
functions) of accessing a Micosoft SQLServer database from U2.
All the procedures I need are covered by the BASIC SQLFunctions, and the
Admin setup seems fairly straightforward, so on the face of it things
look good.
But............
I know it can be done under Unidata 5.2 (because I read that PDF as
well) but I am on Universe 10 and there is nothing in the documentation
about it, only drivers for Oracle, Sybase and Informix,none of which we
use.
The downloaded Universe PDF from the IBM site is dated 2002 so it may be
out of date.
So the question(s) is/are has anyone actually done this, does anyone
know if the relevant driver ships with Universe 10.2 or have IBM put it
into Unidata but not Universe (surely not) ?
Assistance appreciated
Bob
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or
distribute this message or the information in it.
If you have received this message in error, please Email or telephone
the sender immediately.
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
