Hello everyone,

I am new to .NET and I too have been trying to work with the Personal Starter Kit as a learning tool. Unfortunately, my host does not allow the user of  SQL Express 2005 and SQL Server will cost extra.

I converted the "personal" database into MS Access and then used the Sample Access Provider Starter Kit to modify the Login controls to use a MS Access database. Now the project runs on two MS Access databases.

I have created a template file for you to use:
http://www.victorcorey.com/PersonalStarterKitMSAccess.vsi

Please let me know if there are any problems.

Thanks,
VC

I failed to install this on my VWD Express, is it for Pro only?

Hmmmm....

No,  I am using VWD Express.

You should download and open the PersonalStarterKitMSAccess.vsi file and it will install a zip file (Personal Start Kit MS Access.zip) in the C:\Documents and Settings\[user]\My Documents\Visual Studio 2005\Templates\ProjectTemplates\Visual C# directory.

Then when you start VWD Express and goto:
File > New Website...
You should see a template for Personal Start Kit MS Access.

Hope this helps. I was able to create a website from the template and everything works fine. But, I am new to this so I could have done something wrong.

Thanks Victor,

This is the error I get "Installation stopped because the directory for the ProjectType value did not exist.  The project type is invalid for your installation of Visual Studio."

I managed to extract your code but failed in using the default way to install it.

Jackli,

   The problem you're facing is because you need to have Visual C# Express installed in your computer in order to complete the installation. I had the same problem. It was until I downloaded and installed VS C# that the installation worked.

Best Regards,

Carlos Lone

http://blog.contoso.net/dotnetmaniagt

 

Victor,

Thank you so much for your effort by putting up this starter kit. I installed it and it show no sign of failing. But i can't see it from "new project" under C# express. I unzip the file manually and tried to open it as a web project. there is no .csproj file at the root. However there is an empty .webproj file i don't know how VS will recognize this. please advice how should i use it from here.

Your time is highly appreciated!

Sue

Never mind, I found a way to work around it and it works perfectly fine. Thanks so much for Victor for your genorous sharing.

Sue

Sue,

You shouldn't need to unzip the file. When you install the .vsi file, it should put the .zip file in the C:\Documents and Settings\[user]\My Documents\Visual Studio 2005\Templates\ProjectTemplates\Visual C# directory. I am using VWD Express. I'm not sure if that is different than C# Express.

Once I installed it, I restarted VWD Express and when I create a new project that is one of the options.

Hope this helps.

Victor

victor.corey wrote:

Hello everyone,

I am new to .NET and I too have been trying to work with the Personal Starter Kit as a learning tool. Unfortunately, my host does not allow the user of  SQL Express 2005 and SQL Server will cost extra.

I converted the "personal" database into MS Access and then used the Sample Access Provider Starter Kit to modify the Login controls to use a MS Access database. Now the project runs on two MS Access databases.

I have created a template file for you to use:
http://www.victorcorey.com/PersonalStarterKitMSAccess.vsi

Please let me know if there are any problems.

Thanks,
VC

I am net to .NET too. Thank you for this MS Access version of the tool kit. About to upload to the hosting webserver, but I am wondering how the connectionstring should look like in order to be able to connect to the provided access databases. Thank you in advance and pls forgive my ignorance in .NET.

Thanks

 

 

jimmy_au wrote:

I am net to .NET too. Thank you for this MS Access version of the tool kit. About to upload to the hosting webserver, but I am wondering how the connectionstring should look like in order to be able to connect to the provided access databases. Thank you in advance and pls forgive my ignorance in .NET.

Thanks

I don't think you should have to change the connectionstring at all. I believe the Data Source=|DataDirectory|. References the App_Data directory.

I modified the .vsi file to hopefully fix the installation problems. The template should now be installed here: C:\Documents and Settings\{user}\My Documents\Visual Studio 2005\Templates\ProjectTemplates\Visual Web Developer\Personal Starter Kit MS Access.zip

http://www.victorcorey.com/PersonalStarterKitMSAccess.vsi

Please let me know if there are any problems with the file.

Thanks,
VC

Hello vitorcorey

Congratulations your access version modification works perfectly

Have you ever tied to run the application on ODBC ?
The reaseon is, that most host providers requesting only this type of connection.

Yersterday I made my first experiance.
I downloaded the newest MS Odbc assembly. After installing I changed all Oledb to Odbc.

In web.config added two DSN entries for Personal and AspNetDb.

When I compile, I get several errors, because from Namespace: Microsoft.Data.Odbc
most Types are not supported !

Do you know any solution to fix this problem?

Best would be in web.config

Wish you happy Xmas

Richard

 

 

 

 

 

 

 

 

richisieber wrote:

Hello vitorcorey

Congratulations your access version modification works perfectly

Have you ever tied to run the application on ODBC ?
The reaseon is, that most host providers requesting only this type of connection.

Yersterday I made my first experiance.
I downloaded the newest MS Odbc assembly. After installing I changed all Oledb to Odbc.

In web.config added two DSN entries for Personal and AspNetDb.

When I compile, I get several errors, because from Namespace: Microsoft.Data.Odbc
most Types are not supported !

Do you know any solution to fix this problem?

Best would be in web.config

Wish you happy Xmas

Richard

Unfortunately, I have not tried. I would think your idea is correct. You may also have to change the connectionstring.

 

Hello victorcorey

Its' not as simple as it looks like, because the aspnetdb provider which is developed in C+ + have other types as we expect in C# !

Does your application run on a server ?

How did you manage it ?

Richard

 

 

Attempt to edit photo album throws this error.

Exception Details: System.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\<--path to website-->\Upload'.

Line 348: DirectoryInfo d = new DirectoryInfo(System.Web.HttpContext.Current.Server.MapPath("~/Upload")); Line 349: //DirectoryInfo d = new DirectoryInfo("c:\\Upload"); Line 350: return d.GetFileSystemInfos("*.*"); Line 351: } Line 352:

Source File: PhotoManager.cs    Line: 350