I'm doing a bulk insert to a sql server and when I do so, the SQL server connection string I have is logged in as admin, but when I press the "submit" button I'm getting this error. The file that I'm trying to open is in a folder with admin read/write access and as I said the SQL connection string is for the admin account. Anyone have any idea what causes this?
View 1 RepliesI have two servers. One is a web server and one is a sql server. What I'm trying to do is as follows: User uploads a document to a web site. File is stored on a web server in a directory, verified that it's a certain type of file, and saved. When the user presses a submit button, the page is uploaded and the Onclick event triggers a sql bulk insert (not on the same web server.) That's it in a nutshell. The basics of this page are done. The file can be saved but for whatever reason, I'm getting a Operating system error code 3(The system cannot find the path specified.) I've modified the machine.config on the web server to impersonate another user. I've made sure that the directory in question can be reached from both servers (and it can.) I can open/edit/delete the file from the directory from both sides, but evidently that's not the issue.
View 2 Replieshere's hte problem I have.
I create a simple page inserting data to Microsoft access 2007. On my local computer, I have no problem inserting both arabic and english. but after i upload the app on production server. its not working.
heres' the error message "
Selected collating sequence not supported by the operating system.
After hours searching on google, alot ppl said its version issue, but I have english access 2007 installed on my computer and admin told me they have english access 2007 installed on the server too.
what else should i check?
Is there a way in ASP.Net to find out the browser and operating system of the user?
View 1 RepliesI'm looking at building an exhaustive function that returns a friendly name for the Users Operating System.
I think I have most of the Windows stuff down, but I'm not sure about Linux, OSX, and others.
Does anyone know where I can find an exhaustive list of HTTP_USER_AGENT's
'Gets the users operating system
Public Shared Function GetUserOS() As String
Dim strAgent As String = HttpContext.Current.Request.ServerVariables("HTTP_USER_AGENT")
'Windows OS's
If InStr(strAgent, "Windows NT 6.1") Then : Return "Windows 7"
ElseIf InStr(strAgent, "Windows NT 6.0") Then : Return "Windows Vista"
ElseIf InStr(strAgent, "Windows NT 5.2") Then : Return "Windows Server 2003"
ElseIf InStr(strAgent, "Windows NT 5.1") Then : Return "Windows XP"
ElseIf InStr(strAgent, "Windows NT 5.0") Then : Return "Windows 2000"
ElseIf InStr(strAgent, "Windows 98") Then : Return "Windows 98"
ElseIf InStr(strAgent, "Windows 95") Then : Return "Windows 95"
'Mac OS's
ElseIf InStr(strAgent, "Mac OS X") Then : Return "Mac OS X"
'Linux OS's
ElseIf InStr(strAgent, "Linux") Then : Return "Linux"
Else : Return "Unknown"
End If
End Function 'GetUserOS
I basically want to return better results for Mac OS and Linux OS's. It's better in my opinion to say OSX Snow Leopard or OSX Tiger rather than just Mac OS X.
Error:
Executed as user: MACSTEELUSA.COMsa. ...9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:00:17 PM Error: 2010-06-02 20:00:18.56 Code: 0xC0202009 Source: CRM_ORACLE_ARSUMMARY Connection manager "SourceConnectionOLEDB" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Oracle client
and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.". End Error Error: 2010-06-02 20:00:18.58 Code: 0xC020801C Source: Data Flow Task Source - Query [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireCon... The package execution fa... The step failed.
Tasks Taken:Went to this folder checked for tnsnames.ora file but it is in good shape.
C:ORACLEproduct11.2.0client_1
etworkadmin
I am trying to run a script to build a database structure for open source app nopcommerce. When I try to run the script via sql management studio I receive and error (below). I am running sql express on the hosting server. I also have issues connecting via management studio directly to the sql server installation, but am able to connect via remote desktop. I dont know specifics about the installation since I was not the one to install it.
View 1 RepliesI receive the following error in the code below: System.NullReferenceException: Object reference not set to an instance of an object. When I am logged into the page I do not receive the error. My Code:
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub SqlDataSource4_Selecting(ByVal sender As Object, ByVal e As SqlDataSourceCommandEventArgs) Handles SqlDataSource4.Selecting
Dim MemUser As MembershipUser
MemUser = Membership.GetUser()
UserID.Text = MemUser.ProviderUserKey.ToString()
e.Command.Parameters("@UserId").Value = MemUser.ProviderUserKey.ToString()
End Sub
End Class
I read the following online: You are trying to use a reference variable who's value is Nothing/null. When the value is Nothing/null for the reference variable, that means it is not actually holding a reference to an instance of any object that exists on the heap. You either never assigned something to the variable, never created an instance of the value assigned to the variable, or you set the variable equal to Nothing/null manually, or you called a function that set the variableto Nothing/null for you. The following is the Arthur's code example and his suggested fix which I am sure is right:
Private Sub TestString()
Dim a As String
If a.Length = 0 Then
Console.Write("Yes")
End If
End Sub
"System.FormatException was unhandled by user code - Input string was not in a correct format"
This is driving me crazy! Can anyone see what the problem is?
[Code]....
I get and error when I run a sub select statement. What is wrong with the statement?
[Code]....
[Code]....
ERROR:
System.Data.SqlClient.SqlException: Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.
I added a button click event to my project as:
But since this i am getting this error saying:
Cannot implicitly convert type 'string' to 'System.Web.UI.WebControls.TextBox
There seems to be no error in my code.
I am getting error "Cannot implicitly convert type 'string' to 'System.Data.DbType".
When I am passing Stored procedure parameter it expets 'System.Data.DbType" and the Data member is declared as a string.
I am facing the following problem when i try to add record in database. "System.Data.SqlClient.SqlException: A severe error occurred on the current command.The results, if any, should be discarded." This exception occurs occasionally, and the sql server log shows the following error whenever the above exception occurs:
Server,Unknown,A user request from the session with SPID 54 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
[Code]....
View 1 RepliesI am using the SQLDataReader to execute a Stored Procedure that accepts two parameters (BuildingTID and Department) to return the appropritae Value in my case The Director of the Department. My problem is I get the following error when I run the code that I added below for review. Let me also add that the user is selecting the values that I am using for the stored procedure from 2 DropDownLists. I am getting it when I try to assign the value that is in the Department DropDown
list to the first parameter.
Dim myParm As SqlParameter = getDirectorsCMD.Parameters.Add("@BuildingTID", SqlDbType.Int, 15).Value = (ddlDepartment.SelectedValue)
Also obviously there are more issues with my code than just the error because the datareader records property is false meaning I am not returning a row
I can't find my syntax error. Here is my code behind:
[Code]....
I have been running a VWD 2008 express and sql server 2008 express based system both on local server and website successfully, then started getting this error message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Now I cannot run this system on either local server or website.
View 3 RepliesI am attempting to use SqlBulkCopy to import data from an XML document. I receive the following error when executing WriteToServer: Invalid cast from 'System.String' to 'System.Guid'
View 1 RepliesAn unhandled exception of type 'System.InvalidOperationException' occurred in System.Xml.dll
View 1 RepliesI have a website having an aunthentication system. When I am setting my website on IIS 6 the code is absolutly working fine. But when i configure the website on IIS 7 (Windows 2008 server) it is showing me the above error. I am using a stored procedure for it
View 3 RepliesI had to format my hard disk and reinstall the Visual Studio 2005 Enterprise and SQL 2005 Standardprograms.
While my program worked perfectly before and still works ok on my second computer, I get the following error message on the formated computer:
Parser Error Message: Type 'System.Web.UI.WebControls.Parameter' does not have a public property named 'DbType'.
Source Error:
Line 82: <asp:Parameter Name="Olho" Type="String" />
Line 83: <asp:Parameter Name="image" Type="String" />
Line 84: <asp:Parameter DbType="Date" Name="inicio" />
Line 85: <asp:Parameter DbType="Date" Name="termino" />
Line 86: <asp:Parameter Name="pageId" Type="Int32" />
Source File: /0_oserigrafico/Default.aspx Line: 84
In this case I use a datasource control for a datalist and the parameter list is being built ba the system.
The DBType is created for the smalldatetime feild
how do I add the property named 'DbType'.
Background: I use SQL server 2005 developer edition and visual studio 2008. Visual studio 2008 is running on a local machine with Vista business edition. SQL server is running on a remote server using Windows server 2003. Both computers are within the same domain.
Problem: First, I used the server explorer to connect to the SQL server. Everything works as desired. Then I write code to do the same thing. I keep getting the following error message:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
However, I used the exactly identical connection string as the one used in the server explorer. So connection string should not be the problem. In addition, I tried the test code in MSDN, which tells whether my domainusername can flow the network. It turns out the user name is fine. I also went to the SQL server management studio and found the login for my computer is NVCWeihao while my computer login name is NVCweihao. I am wondering if this uppercase letter really affects the connection.
I am getting this compilation error"
All my pages are receiving this error - website is down; here's the code:
[Code]....
Except my web config file shows linq is accounted for? [Code]....
I would note that I updated to VWD Express 2010 then had to revert back to 3.5 because my host at Arvixe had not updated my server yet. He then said he updated it and I reverted up to 4.0 again. It turned out he hadn't and I tried to revert back...and then this showed up and numerous other errors.
I've added the Dynamic.cs file to my project and have set it's Build Action = Compile in order to get the System.Linq.Dynamic namespace.
However, when I try to use any of the new code I am getting an ambiguous call error; see below.
[Code]....
I want to do paging the API Membership without using the datacontrols, but I get this error "Unable to cast object of type '<TakeIterator>d__3a`1[System.Char]' to type 'System.Collections.IList'." when I do this,
[code]....