Solving ReportViewer Rendering Issue on IIS7 | Reportviewer does not render in IIS 7
Posted by VINKAS Solutions Madurai Tamilnadu India in Report Viewer on December 23rd, 2009
Problem
Server Error:
404 – File or directory not found.
The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.
Solution
Adding this line in web config file:
<add name=”Reserved-ReportViewerWebControl-axd”
path=”Reserved.ReportViewerWebControl.axd” verb=”*”
type=”Microsoft.Reporting.WebForms.HttpHandler” resourceType=”Unspecified”/>
HOW TO: Change the Trust Level in web config file for a .NET Framework Assembly
Posted by VINKAS Solutions Madurai Tamilnadu India in Security on July 22nd, 2009
The good news is that most of the web applications I write work just fine in medium trust, so it’s very easy to run your ASP.NET app in partial trust. All it takes is a change to your web.config.
<location allowOverride="false">
<system.web>
<securityPolicy>
<trustLevel name="Full" policyFile="internal" />
<trustLevel name="High" policyFile="web_hightrust.config" />
<trustLevel name="Medium"
policyFile="web_mediumtrust.config" />
<trustLevel name="Low"
policyFile="web_lowtrust.config" />
<trustLevel name="Minimal"
policyFile="web_minimaltrust.config" />
</securityPolicy>
<trust level="Medium" originUrl="" />
</system.web>
</location>
ASP.NET runs at Full trust by default (trust levels didn’t exist in v1.0). Change the level attribute above to a different setting to change the permissions of your ASP.NET code. You can change your trust level, and here’s the rundown of what each one means:
- Full trust – your code can do anything that the account running it can do.
- High trust – same as above except your code cannot call into unmanaged code. i.e. Win32 APIs, COM interop.
- Medium trust – same as above except your code cannot see any part of the file system except its application directory.
- Low trust – same as above except your code cannot make any out-of-process calls. i.e. calls to a database, network, etc.
- Minimal trust – code is restricted from anything but the most trival processing (calculating algorithms).
patterns & practices Developer Center
J.D. Meier, Alex Mackman, Blaine Wastell, Prashant Bansode, Andy Wigley, Kishore Gopalan
Microsoft Corporation
August 2005
Applies To
- ASP.NET version 2.0
Summary
This How To shows you how to configure ASP.NET Web applications to run in medium trust. If you host multiple applications on the same server, you can use code access security and the medium trust level to provide application isolation. By setting and locking the trust level in the machine-level Web.config file, you can establish security policies for all Web applications on the server. Running at medium trust with ASP.NET version 2.0 is easier than with ASP.NET version 1.1 because when using ASP.NET 2.0, you have access to Microsoft SQL Server databases at medium trust. Medium trust still provides a constrained environment for isolating applications from one another and from shared server resources. Medium trust applications have no registry access, no event log access, and no ability to use reflection. Web access is limited to the network address that you define in the <<trust/>> element, and file system access is limited to the application’s virtual directory hierarchy. If medium trust policy is too restrictive, you can create and use a custom policy file.
Contents
Objectives
Overview
What’s New in 2.0
Medium Trust Summary
Summary of Steps
Step 1. Configure Medium Trust
Step 2. Lock the Trust Level
Step 3. Optionally Create a Custom Policy Based on Medium Trust
OleDbPermission, EventLogPermission and FileIOPermission
Developing for Medium Trust
Additional Resources
Objectives
- Learn how to develop Web applications using medium trust.
- Learn what has changed with partial trust Web applications in ASP.NET version 2.0.
- Learn about the constraints while using medium trust levels.
- Configure medium trust levels in your Web application.
- Modify trust levels to create your own custom trust levels.
Overview
By default, ASP.NET 2.0 Web applications and Web services run with full trust and applications can perform privileged operations and access resources subject only to operating system security and Windows access control lists (ACLs).
To lock down an ASP.NET application and to provide an additional level of application isolation in a hosted environment, you can use code access security to restrict the resources the application can access and the privileged operations it can perform. You do this by configuring the <trust> element as shown here.
<trust level="Full|High|Medium|Low|Minimal" />
The <trust> element supports a number of default trust levels. Each level in succession provides a more restrictive environment (with fewer code access security permissions) in which to run your application.
Internet service providers (ISPs) that need to host multiple applications from many different companies frequently use the medium trust level to help ensure that applications cannot read each other’s data or interfere with one another in any way. Medium trust also places restrictions on the types of shared system resources that the applications can access.
What’s New in 2.0
The main differences between ASP.NET version 1.1 and ASP.NET version 2.0 for the trust levels are the following:
- In ASP.NET versions 1.1 and 2.0, medium trust applications can access SQL Server databases because the SQL Server managed data provider does not demand full trust and SqlClientPermission is granted to medium trust applications.
- In .NET Framework version 2.0, the Oracle .NET data provider, the OLE DB .NET data provider, and the ODBC .NET data provider no longer demand full trust. This allows you to access SQL Server and other databases from partial trust applications. To use these providers from medium trust applications in ASP.NET, you need to customize policy and grant the appropriate permission: for example, OraclePermission, OleDbPermission or OdbcPermission.
- In ASP.NET version 2.0, SmtpPermission is available at full, high, and medium trust levels. This allows applications to send e-mail.
- In ASP.NET version 1.1, you had to grant code full trust to access the event log. This is no longer required in ASP.NET version 2.0, although you must still create a custom trust policy file to grant the EventLogPermission, as described later in this document.
Medium Trust Summary
The main constraints placed on medium trust Web applications are:
- OleDbPermission is not available. This means you cannot use the ADO.NET managed OLE DB data provider to access databases. However, you can use the managed SQL Server provider to access SQL Server databases.
- EventLogPermission is not available. This means you cannot access the Windows event log.
- ReflectionPermission is not available. This means you cannot use reflection.
- RegistryPermission is not available. This means you cannot access the registry.
- WebPermission is restricted. This means your application can only communicate with an address or range of addresses that you define in the <trust> element.
- FileIOPermission is restricted. This means you can only access files in your application’s virtual directory hierarchy. Your application is granted Read, Write, Append, and PathDiscovery permissions for your application’s virtual directory hierarchy.
You are also prevented from calling unmanaged code or from using Enterprise Services.
Summary of Steps
To use medium trust in your ASP.NET applications:
- Step 1. Configure medium trust.
- Step 2. Lock the trust level.
- Step 3. Optionally create a custom policy based on medium trust.
Step 1. Configure Medium Trust
To configure an application to run with medium trust, add the following element to either the application’s specific Web.config file in the application’s virtual root directory or to the machine-level Web.config file.
<trust level="Medium" originUrl="" />
Note If present, the originUrl attribute can be used by some permissions, such as WebPermission, to restrict connectivity to a defined set of addresses.
To configure all Web applications on a server to run with medium trust, add this element to the machine-level Web.config file located in the following folder: %windir%\Microsoft.NET\Framework\{version}\CONFIG.
By default, Web applications are configured to run with full trust as shown in the following default configuration from the machine-level Web.config file.
<location allowOverride="true">
<system.web>
<securityPolicy>
<trustLevel name="Full" policyFile="internal" />
<trustLevel name="High" policyFile="web_hightrust.config" />
<trustLevel name="Medium"
policyFile="web_mediumtrust.config" />
<trustLevel name="Low" policyFile="web_lowtrust.config" />
<trustLevel name="Minimal"
policyFile="web_minimaltrust.config" />
</securityPolicy>
<trust level="Full" originUrl="" />
</system.web>
</location>
To review the full set of permissions available to medium trust applications, view the Web_mediumtrust.config file.
Step 2. Lock the Trust Level
Application service providers or anyone responsible for running multiple Web applications on the same server should apply the medium trust policy setting in the machine-level Web.config file and then lock the trust level for all Web applications.
To do this, set the allowOverride attribute to false in the machine-level Web.config file, as shown in the following code example.
<location allowOverride="false">
<system.web>
<securityPolicy>
<trustLevel name="Full" policyFile="internal" />
<trustLevel name="High" policyFile="web_hightrust.config" />
<trustLevel name="Medium"
policyFile="web_mediumtrust.config" />
<trustLevel name="Low"
policyFile="web_lowtrust.config" />
<trustLevel name="Minimal"
policyFile="web_minimaltrust.config" />
</securityPolicy>
<trust level="Medium" originUrl="" />
</system.web>
</location>
By setting allowOverride=”false”, an individual developer is unable to override the medium trust policy setting in their application’s Web.config file.
Step 3. Optionally Create a Custom Policy Based on Medium Trust
If medium trust proves too restrictive, you can create a custom policy file based on the medium trust policy. For example, you might want to allow applications to do one of the following: connect to an Oracle database, write events to the Windows event log, or read files from a specified directory outside of the application’s virtual directory hierarchy.
To create a custom policy based on medium trust
- Copy the medium trust policy file web_MediumTrust.config located in the following directory to create a new policy file in the same directory: %windir%\Microsoft.NET\Framework\{Version}\CONFIG.Give it a name that indicates that it is your variation of medium trust; for example, it could be named customWeb_MediumTrust.config.
- Add the permissions that you want to grant. In the following example, the FileIOPermission is modified to allow read access to a specific directory outside of the application’s virtual directory hierarchy.
<PermissionSet version="1" Name="ASP.Net"> ... <IPermission version="1" Read="C:\SomeDir;$AppDir$" Write="$AppDir$" Append="$AppDir$" PathDiscovery="$AppDir$" /> ... </PermissionSet> - Create a new custom policy level in your machine-level Web.config file. The policy file is the name of the policy file you created in step 1.
<securityPolicy> <trustLevel name="CustomMedium" policyFile="customWeb_mediumtrust.config" /> ... </securityPolicy> - Configure applications to run at the new custom policy level by setting the trust level to “CustomMedium”. Your security policy will resemble the following example.
<system.web> <securityPolicy> <trustLevel name="CustomMedium" policyFile="customWeb_mediumtrust.config" /> <trustLevel name="Full" policyFile="internal" /> <trustLevel name="High" policyFile="web_hightrust.config" /> <trustLevel name="Medium" policyFile="web_mediumtrust.config" /> <trustLevel name="Low" policyFile="web_lowtrust.config" /> <trustLevel name="Minimal" policyFile="web_minimaltrust.config" /> </securityPolicy> <trust level="CustomMedium" originUrl="" /> </system.web>
OleDbPermission, EventLogPermission and FileIOPermission
Common permissions that you might need to add include:
- OleDbPermission
- EventLogPermision
- FileIOPermission
OleDbPermission
If you support multiple database server types, you need to grant OleDbPermission to Web applications in addition to SqlClientPermission, which is already granted by medium trust policy.
To extend medium trust policy to grant OleDbPermission
- Create a custom policy file and configure your application to use the custom trust level, as described in the “Modifying Medium Trust Policy” section earlier in this document.
- Add the following permission class to the <SecurityClasses> section.
<SecurityClass Name="OleDbPermission" Description="System.Data.OleDb.OleDbPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> - Add the unrestricted OleDbPermission to the “ASP.Net” named permission set, as shown in the following example.
<PermissionSet version="1" Name="ASP.Net"> ... <IPermission version="1" Unrestricted="true"/> ... </PermissionSet>
Locking Down Connection Strings
Adding the unrestricted OleDbPermission to your policy file means that your application can use any OLE DB provider on the server. In a hosted environment, an administrator may need to use the more advanced form of the OleDbPermission syntax to lock down connection strings used with OleDbPermission to allow access only to specific databases. The following example shows how to restrict access to a specific OLE DB data source.
<IPermission
version="1">
<add ConnectionString=
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\data\w4w.mdb"
KeyRestrictions=""
KeyRestrictionBehavior="AllowOnly"/>
</IPermission>
The <add> element supports the following attributes:
- ConnectionString. This element specifies a permitted connection string.
- KeyRestrictions. This element specifies additional connection string parameters that may or may not be added to the connection string depending on the value of KeyRestrictionBehavior. Specify connection string parameters using the syntax parameterName=. You can specify multiple parameters by delimiting each one with a semi-colon (;).
- KeyRestrictionBehavior. You can set this to AllowOnly or PreventUsage.
- If you use AllowOnly, only the additional connection string parameters specified in the KeyRestrictions attribute may be added to the connection string specified in ConnectionString.
- If you use PreventUsage, the connection string parameters specified in the KeyRestrictions attribute may not be added to the connection string specified in ConnectionString, although other connection string parameters may be added.
If no key restrictions are specified, and the KeyRestrictionBehavior attribute is set to AllowOnly, no additional connection string parameters are allowed.
If no key restrictions are specified, and the KeyRestrictionBehavior property is set to PreventUsage, additional connection string parameters are allowed.
EventLogPermission
Medium trust policy does not permit access to the Windows event log.
To enable access to the event log
- Create a custom policy file and configure your application to use the custom trust level, as described in the “Modifying Medium Trust Policy” section earlier in this document.
- Add the following permission class to the <SecurityClasses> section to the custom policy file.
<SecurityClasses> ... <SecurityClass Name="EventLogPermission" Description="System.Diagnostics.EventLogPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> ... </SecurityClasses> - Add the following EventLogPermission to the “ASP.Net” named permission set.
<PermissionSet version="1" Name="ASP.Net"> ... <IPermission version="1"> <Machine name="." access="Write"/> </IPermission> ... </PermissionSet>
Note At the time of writing, you must set access=”administer” to be able to write to the event log from a partial trust application.
Creating Event Sources
If your application needs to use application specific event sources, you should create them at installation time when administrator privileges are available. A good approach is to use a .NET installer class, which can be instantiated by the Windows Installer (if you are using .msi deployment) or by the InstallUtil.exe system utility.
If you are unable to create event sources at installation time, and you are in deployment, the administrator should manually create new event source entry beneath the following registry key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\<LogName>
Note You should not grant write permission to the ASP.NET process account (or any impersonated account if your application uses impersonation) on the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\ registry key. If you allow write access to this key and the account is compromised, the attacker can modify any log-related setting, including access control to the log, for any log on the system.
FileIOPermission
If you need to allow your application to access files outside of the application’s virtual directory hierarchy, you can create a custom policy file based on the medium trust file, and then modify the FileIOPermission.
For example, the following definition enables an application to read files in the “C:\SomeDir” directory.
<IPermission version="1" Read="C:\SomeDir;$AppDir$" Write="$AppDir$" Append="$AppDir$" PathDiscovery="$AppDir$" />
By letting applications access files beyond the application’s virtual directory hierarchy, you diminish the ability of code access security to provide application isolation. If you have multiple applications on a single server, you need to protect resources, such as files with ACLs, and use separate identities for each application.
Developing for Medium Trust
To help design and develop your applications for medium trust, consider the following:
- Identify the types of resources that your application needs to access and the privileged operations it needs to perform.You need to know which code access security permissions your application requires. For more information about permission requirements, see the “Resource Access Permissions Summary” and “Privileged Operation Permissions Summary” sections in How To: Use Code Access Security in ASP.NET 2.0.
- Know what permissions are available at medium trust.The best way to learn what permissions are available is to open and examine the web_MediumTrust.config file in the following folder: %windir%\Microsoft.NET\Framework\{Version}\CONFIG.
- Configure your development environment and your application’s Web.config file for medium trust.Do this at the start of development so that you can immediately see what permission requests fail and what issues need to be addressed.
- For existing applications, consider using the Permcalc tool.If you have an existing application that you want to run at medium trust, consider using the Permcalc tool to help you determine precisely which permissions your application needs. You should also make sure that extensive testing is performed to verify that all code paths through your application have been executed. Failure to do so can lead to unexpected security exceptions at run time.
The best approach is to target your trust level before you begin design and development work and to design and develop specifically for this trust level. Common causes of security exceptions when you switch an existing application to medium trust include:
- Calling unmanaged code.
- Accessing the registry.
- Writing to the event log.
- Connecting to databases other than SQL Server.
- Accessing Web resources on remote servers.
- Accessing the file system beyond your application’s virtual directory hierarchy.
Additional Resources
Feedback
Provide feedback by using either a Wiki or e-mail:
- Wiki. Security Guidance Feedback page: http://channel9.msdn.com/wiki/default.aspx/Channel9.SecurityGuidanceFeedback
- E-mail. Send e-mail to secguide@microsoft.com.
We are particularly interested in feedback regarding the following:
- Technical issues specific to recommendations
- Usefulness and usability issues
Technical Support
Technical support for the Microsoft products and technologies referenced in this guidance is provided by Microsoft Support Services. For product support information, please visit the Microsoft Product Support Web site at http://support.microsoft.com.
Community and Newsgroups
Community support is provided in the forums and newsgroups:
- MSDN Newsgroups: http://msdn.microsoft.com/newsgroups/default.asp
- ASP.NET Forums: http://forums.asp.net
To get the most benefit, find the newsgroup that corresponds to your technology or problem. For example, if you have a problem with ASP.NET security features, you would use the ASP.NET Security forum.
Contributors and Reviewers
- External Contributors and Reviewers: Jason Taylor, Security Innovation; Rudolph Araujo, Foundstone Professional Services
- Microsoft Consulting Services and PSS Contributors and Reviewers: Adam Semel, Tom Christian, Wade Mascia
- Microsoft Product Group Contributors and Reviewers: Stefan Schackow
- Test team: Larry Brader, Microsoft Corporation; Nadupalli Venkata Surya Sateesh, Infosys Technologies Ltd; Sivanthapatham Shanmugasundaram, Infosys Technologies Ltd.
- Edit team: Nelly Delgado, Microsoft Corporation; Tina Burden McGrayne, TinaTech Inc.
- Release Management: Sanjeev Garg, Microsoft Corporation
Free Download – BotDetect ASP.NET CAPTCHA Control
Posted by VINKAS Solutions Madurai Tamilnadu India in Control on July 13th, 2009
Developer Tools
- Developer Tutorials
- IDE Software
- Interpreters & Compilers
- Java Software
- Programming Software
- Software Installation Tools
BotDetect ASP.NET CAPTCHA
-
LicenseFree to try
-
Average User Rating: (out of 1 votes) Rate it!
-
Downloads
-
RequirementsIIS, .NET 1.1 – 3.5
-
LimitationsNo limitations
-
Date Added08/07/2009
Click here Download
Upper Deck International is seeking Senior ASP.Net Developer – Asp.Net Jobs
Posted by VINKAS Solutions Madurai Tamilnadu India in Jobs on July 13th, 2009
Upper Deck International is seeking Senior ASP .Net Developer
Functieomschrijving
Upper Deck International B.V. with headquarters based in Weesp, The Netherlands is a premier entertainment publishing company and the industry leader in trading card games such as World of Warcraft and Huntik, delivering a portfolio of innovative and multi-dimensional product experiences to collectors, and sports and entertainment enthusiasts. Upper Deck International BV also develops, produces and distributes toys, puzzles, trading cards, stickers, family card games, board games, miniature board games, figurines, coins and various other collectible products. The organization is growing rapidly by entering new categories, expanding territories and by gaining new distribution channels. Upper Deck International B.V. has offices in Italy, UK, France, Germany, Japan and Australia. The team is very enthusiastic and informal with a strong focus on team work and results. More information: www.upperdeck-international.com
The following values are important to Upper Deck International B.V.:
Innovative: Out of the box thinking, create new ideas;
Quality driven: Strive for the best, involve all departments;
Flexible: Able to reach deadlines, pro active, take calculated risks;
Team player: Respect, accept & trust others, give and receive constructive feedback, communicate openly;
Dedication: Go for the extra mile, be goal oriented, enthusiastic, care for the business.
Senior ASP .Net Developer
(Front- and Back-end)
(vacancy code M906007)
The department:
The online development team is part of the marketing department. The Marketing department is responsible for designing successful product launch programs, marketing campaigns and coordination with branches throughout Europe in order to support the revenue goals of the organization. The department works closely together with the Sales, Product Development, Finance, Online communication and Organized Play departments. The department is multicultural and reflects the international environment of the organization.
Main purpose of the role:
Upper Deck International (UDI) is looking for an enthusiastic ASP.Net developer to strengthen our online department. You will maintain existing and create new online solutions for our Trading Card Games like Huntik and World of Warcraft, as well as our different toy lines.
As part of the online team (currently a junior developer and a graphic designer) you give direction to the technological infrastructure of current and future projects.
Responsibilities include front-end development, creation and migration of databases, and the creation of Functional Design Documents. You will also function as a team- and project lead.
This role requires coordination with your team, other departments within UDI, the Digital team in the USA, and external vendors.
You report to the Marketing Director.
Key Relationships:
Internal: Marketing Department / Category Managers / Production Department / Online communication
External: Photographers if necessary / Translators / Copywriters / Agencies / Printing houses
Goals and deliverables:
- Responsible for managing tasks and workload within the online team
- Coordination with the Digital Team in the USA
- Coordinating and implementing large database migrations from external servers
- Keeping current websites up-to-date and relevant
- Implement relevant online solutions (front- and back-end)
- Initiate new (internal) online projects, meeting deadlines for product releases
- Create and maintain project planning and overview
- Maintaining relationships with vendors and negotiating costs and services.
- Maintain archives and documentation
- Reporting on online traffic statistics
- Have knowledge of online user behavior, and be able to design and implement practical user interfaces.
- Communicate project status, progress and results to Marketing Director and keep up to date on the overall status of all online projects;
- Participate in meetings, discussions and presentations, including the development and presentation of prototypes to Marketing team.
Competences:
Accuracy: Considers all sub-elements in carrying out tasks, works with a high degree of accuracy.
Involvement: Takes assigned tasks seriously and makes an effort to complete them.
Creativity: Creates new and inventive approaches to work-related problems;
Listen attentively: Shows that he/she is listening to others through posture and conduct;
Advisory skills: Presents ideas and solutions based on knowledge and experience to facilitate decision-making by others.
Problem Solving: Gathers analyses and evaluates information effectively and subsequently designs timely and adequate solutions.
Team player: Motivated individual working together within a multidisciplinary team to reach business goals.
Other requirements:
- More than 5 years of relevant experience in ASP.NET development
- HBO education level or higher
- Project Management experience
Knowledge of:
- SQL database structures
- Javascript, XML, CSS, HTML, IIS
- Microsoft Visual Studio 2008, Microsoft SQL Server 2005, and Microsoft Windows Server 2003
- Experience with Dot Net Nuke is a plus
Personal:
- Analytical; problem solver
- Ability to find solutions in a complex technical environment
- Driven by results
- Ability to work under pressure
- Fluent in Dutch and English
- Ability to communicate complex IT issues to a non-technical audience
Start date : as soon as possible
Salary: Market Standard and Upper Deck benefits
Interested?
Upper Deck International offers a challenging position in an international work environment. We stimulate initiative and creativity. Next to a remuneration package that meets market standards with good fringe benefits, Upper Deck International offers you an exciting opportunity to work for a large worldwide leader in entertainment products. We are an ambitious company. Feel free to respond if you fit the profile. Please send your motivated application letter and resume (in English) by e-mail jobsude@upperdeck.com.
For more information please call Human Resources at +31 294 461 629.
This vacancy is also findable under: ASP .Net Development – .Net Ontwikkelaar – Ontwikkelen – Develop – Implementatie Specialist – IT – ICT – Sr. – Ervaren – Coordinator – Coördinator – Project Manager – Projectmanager – Projectleider – Vacature Weesp – Vacature Noord Holland – HBO
Acquisition as a result of this vacancy is not appreciated.
Bezoek onze website voor meer informatie over deze vacature.
How connect mysql in asp.net
Posted by VINKAS Solutions Madurai Tamilnadu India in MySql on June 27th, 2009
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Server=myServerAddress;Port=-1;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Server=serverAddress1 & serverAddress2 & etc..;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Encryption=true;
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;default command timeout=20;
Specifying connection attempt timeout
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Connection Timeout=5;
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Ignore Prepare=true;
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Port=3306;
The value is ignored if Unix socket is used.
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Protocol=socket;
Use “pipe” to use a named pipes connection, “unix” for a Unix socket connection and “memory” to use MySQL shared memory.
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; CharSet=UTF8;
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Shared Memory Name=MYSQL;


Recent Comments