Search results matching tag 'provider'

Migrate from System.Data.OracleClient in two simple steps with Devart

corelab — Tue, 06 Oct 2009 04:00:00 GMT

Devart offers dotConnect for Oracle – fast and reliable ADO.NET provider for the wide range of users. Our ADO.NET provider is the most compatible with OracleClient. dotConnect allows you to migrate from MS OracleClient just in two simple steps.
As you might know from ADO.NET team blog Microsoft announced deprecation of OracleClient as a part of ADO.NET roadmap and strongly recommended to use third-party ADO.NET providers for Oracle instead of continuing to use Microsoft’s OracleClient for new application development.
We have researched problems, which users may encounter migrating from OracleClient to dotConnect for Oracle and found two major. They are Interface differences and Behavior differences. Devart reduces all them just by 2 simple actions. Almost all differences in the names of the classes, methods, and fields between OracleClient and dotConnect for Oracle were removed. Migration Wizard will solve the problems with the minor differences that still exist so you don't have to learn new interface. All behavior differences will be simply reduced just by inserting one string to your code. As simply as that.
What benefits you have using dotConnect for Oracle? We offer you to choose the best Edition to fit your needs. You need functionality similar to OracleClient — get it for FREE! Choose our FREE Express edition! If you want to develop and deploy database applications with ease or you need some advanced features and all functionality of Oracle — choose one of our Advanced Editions. Their prices start just from $149.95. To learn more, download trial and free editions, or order a license welcome to Devart site: www.devart.com/dotconnect/oracle/.
To read full size article with pictures and examples visit dotConnect's team blog: http://www.devart.com/blogs/dotconnect/?p=67 .
Enjoy simplicity of migration with us! About Devart Devart (formerly known as Core Lab) is a software development company with 11 years of experience on the software market and over 20 thousands of devoted users. We specialize in providing native connectivity solutions as well as comprehensive development and management tools for the most popular databases, including Oracle, SQL Server, MySQL, PostgreSQL, InterBase, Firebird, and SQLite. For additional information about Devart, visit www.devart.com/company/.

MPS provider for BES in HMC4

carlosarroba — Sat, 19 Sep 2009 04:00:00 GMT

Hello,

I´m goint to install BES 4.1 in our HMC4 platform, so I need an MPS provider for BES provisioning.

Where can I get the provider?

Can someone send me the provider, or tell me where to get it?

Thank you,

Carlos Arroba.

Save/Retrieve data in profile property

Svetlana Proycheva — Wed, 19 Aug 2009 04:00:00 GMT

My application uses custom objects, stored in profile properties, to store and manipulate data cross pages. It works properly in Visual Studio but does not function all right from the Internet. I thought Serialization caused problems. So I made a test with a simple string profile property instead of a custom class one. The problem still persists:

</properties>

</profile>

protected void Save_Button_Click(object sender, EventArgs e)

{

Profile.Text = Input_TextBox.Text;

}

protected void Retrieve_Button_Click(object sender, EventArgs e)

{

if (Profile.Text != "")

Output_TextBox.Text = Profile.Text;

else Output_TextBox.Text = "Empty";

}

I type some text in Input_TextBox, click on Save_Button, then on Retrieve_Button. The result in Output_TexBox varies:

* When run in Visual Studio: Output_TexBox shows profile property stores the input data.

* When run in Internet: Output_TexBox shows profile property is empty.

The same problem ocurres with session variables. Do I miss something or it’s a server configuration issue?

sql server express 2008 to 2005 --> provider not working

golden_eagle — Thu, 14 May 2009 04:00:00 GMT

I just uninstalled SQL Server Express 2008 and installed 2005 instead because 2008 wouldn't reinstall

SQL Server 2005 seems to be working just fine, but in Visual Web Developer Express 2008 the membership provider no longer works properly because it is not connecting to SQL Server anymore

When I click "Test" next to
WAT > Provider Config. > Select a single provider... > AspNetSqlProvider
I get this message:

Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.

Here is the connection string from the machine.config file:

<add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>

Providers and Entity Data Model

stevoman — Wed, 29 Apr 2009 04:00:00 GMT

I am just planning an application which requires extensive extra functionality from the membership and role providers, so I need to develop new ones. I am planning on using SQL Server as a backend store, and an Entity Data Model to provide code to data mappings throughout the application.

One issue I am now considering is the level of integration of the providers into the data model. Two options seem to be obvious:

1) To build the data model to encompass all the membership, profile, and role classes within the whole application model.

+ Better strongly typed access to all relevant classes the application needs.

2) To build seperate data models for the providers, and link between them based on User ID type keys.

+ Providers are less tightly coupled, and will be easier to modify or replace.
+ Fits better with the ethos of interchangable code blocks. Reusing code will be easier.

Each approach seems to have advantages and disadvantages as noted. Because of the extra functionality needed, the argument for using replacable code blocks seems to carry less weight, so I am veering toward using one monolithic backend store and data model for the entire application.

Are there any other factors (aesthetic, performance, reusability, vileness of design, or other) to either of these approaches that I should consider? Any comments on either approach? Or is there a third way that's better than both?

Thanks,
stevoman

How to implement different access levels within the same Role

vialetti — Fri, 17 Apr 2009 04:00:00 GMT

Hello all.
I am about to develop a web app for managing information that is grouped into different areas or departments, and each one should have an administrator.

I am going to create the following roles using the ASP.NET Forms Roles and Membership providers:

Super Admin
Group Admin
Regular User

Group Admin and Regular User need to have access to the information only in their own groups.

For example, if the groups are: London, Berlin, Rome, then the Rome people should see only the Rome information, and have NO access to London and Berlin information. The different groups are going to be created by the Super Admin. When a new group comes in he creates it, and then creates the admins and users for it.

The roles describes above solve the problem of having different access to certain web pages, but I still don't have a way to distinguish if they belong to London or Berlin or Rome.

So, for this, I am creating fields in my database tables. For example, I have one table called "Contact" which holds the contacts for every group, that table looks something like this:

ContactId
First name
Last name
Phone
Address
GroupId

In "GroupId" I will save the Id of the group that contact belongs to (London, Berlin, or Rome).

And for the Users I will have to create a Profile table of my own and link it to the Membership users, so I can save this extra info for each user:

GroupId

In that field I will save the Id of the group that user belongs to.

In the contact and contact admin web pages I will run a check at the first of the code behind that checks the current logged in user's Group Id and then show only his contacts.

Ok this is the general Idea of my problem and my suggested solution.

I am posting this because I keep wondering if it is the right way to do it or should I create the following Membership Roles:

Super Admin
London Group Admin
Berlin Group Admin
Rome Group Admin
London Regular User
Berlin Regular User
Rome Regular User

My fear of doing so is that I will end up with dozens of roles after a while. And that I will have to create tools for changing the Membership Roles dynamically, is that recommended, safe, etc?

What do you think?

create database infra-structure to Providers

Rodrigo Braga — Wed, 18 Mar 2009 04:00:00 GMT

where can I find SQL scripts to prepare database to use Providers (Membership, Role...) offered by MySQL Connector (6.0 or above)

thanks

MySQL TableProfileProvider

schadha — Tue, 17 Feb 2009 05:00:00 GMT

I urgently need TableProfileProvider with Mysql, and in VB.Net. I can work with C# as well, but it still needs to be in MySQL.

Can anyone please help me with this.

Thanks

Sandy

Extending Role Provider

monkeylee — Fri, 06 Feb 2009 05:00:00 GMT

Hi All, I have started work with the membership providers and roles, I want to use the standard sql based role provider but it only stored the role name, id and app name, is there a way to add an additional field forexample section that I can access for the provider api? or do I need to implement a custom role provider, if so is the above still possible? and can I get/use the code for the default sql role provider for the standard methods such as isUserinrole etc Any direction would be appreciated thanks Lee

3.5 Framework SP1 Membership Provider fails

Nannette — Thu, 13 Nov 2008 05:00:00 GMT

I have windows 2008 web server edition and IIS7, and sql server 2008 web server edition. I am using 3.5 framework with SP1.

On my windows 2000 server and database servers, I use asp.net membership with no problems. But I am having login problems using the membership provider with 2008 and IIS7. I have no problems viewing grids and doing database things that do not require log in. It only effects the membership provider logins and other functionality.

In the app pool I did this:

Set the identity on the app pool in IIS7 to "NetworkService" I tried both Integrated and Classic.

I have forms authentication enabled and anonymous authentication with my SQLIISUser and the password inserted in the IIS7 for this website.

I have tried a connection string with both windows authentication and sql server authentication:

I was told to: update your connection string to "Integrated Security=SSPI;" not "Integrated Security=true;" - which I did.

This gives login failed for anonymous user error:

This gives log in failed for SQLIISUser.

<add name="XXConnectionString" connectionString="Data Source=xx.xx.xx.xx;Initial Catalog=XX;

Persist Security Info=True;User ID=SQLIISUser;Password=XXXXXX"

providerName="System.Data.SqlClient" />

My membership settings also include:

</appSettings>

<system.web>

</providers>

</membership>

</providers>

</roleManager>

On the SQL Server 2008 database, I have the SQLIISUser setup as a user, and given dbdatareader and dbdatawriter and public permissions on the database. I also have a "NT AUTHORITY\NETWORK SERVICE" user with db_owner access.

Again, all database connections work fine remotely, with windows authentication and with sql server authentication if only viewing data in a grid or doing inserts or updates, etc. But once I try to use the membership stuff, that's where it fails.

Please help.

Partial stack trace for login failed for sql user:

System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4844759

System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194

System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392

System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +35

Thanks!