Re: can't get aspnetdb.mdf to work on remote host

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

yes, that's what i mean by remote server. i've been working with them on
this, and they've been helpful in getting me connected to the database.
however i don't think they have a lot of expertise in this particular area.
the database appears to be fine, and i would think that my code and
everything is fine as this works on my machine (common theme i'm
discovering), so i'm confused as to why, if i've recreated an exact duplicate
of the database and can connect to it without any trouble, i'm still not able
to get it to work correctly. i was thinking perhaps someone who understood
the .net framework better could say "you need to do this and this for that to
work." or point me to a better resource than i've been able to find thus far.

"David Wier" wrote:

When you say 'remote server' - are you talking about a hosted site you have
(buying hosting services)?

If so, have you asked them about how to work with it?

David Wier
MVP/ASPInsider
http://aspnet101.com
http://iWritePro.com

"Josh Nikle" <JoshNikle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:162DD4E3-6598-4C3C-9C47-29124483ADDA@xxxxxxxxxxxxxxxx
i'm in the process of putting my first .net app on a remote server, and
i'm
having no end of trouble getting the aspnetdb database (sitememberships on
my
host) to work correctly.

after a lot of research, i'm able to connect to it with this connection
string in my web.config file:
<remove name="LocalSqlServer"></remove>
<add name="LocalSqlServer" connectionString="Data Source=[host server];
User
ID=[username]; Password=[password]; Initial Catalog=sitememberships"
providerName="System.Data.SqlClient" />

however, i'm still unable to use any credentials that were in the database
before, even though i used the new database publishing wizard from ms to
create a .sql file and had my host restore the database from that. if i
create a new user, i can use those credentials...until i add another user.
at that point, i can no longer use any other credentials in the database
but
the ones just created.

can anyone point me to a step-by-step tutorial for how to put this
database
on a remote server or tell me what i'm doing wrong? i found a guide on
creating the .sql file on scottgu's blog, but his connection strings
didn't
work for me. i found the working connection string on google groups. if
i
even knew what steps had to be performed: are there more things that need
changing in the web.config? another file? code changes?

any light shed on this is greatly appreciated.

-josh




.

Relevant Pages

  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: Updating remote MySQL databases
    ... than over Internet directly to the database. ... > I want to maintain with the WinForms program. ... > remote server, that would probably be done with PHP or whatever. ... > the appropriate dialect down the TCP/IP connection from my local PC to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... much rather write stored procedures and use server side cursors. ... local database, it is vital that I get the information to a central server. ... Once the connection is restored, ...
    (microsoft.public.data.ado)