Re: VS.net installs sql express as default datastore for role/membersh

Hi,

I can use sql or access databases for dataaccess, that is not the problem.


If you go, in Visual studio 2005 , to 'asp.net configuration', that is the
Asp.net web site administration tool.
Select provider configuration
select a single provider for all site management data
now the only provider to select is 'AspNetSqlProvider' (in my configuration
it is)
This provider is setup by default for sql express. Visual studio creates the
database in sql server express.
In the documentation, it seems easy to select an other database.
I have no providers for, MS access, SQL server 2000, Sql server 2005
I'm working on a clean installed winXP pro, i'm sure a have all the sp's
installed.
I found traces of AspNetSqlProvider in the IIS ASP.NET configuration . I
tried ad a connectionstring for access.. but it did not work.



"Cowboy (Gregory A. Beamer) - MVP" <NoSpamMgbworld@xxxxxxxxxxxxxxxxxx>
schreef in bericht
news:5239A959-2017-4787-99BD-FEF124406869@xxxxxxxxxxxxxxxx
>I am not sure I understand the issue completely.
>
> Are you saying the website administration website will not allow you to
> create an Access database for membership? If so, you might have a
> permissions
> problem on the directory or it could be missing MDAC bits for Jet
> (depending
> on the version of MDAC you have installed, it is a separate install).
>
>
> Or, are you saying you can use Access with C#, but not VB.NET? If so, get
> the database built and create VB.NET pages. You can also edit the solution
> file, if necessary, to change defaults for the website after you have the
> membership database.
>
> In other words, how deep is the problem?
>
> --
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
>
> ***************************
> Think Outside the Box!
> ***************************
>
>
> "Bruno" wrote:
>
>> Hello,
>>
>> VS.net installs sql express as datastore for role/membership management.
>> I don't like this! I'm not able to choose other databases like ms-access,
>> in
>> the Web Site Administration Tool . (Only AspNetSqlProvider)
>> I've tryed some c# stuff, but id did not work for me, to much trouble. I
>> wish to work with vb.net anyway.
>> Is there a tool/programm or something with less trouble, so i can choose
>> from different providers in the Web Site Administration Tool??
>>
>> (I tried to configure the iis but......it did not work)
>>
>> THX
>>
>> bhspam@xxxxxxxxxxx
>>
>>
>>


.

Relevant Pages

  • Re: application design problem
    ... Actual action is depends on your Provider which provide service for a particual database or data store. ... When I would click Button1 this sql would execute: ... I dont think its a good idea to put all your client spcific logic ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: DMX cmd cant see Access db
    ... into a SQL database - primarily to work around the issues you are running ... SQL Server Data Mining ... provider I'm trying to use in order to read data from an Access ... Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.datamining)
  • Re: .NET data provider or OLEDB provider?
    ... I don't see where you see a built-in query engine. ... There are third party tools that provider SQL parsing IIRC, ... >> database) is that the .NET model doesn't support scrollable, ...
    (microsoft.public.data.oledb)
  • ADO performance
    ... Sql database provider classes vs. the OleDb database provider classes. ...
    (microsoft.public.vb.database.ado)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)