TOPIC:

I don't know where to post this, but can somebody please fix it so I can finally connect to SQL Server.
I tried the explanations and answers in the forum but they all don't work, they keep on giving error that dblib is not found, no matter if it's there or not
I just installed CT once again after some years to see if it finally is working, but still nothing.
I would like to switch from Delphi to CT but I cannot until it finally is working, very very frustrating.
A step by step guide on how to do this that involves all necessary actions, including fixing this anoying dll not find, is what I need, and when that is finally working I would also like to know what to do to install the finished project on some computer without this error poping up again.
CT looks so good and I would really really like to use it, if only it could connect to a database...
 

Please attach here a simple demo project
I will try to fix this problem

No need for a demo project, just open the database explorer and try to connect to SQL Server, I did not get any further than that, that is also the steps I found on the forum on how to do it.
Unless there is an other way to connect to SQL Server, by means of dropping components on a datamodule an set the properties like in Delphi, if so I would like to know them and how to use them, I would actually even prefer that

I found some components in SQL DB 1 and tried to get the connector working, but it keeps giving error

[Window Title]
Error

[Content]
Can not load DB-Lib client library "C:\gg\dblib\x32\dblib.dll". Check your installation.
%1 is not a valid Win32 application.

[OK]

Maybe I have a wrong DBLib.dll, where can I get a correct one ?
Finding the one I have now took me several hours, why is there no explanation of how and where to get all you need ?

now I tried using ntwdblib as described here www.pilotlogic.com/sitejoom/index.php/fo...ction-component.html
My dblib.pp now looks like this

{$IFNDEF FPC_DOTTEDUNITS}
unit DBLib;
{$ENDIF FPC_DOTTEDUNITS}

{$IFDEF FPC}{$mode objfpc}{$ENDIF}{$H+}

{$DEFINE ntwdblib} //if you are using MS SQL Server Client Library (ntwdblib.dll)
{$IFNDEF ntwdblib}
{$DEFINE freetds} //if you are using db-lib from FreeTDS project (MS SQL Server + Sybase support)
{$ENDIF}

{$DEFINE LOAD_DYNAMICALLY}

and now the error is "access violation" if I try to open the connection
Why is this so difficult, all I need is a good working clear documentation on how to do this, why does that not exists ?

Please,
my suggestion, (if you want our help) is to start from the basics:
-Your OS ?
-Your CT version ?
-Your MSSQL Server version?
-What do you want to do, with your project ?

Sir We never use Delphi,
so "Like Delphi" it's NOT for us...

Hello,
my OS here is windows 10, at home it is linux mint 20
CT version is 8.2
SQL Server is version Microsoft SQL Server 2019
I wish to build client applications with rich forms that use SQL Server and that have a windows and a linux version

Like Delphi, well CT is closest to Delphi you can find now, for someone like me who is coming from Delphi the learning curve is almost zero, except for database connections apparently
 

Please, give us time to test and report

Sure, I a m glad that I am getting help so take your time

It's NOT simple task

-First we check FreeTDS libraries

Old FreeTDS library dblib.dll not exist in the latest FreeTDS version 1.4.3
Latest FreeTDS library has :
-libct-4.dll
-libsybdb-5.dll
-libtdsodbc-0.dll

We check the Functions in these Files and we found that libsybdb-5.dll is the old dblib.dll
New libsybdb-5.dll need many GNU libraries to work correct:
-gcc-libs
-libiconv
-openssl

Our solution is to ADD at CTCenter => FreeTDS builder
and "Static" build FreeTDS from sources.

We must Build with CTCenter FreeTDS libraries
We must test these libraries...

You can test the new libsybdb-5.dll => Rename to dblib.dll
from attach file, is 64Bit

And a screen from Our FreeTDS builds...

 


Sir, this is RealTime support,
from most Powerful Progamming Studio on the Planet...

Hello and thank you for your help and all the effort made, I really appreciate it.
As a newbie to CT I would like to ask what is CTCenter ? and how do I add FreeTDSBuilder ?
I am just checking out again (after a few years ago) if I can move to CT (away from delphi and vs) so I have no knowledge yet off all these advanced things.
I am sorry to bother you with all this but I don't know where else to go with all this

CTCenter is the main Build and Setup Actions Application of CodeTyphon Studio


 


 

In NEXT LAB CT release,
FreeTDS library for windows is in:
C:\codetyphon\binRuntimes\x86_64-win64 and
C:\codetyphon\binRuntimes\i386-win32


 

It looks like I don't have this CT Center
This is all I have got under the CT menu
 

CodeTyphon64 


In NEXT LAB CT release,
FreeTDS library for windows is in:
C:\codetyphon\binRuntimes\x86_64-win64 and
C:\codetyphon\binRuntimes\i386-win32

and  CT Center will have this menu....

 

OK I found the CT Center, now what is the next step ? How do I do this freeTDS from there ?

OK, so now I know I need to add FreeTDS to the CT Center.
But, I have no clue how to do that.
I will stare at the menu for some time and click on every option, maybe I can find by chance on how to do this.

I can only repeat it, CT would be a great tool but it is missing one thing that makes it unusable, it misses connection to database support.
I will come back again after a few years to check it out again, CT looks too promising to let it go, but it really needs this.

Thanks for your effort, it's just a shame that I got close to a solution but could not make it to the final meters...