Re: Quick primer on Unidata-to-SQL Server Connectivity?

On May 27, 2:14 pm, "Ed Sheehan" <NOedsS...@xxxxxxxxxxxx> wrote:
I've since learned that the big bottleneck is with running certain SQL
selection criteria in view created by VSG. Running the same sort natively is
fast, but creating a view and then running an SQL query with more than one
where clause is death on wheels.

I have dated, but somewhat extensive experience with UniData SQL. I
ended up recommending the ASG Safari ODBC drivers
http://www.asg.com/products/product_details.asp?code=SOD unless or
until some things improved in UniData ODBC. This provided better
performance (still not as good as mvbasic or uniquery, but typically
very reasonable) as well as better features for handling Many-to-Many
relationships, for example. It is still non-trivial to deploy, as is
pretty much anything in this area, but might be worth looking into.
There are several Datatel customers using it. I also know that
Datatel was working with UniData to make their ODBC offering more
acceptable, so you might also check with IBM on what their most recent
advances are in that area.

Their main goal is to allow outside access (so as not to use up many more
licenses), but still be able to sort/select the data quickly.

ODBC against UniData is, well, rather painful lto the average pickie
(fixed length fields, 3-valued logic, joins and such), but it is
possible. Tony's mv.net approach might be more fun to implement and
work with for the long haul, however, so I am not suggesting that you
push forward with an ODBC solution if you can find a more natural MV
approach you like. Best wishes and let us know what you decide and
just how fun it was, K? smiles --dawn

What kind of pricing would I be looking at for middle tier products? Would
using mv.net require the continuing use of a programmer for additionbal
"views" or is there an interface available for setting up new queries? Or is
it just a metter of creating the front end program, then letting the users
pick all the criteria to push out?

Thanks,

Ed
"Tony Gravagno" <address.is.in.po...@xxxxxxxxxxxxxxxxxxxxxx> wrote in
messagenews:7uoe34l51r9990fn3l1qcpt7sng2a34d35@xxxxxxxxxx



Personally I have a problem with VSG, BCI, OpenDB, OracleGateway, and
any other product that attempts to map a relational environment from
MV.  It's completely unnecessary.  There are millions of people using
relational databases using text-based queries and standard tools and
protocols and MV people feel compelled to using proprietary tools from
MV providers simply because they're there?  Nope, not me.  If nothing
else, create your SQL CRUD queries as text strings, send them to a
middle tier to do the actual query, then return resultsets in a
neutral format.

As usual, my tool of choice is mv.NET.  Cross-platform, cross-vendor,
stable, well supported, and independent of DBMS-vendor patch release
schedules.

<ad>Oh yeah, and we sell it and use it for development here.</ad>

Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
Nebula R&D sells mv.NET worldwide,
and provides related development and training services

"Ed Sheehan" wrote:

I received a question about (re)establishing connectivity between MS SQL
Server and Unidata. Also, something called VSG views (they need to set up
more of them).

Does this ring any bells here? I'll be doing some groundwork to get them
up
and working again. Seems they lost connectivity (I'm assuming file
transfers
etc).

If I could be directed to some lit about connecting these two beasts, I'd
be
much apprecitaive. Then I can ask some probing questions like, "Did
someone
cut the wire?"

Thanks,

Ed- Hide quoted text -

- Show quoted text -

.

Relevant Pages

  • Re: Sybase Source. What "data flow source" to use?
    ... "Allan Mitchell" wrote: ... when I right-click over a SQL 2005 database and select Import ... datasources defined in ODBC Datasources on my computer, ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL using C
    ... I am almost a new C programmer and now I need to use SQL within my C ... The people who are telling you to use a C API are out of their mind. ... is not less complicated than ODBC and ties the user to a single ...
    (comp.lang.c)
  • Re: Quick primer on Unidata-to-SQL Server Connectivity?
    ... Since they're already using ODBC to connect VSG to Unidata, ... the fun factor is exhausted with that solution. ... but somewhat extensive experience with UniData SQL. ...
    (comp.databases.pick)
  • Re: Sybase Source. What "data flow source" to use?
    ... when I right-click over a SQL 2005 ... database and select Import Data, the list of providers does not include ... either A) the list of datasources defined in ODBC Datasources on my computer, ... I've been so excited about SSIS and telling my co-workers how ...
    (microsoft.public.sqlserver.dts)
  • Re: Access SQL DAYOFWEEK() problem
    ... not a SQL function ... "Duane Hookom" wrote: ... >> Could anyone tell me what is the correct syntax for the scalar functions? ... >> ODBC Scalar Functions ...
    (microsoft.public.access.modulesdaovba)