How to connect the SQLite with DBDesigner4?

[winstonma]

I tried to export the the SQL command exported from DBDesigner4 is not going
to run on SQLite. But working on MYSQL. However I saw that the DBDesigner4
can connect to SQLite server.

I tried to download the source code from SQLite CVS. However I have no clue
how to build the SQLite server from the source code. I also tried the binary
on the SQLite webpage. I can't find the server option as well. So is there a
way that I can export my table from DBDesigner4 to SQLite.

[Mihai Limbasan]

Post by winstonma
I tried to export the the SQL command exported from DBDesigner4 is not going
to run on SQLite. But working on MYSQL. However I saw that the DBDesigner4
can connect to SQLite server.
I tried to download the source code from SQLite CVS. However I have no clue
how to build the SQLite server from the source code. I also tried the binary
on the SQLite webpage. I can't find the server option as well. So is there a
way that I can export my table from DBDesigner4 to SQLite.

Instructions on how to build SQLite from source in various environments
can be found at this Wiki page:
http://www.sqlite.org/cvstrac/wiki?p=HowToCompile

Hope this helps.

Mihai Limbasan

[winstonma]

Thanks for the reply. However I downloaded the CVS and tried to compile from
source, I can't find out anything related to server or client.

Post by Mihai Limbasan

Post by winstonma
I tried to export the the SQL command exported from DBDesigner4 is not going
to run on SQLite. But working on MYSQL. However I saw that the DBDesigner4
can connect to SQLite server.
I tried to download the source code from SQLite CVS. However I have no clue
how to build the SQLite server from the source code. I also tried the binary
on the SQLite webpage. I can't find the server option as well. So is there a
way that I can export my table from DBDesigner4 to SQLite.

Instructions on how to build SQLite from source in various environments
http://www.sqlite.org/cvstrac/wiki?p=HowToCompile
Hope this helps.
Mihai Limbasan
_______________________________________________
sqlite-users mailing list
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[Mihai Limbasan]

Post by winstonma
Thanks for the reply. However I downloaded the CVS and tried to compile from
source, I can't find out anything related to server or client.

Oh, I must have missed the part about client/server. You misunderstand
the nature of SQLite. There is no server and no client. SQLite is an
engine that gets embedded in your application and operates on databases
which are contained in single files (although you can attach additional
databases from other files into your main database.)

For more information, please check http://www.sqlite.org/whentouse.html .

I have never used the software you're trying - you might ask the authors
for how to use it with SQLite.

Mihai Limbasan

[Dom Dom]

Hi,

I already asked some weeks ago fabforce.net about the ability to connect
sqlite and dbdesigner.
The answer was as follows

Bye

Dominique

Sorry, we never got the SQLite support finished. We now have the successor
application out, MySQL Workbench, and we might add SQLite support there in
the future. But for now there is no support, sorry.
Best regards,
Mike

[Mihai Limbasan]

Post by Dom Dom
Hi,
I already asked some weeks ago fabforce.net about the ability to connect
sqlite and dbdesigner.
The answer was as follows
Bye
Dominique

Sorry, we never got the SQLite support finished. We now have the successor
application out, MySQL Workbench, and we might add SQLite support there in
the future. But for now there is no support, sorry.
Best regards,
Mike

I think that's pretty clear then, and we can consider the issue closed...

[John Stanton]

There is no Sqlite server. It is embedded.

Post by winstonma
I tried to export the the SQL command exported from DBDesigner4 is not going
to run on SQLite. But working on MYSQL. However I saw that the DBDesigner4
can connect to SQLite server.
I tried to download the source code from SQLite CVS. However I have no clue
how to build the SQLite server from the source code. I also tried the binary
on the SQLite webpage. I can't find the server option as well. So is there a
way that I can export my table from DBDesigner4 to SQLite.

[Kees Nuyt]

Post by winstonma
I tried to export the the SQL command exported from DBDesigner4 is not going
to run on SQLite. But working on MYSQL. However I saw that the DBDesigner4
can connect to SQLite server.
I tried to download the source code from SQLite CVS. However I have no clue
how to build the SQLite server from the source code. I also tried the binary
on the SQLite webpage. I can't find the server option as well. So is there a
way that I can export my table from DBDesigner4 to SQLite.

As some other people already mentioned, SQLite is not a
server.
If DBDesigner can handle ODBC, you could try one of the
SQLite_ODBC drivers. But that will not solve everything, as
DBDesigner probably doesn't know the SQLite syntax.

[winstonma]

Then I wonder how can I "export" my DB4Designer work to the SQLite database?

Post by winstonma
I tried to export the the SQL command exported from DBDesigner4 is not
going to run on SQLite. But working on MYSQL. However I saw that the
DBDesigner4 can connect to SQLite server.
I tried to download the source code from SQLite CVS. However I have no
clue how to build the SQLite server from the source code. I also tried the
binary on the SQLite webpage. I can't find the server option as well. So
is there a way that I can export my table from DBDesigner4 to SQLite.

[Mihai Limbasan]

Post by winstonma
Then I wonder how can I "export" my DB4Designer work to the SQLite database?

I have no idea - again, please consult the DB4Designer documentation to
find out the available export options.