MSSQL connection error dblib.dll
lazarus / 16-Databases

----------------------------------------------------------------------
vvkaymak · 2020-05-07 09:42

Hello friends.
I'm sorry, maybe it's a very simple problem.
I have win10 installed on my computer.
I can't connect to MSSQL.
"dblib.dll" gives an error that it is not installed.
"Can not load DB-Lib client library " dblib.dll". Check your
installation."

I would be glad if you could help.
Best regards.

----------------------------------------------------------------------
marcov · 2020-05-07 09:52

You need to get the dblib.dll from the FreeTDS project:

https://wiki.freepascal.org/mssqlconn

----------------------------------------------------------------------
vvkaymak · 2020-05-07 10:41

Hi
Where do I copy the "dblib.dll" file.

I haven't copied it anywhere.
Where do I need to copy.

----------------------------------------------------------------------
marcov · 2020-05-07 10:42

Where the EXE is .

----------------------------------------------------------------------
vvkaymak · 2020-05-07 10:52

Why is it still failing?
I copied it to where exe was.
I compiled again, but it gives errors.

----------------------------------------------------------------------
TRon · 2020-05-07 10:59

I'm guessing here but since it is provided inside the archive and i
don't see that name on the pictures: libiconv.dll dependency ?

----------------------------------------------------------------------
fred · 2020-05-07 11:07

You can also use something like:
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i  
MyLibiconv2 :=
LoadLibrary(PChar(Application.Location+'RES\libiconv2.dll'));  Mydblib
    := LoadLibrary(PChar(Application.Location+'RES\dblib.dll'));  
FreeLibrary(Mydblib);  FreeLibrary(MyLibiconv2);

----------------------------------------------------------------------
TRon · 2020-05-07 11:14

ah... the readme :-)

QuotePre-compiled DLLs for Windows

 Win32
  dblib_2000.dll - compiled using VC++ 2005 with hardcoded TDS
protocol version 7.1 (SQL Server 2000); based on FreeTDS 0.91
  dblib_2008.dll - compiled using VC++ 2005 with hardcoded TDS
protocol version 7.3 (SQL Server 2008)
  (with ICONV support; requires libiconv2.dll)

 Win64
  dblib.dll      - compiled using VC++ 2010
  dblib_2000.dll - compiled using VC++ 2010 with hardcoded TDS
protocol version 7.1 (SQL Server 2000)
  dblib_2008.dll - compiled using VC++ 2010 with hardcoded TDS
protocol version 7.3 (SQL Server 2008)
  (with ICONV support; requires libiconv.dll)

User vvkaymak seems to be using 64-bit

----------------------------------------------------------------------
vvkaymak · 2020-05-07 11:23

I've tried a lot of things always gives error.
I can't understand where I'm making a mistake.
Can you help remote desktop.

----------------------------------------------------------------------
af0815 · 2020-05-07 16:51

i see only the dblib.dll in your pictures, not the libiconv.dll
(libicon2.dll for win32).

a) is your program (not lazarus) compiled for win32 or win64 ?
b) what is the source (downloaded from) of your dblib.dll ?
c) what is the error message exactly (and if you start the programm
from commandline)