|
Thanks Luc for your help.
I compiled and run my code on 32-bit successfully.
But if I want to run this code on 64-bit then what should I do?
Thanks.
Gagan
|
|
|
|
|
Luc Pattyn wrote: 640bit systems
640 wow, where can i get one of those? what would the maximum addressable memory be??
|
|
|
|
|
DaveAuld wrote: 640 wow, where can i get one of those?
many places, wide stuff[^] has been researched and experimented with for decades.
DaveAuld wrote: what would the maximum addressable memory be??
gigantic wouldn't start to describe it.
|
|
|
|
|
Hey everyone,
I'm working on a project that includes product activation. We are using a TCPclient on the client application to connect to a TCPlistener on the server. 99% of the time, everything goes fine. But we have had a few clients complain that they are unable to activate. I was able to set up a debug server and have the client try activating against that. I watched the incoming connection and the issue seems to be that the client is able to connect and send data (verified by the clients log file), but the server never receives it. The stream.readbyte() function hangs until it times out.
Here's some info on the configuration:
There are two servers, a main and a backup. Both are up and communicating with most users. They listen on ports 80 and 63016. If the connection fails on port 80, it tries 63016. If the main server cannot be connected to, it tries the backup server with the same ports.
My best guess is because it's communicating on port 80 (the http protocol's port), some firewall or security program is blocking the packets because they aren't standard http traffic. It may look like malware trying to "phone home". Which would explain why the connection goes through but the data does not. The client never tries the other port because it successfully connected (I'm in the process of changing this behavior now.)
Please, if you have any ideas or things I can try, I'd be greatly appreciative. I'm at the end of my rope here.
|
|
|
|
|
it depends if the activation problem is intermittent then it is unlikely to be firewall related problem
Firewalls usually require a program to be authorised and I believe it is generally server firewalls that check the traffic content whereas PC firewalls generally tend to block access from a particular program or to a particular port
check the software type and version installed on each client PC and compare working/non working installs to see what is different
if the IP address/netmask dynamically set or could there be differences there
|
|
|
|
|
Hi all...
I am getting an error while searching records between two dates. The error message is "IErrorInfo.GetDescription failed with E_FAIL(0x80004005)."
code is :
Try
Me.listView1.Items.Clear()
Dim resultFound As Integer
DBConnection.connect() 'Code to open database.
Dim sql As String = "select * from MortgageDetails where Current_Date between '" & Convert.ToDateTime(txtDateFrom.Text) & "' and '" & Convert.ToDateTime(txtDateTo.Text) & "'"
Dim cmd As New OleDbCommand(sql, con)
Dim reader As OleDbDataReader = cmd.ExecuteReader 'Getting error on this line.
While reader.Read
Dim item As New ListViewItem(New String() {reader.GetInt32(0), reader.GetString(1), reader.GetString(2), _
reader.GetString(3), reader.GetString(4), reader.GetString(5), _
reader.GetDateTime(6), reader.GetInt32(7), reader.GetInt32(8)})
Me.listView1.Items.Add(item)
resultFound += 1
End While
reader.Close()
lblStatus.Text = resultFound & " record(s) found!"
'Me.Close()
Catch ex As Exception
MsgBox(ex.Message)
End Try
Suggest me what should I do
Thanks.
Gagan
|
|
|
|
|
It's been a while since I've seen a question from you.
Stop using string concatentation to build SQL queries. Use paramterized queries instead and let the OleDbParameter objects convert the dates to the proper format for you.
OleDb Parameterized Queries[^]
|
|
|
|
|
Thanks Dave for your quick reply.
I used parameterised query to search record but still I'm getting same error
Try
me.listView1.Items.Clear()
Dim resultFound As Integer
DBConnection.connect()
Dim sql As String = "select * from MortgageDetails where Current_Date >= ? and Current_Date <= ?"
Dim cmd As New OleDbCommand(sql, con)
cmd.Parameters.AddWithValue("Current_Date", Convert.ToDateTime(txtDateFrom.Text))
cmd.Parameters.AddWithValue("Current_Date", Convert.ToDateTime(txtDateTo.Text))
Dim reader As OleDbDataReader = cmd.ExecuteReader
While reader.Read
Dim item As New ListViewItem(New String() {reader.GetInt32(0), reader.GetString(1), reader.GetString(2), _
reader.GetString(3), reader.GetString(4), reader.GetString(5), _
reader.GetDateTime(6), reader.GetInt32(7), reader.GetInt32(8)})
me.listView1.Items.Add(item)
resultFound += 1
End While
reader.Close()
lblStatus.Text = resultFound & " record(s) found!"
'Me.Close()
Catch ex As Exception
MsgBox(ex.Message)
End Try
Don't know what is wrong.
Gagan
|
|
|
|
|
First, is this using an Access database??
Is this code running in a non-UI thread?
Are your reader.Get... statements matching up EXACTLY with the types returned by the database? If you try to execute a GetInt32 on a column that is actually text, this will cause serious problems.
Change your SELECT * FROM ... SQL statement to the actual column names you want returned. This will return the columns in the exact same order every time instead of relying column numbers in your Get... code. Also, you might want to use column names instead of index numbers...
|
|
|
|
|
I solved my problem.
The problem was that Current_Date is reserved keyword in current Access table and I didn't wrote it in [].
Now I wrote following code and It worked.
cmd.Parameters.AddWithValue("[Current_Date]", Date.Parse(txtDateFrom.Text))
cmd.Parameters.AddWithValue("[Current_Date]", Date.Parse(txtDateTo.Text))
BTW thanks for your help.
Gagan
|
|
|
|
|
For future reference, if you're writing an ASP.NET site or a Windows Forms app with database access from multiple threads, you don't want to use a Access database with it. Access doesn't take very well to multithreaded environments and may throw the error you posted if you do.
|
|
|
|
|
Jesus H Christ... Someone votes me a 2 for this?? Do I REALLY have to dig up the documentation behind this statement?? FINE!! Here it is:
.NET Framework Data Providers (ADO.NET)[^] It's in the second yellow "Note" box on the page.
|
|
|
|
|
Check this CodeProjectForums .com
|
|
|
|
|
This error normally occurs when you are using a column name that is reserved keyword in Access. You don't give us any info on the column names but I would suggest you try using a full SELECT statement putting square brackets around the field names. Something like this
SELECT [Field1], [Field2], [Field3] FROM YourTable WHERE [Current_Date] BETWEEN @StartDate AND @EndDate
Hope this helps.
...and I have extensive experience writing computer code, including OIC, BTW, BRB, IMHO, LMAO, ROFL, TTYL.....
|
|
|
|
|
Thanks for your help. My problem has been solved.
Gagan
|
|
|
|
|
Hmmm... Good to know. I didn't catch it because I don't use Access for anything. I always go for some flavor of SQL Server.
|
|
|
|
|
Yeah, I remembered that from years back. I now use MySQL exclusively.
...and I have extensive experience writing computer code, including OIC, BTW, BRB, IMHO, LMAO, ROFL, TTYL.....
|
|
|
|
|
Can anyone help me on how to display the records of the table from sql server on the treeview control.
Note: I only want is to display the records only on the column1.
|
|
|
|
|
daemonsead2008 wrote: I only want is to display the records only on the column1.
There is no column in TreeView, did you mean a ListView?
And what is the structure of your table? Is it hierarchical? TreeView is used to display hierarchical information.
|
|
|
|
|
I develop and support a simple VB .Net data acquisition application for a University. A request came in from one of our Spanish clients to have the numbers display on the gui in their local numerical format where the decimal point and comma are swapped from their customary positions in the US. In Windows 7, I can easily change the number format using the control panel and in fact this does change the format for most of the numbers in the application with no programmatic intervention on my part. For instance, voltage readings are displayed in text boxes in the appropriate format, but for some values which are assigned to the TEXT property of a label are still displayed in the US format. I have seen a lot of discussions regarding setting the locale on the thread but I would prefer not to have to intervene that way. My question is how do the numbers display properly sometimes but not others automagically? Is their a property on the text box or label that turns on this on? I suspect it has to do with how I assign values to text properties. I use the FORMAT method as
Textbox.TEXT = format(1.0,"0.0")
but I also tried this with the label with little success. Is this because the numbers assigned to text boxes are changing dynamically while the label text is static after loading? In insight would be appreciated.
Regards,
Bob
|
|
|
|
|
bobmc11 wrote: Textbox.TEXT = format(1.0,"0.0")
Where did the format function come from?
You can try using this:
txtBox1.Text = myNumber.ToString("c");
For a more detailed explanation, go through this[^] article.
|
|
|
|
|
Hi all...
When I execute update query, I get error "data type mismatch in criteria expression"
I used following code :
Try
DBConnection.connect() 'code to open database.
Dim sql As String = "update MortgageDetails set [Borrower_Name]='" & txtBorrowerName.Text & "', [Caste]='" & txtCaste.Text & "', " & _
"[Area]='" & txtArea.Text & "', [Address]='" & txtAddress.Text & "', [Product_Detail]='" & txtProductDetail.Text & "', " & _
"[Current_Date]='" & txtCurrentDate.Text & "',[Current_Value]=" & txtProductValue.Text & "," & _
"[Amount_Borrowed]=" & txtAmountBorrowed.Text & " where [S_No]=" & txtSNo.Text
Dim cmd As New OleDbCommand(sql, con)
cmd.ExecuteNonQuery()
MsgBox("Record Updated!", MsgBoxStyle.Information)
Me.Close()
Catch ex As Exception
MsgBox(ex.Message)
End Try
I am using VB2008 and MS Access 2003 as database.
Suggest me what to do.
Thanks.
Gagan
|
|
|
|
|
Sounds like you are passing some data to the table as text when it should be numeric or some other non string format but without seeing your table definition its hard to say something else.
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
|
|
|
|
|
Passing literal data like that always is asking for trouble. The exact problem is most likely the date you have there. Passing dates and other non-string types depends on the exact database you use, and is often problematic.
Suggestion:
1. use programming variables, and TryParse() your textual input before passing the info to the database; this traps input errors and avoids SQL injection;
2. use SqlParameter and pass the above variables; don't use literals in SQL.
In will take a bit more code, but the result will be much more robust.
|
|
|
|
|
Seems the problems is with this piece of code:
"[Current_Date]='" & txtCurrentDate.Text & "'"
Access expects dates to be passed in a specific format, try this:
"[Current_Date]=#" & Convert.ToDateTime(txtCurrentDate.Text).ToString("MM/DD/YYYY") & "#"
|
|
|
|