Sharing database across several domains

Help... Can connect

[5stars]

I don't mean to waste anyone’s time... but I have several sites and I would like to share one database. I use ASP, a MS server, and Access dB.

Can anyone point me in the right direction to making this connection work?

I have searched this board and several search engines and have gotten know where.

Thanks in advance,

[mattglet]

if all the sites are on the same server, you can use a System DSN to specify where/how your files can connect to your database.

-Matt

[5stars]

Thanks Matt.

I have already contacted my hosting company. After they change the DSN... is there anything special I have to do in my connection file?

Thanks again,

Julia

[mattglet]

you have to point all your sites to the same DSN to connect to. after that, you should be all set.

-Matt

[5stars]

Thanks!

I added a DSN to the domain that hosts that database i want to share.

The DSN name is: database
the database name is: shoppingcart

Can you share the connection script I need to use on the files outside the main domain?

Or point me somewhere where I can research it?

Thank you so much!

Julia

[mattglet]

how did you connect to your database when only one site used it? it should be all the same exact settings.

-Matt

[defanjos]

This page has good info:
http*://www.able-consulting.com/ADO_Conn.htm

[5stars]

I have been connecting to the database with a dSN less connection and I have no problems doing that... it's only when I try to connect from one of the other domains that I am having problems.

After going throught the trouble of adding the System DNS my hosting company says there is no way to share the database among the domains on the same server?

frustrating.

[tomasz]

I do not think this can be done, unless your domains are on same network and you have proper file share permissions.
It is time to upgrade to MSDE

[5stars]

Thank you guys for your help! I tinkered with the script for most of the day today and I got it to work despite the fact that my host said it couldn't be done.

Cheers

[mattglet]

i'm glad you got it to work. we just got 2 sites hooked up to the same database today, very easily. it could be that your host wanted you to believe it couldn't be done because they want you to sink more money into purchasing a whole new database.

-Matt