Gagan Bhatia Gagan Bhatia - 10 months ago 75
C# Question

SQL Connection string for Retail Pro Application Database

I am trying to make a program using c# in .net for some custom data report.

I need to do this based on a Retail Pro 8 POS Application and look forward for suggestions / help in understanding how to get the database connection.

A hint given to me was that the application uses oracle database which may not be correct.

I had not worked earlier with oracle database and I'm only familiar with MySQL and MSSQL and what makes me to doubt that the application runs on oracle database is i could easily take the dump from the client machine and run it on my machine without installing any oracle files.

So guess it may be using some kind of portable database I am unable to figure-out the database files..

some of the probable file extensions are
*.DIA, *.DAT, *.IX

As per me Retail Pro is built on Delhi.

Any suggestions on how to access database from within my .net program would be really helpful

Update :
The version i am trying to work is Retail Pro 8 and this version uses B-Tree File data though now the newer version works on Oracle Database.

I was able to get Retail Pro API which has documentation on plugin creation using Delphi 5.

Now i have some clues but still don't prefer to venture out into a new prog lang just for pulling out some data from the data files.

Would appreciate if some one shows some more insight how to open these files using c#.

Thanks !

Answer Source

Retail Pro V8 Comes with a rda2.dll file which can read the database and its a com dll and this can be used in vb6 but there is some issue while using the same in .net as per some documents i referred to since this was built using Delphi5.

Retail Pro also provides api which means additional two files (RPRO_API.dpk and RproAPI.pas) but these files are not provided along with the product and i myself dont have access to them. Would appreciate if some one can share this so that i can try to learn this more.