The difference between a DATA SOURCE (when using ODBC) and a DATA BASE (when using MS/Access directly) can cause confusion

Date:Archived
Product/Release:Visual LANSA
Abstract:The difference between a DATA SOURCE (when using ODBC) and a DATA BASE (when using MS/Access directly) can cause confusion
Submitted By:LANSA Technical Support
External(s):MS Access and ODBC Drivers

You can set up a DATA BASE in many different Data Base Management systems. For example you can go into the MS/Access product and create a data base called LX_LANSA. You could then go into SQL/Server and create another data base called TEST.

If you want to access either of these databases via an ODBC interface (such as LANSA/X uses) then you must first define the data base(s) to ODBC as a DATA SOURCE(s).

When you define a DATA SOURCE to ODBC you must indicating two essential things :

  1. The actual DATA BASE that is to be accessed.
  2. The ODBC driver that will handle the access.

It is recommended that you try and keep the data source and data base names the same (ie: LX_LANSA) as this makes it simpler.