You searched for the word(s): userid:827387

More Search Options

RSS Available

• Re: Unable to open the physical file . Operating system error 5: "5(failed to retrieve text for this error. Reason: 15105)". An attempt to attach an auto-named database for file failed. A database with the same name exists, or specified file cann

  Hi Jian Kang, I suspect it could be permission problems too. But I have tried to configure but still there are errors. Here it's the connection string: <add name="TDPdb" connectionString="Server=(local)\SQLExpress;Database=TDPdb;uid=sa;pwd=abc;"/> I'm sorry, I have upgraded by system to Windows 7. Are their configurations roughly the same? Thanks.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by germaine.tay on 12/9/2009

• Cannot open database "dbName" requested by the login. The login failed. Login failed for user 'sa'.

  Hi. I have checked and ensured that the enabled box for the sa login is checked. However, I still have error message prompting that there is error login using username: sa May I know could this be due to the permissions settings? Apparently, I have done my development on a Windows XP PC. I copy and moved everyfile from the XP PC over to my pc which is Windows 7, and it can't work. Everything works perfectly fine in the Windows XP PC. <add name="database" connectionString="Server

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by germaine.tay on 12/4/2009

• Re: Cannot open database "dbName" requested by the login. The login failed. Login failed for user 'sa'.

  Hi all, thank you for your prompt reply. However the error message that I have faced occured in the web service and not the SQL Server 2005. In the MSSQL, I'm able to log in as sa. This is my web service function... <WebMethod(EnableSession:=True, Description:="Get Schools")> _ Public Function RetrEventNum() As DataTable Dim dtTable As DataTable Try conn = New SqlConnection(strConnection) cmd = New SqlCommand("stp_retrEventNum", conn) cmd.CommandType = CommandType.StoredProcedure

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by germaine.tay on 12/4/2009

• Unable to open the physical file . Operating system error 5: "5(failed to retrieve text for this error. Reason: 15105)". An attempt to attach an auto-named database for file failed. A database with the same name exists, or specified file cannot b

  Hello there. I have upgraded my operating system to Microsoft Vista. Now I need to try my website and the web services that I have created will work in Vista platform. However, I faced this problem, I supposed to be a SQL Server error. I have done all the search and necessary amendments to the SQL settings. However, I still faced this problem. Please kindly assist. Error message encountered: Unable to open the physical file "D:\TDP System Development\DotNetNuke Website1\App_Data\Database.mdf"

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by germaine.tay on 12/2/2009

• Unable to add web reference - Access Denied

  Hi. I have changed my operating system from Wins XP to Wins Vista Business. Everything runs smoothly in Wins XP; including the adding of web references. However, after I changed my OS. I could not update my Web References. It prompted me error msg like failed to add web reference. access denied. Please advise.

  Posted to Installation and Setup (Forum) by germaine.tay on 12/2/2009

• Re: Unable to add web reference - Access Denied

  I have created my own web services. So I am adding my web services.

  Posted to Installation and Setup (Forum) by germaine.tay on 12/2/2009

• Re: button repeat twice

  Yup! Thanks!

  Posted to Web Forms (Forum) by germaine.tay on 8/16/2009

• import excel spreadsheet to SQL Server 2005

  Hi, I have a event table that has the following attributes: 1. EventDetailsID int (Identity) 2. StudID int 3. AcadLevel int 4. Remarks varchar(50) When I uploaded the excel spreadsheet to the server, at the sbc.WriteToServer(dtDataTable) line, error occured. The error message is as followed: Received an invalid column length from the bcp client for colid 1. Could it be related to the Identity? Because without the Identity, it's able to work. I need this Identity to work as a Primary Key in this

  Posted to Data Access and ObjectDataSource Control (Forum) by germaine.tay on 8/16/2009

• button repeat twice

  Hi, I have a "Save" button in my web page that allows user to save a document. I run through the debugger and realized that this Save button actually run through twice, which I do not know why it happens. As I only click once for the doc to save. Is this a bug? I have put statement like Exit Sub, to make sure it's exited. but still it will do twice. Thanks! Protected Sub btnSave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSave.Click If btnYes.Checked Then '

  Posted to Web Forms (Forum) by germaine.tay on 8/15/2009

• Re: Transferring an updated excel spreadsheet into SQL database

  For each drRow as DataRow in objDataTable.Rows str1=drRow("ExcelColumn1") str2=drRow("ExcelColumn2") Next so I will put the details in each row in the datatable to compare with the information in the database. so that means I would also have to pull information from my databae and compare with the values in the excel ya? Thanks!!

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by germaine.tay on 8/13/2009