I've set up IIS on a local machine and have moved a site from my production server to this machine. Everything is copied over correctly. I next re-reference all the .dll's I built in c# to the bin directory, but I get the following error when I open the site:
"The type or namespace name 'ett' could not be found". All the files are sat in the /bin directory. Strangely, if I copy over the dlls from the server (Without changing the references) everything runs fine - but I need to be able to build and test on the local machine. what i'm doing wrong? The site seems to look in the bin to get the copied dlls, but it doesnt seem to see them if I recompile.
I am working my way through Kevin Yanks tutorials on C# and object orientation, and I got stuck at the tree example.
Link to article
When I try loading http://xxx.xxx.xxx.xxx/tweb/test2/PlantTrees.aspx in my webbrowser I get this error message: Compiler Error Message: CS0246: The type or namespace name 'Tree' could not be found (are you missing a using directive or an assembly reference?)
I do however have the Tree.dll file in the bin folder, and it is lookin exactly like its supposed to.
When I try loadinghttp://xxx.xxx.xxx.xxx/test2/PlantTrees.aspx, however, the program works perfectly. (notice the difference in the URL's)
Why is that? Anyone know? Why do I have to remove the root folder name from the url to make it work??
Currently i working on a project using ASP.net and mysql. these are the classes i imported:
<%import Namespace="System.Data" %> <%import Namespace="MySql.Data.MySqlClient"%> Sub Page_Load(sender As Object, e As EventArgs)
Dim myConnection As MySqlConnection Dim myDataAdapter As MySqlDataAdapter Dim myDataSet As DataSet
Dim strSQL As String Dim iRecordCount As Integer
myConnection = New MySqlConnection("server=myserver; user id=XXX; password=XXXX; database=XXXX; pooling=false;")
when i try to test it out on my localhost, i got this error compiler page:
(warning BC40056: Namespace or type specified in the Imports 'MySql.Data.MySqlClient' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.
I have an ASP 2.0 Web site I'm building and I'm adding Atlas to one of the pages. I've created a simple Web Service as a separate project and compiled it. The Web Service has a class to connect to our SQL Server to get data. The service takes two strings and an array of SQL Parameters. I have added the Web Service reference to my Web site app in the App_WebReferences folder.
when I create an instance of the Web Service it attaches the local namespace of the Web Service to the SQLParameter type and gives me an error like: "Value of type '1-dimensional array of System.Data.SQLClient.SqlLParameter' can not be converted to '1-dimensional array oflocalhost.SqlParameter'.because 'System.Data.SqlClient.SqlParameter' is not derived from 'localhost.SqlParameter'.Why is it doing that?
I got a problem while running an application. The code for this is as follows:
aList = Split(strMsg,";") For nX = 0 to UBound(aList) strarry=split(aList(nX),"_") var_year=left(strarry(2),4) var_month=mid(strarry(2),5,2) var_day=mid(strarry(2),7,2) var_date=var_day&"-"&var_month&"-"&var_year var_time1=mid(strarry(2),9,2) var_time2=mid(strarry(2),11,2) var_time=var_time1&":"&var_time2 set rs1=conn.execute("insert into tbl_BackupfileInfo(Filename,Createddate,Createdtim e)values('" &aList(nX)&"','"&var_date&"','"&var_time&"')") Next
while runnig this application some times it works fine .But some times it giving an error
Error Type:Microsoft VBScript runtime (0x800A000D) Type mismatch: 'UBound'.
I have a table with four fields, ID (auto increment), question (varchar(200)), answer (Text), and shop (tinyint(3). When I connect to the database in an ASP page and write this code
but if I change the type of the answer field to type varchar I don't get the error but am limited in the length of the field's contents. I just also noticed that if I keep the type at TEXT and change the collation to ascii_general_ci I don't get the mismatch error but all the ' characters turn into ? characters? Oh woe is me.
I am moving a mySQL db from one server to another. My backup sql is coming from phpMyadmin and I am using another 3rd party db admin program on the server. I am copying and pasting this code:
After about 30 minutes of frustration I finally discovered what was causing a general 500 internal server error and to my surprise it was something I seem to always take for granted for its simplicity. A type mismatch error trying to compare a string to a numerical value, which is something that PHP has no problem or qualms with. However, this continuous problem continues to haunt me year after year and has brought me to tears with frustration. This is the line that raises the error:
nID = Request("ID") If IsNull(nID) Or IsEmpty(nID) Or nID = 0 Then .... (and so on)
In the past I've written a function 30 lines long that compares values by confirming value types of the variables first, but I would rather put a gun to my head than do that. Since there are obviously other bright PHP and ASP developers out there that constantly trip over this problem, I would like to know your suggestions or methods of working around this.
I am new to ASP programming and I am trying to get an existing website to work. I have created the following function to get the day:
function nrDate() nrDate = DAY(Date()) end function
But when I use the page it gives the following runtime error:
Microsoft VBScript runtime error '800a000d' Type mismatch: 'DAY'
I have googled the problem for hours but cannot find anything that may be helpfull. Does anyone have any ideas because this is getting quite urgent and I cannot move forward without this function.
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Could not use ''(unknown)''; file already in use. /asp/PPLMain/memberpage.asp, line 10
and in my line 1o is RsMember.ActiveConnection = MM_connPPL2_STRING
This works before but then it went like this. Anyone can help?
I use Server.CreateObject("MSXML2.ServerXMLHTTP") etc to grab the content of another asp page. I want the other asp page to look like an xml document. So I set the header to text/xml with the line response.contenttype="text/xml" I set this on the calling page and the page that is called. When I view the headers with http://pgl.yoyo.org/http/server-headers.php it is still set to text/HTML. Also the browser displays the page as if it were HTML, not XML
I pass session variables in a querystring to another page, which increments an array and adds them to it. This had been working absolutley fine on my local machine and I uploaded the scripts to a remote server. Everything worked fine (and still does) on the remote server.
I then decided to try opening the script that receives the querystring in a popup with javascript window.open, to display the results in the popup instead of a full new page as before.
When I tried this I got a Type Mismatch on the receiving page. I hadn't changed any of the code in any of the pages apart from calling the receiving page with window.open, so I thought it just didn't like being called/opened that way. So I removed the window.open and went back to the old way - and I still get the Type Mismatch.
I couldn't see why it was throwing this now, so I downloaded the scripts from the remote server (which work fine) to my local machine and I still get the Type Mismatch on the local machine. I tried stopping and starting IIS and then rebooting, but to no avail. It still works remotely but not locally.
The mismatch is occuring apparently between the String I'm trying to add to the array and the array index (which is also a session variable): Code:
Like so many, I will preface my question by saying I'm a complete ASP noob. I am however very experienced with PHP/MYSQL so I understand the concepts, it's just a syntax problem. I have the following:Code:
sqlGroups = "select groupName from Groups where groupID = '" & rsParts("groupID") & "'" set rsGroups = Server.CreateObject("ADODB.Recordset") rsGroups.Open sqlGroups, strConn
response.write(rsGroups("groupName"))
This is resulting in a type mismatch error. rsParts("groupID") is from another recordset in the script, of type Long Int. groupID in the Groups table is autonumber, also of type Long Int.
I am currently taking a lot of web form information and compiling it into a word document for users to download; however, I want to be able to embed any attachments that they have inside the word document. The attachments are coming from a database and the office suite does not reside on the server. Does anyone know if it is possible to create a word document with embedded attachments for download.
Guys i tried this sqlstr= "UPDATE BorrowerTab SET BorrowerName = '" & strName & "', Email = '" & strEmail & "', Phone = '" & strPhone & "'"
I get the error [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
I think the problem is i need to have a WHERE clause in my sql statement The thing is i dont know how to... Cuz the field is an auto number(BorrowerId)
One ASP page doesn't throw a type mismatch error and the same exact code in a second ASP page throws a type mismatch error.
I simply throw a Cdbl around my variables and it clears the error, but i'm getting a new one today that i didn't get yesterday on the second page. Again, putting a Cdbl around it... Why is this page being so particular?
I have verified that the info from my submit form with the datbase and have figured out it has something to do with my database. When I dont fill out a certain field on the form like LoanAmount it gives me that error.
In my database the field type is set to currency and no required with a default value of 0. If i change the field type to text it works if I dont fill in the LoanAmount field, but I dont want to change it to that . Any suggestions? I want to be able to not have to enter info if not needed into certain fields and still be able to submit the rest of the info. here is my submit page: Code:
I am an ASP developer seeking to build an interactive web site. Unfornately I'm so very frustrated and out of answers for a pivital part of my ASP programming. You see, A number of database Tables are linked together through a common ID Value in a Numbered Field.
These values are the ManagerID and the UserID. The ManagerID is used to get data about the manager and the UserID is used to get data about the users. Unfornately I am getting a ton of Type Mismatch results when I try and compare a numeric value to a string value stored in a Session Variable.
While using a Text Field methoud partially solves this problem, it causes a problem when records go above ID 9, as it instantly puts record ID 10 out of order in the table, thus causing severe problems with various functions in the project that add new records to the tables and generate a new ID value.
This is because when new records are added, it takes the last value stored in the bottom field and increments it by 1. thus since the last value would be 9, and if it increments to 10, you get a duplication error every time you try and add a record above 10. Thus only a Numeric Field which can auto-adjust according to the record values can this program function in the way it needs to.
For your review, here is the code of my Login Script page, I will site where the problem is. If I can find a solution to this problem, I can find a solution to plenty of others as well (As many other parts call on Numeric Field values to call records from the database.) Code:
I'm using this to show an expandable/retracable naviation list but I'm getting a type mismatch on line 46:
Error Type: Microsoft VBScript runtime (0x800A000D) Type mismatch
I'm guessing it might be because it's trying to compare a string to an int but I can't find where my variable would become a string. So if you guys can help it would be great I've been at this since at 8 this morning. Code:
On the website i'm working on, i'm using a database filled with pdf files. Users can download these files from the website. When you click the link of a file, you see a popup screen that asks you wether you want to download the file or open it. My problem is that it is empty behind the content type. The download works fine, and i have the content type stored in my database. What do i do wrong here??
If Not rs.EOF Then Response.AddHeader "content-disposition", "attachment; filename=""" & titleDownload & """" Response.ContentType = rs("Content Type") Response.BinaryWrite rs("File Data")