odb database path

Martin Obongita martin.obongita at yahoo.com
Mon Aug 8 22:45:19 UTC 2022


 Hi JIM,
I have the line below at STARTUP:
Open data file {odb://127.0.0.1:5913:PAYROLL,PAYROLL}

The IF statement after this line returns a false flag.Have you tried this IF In your app right after the odb command?What flag do you get?
I am running Omnis 73 v8.7ODB version 1.78 (service is running...)Win 10, 64
Martin O.



    On Tuesday, August 9, 2022 at 01:33:12 AM GMT+3, Jim Edison <jime at ediconcepts.net> wrote:  
 
 Hi Martin,

There is an excellent pdf with the ODB.pdf that has much more of this info.
Here are a couple of quick thoughts.

You don't need to include the IP or server name in the config file, that is
needed in the connection string.  If the location of the DF1 on the server
is in C:\Apps\OmnisDF\MyDataFile.df1 that is what is in the config file even
if my WS sees the location as r:\OmnisDF\MyDataFile.df1.

Now assuming the ODB is running (recommend installing as a service) based on
the server IP address and assuming the port as specified in config.xml being
5913, your connection string would be;  (odb://IP-address:port:name,internal
name')  IP-Address is the machine on which the odbridge.exe is running.
Server ip 192.168.25.1 so connection string would be
odb://192.168.25.1:5913:MyDataFile,MyDataFile using the Open Data File
command
Server ip 127.0.0.1 so connection string would be
odb://127.0.0.1:5913:MyDataFile,MyDataFile (only appropriate when all are
connecting to a remote server so they are all basically on the same
computer)

You can also test using the SQL browser but you drop the "Name" and just use
'IP-address:port,internal-name' or in the case above
odb://192.168.25.1:5913:MyDataFile

Hope that helps, have fun.

Best Regards,
Jim Edison CPCU

EDI Concepts Inc. - InStar Support and Programming 

-----Original Message-----
From: omnisdev-en <omnisdev-en-bounces at lists.omnis-dev.com> On Behalf Of
Martin Obongita via omnisdev-en
Sent: Friday, August 5, 2022 12:32 PM
To: omnisdev-en at lists.omnis-dev.com
Cc: Martin Obongita <martin.obongita at yahoo.com>
Subject: odb database path

Hi ALL,
I have installed the Omnis Data Bridge in the server.
How do I setup the path to Omnis database in the config xml file for a
remote server to enable concurrent access from client?
The datafile is created in the server in a folder
"D:\PAYROLL\PAYDATA\PAYDATA.DF1"
I'm looking at IP, drive and a folder. eg:
 <string>127.0.0.1/D/PAYROLL/PAYDATA/PAYDATA.DF1</string>

or should it be  <string>127.0.0.1/D:/PAYROLL/PAYDATA/PAYDATA.DF1</string>

or should it be <string>127.0.0.1:D/PAYROLL/PAYDATA/PAYDATA.DF1</string>

My problem is where/how to insert the colon in the string.
RgdsMartin.

_____________________________________________________________
Manage your list subscriptions at https://lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 

  


More information about the omnisdev-en mailing list