2 Different Data Bases

Troy7k · Post by **Troy7k** » Tue Mar 10, 2009 5:35 am

Is it possible to open 2 totally separate data bases? I'm using one data base, let's call it OverdrivePro.mdb in which I get almost all of my information from but I have another data base called Part Labels_NEST.mdb. I need a small portion of information from this 'other' data base. I'm not sure if it's even possible since I'm a new user.

It's like I need to temporarily open another data base pull some data, print it, and close it.

Any suggestions?

Brendan · Post by **Brendan** » Tue Mar 10, 2009 5:59 am

This shouldn't be a problem

I think it's just a matter of adding two connections to the report Dictionary rather than one.
Then each Datasource can be based off the appropriate connection.

Troy7k · Post by **Troy7k** » Tue Mar 10, 2009 6:14 am

Thank you, I'll play with that a bit and see if I can figure it out.

Post by **Edward** » Tue Mar 10, 2009 6:37 am

Hi

And one more thing. If you need to create relations between these datasources, then please set CacheAllData property of the 'report' object in the 'Properties' window of the designer in true.

Thank you.

Brendan · Post by **Brendan** » Tue Mar 10, 2009 6:53 am

Here's a video that shows how to add multiple connections.

http://www.bstash.com/ReportSamples/Mul ... ction.html

One thing to note is that I forgot to set the CacheAllData property. (yet it seems to have still worked without it?)

To set this property select the Properties Tab and click outside the page margin. This will display the properties of the Report itself.
Change the 'Cache All Data' from False to True.

Troy7k · Post by **Troy7k** » Tue Mar 10, 2009 10:35 am

Thank you, all of you, it seems rather easy with the video. Since I didn't create the data bases, an engineering piece of software did that, I'm having problems connecting with the data base itself. I'm in contact with the software company to find out the information I need to access their data bases. Seems like a little thing but it's like pulling teeth.

Great video, the only question I really have is if the data base is created with each job and located in that specific job folder ... is there a way to make the location of the data base the 'current working directory' ?

Post by **Edward** » Wed Mar 11, 2009 5:41 am

Hi,

Yes, it is possible to know the current path from which the application has been launched:

Application.ExecutablePathd

Thank you.