oracle

← →
Alexander Kolesnikov (2003-11-19 17:53) [0]

Посоветуйте, плс, движок прямого доступа к Oracle (nonVCL)

← →
aser (2003-11-20 00:25) [1]

в kol нет такого движка

← →
aser (2003-11-20 00:29) [2]

кстати, вопрос к Богуславу насчет компонент для работы с интербейсом. можно ли на что-то надеяться ?

← →
Boguslaw (2003-11-22 14:47) [3]

Hmm...sorry, I dropped this problem from my list ;-( I use KOLSQlite and for my needs it is enough. But it is really interesting problem.

← →
aser (2003-11-24 16:39) [4]

Я писал о проблеме с кириллицей в sqlite... Они пишут, что dll-ка скомпилирована с помощью mingw под линукс в режиме емуляции windows (или что-то вроде того). В исходнике есть опция для языка. Может научите, как скомпилировать dll-ку указанным компилятором (или может у кого есть оная) с кириллицей ?

← →
Boguslaw (2003-12-01 12:52) [5]

SQLITE
Win32 recompile with mingw32/msys

1. Download mingw from http://prdownloads.sourceforge.net/mingw/MinGW-2.0.0-3.exe

2. Download msys from http://prdownloads.sourceforge.net/mingw/MSYS-1.0.8.exe

3. Install mingw to c:\mingw and msys to c:\mingw

4. Download the FULL sqlite source (http://www.sqlite.org/sqlite-2.8.0.tar.gz) and extract it into c:\mingw\sqlite

5. start the msys.bat and cd to /home/drh/sqlite and ./configure with mingw/msys

6. edit src/os.h, go to ~ line 90 (behind the #ifndef OS_UNIX block) and add

#define OS_WIN 1
#define OS_MAC 0
#define OS_UNIX 0

to the source to force the os type. I don"t know why but the os type isn"t guessed right and redefined in the os.h... Whatever, force it ;) The defines from the makefile don"t work.

7. call mingw32-make to compile! make isn"t used anymore (see http://www.mingw.org/mingwfaq.shtml#faq-mingw32-make.exe)

8. create a file called sqlite.def which contains

EXPORTS
sqlite_open
sqlite_close
sqlite_exec
sqlite_last_insert_rowid
sqlite_error_string
sqlite_interrupt
sqlite_complete
sqlite_busy_handler
sqlite_busy_timeout
sqlite_get_table
sqlite_free_table
sqlite_mprintf
sqlite_vmprintf
sqlite_exec_printf
sqlite_exec_vprintf
sqlite_get_table_printf
sqlite_get_table_vprintf
sqlite_freemem
sqlite_libversion
sqlite_libencoding
sqlite_changes
sqlite_create_function
sqlite_create_aggregate
sqlite_function_type
sqlite_user_data
sqlite_aggregate_context
sqlite_aggregate_count
sqlite_set_result_string
sqlite_set_result_int
sqlite_set_result_double
sqlite_set_result_error
sqliteMalloc
sqliteFree
sqliteRealloc
sqlite_set_authorizer
sqlite_trace
sqlite_compile
sqlite_step
sqlite_finalize

9. dllwrap --dllname sqlite.dll --def sqlite.def *.o (or if this doesn"t work, dllwrap --def sqlite.def -v --export-all --driver-name gcc --dlltool-name dlltool --as as --target i386-mingw32 -dllname sqlite.dll -lmsvcrt *.o)

10. strip sqlite.dll

11. Ready.

--------------------------------------------------------------------------------
Win32 recompile with borland c++ builder
1. Download preprocessed source from http://www.sqlite.org/sqlite_source.zip

2. Unzip the source to a project directory, e.g. C:\sqlite

3. Fire up your borland c++ builder and create a new dll project, plain C without mfc or something like that

4. Save the project as (e.g.) C:\sqlite\sqlite.bpr

5. Add the sqlite source files from c:\sqlite to the project

6. Remove the unit1.* files from your project

7. Even if .def files are not the clean way, it will be easier than rewriting the sourcecode. Create the file sqlite.def with the following content and add it to the project:

LIBRARY sqlite.dll
EXPORTS
sqlite_open = _sqlite_open
sqlite_close = _sqlite_close
sqlite_exec = _sqlite_exec
sqlite_last_insert_rowid = _sqlite_last_insert_rowid
sqlite_error_string = _sqlite_error_string
sqlite_interrupt = _sqlite_interrupt
sqlite_complete = _sqlite_complete
sqlite_busy_handler = _sqlite_busy_handler
sqlite_busy_timeout = _sqlite_busy_timeout
sqlite_get_table = _sqlite_get_table
sqlite_free_table = _sqlite_free_table
sqlite_mprintf = _sqlite_mprintf
sqlite_vmprintf = _sqlite_vmprintf
sqlite_exec_printf = _sqlite_exec_printf
sqlite_exec_vprintf = _sqlite_exec_vprintf
sqlite_get_table_printf = _sqlite_get_table_printf
sqlite_get_table_vprintf = _sqlite_get_table_vprintf
sqlite_freemem = _sqlite_freemem
sqlite_libversion = _sqlite_libversion
sqlite_libencoding = _sqlite_libencoding
sqlite_changes = _sqlite_changes
sqlite_create_function = _sqlite_create_function
sqlite_create_aggregate = _sqlite_create_aggregate
sqlite_function_type = _sqlite_function_type
sqlite_user_data = _sqlite_user_data

sqlite_aggregate_context = _sqlite_aggregate_context
sqlite_aggregate_count = _sqlite_aggregate_count
sqlite_set_result_string = _sqlite_set_result_string
sqlite_set_result_int = _sqlite_set_result_int
sqlite_set_result_double = _sqlite_set_result_double
sqlite_set_result_error = _sqlite_set_result_error
sqliteMalloc = _sqliteMalloc
sqliteFree = _sqliteFree
sqliteRealloc = _sqliteRealloc
sqlite_set_authorizer = _sqlite_set_authorizer
sqlite_trace = _sqlite_trace
sqlite_compile = _sqlite_compile
sqlite_step = _sqlite_step
sqlite_finalize = _sqlite_finalize

9. Fire up the compiler.

10. Ready.

oracle Найти похожие ветки