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 |
Description:
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.
