Question Re: Access from xMII to Dbase(dbf) file in Product Lifecycle Management Q&A

Access from xMII to Dbase(dbf) file

Former Member — Thu, 18 Jan 2007 10:13:17 GMT

Hi, EveryOne,

I have a client which stores history data in .dbf file and all of them's file name is more then 10 symbols length.

Does somebody know how to get access to dbf?

Great thnks and best regards,

Serj

Re: Access from xMII to Dbase(dbf) file

Former Member — Thu, 18 Jan 2007 11:02:58 GMT

Hi Sergey,

What kind of history data they are storing and what kind of database files they are...

Thanks,

Rajesh

Re: Access from xMII to Dbase(dbf) file

Former Member — Thu, 18 Jan 2007 13:41:22 GMT

Hi, Rajesh

1. flowing water

2. water pressure

3. water level

4. others

Serj

Re: Access from xMII to Dbase(dbf) file

Former Member — Thu, 18 Jan 2007 13:42:21 GMT

It is general dbf files

Re: Access from xMII to Dbase(dbf) file

Former Member — Thu, 18 Jan 2007 16:30:25 GMT

Get an ODBC driver for dBase (google it). Then use the xMII ODBC_Database data server. If there is an available JDBC driver then use that one.

Re: Access from xMII to Dbase(dbf) file

Former Member — Thu, 18 Jan 2007 17:38:27 GMT

If you have a DBF file containing a local database table, you first create an ODBC data source in Windows Services:

- Go to (windows) start -> control panel -> administrative tools -> data sources (ODBC)

- Go to tab “system DSN” -> click on “add” -> click on “Microsoft dBase Driver”

- Click on “finish”

- choose “select” in database area

- navigate to the file directory: C:\path-to-dbf\dbf-file-with-more-than-10-chars-in-name.dbf

- choose the database by clicking on it

- and click “ok”

- define the name “FOODBF” for the datasource and confirm by clicking on “ok”

- confirm the datasource creation by once again clicking on “ok”

As a second step, create the ODBC server connection in xMII:

- logon to xMII -> go to “data services” -> “data servers”

- choose “default ODBC database”

- copy this database

- rename it to “FOODBF”

- rename the database description as you like

- rename the server URL to jdbc:odbc:FOODBF

- click on “save” -> click on “status” to see if the database is running

Hope it's clear enough. You can play with FOODBF name if you like.

Cheers.

Re: Access from xMII to Dbase(dbf) file

Former Member — Thu, 18 Jan 2007 20:53:14 GMT

Hi, Sergey.

Actually, you want to use the OLEDB UDS connector and an OLEDB driver for DBF files. This will be your optimal performance, lowest cost, and most reliable solution.

You must be very careful, however, that your OLEDB driver does not lock the DBF files if they are simultaneously being written do by the data storage application.

Generally, apps that would use a DBF format were not well designed for multiuser access.

Best regards,

Rick Bullotta

Re: Access from xMII to Dbase(dbf) file

Former Member — Fri, 19 Jan 2007 08:48:29 GMT

Paul, Hi

Your suggestion works great with files which have a length of 8 simbols or less but not more. it is WinCC 5.1.

I think we have a great difference in time. I will try to find workaround with longname.

Serj

Re: Access from xMII to Dbase(dbf) file

Former Member — Fri, 19 Jan 2007 10:33:54 GMT

Not working. and it's impossible to cut filenames. -(

Re: Access from xMII to Dbase(dbf) file

abesh — Fri, 19 Jan 2007 11:38:07 GMT

The best way as Rick mentions is to use the OLEDB UDS.

Download the same from SAP Service Marketplace or click on this link :

<a href="https://smpdl.sap-ag.de/~swdc/012002523100006378582006D/XMIIOLEDBUDS_3-20001994.zip?_ACTION=DL_DIRECT">XMIIOLEDBUDS</a> and try to configure it.

In case you face any problems, post here, and i'll be glad to help

Re: Access from xMII to Dbase(dbf) file

Former Member — Fri, 19 Jan 2007 12:09:14 GMT

Abesh, HI

I want to be wrong but it does not matter OLEDB UDS or just as Paul said in both cases you will see the error:

Error found. OLEDB Error Record #(0x1): [source = Microsoft OLE DB Provider for ODBC Drivers] [error = [Microsoft][ODBC dBase Driver] <b>The Microsoft Jet database engine could not find the object 't_zagotovka'.</b> Make sure the object exists and that you spell its name and the path name correctly.]. Error was spawned by -- File:.\Query.cpp Line:89 Function:COleDbQuery::ExecuteOleDbMode.

But if you cut the file name there is no mistake.

Serj

Re: Access from xMII to Dbase(dbf) file

Former Member — Fri, 19 Jan 2007 12:40:06 GMT

Hi, Everybody,

Everything is working. For history I did:

1. Find Microsoft FoxPro VFP Driver for DBF. Install it

2. It is impossible to configure this driver through ODBC config but it can be done by ..

3. Create OLEDB UDS. Make the connecting string "DRIVER=Microsoft FoxPro VFP Driver (*.dbf); Exclusive=No;SourceType=DBF;SourceDB="+ Path to the directory of file"

4. After it put any configuration data you would like, remember after pressing the button “Finish” you can not change at all anything because of error

Great thnks to everyone,

Serj