× Components and Libraries for Database Development, discussions, problems and suggestions

Question Connecting to MS SQL Sever using CT Center 7.70 for MacOS64 -> Database Desktop

  • Gary Campbell
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 month 2 weeks ago #17049 by Gary Campbell
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? 

Please Log in or Create an account to join the conversation.

  • Matis A.
  • Matis A.'s Avatar
  • Away
  • Moderator
  • Moderator
More
1 month 2 weeks ago #17050 by Matis A.
Did you install  MS SQL Server client library
to your MacOS ?

PilotLogic Core Programmer

Please Log in or Create an account to join the conversation.

  • Gary Campbell
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 month 2 weeks ago #17051 by Gary Campbell
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"

Please Log in or Create an account to join the conversation.

  • Matis A.
  • Matis A.'s Avatar
  • Away
  • Moderator
  • Moderator
More
1 month 2 weeks ago #17053 by Matis A.
You need more info

PilotLogic Core Programmer

Please Log in or Create an account to join the conversation.

  • Gary Campbell
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 month 2 weeks ago #17058 by Gary Campbell
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.

 

Please Log in or Create an account to join the conversation.

  • Matis A.
  • Matis A.'s Avatar
  • Away
  • Moderator
  • Moderator
More
1 month 2 weeks ago - 1 month 2 weeks ago #17059 by Matis A.
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.
 

PilotLogic Core Programmer
Last edit: 1 month 2 weeks ago by Matis A..

Please Log in or Create an account to join the conversation.

  • Gary Campbell
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 month 5 days ago #17077 by Gary Campbell
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.   

Please Log in or Create an account to join the conversation.

  • Matis A.
  • Matis A.'s Avatar
  • Away
  • Moderator
  • Moderator
More
1 month 4 days ago - 1 month 4 days ago #17078 by Matis A.
Did you test your FreeTDS installation ?

More info

tsql -H <host> -p <port> -U <username> -P <password>

PilotLogic Core Programmer
Last edit: 1 month 4 days ago by Matis A..

Please Log in or Create an account to join the conversation.

  • Gary Campbell
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 month 4 days ago #17084 by Gary Campbell
Yes. The tsql command connects to the SQL Server database.

Please Log in or Create an account to join the conversation.

  • Matis A.
  • Matis A.'s Avatar
  • Away
  • Moderator
  • Moderator
More
1 month 4 days ago #17086 by Matis A.
Please, try and CT ctSchemaEditor tool

PilotLogic Core Programmer

Please Log in or Create an account to join the conversation.

  • Gary Campbell
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 month 2 days ago #17087 by Gary Campbell
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.

Please Log in or Create an account to join the conversation.

  • Matis A.
  • Matis A.'s Avatar
  • Away
  • Moderator
  • Moderator
More
1 month 2 days ago #17088 by Matis A.
Thanks

PilotLogic Core Programmer

Please Log in or Create an account to join the conversation.