We have a large RD D3 database we are offloading to TXT files every
night and recreating a SQL-SERVER DB using a simple DTS job.

We want to update SQL-SERVER rows now interactively, we have no locking
problem as we are the only application UPDATING SQL-SERVER

We have prepared by converting all of the writes in the D3 to go
through one UPDATE.SUB subroutine.

Any ideas on a simple solution using IIS standard toolset?

Thanks,

Nick Quinn
Pickie 20+, Winblows 0 :-)

Contact RD and get a copy of OSFI. Then you can update the SQL Server file
directly from Pick/Pick Basic.

Mark Brown

<nquinn (AT) totalgroup (DOT) bm> wrote

"Mark Brown" wrote:
I think Mark meant OpenDB which uses OSFI:
http://rainingdata.com/products/conn...ndb/index.html

Nick, good to see you again. I thought you were retiring.

The answer sort of depends on your topology. We don't have all of the
info required to make full suggestions.

Why can't you use the code you have, write data to a tickler file,
update the SQL Server, then return control to D3? This can be done in
a manner that doesn't lock up D3 if the process fails. If D3 and SQL
Server are on different boxes you can use mapped Windows paths or
Samba to write directly to the remote file system.

We've also discussed .NET before. This is another good application
for it. Code can be written to extract data from D3 and pipe it into
SQL Server - even go the other way. I'm doing a little project to do
this with Oracle now. Depending on where the DBMS is and where the
SQL Server is you may not need any third-party connectivity
components. I'd prefer this option to a for-fee RD-only solution
which requires coding SQL into D3. Your Subject says "XML", which
wouldn't fit with OpenDB. I'd also much rather use the tools
available in .NET to create and manipulate XML documents for use with
a relational database, compared to doing the same in BASIC. If you're
wondering about "adding" a Windows component, OpenDB via OSFI uses
Windows ODBC drivers too, and since you're using SQL Server we know
you have a Windows box there somewhere.

Feel free to e-mail, as always.
Regards,
Tony
TG@ removethisNebula-RnD.com

Hi Tony,

Yeah, retire... I thought so too. But I am back in it. Built a great
business and have had great difficulty hiring a replacement :-)

Anyway, got bored, three years of golf and boats (R/C Sail), Now I am
researching Reality 12 and PROIV from a real company.

We'll probably do .NET as I have a team of 4 in NY, and a superb guy in
Bermuda. I have a DTS job which runs every 5 minutes picking up deletes
and insertions now. SQL Server is an UN NORMALIZED reporting database
for our D3 app, is all.

Nice hearing from you, RD Dead yet? From some of the other threads I
think so.

Best,

Nick

G'day Nick!

FYI we will be soon releasing a version of Visage for Reality, which
may be a better/easier alternative that .NOT (err, I mean .NET)
solution .... depending on WHATyou are getting out the SQL Server,
other parts of the Visage product suite (BIT for data
warehouse/business intelligence, Reporter for "nice" reports & forms)
may fill the void for you,

Regards

Ross Ferris
Stamina Software
Visage > Better by Design!


NickQ wrote:

"NickQ" wrote:
As usual, you know I'm here if you'd like to discuss your .NET
projects, integration between your apps and anything in the outside
world, etc. I plan to start working with Reality within the next
couple months as well, since mv.NET and DesignBais support for that
platform have been announced.

About RD, due to popular demand from this forum, I'm no longer
commenting on their processes, positioning, or business standing.
I'll leave this to RD and their VAR channel. I have no problem
discussing D3 itself.

My best,
T