473,395 Members | 1,968 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

one application for two connections

137 100+
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...

Expand|Select|Wrap|Line Numbers
  1. Public Sub getconnect()
  2. Set ws = CreateWorkspace("", "abc", "", dbUseODBC)
  3. Set dbaccount = ws.OpenDatabase("", , False, "ODBC;dsn=PostgreSQL10;uid=postgres;pwd=''")
  4.  
  5. End Sub
Aug 9 '07 #1
0 775

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Patrick | last post by:
I had a new production envrionment running ASP pages, and after 4 days in production, I am getting HTTP1.1/ New Application Failed error. Old environment which worked OK: Windows 2000 Server...
43
by: Davey | last post by:
I am planning on developing an application which will involve skills that I have very little experience of - therefore I would appreciate comments on my initial design thoughts. Overview on...
15
by: Chakkaradeep | last post by:
Hi all, i have written a Service,now i want to execute another application (for eg;calc.exe) in the service....how will i perform it??... i tried using this.... /**************Executing a...
4
by: Keith Chadwick | last post by:
I am having some trouble referencing an Application("myVar") variable from within a module.vb file on my ASP.NET site. According to the documentation I should be able to reference...
9
by: Abhishek Srivastava | last post by:
Hello All, In IIS 6.0 We have a concept of worker processes and application pools. As I understand it, we can have multiple worker process per appliction pool. Each worker process is dedicated...
2
by: Rui Dias | last post by:
Hi there! I've got this situation: One application server where the application is installed; One DB Server where the VB.NET application opens two sqlconnections at startup; One intranet wich...
20
by: Keith G. Murphy | last post by:
I'm trying to get a feel for what most people are doing or consider best practice. Given a mod_perl application talking to a PostgreSQL database on the same host, where different users are...
3
by: mamin | last post by:
My application works under IIS 5.1 and is connected with oracle 9.2 database. After a few days of working it starts to work slower aned slower. I've checked connections with database if they are...
2
by: NEWS | last post by:
Hi Could anyone pls guide . I am getting this error : Thankx in anticipation Server Error in '/webpdms' Application....
4
by: Andrus | last post by:
For winforms application with multiple related forms it is reasonable to create Linq database context object in start of application. Context object is released only when application exits. So...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.