Need Desperately Your Help
Apr 3, 2006
Hi all,
I am trying to connect my sql through a wireless network with no success. I can ping the sql server from my laptop pc(windows xp home while the server uses windows professional)but i cannot connect it...
I went to client network utility where i set up the port 1433 and the ip address for the server...I went to enterprise manager to register but nothing...I was trying to connect through sql analyser but again nothing...
I have disable any firewall from the server and the client(router etc)
I am stucked...please someone to help???
View 13 Replies
Apr 30, 2008
I have project table containing ID field and parentID field.
In this table I have three levels: program, project and taskorder. taskorder is a child of Project and project is child of program.
For example the table looks like below with ID, name and ParentID field :
ID Name parent ID
1 Program14 Null
2 Project1 1
3 Taskorder1 2
4 Taskorder2 2
I have another table survey table which is a child table of Project
table( project.ID= survey.projectID). This table contains the data for scores at the lowest level only ( that is task order in this case)The scoreID has only 3 values:1,2,3
the data in survey table lokks as folows:
projectID monthID questionID scoreID
3 1 1 1
3 1 2 1
3 1 3 2
3 1 4 3
3 1 5 2
4 1 1 1
4 1 2 1
4 1 3 2
4 1 4 3
4 1 5 2
In the above data for the projectID=3(taskordeer1) if I countthe number of 1's,2's and 3's in scoreID and group it for task order1 then I will have
the values as :scoreID count
1 2
2 2
3 1
and for task order2 then I will have
the values as :scoreID count
1 2
2 2
3 1
The question I have is :
In the above scenario how will I roll up the total of taskorder 3 and tasak order 4 into its parent project1 (using query only with out writing procedure and creating another table for totals):
in other words when I roll up for project1
I should get the data as follows for Project1:
the values as :scoreID count
1 4
2 4
3 2
View 1 Replies
View Related
May 28, 2007
Hai friends,
I am tired of searching for this. I need a help desperately from you, i want to use IN condition in an stored procedure i have searched in net but most of the answers are like making the whole statement to one parameter and adding the IN condition at last. Can any body help me how to pass parameters to the ?IN condition and how to write the stored procedure with the IN condition. Thankx in advance
View 4 Replies
View Related
Mar 13, 2006
Hi
I am currently working on my final year project for uni using vs 2005, sql server express and xp pro sp2.
Basically I created a website in asp.net and created a database in the app_data directory.
Everything was working fine up until last week until I downloaded sql server management studio. I was experimenting with the IDE and attached the database from the app_data directory of the website to the sqlserver management studio.
Ever since I havent been able to connect to the database and am very worried about it as I have spent a week tearing my hair out to no avail.
The error I am getting is:
Server Error in '/WebSite/Iftams Project' Application.
Cannot open user default database. Login failed.
Login failed for user 'RODNEY-DESKASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'RODNEY-DESKASPNET'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): Cannot open user default database. Login failed.
Login failed for user 'RODNEY-DESKASPNET'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734963
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84
System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197
System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42
System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83
System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160
System.Web.UI.WebControls.Login.AttemptLogin() +105
System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.ImageButton.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +171
System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
I believe that the connection string in my web.config is looking for the database in the app_data folder however the default database (whatever this means) is not set to the database I have or else the aspnet user is not allowed to see the database because ssms has corrupted the settings.
Please help!
Regards
Rodney
View 4 Replies
View Related
Jun 2, 2008
I have Microsoft SQL express server 2005 setup on one server and I have a website setup on another server, I am trying to get some data from the SQL server on the other one.
I am currently getting this error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) I have done plenty of searching on Google, and already been through the tutorial on changing the setting in ‘SQL Server 2005 Surface Area Configuration’ to allow remote connections
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspxhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
It works perfectly when I call data from my local machine.
Also I don’t know if it is a timeout issue, because I tested in on two other servers I have access to and it worked on one of them.
Any help would be very much appreciated.
Thanks in advance.
View 1 Replies
View Related
Jul 20, 2005
I'm a complete newbie. Need to insert a Company logo into a databasecolumn to use later on in a check printing application. Read how toinsert the pointer instead of the object into the column. Below iswhat I did:SET QUOTED_IDENTIFIER OFFGOINSERT INTO BankInfo(CoLogo) VALUES(0xFFFFFFFF)***Then I did this****DECLARE @Pointer_Value varbinary(16)Select @Pointer_Value = TEXTPTR(CoLogo)FROM BankInfoWHERE CMCo = '91'WRITETEXT BankInfo.CoLogo @Pointer_Value"\192.31.82.77DataCheckImagesWyattLogo.jpg"****This was straight out of a book and it seemed to work it gave me amessage that it was successful and when I view the data in the columnI can see the pointer0x453A5C436865636B496D616765735C57796174744C6F676F 2E6A7067*****But when I try to use the column in either Crytal Report or an AccessReport the Bank Logo does not show up. I also placed the logo on my Cdrive and tried pointing to it there with "C:WyattLogo.jpg" with nosuccess.It can't be this difficult to get a Company logo into a column. Idesperately need assistance. Remember I am the ultimate newbie. Ilooked at my first sql database last week. Thanks in advance for anyhelp, it is appreciated.
View 1 Replies
View Related
