Is it possible to combine Databases?

Do i combine my databases or is there a technical way to link them.

[ericf451]

I'm running into situations where I would like to cross reference info between databases. I know its possible to cross reference tables but how about the whole database?

For example...

I have a database with usernames and passwords in one databse and their profiles and pictures in another database.

One database is for them to just become a member for purposes regarding newsletters and to post a pic or something... the other database i added later because I found out how to make a person enter a username and password before they could access certain pages.

I'm not a certified expert on databases or programming.. these are just scripts i found in aspin.com. I could probably figure it out over time but is there a forum or website someone could refer for learning how to direct my search engine to ALL databases or to access more than one?

If this is too much to ask then could somebody tell me if its very possible or a waste of time! haha

Eric

[lorax]

ericf451,
Welcome to WebmasterWorld.

It is quite possible. The 'how to' specifics depends upon what database you're using. Or you could use WDDX [openwddx.org], SOAP [w3.org] or XML-RPC [xmlrpc.com] to complete the communications.

[txbakers]

Ideally you should have one database, with various tables, then you can link the tables as needed.

If you want different databases, your ASP scripts will need two distinct connection objects, and you'll have to use variables to link between databases. It's not very pretty.

[lorax]

>> Ideally you should have one database

Absolutely. My response is based on two seperate dbs that, for one reason or another, must remain seperate. If you can, combine them into one db.

[ericf451]

Hey thank you!

I actually just went to my main database and "imported" the other database tables and just changed my "connection.asp" page to just reflect the one database.

I didn't realize it was that easy so its a good deal now!

Sorry just learning new things everyday, i bet that was a dumb question.

Thank you again for your advice!