Help please - how to create a dll

[cbrooks]

Hi all;

This may be a little bit tricky or perhaps easier than I expect.

I have a lot of code written in QB64 that will take me too long to re-write in PB. However, I am making the transition over to PB as I see a lot of advantages for new programs.

Still, I don't want to re-write old code.

So, in order to give access to SQL to my old QB64 apps, is it possible to create a dll accessible from QB64? I thought one way of doing it was perhaps through a TCP/IP local host connection - but I bet there is a better way. (QB64 does not read sql well - can't read past the first column fyi )

I have an array of information to pass between the two: a$(1) to a$(32) I'd like to send a string request to the dll (such as query column "phone" for "905" and receive back the array a$(1-32) for all responses.)

You have helped me build the code to read/write the sql (thank you) - perhaps you can get me started on this task.

with thanks

Chris

[infratec]

Hi,

than it would be better to use the sqlite dll directly.
http://www.sqlite.org/download.html/

Bernd

[cbrooks]

thanks. it refers to sqlite - is that the same as mysql? which is what i am using.

[srod]

SQLite is not the same as MySQL no sir; they are worlds apart.

MySQL runs as a server and is a heavyweight beast.

You will need to install an ODBC driver for MySQL before you can access a MySQL database on some server or other (or use a client library; I think there is a dll around these forums somewhere).