Data Synchronization-Based Development Tools 1

[jebamani]

Hi,

Can someone tell me if it is possible to write an application in VB/C++ to access Oracle Lite database and synchronize data from it?

Is there a special dll file to do this?

Has anyone got a code snippet on this subject and willing to share it?

Thanks in advance,

A Jebamani.

 

[toranjeet]

Yes dear.... its very easy to write an application in VB/C++ to access Oracle Lite database and synchronize data from it:- For example i m explaining in the context of VB....using ADO.....
you first should create the DSN for the oracle server then use this code in your module of the VB Project.....

Public Declare Function GetComputerName Lib "kernel32" Alias "GetComputerNameA" (ByVal lpBuffer As String, nSize As Long) As Long
Public adcon As New ADODB.Connection

Public Sub Main()
If adcon.State <> adStateClosed Then adcon.Close
adcon.Open (&quot;DSN=ora;UID=user1;PWD=ranjeet&quot
On Error Resume Next
frmForm1.Show
End Sub

After writing this code in your sub main function of your vb project and after successfull connectivity you can highly injoy the easy and interesting coding structures....
By for now and for further problems you may contact on &quot;toranjeet@glide.net.in&quot;.....