TOPIC:

Using the CodeTyphon Center Ver 7.70 for MacOS64 -> Database Desktop

When I enter the connection parameters to remotely connect to a MS SQL Server database, I receive the following message:

Can not load DB-Lib client library "libsybdb.dylib". Check your installation. No such file or directory. 

Is there a solution for this? 

Did you install  MS SQL Server client library
to your MacOS ?

I do have the libsybdb.dylib file located in the "/opt/local/lib/" folder 

When I change to the "/opt/local/lib/" folder and issue a "ls -all libsybdb.dylib" command

I get a symlink result that displays: "libsybdb.dylib -> libsybdb.5.dylib"

When I enter the /opt/local/lib/libsybdb.dylib file path and name, into the Database Desktop Client Library text box, I continue to receive the message:Can not load DB-Lib client library "/opt/local/lib/libsybdb.dylib"

You need more info

When you say "I need more info", do you mean the connection parameters such as the IP number, port number, database name, user name and password? If that is what you mean, I've entered those parameters, but still can not connect. I've also used the same connection parameters in Lazarus using UniDAC, and the connection works, but I'd rather use Typhon and will make a donation for your time and effort. If you mean something else, then I do not know what you mean.

 

Did you try,
to leave empty the
Database Desktop Client Library text box ?

We add this text box primary for Windows OS.
On Uxix and MacOS, if your Database Libraries are proper installed to the OS,
you must leave empty this text box.
In this case, Database Desktop will ask the OS for the correct location of Database Libraries.

If Database Desktop can't load the Database Libraries with empty Client Library text box,
then your Database Libraries are NOT "visible" to Database Desktop.
 

I tried what you suggested, but nothing is working. Some discussion on Github, and here, suggests that macOS upgrades break software programs. In the meantime I have a workaround which works for my client. The workaround runs Windows 11 on macOS version 12.4 under UTM (a virtual machine). Windows 11 is able to run a Delphi 7 program that the client needs to run.   

Did you test your FreeTDS installation ?

More info

Yes. The tsql command connects to the SQL Server database.

Please, try and CT ctSchemaEditor tool

I tried the CT ctSchemaEditor but I keep getting the same message that it can't find libsybdb.dylib (pathname included), or if I try using an ODBC connection then I get a message that it can't find the odbc client file (even when I include the pathname).

Not going to worry about it. I have a workaround. My client likes the new prototype application I created with Typhon which uses a SQLite database.

All is well.

Thanks