Conection Strings

Hi,
I have two mdf files attached to my server. The connection string connects to one mdb ok.

How do connect to the other mdb on the server?

I have tried adding another connection string but an error "LocalSqlServer......" already named.

 

Hi,
There is a bit of confusion here...
You can't connect to an Express DB on the live server.
You can attach it to your remote DASP SQL Server but only once.
Each time you attach one it will wipe out the other.
To get two Express DBes on the server you will need to merge them.
You can of course use more than one connection string in your web.config, but not to a remoteExpress DB.


Let me know how I can help with this.
Salute,
Mark

 

Hi Mark,


thanks a lot for that info - I didnt realise this !!!


Anyway, i didnt "merge" my mdb's but I did reimplement a set of small tables into the one mdb.


Now I have a fully working application on line and Im feeling good!!


Thanks again for taking time to answer my query.


See ya !!


Rico