Welcome, Guest
Username: Password: Remember me
Components and Libraries for Database Development, discussions, problems and suggestions
  • Page:
  • 1

TOPIC:

Connecting to MS SQL Sever using CT Center 7.70 for MacOS64 -> Database Desktop 2 years 6 months ago #17049

  • Gary Campbell
  • Gary Campbell's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 14
  • Thank you received: 0
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.

Connecting to MS SQL Sever using CT Center 7.70 for MacOS64 -> Database Desktop 2 years 6 months ago #17050

  • Matis A.
  • Matis A.'s Avatar
  • Away
  • Moderator
  • Moderator
  • Posts: 1121
  • Thank you received: 166
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.

Connecting to MS SQL Sever using CT Center 7.70 for MacOS64 -> Database Desktop 2 years 6 months ago #17051

  • Gary Campbell
  • Gary Campbell's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 14
  • Thank you received: 0
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.

Connecting to MS SQL Sever using CT Center 7.70 for MacOS64 -> Database Desktop 2 years 6 months ago #17053

  • Matis A.
  • Matis A.'s Avatar
  • Away
  • Moderator
  • Moderator
  • Posts: 1121
  • Thank you received: 166
You need more info
PilotLogic Core Programmer

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

Connecting to MS SQL Sever using CT Center 7.70 for MacOS64 -> Database Desktop 2 years 6 months ago #17058

  • Gary Campbell
  • Gary Campbell's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 14
  • Thank you received: 0
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.

Connecting to MS SQL Sever using CT Center 7.70 for MacOS64 -> Database Desktop 2 years 6 months ago #17059

  • Matis A.
  • Matis A.'s Avatar
  • Away
  • Moderator
  • Moderator
  • Posts: 1121
  • Thank you received: 166
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

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

Last edit: by Matis A..

Connecting to MS SQL Sever using CT Center 7.70 for MacOS64 -> Database Desktop 2 years 6 months ago #17077

  • Gary Campbell
  • Gary Campbell's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 14
  • Thank you received: 0
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.

Connecting to MS SQL Sever using CT Center 7.70 for MacOS64 -> Database Desktop 2 years 6 months ago #17078

  • Matis A.
  • Matis A.'s Avatar
  • Away
  • Moderator
  • Moderator
  • Posts: 1121
  • Thank you received: 166
Did you test your FreeTDS installation ?

More info

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

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

Last edit: by Matis A..

Connecting to MS SQL Sever using CT Center 7.70 for MacOS64 -> Database Desktop 2 years 6 months ago #17084

  • Gary Campbell
  • Gary Campbell's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 14
  • Thank you received: 0
Yes. The tsql command connects to the SQL Server database.

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

Connecting to MS SQL Sever using CT Center 7.70 for MacOS64 -> Database Desktop 2 years 6 months ago #17086

  • Matis A.
  • Matis A.'s Avatar
  • Away
  • Moderator
  • Moderator
  • Posts: 1121
  • Thank you received: 166
Please, try and CT ctSchemaEditor tool
PilotLogic Core Programmer

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

Connecting to MS SQL Sever using CT Center 7.70 for MacOS64 -> Database Desktop 2 years 6 months ago #17087

  • Gary Campbell
  • Gary Campbell's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 14
  • Thank you received: 0
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.

Connecting to MS SQL Sever using CT Center 7.70 for MacOS64 -> Database Desktop 2 years 6 months ago #17088

  • Matis A.
  • Matis A.'s Avatar
  • Away
  • Moderator
  • Moderator
  • Posts: 1121
  • Thank you received: 166
Thanks
PilotLogic Core Programmer

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

  • Page:
  • 1