ASP Connection Strings

date posted 26th July 2001 17:20

Freelancers,

I am in the process of building a management system and the interface needs
to connect to several different databases. I know how to create different
file connection strings using the OLE DB layer; e.g:

---------------------
dim database
dim username
dim password

database="Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=""e:mydomaindatabase1.mdb"";"
username="admin"
password=""
---------------------

The trouble I am having is that one of the databases I need to connect to,
is held on a different website from the one that I am calling the connection
string from.

Example: Say I am working from a web-interface that is held on
www.orbinternet.com and one of the databases is held on www.orbinternet.com.
I can connect to this database fine. However, the web-interface held on
www.orbinternet.com needs to connect to a database on
www.orbinternet.co.uk - a completely different website. I have tried use the
same connection method as above, and even tried using the http:// approach
for the filepath but unfortunately neither work.

Am I able to connect to this database? I thought that the advent distributed
information management was possible because of this very facet. I appreciate
the security concerns by being able to connect to another database from
another website - and will happily recognise such issues if I can find some
information on this ability.

I have tried looking on the web and in my books, but it isn't the most
common of problems (I think) and as such am coming up a blank.

If any of you could shed any light on this matter, whatsoever, it would be
much appreciated.

Sincerely,

Stephen
http://www.orbinternet.com