Re: [Sqlrelay-discussion] Use with standard programs

[Alain M. <al...@po...>]

Ok, thanks for the info but...

I had already read those pages careefully. It shows how to use drop-in 
libraries in Linux. The problem is when I *need* to use some client in 
Windows. Most of them may not

But reading more carefully your explanation, maybe you are really 
answering my question :) - Can I have an ODBC server in my Linux machine 
and this in turn use the drop-in library and thus be accessed by any 
windows client program?

This would be PERFECT, is there any tutorial about that?

Thanks,
Alain

David Muse escreveu:
> Using the sqlrelay drop-in-replacement libraries, in theory, you can use
> SQL Relay with any program except PHP that supports mysql or postgresql.
> 
> See these pages for more info:
> http://sqlrelay.sourceforge.net/sqlrelay/dropin/mysql.html
> http://sqlrelay.sourceforge.net/sqlrelay/dropin/postgresql.html
> 
> If an app uses odbc, then in theory, you could configure ODBC to use
> mysql or postgresql, then use the drop-in replacement libraries on top
> of that.
> 
> I say in theory because I haven't tried doing that with lots of apps and
> there could be things that don't work.
> 
> I'm currently working on an ODBC api for SQL Relay which should enable
> it to work with any app that uses ODBC without having to pretend to be
> mysql or postgresql.  But it has turned out to be quite a project and
> may be a while before it's production-ready.
> 
> Dave
> 
> On Fri, 2008-07-04 at 21:45 -0300, Alain M. wrote:
>> Hi,
>>
>> is it possible to access SqlRelay (and it's backend database) using 
>> standard programs like Delphi or report manager?
>>
>> Is this what the ODBC API is about? If so, how far is it in the Todo list?
>>
>> Thanks for any information,
>> Alain
>>