|
Passing the date to the select statement directly (not parameter) raises this exception: "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.\r\nThe statement has been terminated."
|
|
|
|
|
I've ran the query directly in sql and tried different date formats. It finnaly accepted "mm/dd/yyyy hh:mm:ss". How can I make c# convert into the right format without changing regional settings. My current date format (from regional settings) is dd.mm.yyyy
|
|
|
|
|
Hi,
Last day there was some problem in the afternoon in posting the message. So I was unable to reply you though I tried many times. However, I emailed you the solution.
Try with the solution which I gave . That's a running application.
N.B.~ The default DateTime format in my system is "mm/dd/yyyy hh:mm:ss"
By the way if you need to convert the date format e.g. dd.mm.yyyy to
mm/dd/yyyy hh:mm:ss, use the
DateTime.ParseExact() Method .
e.g. I want to convert from 28.06.2009 i.e. dd.mm.yyyy to
mm/dd/yyyy hh:mm:ss
string OldDateFromat = "28.06.2009";
DateTime dt = DateTime.ParseExact(OldDateFromat, "dd'.'MM'.'yyyy",
CultureInfo.InvariantCulture);
Hope this helps you.
Let me know in case of any concern
Niladri Biswas
modified on Sunday, June 28, 2009 11:25 PM
|
|
|
|
|
Niladri_Biswas wrote: The default date format in c sharps Datetime.Now is "mm/dd/yyyy hh:mm:ss".
I disagree: the default DateTime format is the one specified in your Regional Settings Control Panel, it is up to the user to choose the format he likes to use.
FYI: For data interchange, there is an IEC 8601 standard, as explained here[^].
FWIW: where ever possible, a real date or datetime field is better than a string.
Luc Pattyn [Forum Guidelines] [My Articles]
DISCLAIMER: this message may have been modified by others; it may no longer reflect what I intended, and may contain bad advice; use at your own risk and with extreme care.
|
|
|
|
|
Correct . I am sorry for my mistake . I edited that line.
Niladri Biswas
|
|
|
|
|
Thanks for your help. I've done it with DateTime.Parse() already.
|
|
|
|
|
I have been trying to solve this for quite sometime, I have google it as well. My connection string is as follows: "Data Source=xxx.xxx.8.20,1433;Network Library=DBMSSOCN;Initial Catalog=myDatabase;Trusted_Connection=Yes;"
Though my remote server is SQL 2000 Server. On my developer platform I have SQL 2005 and 2000, but whenever I debug the application, it is giving the error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)
I can ping the remote server. I can also connect to the server from the studio, please what can I do to solve this problem.
Thank you in advance.
Thayhor
|
|
|
|
|
Enable the TCP/IP port.
It should have been done at the time of installation of SQL SERVER only.
However, follow these steps
1) Start Menu - > Microsoft Sql Server 2005 -> Configuration tools -> Sql Server Configuration Manager
2)Once in that window, expand the SQL Native Client Configuration node which you will find on your left side.
3) From there, choose the Client Protocols. All the client protocols, that are available in your system will be listed in the right pane.
4) Enable the TCP/IP port.
5) Re-Start the SQL SERVER Agent from the services.
Hope this helps.
Niladri Biswas
|
|
|
|
|
Thanks for your reply. I have done and enable TCP/IP several time and restart the SQL Agent before. What else can I do. I forget to mention that in my earlier post.
Thank you.
|
|
|
|
|
I cannot telnet to my remote server on port 1433. put I can ping the server. What can I do?
Thank you.
modified on Sunday, June 28, 2009 4:34 AM
|
|
|
|
|
For some reason I could not post this earlier this day.
Check to see if telnet is enabled. On the Vista OS (and WinSrv'08 I believe) telnet is disabled by default unlike XP and WinSrv'03 sp1.
"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering
|
|
|
|
|
|
Hello Thayhor,
I am also having the same issue. I am trying to build a Window application where i want to connect to a remote sql server 2000 database. Fortunately i have figured out some settings in "Surface Area Manager" of 2005, but no help regarding remote connection in sql server 2000.
Please let me know in case you have figured out the solution. Any help is highly awaited.
Regards
Sujay
|
|
|
|
|
Hi Sujay,
The default port on which SQL SERVER 2005 is running is I guess 1433.
If that is supposed to be the case, then on the same port SQL SERVER 2k cannot run.
Change the port, give Server name as [INSTANCE NAME,PORT NUMBER] and try
again.
Also check the bandwidth of the connection, since data storage and
retrieval might take a lot of time
At the same time check if the firewall is open or not!
Niladri Biswas
|
|
|
|
|
Hello Niladri,
Thanks for the quick response. Well actually i am new in developing and not having that much sense. I was wondering if you could please provide me with some detailed step by step configuration of sql server. As far as ports are concerned i think we can put it in between 1433-1444 and i have given it 1438. but still i am stuck with two errors:
A dialog box (Not from VS 2005 that's for sure) appears with the following error - Invalid Parameter and then asking to enable JIT in my machine.config file to debug the issue
Similarly another dialog box occurs this time with the error msg as Object reference not set to the instance of object. and i am sure this is also not comming from vs 2005 because i have put my code in try.... catch and have a different messagebox to display the exception.
....
Using System.Data.SqlClient;
....
....
SqlConnection oSQLConn = new SqlConnection();
.....
oSQLConn.ConnectionString = "Network Library=DBMSSOCN; Data Source=xxx.xxx.xxx.xxx,1438;Initial Catalog=databaseName;User ID=myUsername;Password=myPassword"
Please guide me further in the issue
Regards
Sujay
|
|
|
|
|
Does anyone see a problem with the following? I am getting a a mesage saying "Syntax Error" when I try to run the query to create the table.
sql = "CREATE TABLE tblPrograms ([index] Counter," & _
"[lngPlatformFK] TEXT(255) NOT NULL," & _
"[strCompany] TEXT(255)," & _
"[strProgramName] TEXT(255) NOT NULL," & _
"[strVersion] TEXT(255)," & _
"[strInfo] MEMO NOT NULL," & _
"[strURL] MEMO," & _
"[strLetter] TEXT(1) NOT NULL," & _
"[strNew] NUMBER(1)," & _
"[strMU] TEXT(1) NOT NULL," & _
"[strUpdate] TEXT(255)," & _
"[strType] TEXT(10)," & _
"[strKey] MEMO NOT NULL)"
bah10z
|
|
|
|
|
I don't see anything wrong, but that may be because I didn't look closely since you didn't use PRE tags which would improve readability.
The good thing is you were wise to choose multiple lines, so you can easily remove part of the statement and discover which part is causing the trouble.
Luc Pattyn [Forum Guidelines] [My Articles]
DISCLAIMER: this message may have been modified by others; it may no longer reflect what I intended, and may contain bad advice; use at your own risk and with extreme care.
|
|
|
|
|
engbahramZarin wrote: "[strNew] NUMBER(1)," & _
Is this really a string datatype, or are you naming it as a string even though you are declaring it a number type just to keep the guys on their toes?
"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering
|
|
|
|
|
Can any one tell me where the SSIS package saved in SQL server2005 Standard edition.???
I made one import package , but i don't know where it is saved in SQL2005.
Thanks in Advance.
Aman
|
|
|
|
|
Depending on your deployment, they are generally stored either on MSDB database or in the file systems.
I basically use VS 2008 and MSSQL2005 and the SSIS packages are stored in
drive name:\Documents and Settings\My Documents\Visual Studio 2005\Projects
Or else you can also look into thru the defined projects path in Tools>Options of Visual Studio
Anyway, for more details on
How to: Save a Package to the File System visit this link
[ http://msdn.microsoft.com/en-us/library/ms137970.aspx[^] ]
How to: Save a Copy of a Package in MSDB database
[ http://msdn.microsoft.com/en-us/library/ms137565.aspx[^]]
Hope this helps
Niladri Biswas
|
|
|
|
|
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER proc [dbo].[Usp_D_et_Login1234]
@name nvarchar(max),
@pwd nvarchar(100),
@type nvarchar(5)
as
begin
if @type='1'
begin
select DId,LoginName from dd_login where LoginName=@name and Password=@pwd
end
if @type='0'
begin
select RId,LoginName from dr_login where LoginName=@name and Password=@pwd
end
end
Is this stored procedure can be injected?
Whether sql injections can be apply on this procedure?
If yes tell me how ?
and also how to recover from it? In sqlserver2005.(backend)(asp.net frontend)
|
|
|
|
|
|
Hello, I am new to databases. I need urgent help. I have a table named Category, which contains 4 fields - categoryid, siteproprtyid, topCategoryId.
the topcategoryid contains the categoryid of the higher level category. Likewise there are four level of category. An example to this is-
categoryid sitepropertyid topcategoryid
---------- -------------- -------------
1 16 Null
2 16 1
3 16 2
4 16 3
5 16 1
I want the output to be like
Category1 Category2 Category3 Category4
--------- --------- --------- ---------
1 2 3 4
1 5
Please help me regarding this
|
|
|
|
|
Hi, your question is not so clear.
As of now what I understood, you need a row column transposition which can be achieved using PIVOT function of SQL SERVER .
You are saying that there are 4 level of categories.
In the output, that you presented here, I cannot find any sort of link between the first and second rows.
What is 5 doing in the second row? How is it related in this context? Does 1 will always appear in the Category1?
Is this 1, the TOPCATEGORYID and is it a demarcation indicating for a next row?
Category1 Category2 Category3 Category4
--------- --------- --------- ---------
1 2 3 4
1 5
Explain everything clearly... then it will be easier to answer your problem.
Niladri Biswas
modified on Friday, June 26, 2009 10:14 PM
|
|
|
|
|
Hi, yea may be I was not able to put my question properly. Let me try once more. Suppose CategoryId 1 is the root level, so thete is no top level category for it and it is null. The CategoryId 2 is the child of CategoryId 1, therefore, the topcategoryid for Category 2 is 1. Like wise for Category 3, the topcategoryid is 2 and for CategoryId 4, the topcategoryid is 3. CategoryId 5 is the child of CategoryId 1 and there are further no child categories under it.
Therefore, I showed thebase table like that. For the same, I want the output in the manner I depicted.
I hope I am able to explain this time.
Thanks for bearing with me.
-----Have A Nice Day-----
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
