Windows 2008 server and datafiles

[Mike Matthews]

Hello Jock,

Very easy if you take the path of least resistance.

Install the ODB software, choosing the right version for the clients.
By default, the ODB will run with a test set of data in the ODB folder, so I renamed my DF1 to match and put it in the same location until I got brave.
I kept the default TCP port, 5913
I do allow any sharing of the datafile with traditional methods as this will mess with the integrity of the DF.
I connect to the datafile using the 4GL command as usual with this syntax:

Open data file {odb://192.168.2.100:5913:SQLWORKSDATA}

If you want to query the open datafiles that are being served by the ODB, use this command:
Prompt for data file {odb://192.168.2.100:5913:SQLWORKSDATA}
You will get a prompted window with the open DF files.

One wee point, if you have multiple segments, then each segment must be added to the XML setup file.

Quite easy and used mainly on a Mac workstation, server OS not required, be brave.

Mike



Mike Matthews
Managing Director 
Lineal Software Solutions Ltd

Past Authorised Apple Reseller,  Omnis Business Partner

Tel: 01271 850 550 

Email: mike.matthews at lineal.co.uk

Web: www.lineal.co.uk


On 1 Dec 2010, at 23:21, Jock Philip wrote:

> I've never looked at odb. What's involved in setting that up?
> Thanks
> Jock
> 
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~
> Jock Philip       [jock at visionchips.com]
> Vision Chips, Inc.
> 888.517.7779 x 3563
> http://www.visionchips.com/
> 
> Developers of OBserver OB/GYN Ultrasound Reporting and Image Archiving
> System
> 
> 
>> -----Original Message-----
>> From: omnisdev-en-bounces at lists.omnis-dev.com [mailto:omnisdev-en-
>> bounces at lists.omnis-dev.com] On Behalf Of Jan Leijenhorst
>> Sent: Wednesday, December 01, 2010 2:59 PM
>> To: OmnisDev List - English
>> Subject: Re: Windows 2008 server and datafiles
>> 
>> consider OmnisDataBridge
>> 
>> regards
>> Jan
>> 
>> ----- Original Message -----
>> From: "Derek Delpero" <derek.delpero at gmail.com>
>> To: <omnisdev-en at lists.omnis-dev.com>
>> Sent: Wednesday, December 01, 2010 10:52 PM
>> Subject: Windows 2008 server and datafiles
>> 
>> 
>>> Hi,
>>> 
>>> We have some sites that recently upgrade their servers to Windows
>>> 2008. The app is Omnis7 with a multi-user data file. They've been
>>> running pretty solid for years, and since the upgrade they've been
>>> having a lot of data corruption issues with indexes and duplicated
>>> rsns.
>>> 
>>> We looked at disabling opportunistic locking but according to this
>>> Microsoft kb article (http://support.microsoft.com/kb/296264), it's
>>> not possible to disable opportunistic locking in Windows 2008.
>>> 
>>> Does anyone know if disabling SMB2 is the only option? Any
>>> disadvantages of disabling SMB2?
>>> 
>>> Thanks,
>>> 
>>> Derek
>>> _____________________________________________________________
>>> Manage your list subscriptions at http://lists.omnis-dev.com
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
> 
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com