View Complete Post
I am novice user to raizor syntax using webmatrix and i am trying to connect MS Sql server database (instead of using .sdf file i am using .mdf file) using the tool webmatrix for startersite.
The connection string that i setup as follows.
<?xml version="1.0"?><configuration> <system.web> <compilation debug="false" targetFramework="4.0" /> </system.web> <connectionStrings> <add name="OESConnectionString" connectionString="Data Source=.\SQLServer2005;AttachDbFilename=|DataDirectory|\OES_Data.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> </connectionStrings></configuration>
And i am using websecurity helper as well and the setup is as follows.
WebSecurity.InitializeDatabaseConnection("Data Source=INLTE5556\\SQLServer2005;Initial Catalog=OES;Integrated Security=True", "System.Data.SqlClient", "UserProfile", "UserId", "Email", true);
When i am trying to insert the user details into database i am getting the below error.
Format of t
MSDN Magazine November 2000
So I've intalled SQL 2005 Express and Sql Server Management Studio Express (SSMSE). I don't have any problems connecting to it using Windows authentication. But I would like to set it up so that I can log in using Sql Server Authentication with a username and password.
But I'm getting an error message of "A connection was successfully established with the server, but then an error occured during the login process. (provider: Shared Memory Provider, error: 0- No process is on the other end of the pipe) (Microsoft SQL Server, Error: 233).
What I've done
I've created a new "Login" in the Security node. Provided all necessary role access level. Granted permission to connect to database and enabled login.
I've used the Sql Server Surface Area Configuration to set the Remote Connection type to "Using TCP/IP only" or "Using Both TCP/IP and named pipes" (tried both, but in either situation I get the same error message when attempting to login to SSMSE with the user name and password). I also made sure to restart the service.
What do I need to do to fix this problem?
I am working on updating a reporting system that uses Crystal Reports. All of the 250+ reports were created in CR 8 and I have been opening up the old files in Visual Studio 2005 and updating the database location. All I have had to do with all connections to views and even a couple of stored procedures is create a new connection to the database and then update the old report's datasource location. The reason I need to update the location is so that the .NET application will use the correct driver. Everything has worked fine up until I got to one stored procedure. The old version of the report works perfectly with the stored procedure, but when I try to run the report using VS 2005 I keep getting errors.
First I connected to the database using the Oracle OLE DB provider, then updated the location of the stored procedure in the report. It then prompts me for the two parameter values for the stored procedure, both of which I keep as NULL so that the report parameters will be passed to the procedure. Then I get the following error:
Query Engine Error: 'ADO Error Code: 0x
Description: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'STORED_PROCEDURE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored'
HI, I am using VPN connection . When I try modify a file and try to checkin the file in sharepoint document library it does not gets checked in. I get a message saying
"Unable to checkin the file, since File is being edited in Local Draft, please close the application or discard the checkout ".
Please do the needful....
Hello Share Point experts,
For the first time I'm trying to connect to BDC in SharePoint. I created the Application Definition File and successfully uploaded it to the page. Here is the Authentication part of my ADF:
I'm new in using sharepoint and tried to use my windows xp home computer to connect on the company's network. However, when I am trying to join sharepoint as a client computer, I come up with the following message:
Run the wizard to complete networking setup
Problem however, is that the wizard doesn't run.
While I found info describing this issue for win 7 and vista, http://support.microsoft.com/kb/926505, I can't find any regarding XP home.
Can someone kindly assist?
I have recently combined my aspnet membership database and main website database into one database file, I'm happy with the schemas, stored procedures etc. (This is a development project not yet a production project.)
My problem is that I can no longer simultaneously connect to the database from Visual Studio if a user is logged in to the website.
Scenario 1: No user is logged in to the website. I can go to the Data Connection window in VS, choose "Add Connection" and then inspect the contents and schemas of the database. This is fine.
Scenario 2: A user is logged in on the website. I try to connect to the website in VS and get the error:
"Cannot open user default database. Login failed. "
Scenario 3: I am connected to the database in VS and nobody is logged into the website. If someone tries to log into the website they get the following error:
So it seems from the above that there can be only one connection to the database at a time? However this was not the case before I combined the membership database with the main website database. I could always make changes as a user logged