The scenario would be the sqlite database is managed using CGI C, resides in Linux environment, and accessed through the web. Then the sql server would be replicating whatever changes would occur in the sqlite database (both sqlite and sql server have the same tables). This will also happen vice versa wherein any change in sql server will be replicated in the sqlite. Sql server is managed using ASP and resides in windows server 2003.
Asif Lodhi wrote: > > Hi maitong, > > On 7/11/07, maitong uy <[EMAIL PROTECTED]> wrote: >> >> >> I see...any idea as to how exactly? I really am out of ideas regarding >> this... :( >> > > I think I did see some UnixODBC files on a Linux environment (Fedora Core > 6, > to be exact) and if you have the same kind of UnixODBC files on your > system > then you can use that to access the SQL Server database on the SQL Server > machine. When it comes to SQLServer-to-Sqlite communication, it should be > noted that Sqlite is an embedded database solution and you will have to > write and some kind of a listener on your Linux server so that a windows > program can communicate with it. > > You can use a CORBA environment that exists on both Linux and Windows > environment and use that to update both of your databases. > > You can use Java for this task as well using its JNI interface. These are > a > few possibilities that have immediately popped up in my mind when I read > your post. > > -- > HTH > > Asif > > -- View this message in context: http://www.nabble.com/Replicating-table-data-from-sqlite-to-ms-sql-server-tf4053878.html#a11609481 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
