mORMot Open Source

dualarrow

Member

From: Australia

Registered: 2018-06-28

Posts: 21

Having problems connecting to an external database

I'm tyring to connect to a Faircom CTree SQL Server using ODBC.

Using the sample SynDBExplorer to test it out, I keep getting the following exception

---------------------------
Debugger Exception Notification
---------------------------
Project SynDBExplorer.exe raised exception class EODBCException with message 'TODBCConnection.Connect: unrecognized provider DBMSName=ctreeSQL DriverName=CTODBC9.DLL DBMSVersion=11.2.2.24260(Build-170219)'.
---------------------------
Break   Continue   Help   
---------------------------

Is this a message from mormot to say there is no support for this driver or should any/most ODBC drivers work and I'm providing incorrect information for the "New Connection" dialog ?

dualarrow

Member

From: Australia

Registered: 2018-06-28

Posts: 21

Re: Having problems connecting to an external database

I name have a modified SynDbOdbc.pas that at least works with the explorer example now. What I'm now having problems with is creating a rest server that uses a TODBCConnection. Can anyone offer advice on how to get a rest server (presumably a TSQLRestServerDB) to work with a TODBCConnection instead of the sqlite ?