Re: [sqlite] .lib file?

[Paul Claessen]

Thank A.J. Milan!
Forcing VS2008 to compile the amalgamation as C (as opposed to the default C++) 
took care of everything.
I also had the comment-out the #include sqlite3.h header file, and let it use 
all the 'built-in' stuff (else you get an undefined
for the _sqlite3_version extern!)

Works fine now too.

Great forum!

> -Original Message-
> From: sqlite-users-boun...@sqlite.org 
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of A.J.Millan
> Sent: Sunday, July 26, 2009 12:19 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] .lib file?
> 
> Basides the mentioned option of build a .lib file and link it statically
> against your code, or a dinamic library, there are the option of include the
> sqlite3.c file in your code without so many problems with the casting of
> pointers -and some others-.
> 
> If you are using a C++ project in MS Visual Studio, the sqlite3.c file must
> be compiled as "C".
> 
> See in:   File-Properties > C/C++ > Advanced > Compile As
> 
> Select  "Compile as C Code (/TC)"
> 
> The rest of the project can remain compiled as usual C/C++ files.
> 
> Probably you must disable the use of precompiled headers also.
> 
> HTH.
> 
> A.J.Millan
> 
> 
> > -Original Message-
> > From: Paul Claessen paul at claessen.com
> > Sat Jul 25 15:48:37 GMT 2009
> > To: paul at claessen.com; General Discussion of SQLite Database
> > Subject: Re: [sqlite] .lib file?
> >> Two points though:
> 
> > 1. The amalgated sources were, apparently, not written with MS Visual
> > Study in mind, since compiling it results in over 100 errors
> > (mostly invalid pointer conversions)
> > 2. If I have a number of apps, it would really be more efficient to use
> > the DLL.
> 
> > I'm sure I can fix all the pointer casts (shouldn't be necessary if the
> > code used more consistent types!), but that would take me a
> > lot of time, plus, there should be a way to simply use the .dll: since
> > there IS a windows console app, there must be either a .lib
> > file somewhere, or there is an alternative way of using DLL's from a
> > windows console app, that I'm not aware of.
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] .lib file?

[Mihai Limbasan]

The library created by MinGW's dlltool will be a static archive in ar(1) 
format. The contained object files might be compatible between ld(1) and 
Microsoft's linker - I honestly don't know, since I use Qt on the gcc 
(*nix) and MinGW (Windows) toolchains and have limited experience with 
recent Microsoft C++ compilers. If they're compatible, then all the 
better, but I suspect compatibility will be one way only, i.e. with 
MinGW's linker accepting objects produced by the Microsoft toolchain and 
not the other way around.

HTH.

Mihai Limbasan

On 07/26/2009 12:46 AM, Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Paul Claessen wrote:
>
>> Actually, I was able to generate a .lib file from the DLL using Doug's 
>> suggesting (link /lib /def:sqlite3.def).
>> Works fine now!
>>  
>
> MinGW comes with a tool named 'pexports.exe' that can generate the def
> file directly from any dll so you don't have to rely on a hand
> maintained def file.  It also has dlltool which can take that def file
> and generate a lib but I don't know if it is a generic lib file or in
> MinGW format.
>
> Roger
>
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.4.9 (GNU/Linux)
>
> iEYEARECAAYFAkprfSAACgkQmOOfHg372QRjkgCeJVX6cpXGQrEC1yvk94q98Evm
> D+gAoJ9j3AzwbS2YKzQGcdjPAHUuEBVd
> =fCCI
> -END PGP SIGNATURE-
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] .lib file?

[A.J.Millan]

Basides the mentioned option of build a .lib file and link it statically 
against your code, or a dinamic library, there are the option of include the 
sqlite3.c file in your code without so many problems with the casting of 
pointers -and some others-.

If you are using a C++ project in MS Visual Studio, the sqlite3.c file must 
be compiled as "C".

See in:   File-Properties > C/C++ > Advanced > Compile As

Select  "Compile as C Code (/TC)"

The rest of the project can remain compiled as usual C/C++ files.

Probably you must disable the use of precompiled headers also.

HTH.

A.J.Millan


> -Original Message-
> From: Paul Claessen paul at claessen.com
> Sat Jul 25 15:48:37 GMT 2009
> To: paul at claessen.com; General Discussion of SQLite Database
> Subject: Re: [sqlite] .lib file?
>> Two points though:

> 1. The amalgated sources were, apparently, not written with MS Visual 
> Study in mind, since compiling it results in over 100 errors
> (mostly invalid pointer conversions)
> 2. If I have a number of apps, it would really be more efficient to use 
> the DLL.

> I'm sure I can fix all the pointer casts (shouldn't be necessary if the 
> code used more consistent types!), but that would take me a
> lot of time, plus, there should be a way to simply use the .dll: since 
> there IS a windows console app, there must be either a .lib
> file somewhere, or there is an alternative way of using DLL's from a 
> windows console app, that I'm not aware of. 

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] .lib file?

[Brodie Thiesfield]

>> -Original Message-
>> From: sqlite-users-boun...@sqlite.org
>> [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Doug
>> Sent: Saturday, July 25, 2009 11:24 AM
>> To: 'General Discussion of SQLite Database'
>> Subject: Re: [sqlite] .lib file?
>>
>>
>> Hi Paul --
>>
>> When I build SQLite (from the amalgamation) into a DLL VS2008 (and earlier
>> as I recall) automatically creates an import library in the same directory
>> as the .DLL file.  I also _used_ to run the following command separately to
>> create the import lib:
>>
>> link /lib /def:sqlite3.def
>>
>> I haven't kept my sqlite3.def file up to date, but it's fairly recent if you
>> want to use it.  Since we can't post files to the newsgroup, I'll append it
>> here.
>>
>> Doug

Easy to generate the .def file too.

http://www.google.com/search?q=create+.lib+from+.dll
http://support.microsoft.com/kb/131313

Regards,
Brodie
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] .lib file?

[Fred Williams]

Good!  I just told my wife to put the gun down... But she's not listening...

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Paul Claessen
Sent: Saturday, July 25, 2009 4:35 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] .lib file?


Actually, I was able to generate a .lib file from the DLL using Doug's
suggesting (link /lib /def:sqlite3.def).
Works fine now!

Thanks all!

~ Paul Claessen

> -Original Message-
> From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Fred
> Williams
> Sent: Saturday, July 25, 2009 4:44 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] .lib file?
>
> Hum.  So Mickeysoft does not supply a lib converter/creator utility?  I
even
> have a "Make" and "Grep" utility when I get nostalgic for my limited Unix
> days.
>
> My generator has an "-a" option to, "Add '_' alias for MS flavor cdecl
> functions."
>
> Is that what you mean?
>
> Someday if I can find someone to hold a big enough caliber gun to my head,
> I'm going to learn something about the "Visual" development world.  I
> installed the C++ "Express" version and was so underwhlmed by the
> performance I started look for that person with a giant gun :-(
>
> Fred
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Mihai Limbasan
> Sent: Saturday, July 25, 2009 1:13 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] .lib file?
>
>
> Fred,
>
> Unfortunately, .lib (or, for that matter, .obj) files created by Borland
> compilers are not compatible with the Microsoft toolchain, and
> vice-versa. Borland uses a variant of the OMF object format, and
> Microsoft uses a variant of COFF.
>
> On 07/25/2009 08:09 PM, Fred Williams wrote:
> > Paul,
> >
> > If you wish I can send yoou a SQLite3.lib file I just generated using my
> old
> > Borland C++ Builder 5 Lib utility.  Can't attach it here so contact me:
> >
> > fwillia...@gmail.com
> >
> > And I'll attach it to a reply.
> >
> > Fred
> >
> >
> > -Original Message-
> > From: sqlite-users-boun...@sqlite.org
> > [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Doug
> > Sent: Saturday, July 25, 2009 11:24 AM
> > To: 'General Discussion of SQLite Database'
> > Subject: Re: [sqlite] .lib file?
> >
> >
> > Hi Paul --
> >
> > When I build SQLite (from the amalgamation) into a DLL VS2008 (and
earlier
> > as I recall) automatically creates an import library in the same
directory
> > as the .DLL file.  I also _used_ to run the following command separately
> to
> > create the import lib:
> >
> > link /lib /def:sqlite3.def
> >
> > I haven't kept my sqlite3.def file up to date, but it's fairly recent if
> you
> > want to use it.  Since we can't post files to the newsgroup, I'll append
> it
> > here.
> >
> > Doug
> >
> > 
> > EXPORTS
> > sqlite3_aggregate_context
> > sqlite3_aggregate_count
> > sqlite3_auto_extension
> > sqlite3_bind_blob
> > sqlite3_bind_double
> > sqlite3_bind_int
> > sqlite3_bind_int64
> > sqlite3_bind_null
> > sqlite3_bind_parameter_count
> > sqlite3_bind_parameter_index
> > sqlite3_bind_parameter_name
> > sqlite3_bind_text
> > sqlite3_bind_text16
> > sqlite3_bind_value
> > sqlite3_bind_zeroblob
> > sqlite3_blob_bytes
> > sqlite3_blob_close
> > sqlite3_blob_open
> > sqlite3_blob_read
> > sqlite3_blob_write
> > sqlite3_busy_handler
> > sqlite3_busy_timeout
> > sqlite3_changes
> > sqlite3_clear_bindings
> > sqlite3_close
> > sqlite3_collation_needed
> > sqlite3_collation_needed16
> > sqlite3_column_blob
> > sqlite3_column_bytes
> > sqlite3_column_bytes16
> > sqlite3_column_count
> > sqlite3_column_decltype
> > sqlite3_column_decltype16
> > sqlite3_column_double
> > sqlite3_column_int
> > sqlite3_column_int64
> > sqlite3_column_name
> > sqlite3_column_name16
> > sqlite3_column_text
> > sqlite3_column_text16
> > sqlite3_column_type
> > sqlite3_column_value
> > sqlite3_commit_hook
> > sqlite3_complete
> > sqlite3_complete16
> > sqlite3_create_collation
> > sqlite3_create_collation16
> > sqlite3_create_collation_v2
> > sqlite3_create_function
> > sqlite3_create_function16
> > sqlite3_create_module
> > sql

Re: [sqlite] .lib file?

[Roger Binns]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Paul Claessen wrote:
> Actually, I was able to generate a .lib file from the DLL using Doug's 
> suggesting (link /lib /def:sqlite3.def).
> Works fine now!

MinGW comes with a tool named 'pexports.exe' that can generate the def
file directly from any dll so you don't have to rely on a hand
maintained def file.  It also has dlltool which can take that def file
and generate a lib but I don't know if it is a generic lib file or in
MinGW format.

Roger

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkprfSAACgkQmOOfHg372QRjkgCeJVX6cpXGQrEC1yvk94q98Evm
D+gAoJ9j3AzwbS2YKzQGcdjPAHUuEBVd
=fCCI
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] .lib file?

[Paul Claessen]

Actually, I was able to generate a .lib file from the DLL using Doug's 
suggesting (link /lib /def:sqlite3.def).
Works fine now!

Thanks all!

~ Paul Claessen

> -Original Message-
> From: sqlite-users-boun...@sqlite.org 
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Fred
> Williams
> Sent: Saturday, July 25, 2009 4:44 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] .lib file?
> 
> Hum.  So Mickeysoft does not supply a lib converter/creator utility?  I even
> have a "Make" and "Grep" utility when I get nostalgic for my limited Unix
> days.
> 
> My generator has an "-a" option to, "Add '_' alias for MS flavor cdecl
> functions."
> 
> Is that what you mean?
> 
> Someday if I can find someone to hold a big enough caliber gun to my head,
> I'm going to learn something about the "Visual" development world.  I
> installed the C++ "Express" version and was so underwhlmed by the
> performance I started look for that person with a giant gun :-(
> 
> Fred
> 
> -Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Mihai Limbasan
> Sent: Saturday, July 25, 2009 1:13 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] .lib file?
> 
> 
> Fred,
> 
> Unfortunately, .lib (or, for that matter, .obj) files created by Borland
> compilers are not compatible with the Microsoft toolchain, and
> vice-versa. Borland uses a variant of the OMF object format, and
> Microsoft uses a variant of COFF.
> 
> On 07/25/2009 08:09 PM, Fred Williams wrote:
> > Paul,
> >
> > If you wish I can send yoou a SQLite3.lib file I just generated using my
> old
> > Borland C++ Builder 5 Lib utility.  Can't attach it here so contact me:
> >
> > fwillia...@gmail.com
> >
> > And I'll attach it to a reply.
> >
> > Fred
> >
> >
> > -Original Message-
> > From: sqlite-users-boun...@sqlite.org
> > [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Doug
> > Sent: Saturday, July 25, 2009 11:24 AM
> > To: 'General Discussion of SQLite Database'
> > Subject: Re: [sqlite] .lib file?
> >
> >
> > Hi Paul --
> >
> > When I build SQLite (from the amalgamation) into a DLL VS2008 (and earlier
> > as I recall) automatically creates an import library in the same directory
> > as the .DLL file.  I also _used_ to run the following command separately
> to
> > create the import lib:
> >
> > link /lib /def:sqlite3.def
> >
> > I haven't kept my sqlite3.def file up to date, but it's fairly recent if
> you
> > want to use it.  Since we can't post files to the newsgroup, I'll append
> it
> > here.
> >
> > Doug
> >
> > 
> > EXPORTS
> > sqlite3_aggregate_context
> > sqlite3_aggregate_count
> > sqlite3_auto_extension
> > sqlite3_bind_blob
> > sqlite3_bind_double
> > sqlite3_bind_int
> > sqlite3_bind_int64
> > sqlite3_bind_null
> > sqlite3_bind_parameter_count
> > sqlite3_bind_parameter_index
> > sqlite3_bind_parameter_name
> > sqlite3_bind_text
> > sqlite3_bind_text16
> > sqlite3_bind_value
> > sqlite3_bind_zeroblob
> > sqlite3_blob_bytes
> > sqlite3_blob_close
> > sqlite3_blob_open
> > sqlite3_blob_read
> > sqlite3_blob_write
> > sqlite3_busy_handler
> > sqlite3_busy_timeout
> > sqlite3_changes
> > sqlite3_clear_bindings
> > sqlite3_close
> > sqlite3_collation_needed
> > sqlite3_collation_needed16
> > sqlite3_column_blob
> > sqlite3_column_bytes
> > sqlite3_column_bytes16
> > sqlite3_column_count
> > sqlite3_column_decltype
> > sqlite3_column_decltype16
> > sqlite3_column_double
> > sqlite3_column_int
> > sqlite3_column_int64
> > sqlite3_column_name
> > sqlite3_column_name16
> > sqlite3_column_text
> > sqlite3_column_text16
> > sqlite3_column_type
> > sqlite3_column_value
> > sqlite3_commit_hook
> > sqlite3_complete
> > sqlite3_complete16
> > sqlite3_create_collation
> > sqlite3_create_collation16
> > sqlite3_create_collation_v2
> > sqlite3_create_function
> > sqlite3_create_function16
> > sqlite3_create_module
> > sqlite3_create_module_v2
> > sqlite3_data_count
> > sqlite3_db_handle
> > sqlite3_declare_vtab
> > sqlite3_enable_load_extension
> > sqlite3_enable_shared_cache
> > sqlite3_errcode
> > sqlite3_errmsg
> > sqlite3_errmsg16
> > sqlite3_exec
> > sqlite3_exp

Re: [sqlite] .lib file?

[Fred Williams]

Hum.  So Mickeysoft does not supply a lib converter/creator utility?  I even
have a "Make" and "Grep" utility when I get nostalgic for my limited Unix
days.

My generator has an "-a" option to, "Add '_' alias for MS flavor cdecl
functions."

Is that what you mean?

Someday if I can find someone to hold a big enough caliber gun to my head,
I'm going to learn something about the "Visual" development world.  I
installed the C++ "Express" version and was so underwhlmed by the
performance I started look for that person with a giant gun :-(

Fred

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Mihai Limbasan
Sent: Saturday, July 25, 2009 1:13 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] .lib file?


Fred,

Unfortunately, .lib (or, for that matter, .obj) files created by Borland
compilers are not compatible with the Microsoft toolchain, and
vice-versa. Borland uses a variant of the OMF object format, and
Microsoft uses a variant of COFF.

On 07/25/2009 08:09 PM, Fred Williams wrote:
> Paul,
>
> If you wish I can send yoou a SQLite3.lib file I just generated using my
old
> Borland C++ Builder 5 Lib utility.  Can't attach it here so contact me:
>
> fwillia...@gmail.com
>
> And I'll attach it to a reply.
>
> Fred
>
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Doug
> Sent: Saturday, July 25, 2009 11:24 AM
> To: 'General Discussion of SQLite Database'
> Subject: Re: [sqlite] .lib file?
>
>
> Hi Paul --
>
> When I build SQLite (from the amalgamation) into a DLL VS2008 (and earlier
> as I recall) automatically creates an import library in the same directory
> as the .DLL file.  I also _used_ to run the following command separately
to
> create the import lib:
>
> link /lib /def:sqlite3.def
>
> I haven't kept my sqlite3.def file up to date, but it's fairly recent if
you
> want to use it.  Since we can't post files to the newsgroup, I'll append
it
> here.
>
> Doug
>
> 
> EXPORTS
> sqlite3_aggregate_context
> sqlite3_aggregate_count
> sqlite3_auto_extension
> sqlite3_bind_blob
> sqlite3_bind_double
> sqlite3_bind_int
> sqlite3_bind_int64
> sqlite3_bind_null
> sqlite3_bind_parameter_count
> sqlite3_bind_parameter_index
> sqlite3_bind_parameter_name
> sqlite3_bind_text
> sqlite3_bind_text16
> sqlite3_bind_value
> sqlite3_bind_zeroblob
> sqlite3_blob_bytes
> sqlite3_blob_close
> sqlite3_blob_open
> sqlite3_blob_read
> sqlite3_blob_write
> sqlite3_busy_handler
> sqlite3_busy_timeout
> sqlite3_changes
> sqlite3_clear_bindings
> sqlite3_close
> sqlite3_collation_needed
> sqlite3_collation_needed16
> sqlite3_column_blob
> sqlite3_column_bytes
> sqlite3_column_bytes16
> sqlite3_column_count
> sqlite3_column_decltype
> sqlite3_column_decltype16
> sqlite3_column_double
> sqlite3_column_int
> sqlite3_column_int64
> sqlite3_column_name
> sqlite3_column_name16
> sqlite3_column_text
> sqlite3_column_text16
> sqlite3_column_type
> sqlite3_column_value
> sqlite3_commit_hook
> sqlite3_complete
> sqlite3_complete16
> sqlite3_create_collation
> sqlite3_create_collation16
> sqlite3_create_collation_v2
> sqlite3_create_function
> sqlite3_create_function16
> sqlite3_create_module
> sqlite3_create_module_v2
> sqlite3_data_count
> sqlite3_db_handle
> sqlite3_declare_vtab
> sqlite3_enable_load_extension
> sqlite3_enable_shared_cache
> sqlite3_errcode
> sqlite3_errmsg
> sqlite3_errmsg16
> sqlite3_exec
> sqlite3_expired
> sqlite3_extended_result_codes
> sqlite3_file_control
> sqlite3_finalize
> sqlite3_free
> sqlite3_free_table
> sqlite3_get_autocommit
> sqlite3_get_auxdata
> sqlite3_get_table
> sqlite3_global_recover
> sqlite3_interrupt
> sqlite3_last_insert_rowid
> sqlite3_libversion
> sqlite3_libversion_number
> sqlite3_load_extension
> sqlite3_malloc
> sqlite3_memory_alarm
> sqlite3_memory_highwater
> sqlite3_memory_used
> sqlite3_mprintf
> sqlite3_mutex_alloc
> sqlite3_mutex_enter
> sqlite3_mutex_free
> sqlite3_mutex_leave
> sqlite3_mutex_try
> sqlite3_open
> sqlite3_open16
> sqlite3_open_v2
> sqlite3_overload_function
> sqlite3_prepare
> sqlite3_prepare16
> sqlite3_prepare16_v2
> sqlite3_prepare_v2
> sqlite3_profile
> sqlite3_progress_handler
> sqlite3_realloc
> sqlite3_release_memory
> sqlite3_reset
> sqlite3_reset_auto_extension
> sqlite3_result_blob
> sqlite3_result_double
> sqlite3_result_error
> sqlite3_result_error16
> sqlite3_result_error_nomem
> sqlite3_result_error_toobi

Re: [sqlite] .lib file?

[Mihai Limbasan]

Fred,

Unfortunately, .lib (or, for that matter, .obj) files created by Borland 
compilers are not compatible with the Microsoft toolchain, and 
vice-versa. Borland uses a variant of the OMF object format, and 
Microsoft uses a variant of COFF.

On 07/25/2009 08:09 PM, Fred Williams wrote:
> Paul,
>
> If you wish I can send yoou a SQLite3.lib file I just generated using my old
> Borland C++ Builder 5 Lib utility.  Can't attach it here so contact me:
>
> fwillia...@gmail.com
>
> And I'll attach it to a reply.
>
> Fred
>
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Doug
> Sent: Saturday, July 25, 2009 11:24 AM
> To: 'General Discussion of SQLite Database'
> Subject: Re: [sqlite] .lib file?
>
>
> Hi Paul --
>
> When I build SQLite (from the amalgamation) into a DLL VS2008 (and earlier
> as I recall) automatically creates an import library in the same directory
> as the .DLL file.  I also _used_ to run the following command separately to
> create the import lib:
>
> link /lib /def:sqlite3.def
>
> I haven't kept my sqlite3.def file up to date, but it's fairly recent if you
> want to use it.  Since we can't post files to the newsgroup, I'll append it
> here.
>
> Doug
>
> 
> EXPORTS
> sqlite3_aggregate_context
> sqlite3_aggregate_count
> sqlite3_auto_extension
> sqlite3_bind_blob
> sqlite3_bind_double
> sqlite3_bind_int
> sqlite3_bind_int64
> sqlite3_bind_null
> sqlite3_bind_parameter_count
> sqlite3_bind_parameter_index
> sqlite3_bind_parameter_name
> sqlite3_bind_text
> sqlite3_bind_text16
> sqlite3_bind_value
> sqlite3_bind_zeroblob
> sqlite3_blob_bytes
> sqlite3_blob_close
> sqlite3_blob_open
> sqlite3_blob_read
> sqlite3_blob_write
> sqlite3_busy_handler
> sqlite3_busy_timeout
> sqlite3_changes
> sqlite3_clear_bindings
> sqlite3_close
> sqlite3_collation_needed
> sqlite3_collation_needed16
> sqlite3_column_blob
> sqlite3_column_bytes
> sqlite3_column_bytes16
> sqlite3_column_count
> sqlite3_column_decltype
> sqlite3_column_decltype16
> sqlite3_column_double
> sqlite3_column_int
> sqlite3_column_int64
> sqlite3_column_name
> sqlite3_column_name16
> sqlite3_column_text
> sqlite3_column_text16
> sqlite3_column_type
> sqlite3_column_value
> sqlite3_commit_hook
> sqlite3_complete
> sqlite3_complete16
> sqlite3_create_collation
> sqlite3_create_collation16
> sqlite3_create_collation_v2
> sqlite3_create_function
> sqlite3_create_function16
> sqlite3_create_module
> sqlite3_create_module_v2
> sqlite3_data_count
> sqlite3_db_handle
> sqlite3_declare_vtab
> sqlite3_enable_load_extension
> sqlite3_enable_shared_cache
> sqlite3_errcode
> sqlite3_errmsg
> sqlite3_errmsg16
> sqlite3_exec
> sqlite3_expired
> sqlite3_extended_result_codes
> sqlite3_file_control
> sqlite3_finalize
> sqlite3_free
> sqlite3_free_table
> sqlite3_get_autocommit
> sqlite3_get_auxdata
> sqlite3_get_table
> sqlite3_global_recover
> sqlite3_interrupt
> sqlite3_last_insert_rowid
> sqlite3_libversion
> sqlite3_libversion_number
> sqlite3_load_extension
> sqlite3_malloc
> sqlite3_memory_alarm
> sqlite3_memory_highwater
> sqlite3_memory_used
> sqlite3_mprintf
> sqlite3_mutex_alloc
> sqlite3_mutex_enter
> sqlite3_mutex_free
> sqlite3_mutex_leave
> sqlite3_mutex_try
> sqlite3_open
> sqlite3_open16
> sqlite3_open_v2
> sqlite3_overload_function
> sqlite3_prepare
> sqlite3_prepare16
> sqlite3_prepare16_v2
> sqlite3_prepare_v2
> sqlite3_profile
> sqlite3_progress_handler
> sqlite3_realloc
> sqlite3_release_memory
> sqlite3_reset
> sqlite3_reset_auto_extension
> sqlite3_result_blob
> sqlite3_result_double
> sqlite3_result_error
> sqlite3_result_error16
> sqlite3_result_error_nomem
> sqlite3_result_error_toobig
> sqlite3_result_int
> sqlite3_result_int64
> sqlite3_result_null
> sqlite3_result_text
> sqlite3_result_text16
> sqlite3_result_text16be
> sqlite3_result_text16le
> sqlite3_result_value
> sqlite3_result_zeroblob
> sqlite3_rollback_hook
> sqlite3_set_authorizer
> sqlite3_set_auxdata
> sqlite3_sleep
> sqlite3_snprintf
> sqlite3_soft_heap_limit
> sqlite3_sql
> sqlite3_step
> sqlite3_thread_cleanup
> sqlite3_threadsafe
> sqlite3_total_changes
> sqlite3_trace
> sqlite3_transfer_bindings
> sqlite3_update_hook
> sqlite3_user_data
> sqlite3_value_blob
> sqlite3_value_bytes
> sqlite3_value_bytes16
> sqlite3_value_double
> sqlite3_value_int
> sqlite3_value_int64
> sqlite3_value_numeric_type
> sqlite3_value_text
> sqlite3_value_text16
> sqlite3_value_text16

Re: [sqlite] .lib file?

[Fred Williams]

Paul,

If you wish I can send yoou a SQLite3.lib file I just generated using my old
Borland C++ Builder 5 Lib utility.  Can't attach it here so contact me:

fwillia...@gmail.com

And I'll attach it to a reply.

Fred


-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Doug
Sent: Saturday, July 25, 2009 11:24 AM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] .lib file?


Hi Paul --

When I build SQLite (from the amalgamation) into a DLL VS2008 (and earlier
as I recall) automatically creates an import library in the same directory
as the .DLL file.  I also _used_ to run the following command separately to
create the import lib:

link /lib /def:sqlite3.def

I haven't kept my sqlite3.def file up to date, but it's fairly recent if you
want to use it.  Since we can't post files to the newsgroup, I'll append it
here.

Doug


EXPORTS
sqlite3_aggregate_context
sqlite3_aggregate_count
sqlite3_auto_extension
sqlite3_bind_blob
sqlite3_bind_double
sqlite3_bind_int
sqlite3_bind_int64
sqlite3_bind_null
sqlite3_bind_parameter_count
sqlite3_bind_parameter_index
sqlite3_bind_parameter_name
sqlite3_bind_text
sqlite3_bind_text16
sqlite3_bind_value
sqlite3_bind_zeroblob
sqlite3_blob_bytes
sqlite3_blob_close
sqlite3_blob_open
sqlite3_blob_read
sqlite3_blob_write
sqlite3_busy_handler
sqlite3_busy_timeout
sqlite3_changes
sqlite3_clear_bindings
sqlite3_close
sqlite3_collation_needed
sqlite3_collation_needed16
sqlite3_column_blob
sqlite3_column_bytes
sqlite3_column_bytes16
sqlite3_column_count
sqlite3_column_decltype
sqlite3_column_decltype16
sqlite3_column_double
sqlite3_column_int
sqlite3_column_int64
sqlite3_column_name
sqlite3_column_name16
sqlite3_column_text
sqlite3_column_text16
sqlite3_column_type
sqlite3_column_value
sqlite3_commit_hook
sqlite3_complete
sqlite3_complete16
sqlite3_create_collation
sqlite3_create_collation16
sqlite3_create_collation_v2
sqlite3_create_function
sqlite3_create_function16
sqlite3_create_module
sqlite3_create_module_v2
sqlite3_data_count
sqlite3_db_handle
sqlite3_declare_vtab
sqlite3_enable_load_extension
sqlite3_enable_shared_cache
sqlite3_errcode
sqlite3_errmsg
sqlite3_errmsg16
sqlite3_exec
sqlite3_expired
sqlite3_extended_result_codes
sqlite3_file_control
sqlite3_finalize
sqlite3_free
sqlite3_free_table
sqlite3_get_autocommit
sqlite3_get_auxdata
sqlite3_get_table
sqlite3_global_recover
sqlite3_interrupt
sqlite3_last_insert_rowid
sqlite3_libversion
sqlite3_libversion_number
sqlite3_load_extension
sqlite3_malloc
sqlite3_memory_alarm
sqlite3_memory_highwater
sqlite3_memory_used
sqlite3_mprintf
sqlite3_mutex_alloc
sqlite3_mutex_enter
sqlite3_mutex_free
sqlite3_mutex_leave
sqlite3_mutex_try
sqlite3_open
sqlite3_open16
sqlite3_open_v2
sqlite3_overload_function
sqlite3_prepare
sqlite3_prepare16
sqlite3_prepare16_v2
sqlite3_prepare_v2
sqlite3_profile
sqlite3_progress_handler
sqlite3_realloc
sqlite3_release_memory
sqlite3_reset
sqlite3_reset_auto_extension
sqlite3_result_blob
sqlite3_result_double
sqlite3_result_error
sqlite3_result_error16
sqlite3_result_error_nomem
sqlite3_result_error_toobig
sqlite3_result_int
sqlite3_result_int64
sqlite3_result_null
sqlite3_result_text
sqlite3_result_text16
sqlite3_result_text16be
sqlite3_result_text16le
sqlite3_result_value
sqlite3_result_zeroblob
sqlite3_rollback_hook
sqlite3_set_authorizer
sqlite3_set_auxdata
sqlite3_sleep
sqlite3_snprintf
sqlite3_soft_heap_limit
sqlite3_sql
sqlite3_step
sqlite3_thread_cleanup
sqlite3_threadsafe
sqlite3_total_changes
sqlite3_trace
sqlite3_transfer_bindings
sqlite3_update_hook
sqlite3_user_data
sqlite3_value_blob
sqlite3_value_bytes
sqlite3_value_bytes16
sqlite3_value_double
sqlite3_value_int
sqlite3_value_int64
sqlite3_value_numeric_type
sqlite3_value_text
sqlite3_value_text16
sqlite3_value_text16be
sqlite3_value_text16le
sqlite3_value_type
sqlite3_version
sqlite3_vfs_find
sqlite3_vfs_register
sqlite3_vfs_unregister
sqlite3_vmprintf



> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Paul Claessen
> Sent: Saturday, July 25, 2009 10:49 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] .lib file?
>
> Thanks Pavel.
>
> Two points though:
>
> 1. The amalgated sources were, apparently, not written with MS Visual
> Study in mind, since compiling it results in over 100 errors
> (mostly invalid pointer conversions)
> 2. If I have a number of apps, it would really be more efficient to use
> the DLL.
>
> I'm sure I can fix all the pointer casts (shouldn't be necessary if the
> code used more consistent types!), but that would take me a
> lot of time, plus, there should be a way to simply use the .dll: since
> there IS a windows console app, there must be either a .lib
> file somewhere, or there is an alternative way of using DLL's from a
> windows console app, that I'm not aware of.
>
> Kind rega

Re: [sqlite] .lib file?

[Doug]

Hi Paul --

When I build SQLite (from the amalgamation) into a DLL VS2008 (and earlier
as I recall) automatically creates an import library in the same directory
as the .DLL file.  I also _used_ to run the following command separately to
create the import lib:

link /lib /def:sqlite3.def

I haven't kept my sqlite3.def file up to date, but it's fairly recent if you
want to use it.  Since we can't post files to the newsgroup, I'll append it
here.

Doug


EXPORTS
sqlite3_aggregate_context
sqlite3_aggregate_count
sqlite3_auto_extension
sqlite3_bind_blob
sqlite3_bind_double
sqlite3_bind_int
sqlite3_bind_int64
sqlite3_bind_null
sqlite3_bind_parameter_count
sqlite3_bind_parameter_index
sqlite3_bind_parameter_name
sqlite3_bind_text
sqlite3_bind_text16
sqlite3_bind_value
sqlite3_bind_zeroblob
sqlite3_blob_bytes
sqlite3_blob_close
sqlite3_blob_open
sqlite3_blob_read
sqlite3_blob_write
sqlite3_busy_handler
sqlite3_busy_timeout
sqlite3_changes
sqlite3_clear_bindings
sqlite3_close
sqlite3_collation_needed
sqlite3_collation_needed16
sqlite3_column_blob
sqlite3_column_bytes
sqlite3_column_bytes16
sqlite3_column_count
sqlite3_column_decltype
sqlite3_column_decltype16
sqlite3_column_double
sqlite3_column_int
sqlite3_column_int64
sqlite3_column_name
sqlite3_column_name16
sqlite3_column_text
sqlite3_column_text16
sqlite3_column_type
sqlite3_column_value
sqlite3_commit_hook
sqlite3_complete
sqlite3_complete16
sqlite3_create_collation
sqlite3_create_collation16
sqlite3_create_collation_v2
sqlite3_create_function
sqlite3_create_function16
sqlite3_create_module
sqlite3_create_module_v2
sqlite3_data_count
sqlite3_db_handle
sqlite3_declare_vtab
sqlite3_enable_load_extension
sqlite3_enable_shared_cache
sqlite3_errcode
sqlite3_errmsg
sqlite3_errmsg16
sqlite3_exec
sqlite3_expired
sqlite3_extended_result_codes
sqlite3_file_control
sqlite3_finalize
sqlite3_free
sqlite3_free_table
sqlite3_get_autocommit
sqlite3_get_auxdata
sqlite3_get_table
sqlite3_global_recover
sqlite3_interrupt
sqlite3_last_insert_rowid
sqlite3_libversion
sqlite3_libversion_number
sqlite3_load_extension
sqlite3_malloc
sqlite3_memory_alarm
sqlite3_memory_highwater
sqlite3_memory_used
sqlite3_mprintf
sqlite3_mutex_alloc
sqlite3_mutex_enter
sqlite3_mutex_free
sqlite3_mutex_leave
sqlite3_mutex_try
sqlite3_open
sqlite3_open16
sqlite3_open_v2
sqlite3_overload_function
sqlite3_prepare
sqlite3_prepare16
sqlite3_prepare16_v2
sqlite3_prepare_v2
sqlite3_profile
sqlite3_progress_handler
sqlite3_realloc
sqlite3_release_memory
sqlite3_reset
sqlite3_reset_auto_extension
sqlite3_result_blob
sqlite3_result_double
sqlite3_result_error
sqlite3_result_error16
sqlite3_result_error_nomem
sqlite3_result_error_toobig
sqlite3_result_int
sqlite3_result_int64
sqlite3_result_null
sqlite3_result_text
sqlite3_result_text16
sqlite3_result_text16be
sqlite3_result_text16le
sqlite3_result_value
sqlite3_result_zeroblob
sqlite3_rollback_hook
sqlite3_set_authorizer
sqlite3_set_auxdata
sqlite3_sleep
sqlite3_snprintf
sqlite3_soft_heap_limit
sqlite3_sql
sqlite3_step
sqlite3_thread_cleanup
sqlite3_threadsafe
sqlite3_total_changes
sqlite3_trace
sqlite3_transfer_bindings
sqlite3_update_hook
sqlite3_user_data
sqlite3_value_blob
sqlite3_value_bytes
sqlite3_value_bytes16
sqlite3_value_double
sqlite3_value_int
sqlite3_value_int64
sqlite3_value_numeric_type
sqlite3_value_text
sqlite3_value_text16
sqlite3_value_text16be
sqlite3_value_text16le
sqlite3_value_type
sqlite3_version
sqlite3_vfs_find
sqlite3_vfs_register
sqlite3_vfs_unregister
sqlite3_vmprintf



> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Paul Claessen
> Sent: Saturday, July 25, 2009 10:49 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] .lib file?
> 
> Thanks Pavel.
> 
> Two points though:
> 
> 1. The amalgated sources were, apparently, not written with MS Visual
> Study in mind, since compiling it results in over 100 errors
> (mostly invalid pointer conversions)
> 2. If I have a number of apps, it would really be more efficient to use
> the DLL.
> 
> I'm sure I can fix all the pointer casts (shouldn't be necessary if the
> code used more consistent types!), but that would take me a
> lot of time, plus, there should be a way to simply use the .dll: since
> there IS a windows console app, there must be either a .lib
> file somewhere, or there is an alternative way of using DLL's from a
> windows console app, that I'm not aware of.
> 
> Kind regards,
> 
> ~ Paul Claessen
> 
> 
> > -Original Message-
> > From: Pavel Ivanov [mailto:paiva...@gmail.com]
> > Sent: Saturday, July 25, 2009 11:31 AM
> > To: p...@claessen.com; General Discussion of SQLite Database
> > Subject: Re: [sqlite] .lib file?
> >
> > You can take sqlite3.c from amalgamation package and include it into
> > your project. This way SQLite will be included into 

Re: [sqlite] .lib file?

[Paul Claessen]

Thanks Pavel.

Two points though:

1. The amalgated sources were, apparently, not written with MS Visual Study in 
mind, since compiling it results in over 100 errors
(mostly invalid pointer conversions)
2. If I have a number of apps, it would really be more efficient to use the 
DLL. 

I'm sure I can fix all the pointer casts (shouldn't be necessary if the code 
used more consistent types!), but that would take me a
lot of time, plus, there should be a way to simply use the .dll: since there IS 
a windows console app, there must be either a .lib
file somewhere, or there is an alternative way of using DLL's from a windows 
console app, that I'm not aware of.

Kind regards,

~ Paul Claessen


> -Original Message-
> From: Pavel Ivanov [mailto:paiva...@gmail.com]
> Sent: Saturday, July 25, 2009 11:31 AM
> To: p...@claessen.com; General Discussion of SQLite Database
> Subject: Re: [sqlite] .lib file?
> 
> You can take sqlite3.c from amalgamation package and include it into
> your project. This way SQLite will be included into your application
> and you won't need any .dll or .lib files.
> 
> Pavel
> 
> On Sat, Jul 25, 2009 at 10:41 AM, Paul Claessen<p...@claessen.com> wrote:
> > Greetings,
> >
> >
> >
> > I'm trying to build and use the short sample C code on the quick start page
> (http://www.sqlite.org/quickstart.html) for windows as a
> > simple win32 console app, using Visual Studio 2008.
> >
> > In order to provide linkage to the DLL, I need to link with the .lib file 
> > that is usually created
> when creating a DLL. Where can I
> > find that file?
> >
> > Or are there other ways to actually build the above mentioned app, without 
> > such a library?
> >
> > There is a windows test console app, but I can't find the project files for 
> > it. Does anyone have
> them, and knows how to build a
> > simple console app, using the dell, in Visual Studio?
> >
> >
> >
> > Kind regards,
> >
> >
> >
> > ~ Paul Claessen
> >
> >
> >
> >
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] .lib file?

[Pavel Ivanov]

You can take sqlite3.c from amalgamation package and include it into
your project. This way SQLite will be included into your application
and you won't need any .dll or .lib files.

Pavel

On Sat, Jul 25, 2009 at 10:41 AM, Paul Claessen wrote:
> Greetings,
>
>
>
> I'm trying to build and use the short sample C code on the quick start page 
> (http://www.sqlite.org/quickstart.html) for windows as a
> simple win32 console app, using Visual Studio 2008.
>
> In order to provide linkage to the DLL, I need to link with the .lib file 
> that is usually created when creating a DLL. Where can I
> find that file?
>
> Or are there other ways to actually build the above mentioned app, without 
> such a library?
>
> There is a windows test console app, but I can't find the project files for 
> it. Does anyone have them, and knows how to build a
> simple console app, using the dell, in Visual Studio?
>
>
>
> Kind regards,
>
>
>
> ~ Paul Claessen
>
>
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] .lib file?

[Paul Claessen]

Greetings,

 

I'm trying to build and use the short sample C code on the quick start page 
(http://www.sqlite.org/quickstart.html) for windows as a
simple win32 console app, using Visual Studio 2008.

In order to provide linkage to the DLL, I need to link with the .lib file that 
is usually created when creating a DLL. Where can I
find that file?

Or are there other ways to actually build the above mentioned app, without such 
a library?

There is a windows test console app, but I can't find the project files for it. 
Does anyone have them, and knows how to build a
simple console app, using the dell, in Visual Studio?

 

Kind regards,

 

~ Paul Claessen

 

 

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users