Hi Ernie, If you haven’t already, I would start by using Microsoft SQL Server Management Studio (SSMS) to access whatever details you can of the database. There may be documentation or ERD diagrams available there. SQ Query Analyzer, part of SSMS, is a great tool for writing queries. Get your queries to work there, then it’s much easier to write them in 4D. Also, there may be stored procedures exposed for your use.
To connect you would set up an ODBC data source on your machine to connect to the SQL Server then use the 4D SQL commands connect to it. If you’re using 4D 64bit client, use the 64 bit version of ODBC Data Source administrator app (it's in Windows Settings) otherwise use 32bit version. The 4D documentation is pretty good on the whole ODBC and the SQL LOGIN command. Let me know if you have further questions as you proceed. HTH, Tom Benedict > On Jul 1, 2019, at 13:31, ernest hilgers via 4D_Tech <[email protected]> > wrote: > > Hi All, > > using 4D v17.2 pc. > I need to have some basic knowledge on accessing a database used in the > supermarket business called: LOC Store Management Suit. > It’s running on MS server 2008 and MS sql. the program that is using it : > storeman; SMS Pro V340. > Only need to ‘read’ from the datafile which I found on the disk and is called > : SMSDB.dat > > I have a discription of the tables (files) used including the field.names > (the most weird naming system). > > Pointers how to access this data would be very welcome if anyone has any > experience with this datafile. > > greetings > > ernie hilgers (aruba) > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
