Recent

Author Topic: A short and concrete question about dblib.dll  (Read 11352 times)

Gosh

  • Jr. Member
  • **
  • Posts: 72
A short and concrete question about dblib.dll
« on: April 24, 2015, 02:51:10 pm »
From where I can download this file?

I tried with google without results


Gosh

  • Jr. Member
  • **
  • Posts: 72
Re: A short and concrete question about dblib.dll
« Reply #2 on: April 24, 2015, 06:56:02 pm »
First link sends to second but ftp site has an issue which doesn't allow downloading.

Third links works fine but I was shocked with size of file- 171MB!!!

Gosh

  • Jr. Member
  • **
  • Posts: 72
Re: A short and concrete question about dblib.dll
« Reply #3 on: April 24, 2015, 07:30:45 pm »
After I installed that 171MB large file, I couldn't find  dblib.dll inside....

Basile B.

  • Guest
Re: A short and concrete question about dblib.dll
« Reply #4 on: April 24, 2015, 08:53:31 pm »

LacaK

  • Hero Member
  • *****
  • Posts: 577
Re: A short and concrete question about dblib.dll
« Reply #5 on: April 25, 2015, 09:23:21 am »
ftp://ftp.freepascal.org/fpc/contrib/windows/dblib_current.zip

No problem to download also for me.
And please use above mentioned file, there is latest precompiled version tested with current TMSSQLConnection.

Gosh

  • Jr. Member
  • **
  • Posts: 72
Re: A short and concrete question about dblib.dll
« Reply #6 on: April 25, 2015, 05:20:19 pm »
Hmmm... I'm not sure how you did that!

I tried from Firefox, Chrome, Opera...

Quote
This webpage is not available

The webpage at ftp://ftp.freepascal.org/fpc/contrib/windows/dblib_current.zip might be temporarily down or it may have moved permanently to a new web address.

I also tried from FileZilla to establish direct FTP connection to site but when I try to go inside of /pub/fpc/contrib/windows folder, the following error occurs:

Quote
Command:   LIST
Response:   425 Security: Bad IP connecting.
Error:   Failed to retrieve directory listing

Can someone put this file on a cloud service to download from there?

Gosh

  • Jr. Member
  • **
  • Posts: 72
Re: A short and concrete question about dblib.dll
« Reply #7 on: April 25, 2015, 05:30:34 pm »

LacaK

  • Hero Member
  • *****
  • Posts: 577
Re: A short and concrete question about dblib.dll
« Reply #8 on: April 25, 2015, 05:46:03 pm »

Quote
Command:   LIST
Response:   425 Security: Bad IP connecting.
Error:   Failed to retrieve directory listing

Can it be, that some IP addresses (areas, countries) are blocked ?

Gosh

  • Jr. Member
  • **
  • Posts: 72
Re: A short and concrete question about dblib.dll
« Reply #9 on: April 25, 2015, 07:48:42 pm »
in that case I'd not be able to connect on that FTP server at all, right? ;) I have connection on about 1/3 of folders from ftp server.

Unfortunately, my troubles continues. I put that 3 dll files into WOW64 folder but I'm still getting the message about missing dblib.dll. What else I have to do?

LacaK

  • Hero Member
  • *****
  • Posts: 577
Re: A short and concrete question about dblib.dll
« Reply #10 on: April 25, 2015, 08:22:01 pm »
Unfortunately, my troubles continues. I put that 3 dll files into WOW64 folder but I'm still getting the message about missing dblib.dll. What

Which 3 files ?
you need only 2 files:
  dblib.dll and libiconv2.dll (Win32) or libiconv.dll (Win64)

Anp put these files in folder where you have your compiled exe application (or in folder where you have lazarus.exe if you want use connection during developing in IDE)

Gosh

  • Jr. Member
  • **
  • Posts: 72
Re: A short and concrete question about dblib.dll
« Reply #11 on: April 25, 2015, 11:03:17 pm »
All 3 files from Win64 folder I put into WOW64 folder, didn't help.

After that I tried with putting files from Win32 folder into Lazarus' main folder. Didn't help.
After that I tried with files from Win64 folder. Didn't help too.

At last I tried inserting these file into project's directory. Didn't work.

  Maybe I'm doing something wrong? I put MSSQL component onto form and set HostName property to "CPC\SQLEXP" and DatabaseName to "Northwind". By idea, this should work fine.
« Last Edit: April 26, 2015, 11:08:42 am by Gosh »

LacaK

  • Hero Member
  • *****
  • Posts: 577
Re: A short and concrete question about dblib.dll
« Reply #12 on: April 27, 2015, 07:21:59 am »
Which error do you receive ?
About missing dblib.dll or other ?

Btw. dblib_2008.dll is alternative to dblib.dll
So both are not required.
If you are connecting to MS SQL 2008 or higher you can rename dblib_2008.dll to dblib.dll and use it.

Gosh

  • Jr. Member
  • **
  • Posts: 72
Re: A short and concrete question about dblib.dll
« Reply #13 on: April 27, 2015, 12:22:54 pm »
I'm using Win7 x64 and 32-bit version of Lazarus/FPC. Server is SQLServer Express 2008 SP2.

In that case, which version of dblib.dll I have to use? 32 or 64 bit?

Honestly, my start with Lazarus if very confusing and frustrating. There are so many obstacles on every step.                                                                                                                                                                                                                                                             EDIT: I renamed dblib2008 file as you suggested but results are the same.
« Last Edit: April 27, 2015, 12:31:29 pm by Gosh »

LacaK

  • Hero Member
  • *****
  • Posts: 577
Re: A short and concrete question about dblib.dll
« Reply #14 on: April 28, 2015, 10:01:02 pm »
In that case, which version of dblib.dll I have to use? 32 or 64 bit?
It depends if you compile for Win32 or Win64 target OS (See in Project/Options)?
I guess, that it is Win32 if you have Lazarus for Win32.

Error message indicates, that your application can not locate dblib.dll or libiconv2.dll

Does this error appears if you are working with Lazarus or when you run already compiled application?