Hi experts
I am using VB6 and postgres. I connect it with the ODBC.
I have completed one application. But where I am stuck is I have to run two same applications from the same computer. So I have to create the next ODBC connection for the next one. So it is like two different applications. If I have to make changes then I have to change in both applications. It is increasing my troubles.
What I want is when both the applications are same, can't I make only one application with two different connections. If I have to change, then I will only update one application and the changes will be on both applications.
Can anyone suggest how to do that?
Thanks in advance.
P.S. My connection string is...
[CODE=vb]Public Sub getconnect()
Set ws = CreateWorkspace ("", "abc", "", dbUseODBC)
Set dbaccount = ws.OpenDatabase ("", , False, "ODBC;dsn=Postg reSQL10;uid=pos tgres;pwd=''")
End Sub[/CODE]
I am using VB6 and postgres. I connect it with the ODBC.
I have completed one application. But where I am stuck is I have to run two same applications from the same computer. So I have to create the next ODBC connection for the next one. So it is like two different applications. If I have to make changes then I have to change in both applications. It is increasing my troubles.
What I want is when both the applications are same, can't I make only one application with two different connections. If I have to change, then I will only update one application and the changes will be on both applications.
Can anyone suggest how to do that?
Thanks in advance.
P.S. My connection string is...
[CODE=vb]Public Sub getconnect()
Set ws = CreateWorkspace ("", "abc", "", dbUseODBC)
Set dbaccount = ws.OpenDatabase ("", , False, "ODBC;dsn=Postg reSQL10;uid=pos tgres;pwd=''")
End Sub[/CODE]