Oracle Sql Run Via .net I Get 'ORA-01857: Not A Valid Time Zone' Error
Apr 10, 2009
i am using Visual Studio 2008, .net 3.5sp1 When i do the following oracle query on Oracle9i database
a)select NEW_TIME( sysdate, 'EDT','EST') as NT from dual;it works ok on Sql Developer and from vb.net
b) select NEW_TIME( sysdate, EXTRACT(TIMEZONE_ABBR FROM CURRENT_TIMESTAMP),'EST') as NT from dual;
c) select NEW_TIME( sysdate, to_char(EXTRACT(TIMEZONE_ABBR FROM CURRENT_TIMESTAMP)),'EST') as NT from dual;
Both b) and c) work okay on Oracle Sql Developer but fail when run via vb.net with error: ORA-01857: not a valid time zone
I want either b) or c) to be run successfully from .net I also tried replacing 'sysdate' with 'current_timestamp' and the results are similar.
View 2 Replies
ADVERTISEMENT
Sep 6, 2009
I have an ASP.NET application with a SQL Server back end. I am storing all my dates in UTC format and doing the appropriate conversions to the local time zone of the browser viewing it. One of the pages asks for a start date and end date (no times).
I am taking the start date and setting the time to 00:00:00 hours (midnight) and I'm taking the End time and adding a time of 23:59:59, so that the date range covers the whole day. Now what I'm trying to do is do a SQL query to do a search for records in this date range. The problem is, the data in SQL is in UTC time and the user is typing their dates and times in their local date and times. My quickest solution was to convert the date and time to UTC, then search the records. However, by doing this, I am to believe ASP.NET converts the given time and date to UTC based on the server time zone. How can I convert a date and time to UTC time based on the time zone of the user?
View 5 Replies
Jul 22, 2011
So I currently have the following:
2 timers
2 labels
1st label is "Clock" this pulls the time from the users current time zone/local time
2nd label is "UTCClock" Which would be UTC time
Now I have this for the first label: clock.Text = Format(TimeOfDay, "hh:mm:ss tt")
Which would give the users current time zone/local time. As for the UTC.. how would I add in for the UTC time from where the user is located at? I did some searches.. but couldnt find what I was looking for.. IM pretty sure its not as easy as getting the users current time zone/local time.. So im assuming that Theres a "bit more" code into getting UTC time..
View 5 Replies
Aug 24, 2011
I used .NET Framework 1.1 in C/S project before. Now I have updated the project to use .NET Framework 3.5 without modifying source code, but I have found that : the Remoted DateTime values can not be converted to the equivalent local time of a remote computer that is in a different time zone. In .NET Framework 1.1, the DateTime values can be converted automatically.
[Code]...
View 2 Replies
Jan 14, 2010
How do I change the time zone using VB.NET 2.0? I found an article explaining how to do it in VB6 [URL] but I can't adapt it to .NET 2.0 - I just don't have enough expierience I guess.
View 4 Replies
Jan 15, 2010
I'm trying to write code in .NET 2.0 to change the time zone - long story short its toautomate server deployment. I'm having a problem adding the SE_TIME_ZONE_NAME privilege I found code online to add the SE_SHUTDOWN_NAME privilege which I adapted into the following code:
Imports System.Runtime.InteropServices
Module ChangeTokenPrivs
Private Const ANYSIZE_ARRAY As Integer = 1
[code].....
View 1 Replies
Jun 13, 2012
Basically I am looking for a means within a asp.net 2.0 (or higher) application, to identify a time zone and UTC offset for a specific location and date. I want to be able to look up the time zone rules using either city & state, Zip, or LAT & LON I have an event database that tracks location, date and time for the events. Times are recorder relative to the event and the records do not currenlty indicate the timezone for the event or whether or not DST is in effect. Recently, I have encountered a situation where I need to link several events across different time zones. What I am looking to do is:
first, record a master event, say for August 13 2012 at 8:PM in New York, NY 10021
Second I need to record a related event in Houston TX.
When I record the related event I want it to automatically populate the date and time relative to its local time time zone rules. To do this it needs to be able to identify the effective timezone and UTC offset for the master event as well as the linked event so that I can calculate the correct date and time to display on the satelite program. As a future update I would probably capture the time zone /utc offsets with each program so that I don't have to recalculate the master record each time I want to add a related event.
So far I have not seen a way from system.timezone or timezoneinfo to be able to look up a timezone and the effective UTC offset of a given date and location.
View 2 Replies
Apr 18, 2011
Ok, i am really in need of finding a way to do this via a string to clob instead of using the update query to to do all.
Dim theXMLCode As OracleClob
Dim OracleConnection2 As New OracleConnection()
Dim dr2 As OracleDataReader
[code].....
View 2 Replies
Jan 15, 2010
In my last "Question" today Re-ComboBox", I was told that I can add the actual TimeZones into the ComboBox using the following; ComboBox1.Items.AddRange(TimeZoneInfo.GetSystemTimeZones. ToArray) I was able to get the ComboBox filled with those information. However, I'm facing a problem in using those information for my "Sunrise Tme" program.
My problem is : I need to add the "Time Zone" (is declared as Double) - which I select in the ComboBox - to the Calculated Time (in GMT). I am unable to get the Value added to the GMT, ie the Value such as 2.5 or 5.5 or 6.0, because the information in the ComboBox is of several Data-type. Keyword such as "CDbl" didn't work. What mistake am I making?
[Code]...
View 6 Replies
Dec 31, 2009
I've written the following code to draw a trajectory of points in my program:
Private intNumOfPoints As Integer = 0
Private PtTrajectory(intNumOfPoints) As Point[code]....
*Pos.X and Pos.Y are calculated in the other parts of my program. But, it has a run-time error: "Parameter is not valid".
View 7 Replies
Dec 8, 2009
I have the following Stored Procedures create or replace PROCEDURE WEB_AC
[Code]...
First one: At some point in the application I have the valor parameter (of the visual Basic Function) as a string with spaces that is something like "some string with spaces". When this happens, the stored procedure don't update the table. If I execute the SP directly in the DB (with SQL Developer) all works fine. I know it has something to do with the string missing some quotes(') but I haven't make it work yet. Some ideas on this?
Second problem: Sometimes, when debuging the application, if I interrupt the execution, I start getting the ORA-24338 'statement handle not executed' error for hours every time I try to execute it again. I believe it has something to do with an open transaction. But honestly, as I'm new in working with Oracle, I really have no idea what the problem could be.
[Code]...
View 1 Replies
May 26, 2011
I am trying to insert date and time in dtime column in oracle database by using this code but it gives me following error ORA-01830 date formate pictures ends before converting entire output.
[Code]...
View 5 Replies
May 24, 2012
i use below DLL to connect direct to oracle from client.oci.dll, Oracle.DataAccess.dll, oraociicus11.dll, OraOps11w.dll, orannzsbb11.dll, oraocci11.dll, ociw32.dll
connection string:
Dim oradb As String = "Data Source=(DESCRIPTION=(ADDRESS_LIST=" _
+ "(ADDRESS=(PROTOCOL=TCP)(HOST=172.20.128.33)(PORT=1521)))" _
+ "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=bipcdb)));" _
+ "User Id=msavameri;Password=123456;"
but when I run application the following error occurs:
ORA-28547: connection to server failed, probable Oracle Net admin error
View 1 Replies
Apr 22, 2010
I want to update a particular row in the database table but no success,i keep on receiving this error One or more errors occurred during processing of command. ORA-00907: missing right parenthesis
Cmd = New OleDbCommand("UPDATE SUB_DETAIL SET (LECT_ID = " & TextBox3.Text & ") WHERE SUB_ID = " & cmb_subID.Text & ")", con)
con.Open()
[code].....
View 2 Replies
May 5, 2012
I am having a problem that I keep getting the following error when I try to run my program.I am trying to make a circle the size of the value of FrameSize.A first chance exception of type 'System.InvalidOperationException' occurred in System.Windows.Forms.dll
This is the details of the error:
System.InvalidOperationException was unhandled
Message=An error occurred creating the form. See Exception.InnerException for details. The error is: Cross-thread operation not valid: Control '' accessed from a thread other than the thread it was created on.
Source=DreamCatcher[code]......
View 3 Replies
Jul 5, 2011
I am trying to Connect my VB.net Window Application to IBM_DB2 Database.I have used the same method to connect to previous other databases such as SQL Server, Oracle. But getting an error in DB2.
Dim cn As New OdbcConnection("dsn=Sample;uid=db2admin;pwd=password") 'Sample is DSN
cn.Open()
Dim da As New OdbcDataAdapter("Select * from Employee", cn)[code]......
View 3 Replies
Mar 30, 2009
I have the following insert into statement. What I want to do is insert the values to gprdsql.TblOracleNos if TxtOracleNo is not empty, therefore if a user logs on and fill the textbox the values are saved to the table. However, if the oracle number exists in gprdsql.TblOracleNos (i.e, the values ) it should not insert the values, presently it creates the same record again with same values (when the save button is clicked) and this creates duplication. Instead probably bring a pop up message "Oracle number already exists. [Code]
View 6 Replies
Mar 4, 2010
I am reading a csv file in to a datatable in vb.net and making a few checks and appending an extra column. I then want to perform a bulk insert using microsofts Oracle.DataAccess (no choice in this) to an Oracle database. what would be the best way to perform this as there is no bulkImport like in SQLserver.
View 2 Replies
Dec 29, 2009
can you tell me,how can i add a provider for oracle(Microsoft Provider oledb for oracle).Actually i had Microsoft ODBC for oracle but i want to add a provider above mention.
View 2 Replies
Mar 24, 2011
recommend a zone ocr sdk package. What i would like to accomplish is to automatically import a set of images, pdf or jpg, and then apply zone ocr to each image to extract data into a database. I have already looked at and spoken to Lead Tools and it does seem like they have everything that i would need but by the time you add up all the modules / addons needed, the cost is just too high for our small shop.
View 3 Replies
Jan 1, 2010
at the time of recoredset movenext out of memory error occured in run time data have 3800000 lakh recored
View 2 Replies
May 19, 2010
I'm Loading data to DataGridView 'Unbound' I'm getting following error when i scrolling down in the datagridview
"Value of '264' is not valid for 'Value'. 'Value' should be between 'minimum' and 'maximum'. Parameter name: Value"
I have checked at the end of the load it say 130 recordcount (dgv.Rows.count) and RS code as below:
do while NOT rs.EOF
Dim n As Integer = grdSearchDetails.Rows.Add()
Me.grdSearchDetails.Rows.Item(n).Cells(Columns.Description).Value = rs.Description
[code]....
View 2 Replies
Mar 25, 2009
used the WMI ChangeZoneType DNS command in C#VB.net before. I get an incorrect parameter exception when i try and invoke the changezonetype command. I get the dns zone that i want to change from the dns server (via query), set the zonetype to the appropriate uint value but am then getting the exception. I am trying to change the zone from secondary to primary and according to MSDN all the other values are optional (and as far as i am aware are needed when you want to change from primary to secondary) so i have not included them.
Below is the code that i am using....
For Each DNSZone As ManagementObject In mgrZones
mngrZones = DNSZone.GetMethodParameters("ChangeZoneType")
mngrZones("ZoneType") = System.Convert.ToUInt32(zoneType)
[code]....
View 2 Replies
Mar 16, 2009
Adding and deleting a web part zone at runtime. I have tried all possible ways through internet but no luck.
View 1 Replies
Jun 21, 2010
I'm trying to make simple payroll system using vb.net 2003 and Access 2007. When I press 'delete' button in this application, having a "Specified cast is not valid" error.
conPayroll.Open()
Dim strSQL As String
strSQL = "select*from EMT where Empno='" & mskEmpno.ClipText & "'"
comEMT.CommandText = strSQL
[code]....
View 4 Replies
Oct 21, 2011
I am currently coding a tabbed web browser. I am adding a bookmarks function, but this stupid error is holding me back from compiling. I believe the code is flawless, but yet it says that a period is an invalid chracter [Code] The period in the SelectedTab.Controls is the one causing the problems, and I have no idea why.
View 4 Replies
Feb 26, 2012
This is the code I am using -I want to be able to find a files extension by selecting it with a OpenFileDialog.
Dim foundFile As String = My.Computer.FileSystem.GetFiles(OpenFileDialog1.FileName.ToString).ToString
Dim check As String = _
System.IO.Path.GetExtension(foundFile)
MsgBox("The file extension is " & check)
TextBox1.Text = OpenFileDialog1.FileName
The error message I keep getting is that the directory name is invalid ( on the first line of code.
View 5 Replies
Apr 3, 2011
If TreeView1.SelectedNode.Text = "Kunkka - Admiral Proudmoore" Then RichTextBox1.AppendText("ME")
End If
I got character not valid error.
View 1 Replies
May 14, 2012
Dim data As Byte() = DirectCast(sdr.Item("Image"), Byte())
Dim ms As New System.IO.MemoryStream(CType(sdr.Item("Image"), Byte()))
PictureBox2.Image = Image.FromStream(ms)
After reading many forums and trying the different examples, when I try and load my image from the database I get the "Parameter is not Valid" error.Im using VB 2010, SQL Server 2008 R2, and the data type is Image. I do not have access to the source code that is used to save the picture to the database, just access to tthe data in the db.The code I have included is the code I use to retrieve images from my db which stores the pictures as Image.
View 2 Replies
Aug 17, 2010
STEP1--image data is sending by a vehicle tracking unit.using a socket application i am tracing that data.the data from the vehicle tracking unit is not in a decimal format.image data coming from socket containing lot of special type of characters. so i am converting this image information to hex format using the code below.
Private Function Data_Asc_Hex(ByRef Data As String) As String On Error Resume Next 'first take each charcter using substring. 'then convert character into ascii. 'then convert ascii value into Hex Format Dim sValue As String Dim sHex As String = ""
[code]....
View 14 Replies
