473,385 Members | 1,546 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,385 software developers and data experts.

using multiple database in one program

1
hi! i'm presently creating a visual basic program which is suppose to be connected in multiple databases.

i've already managed to connect my program to one database in access. however, when i tried connecting another access database to it, it doesn't work.

i made two connections and two recordsets separately for the two database using two adodc but it doesn't work.

is there anything else that i am suppose to add in my codes? is it possible to use multiple access databases in one vb program?

thanks.
Jan 28 '08 #1
4 3070
r035198x
13,262 8TB
hi! i'm presently creating a visual basic program which is suppose to be connected in multiple databases.

i've already managed to connect my program to one database in access. however, when i tried connecting another access database to it, it doesn't work.

i made two connections and two recordsets separately for the two database using two adodc but it doesn't work.

is there anything else that i am suppose to add in my codes? is it possible to use multiple access databases in one vb program?

thanks.
Please make sure you are posting in the correct forum next time.

What happened when you tried to connect to the other database? Did you get an error? Do you have to be connected to both databases at the same time or is it possible to acheive your requirements by connecting to the databases one at a time?
Jan 28 '08 #2
werks
220 100+
hi! i'm presently creating a visual basic program which is suppose to be connected in multiple databases.

i've already managed to connect my program to one database in access. however, when i tried connecting another access database to it, it doesn't work.

i made two connections and two recordsets separately for the two database using two adodc but it doesn't work.

is there anything else that i am suppose to add in my codes? is it possible to use multiple access databases in one vb program?

thanks.
hi raiza it would be helpful if you could post the exact codes for connecting on your database..


Better Than Yesterday ^^
Jan 28 '08 #3
lotus18
866 512MB
I think you are planning to create a distributed dbms.
Jan 28 '08 #4
debasisdas
8,127 Expert 4TB
Its better to use ADODB .

try to use two separate connetion object and its related other objects.
Jan 28 '08 #5

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

Similar topics

6
by: James Turner | last post by:
I am trying to store formatted text (windows format) into a MySQL database and then retrieve it. The field in the database is a varchar. I cut and paste the test into a form field formatted, then...
3
by: Mohammed Mazid | last post by:
Hi folks! Can anyone please help me with this? I am developing a Quiz program but I am stuck with "multiple answers". Basically I need some sort of code that would select multiple answers...
7
by: Billy Jacobs | last post by:
I am using a datagrid to display some data. I need to create 2 header rows for this grid with columns of varying spans. In html it would be the following. <Table> <tr> <td colspan=8>Official...
7
by: Dave | last post by:
Apologies for the newbie question. I have created a vb.net program for my company that is designed to work with Word Templates (about forty of them that we commonly use) that are selected by the...
0
by: Dimitar | last post by:
Hi, I have a program in C/C++, with embedded SQL, with a single thread of execution. I am trying to establish two database connections, to the same database, so I can have concurrent,...
4
by: Akinyemi | last post by:
I am currently using Visual Basic 6 to write a Payroll Program. I created a Database with one Table in Microsoft Access that ships with Office 2000. The name of the Database is "Payroll", and the...
14
by: Ben | last post by:
I don't know whether anyone can help, but I have an odd problem. I have a PSP (Spyce) script that makes many calls to populate a database. They all work without any problem except for one...
7
by: Pete | last post by:
I need to import multiple tab delimited files for which I do not have the formats. All files have column headers in the the line. The files must be dynamic. The only common value is that the...
2
by: Steve | last post by:
Hi All I have several POS programs (Windows forms VS 2005) Some customers have multiple copies of the programs, all networked to the 1 SQL Server 2005 Database which resides on 1 of the...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
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
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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...

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.