hey Imar,
1) I'm deploying the Classifieds web page tutorial, using Web Deploy.

2) I'm getting a "WebSecurity.InitializeDatabaseConnection("Classif ieds","Users","UserId","UserName",true); " ERROR

Exception Details: System.ArgumentException: Keyword not supported: 'file access retry timeout'.


3) I added a connection string to web.config, and created a SQL DB/user/pswd at my provider(DB="Classifieds")

4)? is my connection string wrong or am I accessing it incorrectly in my
erroring statement ?

Thanks, Imar


******************** The Error ***********************
Exception Details: System.ArgumentException: Keyword not supported: 'file access retry timeout'.

Source Error:
Line 1: @{
Line 2: WebSecurity.InitializeDatabaseConnection("Classifi eds","Users","UserId","UserName",true);

********** web.config *******************
<connectionStrings>
<clear/>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=AVEN.arvixe.com;Initial Catalog=Classifieds;User ID=Eddie_DBU;Password=PASSWORD;" providerName="System.Data.SqlClient"/>
</connectionStrings>

Web Pages 2 generates a SQL Compact 4.0 SP1 connection string, which includes a new keyword: File Access Retry Timeout. It appears that your host does not have the latest version of SqlServerCE.dll, so you need to make sure it is included in your bin folder. You can get it from here: http://www.microsoft.com/en-us/downl....aspx?id=30709

Hey Mike Thanks for looking,

I'm still getting the same error..Keyword not supported: 'file access retry timeout'.

1) I downloaded/installed the file you mentioned(twice). I had to go get it out of the compact dir(?) and put it in the Bin Dir(& bin/x86 just to be sure).

2)redeployed it as u can see from log below, should i do a full redeploy ?.

3)The file i found is dated 6/4/12: System.Data.SqlServerCe.dll...
is that the correct one ?

4) What's next to try ?

Thankds for your assistance Mike,
Eddie in Mesquite



**** Web Deploy Log***********************

0/25/2012 9:02 PM
9:02:40 PM: Using ID 'affe1a6d-67e0-4fb2-9fe2-2b28c07fc002' for connections to the remote server.
9:02:42 PM: Object filePath (edwardsolon.com\Web.config) skipped due to skip directive 'Autogenerated Skip Directive 1035'.
9:02:42 PM: Updating setAcl (edwardsolon.com/App_Data).
9:02:42 PM: Using ID '4aeb9499-f8b9-409f-9687-b04c231936f8' for connections to the remote server.
9:02:44 PM: Updating filePath (edwardsolon.com\bin\System.Data.SqlServerCe.dll).
9:02:53 PM: Adding child filePath (edwardsolon.com\bin\X86\System.Data.SqlServerCe.d ll).
9:02:53 PM: Object filePath (edwardsolon.com\Web.config) skipped due to skip directive 'Autogenerated Skip Directive 1035'.
9:02:53 PM: Updating setAcl (edwardsolon.com/App_Data).
9:02:53 PM: Publish completed.

Hey Mike & Imar,

Turns out, the problem was at the web provider, I finally did it all over again on one of their free temp Webmatrix 2.0 sites. It ran perfectly the first time. I pointed this out to them and they fixed it without me doing anything further/at all.

site:edwardsolon.com

You guys may close/delete this as it does not any coding issues to share.

Thanks Guys,
Edgy
(but i have another question, which I'll post seperately)