LE9 OLEDB Database link to MS SQL server
LE9 OLEDB Database link to MS SQL server
Has anyone managed to create an OLEDB Database Link on LE9 to MS SQL server?
When trying to create a link on a new application, it either does nothing when selecting 'Add' or crashes.
On an application migrated from DE8.5 the original Database links are visible and the MSSQL tables can be opened.
Database links dialogue Refresh results in a crash - no error message
There also does not appear to be a specific catalogue section to see the Database link table list, nor any way to easily see what tables are DB links?
Re:LE9 OLEDB Database link to MS SQL server
Checked older LE9.6490 version and get the same issue with "Database Links" .
DE8.5 "Database Links" works with no issues.
Looks like DB links is broken in LE9?
Re:Re:LE9 OLEDB Database link to MS SQL server
The issue is only with the OLEDB provider option.
This has always been convenient as the logon credentials can be saved in the UDL.
"Other engines via ODBC" works
A database link can be created successfully with the SQL server ODBC provider.
How do you store the ODBC DB link logon credentials?
Re:Re:Re:LE9 OLEDB Database link to MS SQL server
Found a way to get OLEDB DB links working in LE9 although not sure if this can be a reliable option.
Replaced the LE9 'oledb_drv.dll' with the same dll from DE 8.5
OLEDB DB links can be created, forms created and table read / write works.
This implies the issue is with the LE9 'oledb_drv.dll' (2023-05-21)