p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: Two Databases in one folder....


Message #1 by TL Jackson <actionjackson@a...> on Sat, 22 Dec 2001 02:29:06 -0500
Can two databases co-exist in the same folder as long as they have 

different connection name?  I'm using frontpage 2000 and it also tells me 

that it recommended to be put in one specific folder.  Any problems I need 

to worry about?



T.L.



Message #2 by "Ken Schaefer" <ken@a...> on Sat, 22 Dec 2001 19:01:13 +1100
I assume you are talking about Access databases.

Yes, they can happily co-exist in the same folder.



When you open a connection you need to specify a connection string. The

connection string contains the necessary information to connect to the

correct Access .mdb file. If you want to connect to both simultaneously

you'll need two connection objects. When you open each connection object you

provide the necessary connection details for the database you want to

connect to.



Whether this causes problems for the various wizards that Frontpage uses I

don't know...



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "TL Jackson" <actionjackson@a...>

Subject: [asp_databases] Two Databases in one folder....





: Can two databases co-exist in the same folder as long as they have

: different connection name?  I'm using frontpage 2000 and it also tells me

: that it recommended to be put in one specific folder.  Any problems I need

: to worry about?



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



Message #3 by TL Jackson <actionjackson@a...> on Sat, 22 Dec 2001 12:10:30 -0500
Ken,



         Yes, you assumed right.  Sorry I forgot to say Access 

databases.  Thank you for the information.



T.L.





At 07:01 PM 12/22/2001 +1100, you wrote:

>I assume you are talking about Access databases.

>Yes, they can happily co-exist in the same folder.

>

>When you open a connection you need to specify a connection string. The

>connection string contains the necessary information to connect to the

>correct Access .mdb file. If you want to connect to both simultaneously

>you'll need two connection objects. When you open each connection object you

>provide the necessary connection details for the database you want to

>connect to.

>

>Whether this causes problems for the various wizards that Frontpage uses I

>don't know...

>

>Cheers

>Ken




  Return to Index