The difference between a DATA SOURCE (when using ODBC) and a DATA BASE (when using MS/Access directly) can cause confusion
|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 :
- The actual DATA BASE that is to be accessed.
- 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.