Pervasive db connect

[snm]

I have question if somebody have an idea how to connect to Pervasive database from LiveCode application as we can do with SQLite, MySql or Valentina.

Marek

[shaosean]

You would need to write code to connect to it either using sockets or an external..

[sturgis]

IF it has odbc drivers you should be able to connect to it that way (I think) or as shaosean said, connect using sockets or write an external using whatever api as provided by pervasive.

[snm]

Thanks for reply sturgis and shaosean.

I know that connection should be made by socket, but problem is that I can't find any pervasive db driver working with LiveCode. There is only SQLite, MySql, Valentina, Postgre possible to connect directly from LC stacks. Other side I'm too "green" to write external using pervasive api.

I'm using bookkeeping software on Windows/PC in my office, which is working on pervasive 5 users db. I must make synchronization of stock and prices of this software with internet shop and other system working on Mac computers. The best for me, even only one choice is to write needed application in LC, and then think to replace used software with next applications working each other.

My son promised me to write such socket interface in Java, but it'll be next chain not fully controlled and expandable by me in this system (as I'm not Java programmer).

The only hope for me is try to ask you if maybe you can show me the proper way how to solve my problem.

Marek

[sturgis]

This is why I mentioned odbc. If you look at the entry for revopendatabase the 2nd example is this:
revOpenDatabase("odbc",host[:port], databaseName, [userName],[password],[cursorType])

And odbc is listed under the database connection types. (ODBC = Open DataBase Connectivity)

See this thread here http://cs.pervasive.com/forums/p/14113/48570.aspx

Thanks for reply sturgis and shaosean.

I know that connection should be made by socket, but problem is that I can't find any pervasive db driver working with LiveCode. There is only SQLite, MySql, Valentina, Postgre possible to connect directly from LC stacks. Other side I'm too "green" to write external using pervasive api.

I'm using bookkeeping software on Windows/PC in my office, which is working on pervasive 5 users db. I must make synchronization of stock and prices of this software with internet shop and other system working on Mac computers. The best for me, even only one choice is to write needed application in LC, and then think to replace used software with next applications working each other.

My son promised me to write such socket interface in Java, but it'll be next chain not fully controlled and expandable by me in this system (as I'm not Java programmer).

The only hope for me is try to ask you if maybe you can show me the proper way how to solve my problem.

Marek