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...
Expand|Select|Wrap|Line Numbers
- Public Sub getconnect()
- Set ws = CreateWorkspace("", "abc", "", dbUseODBC)
- Set dbaccount = ws.OpenDatabase("", , False, "ODBC;dsn=PostgreSQL10;uid=postgres;pwd=''")
- End Sub