Data-in-motion Error (First Time)
Mar 16, 1999
Has anyone seen this error? I am getting this error on one of my server. It is an ongoing error being reported to the error log.
99/03/16 13:21:52.80 spid3 flush_cache: timeout, data-in-motion, bp 0x118b340, pg 0x3c8, stat 0x100c/0x244000, obj 0xf0d453d, bpss 0)
99/03/16 13:23:32.80 spid3 flush_cache: timeout, data-in-motion, bp 0x118b340, pg 0x3c8, stat 0x100c/0x244000, obj 0xf0d453d, bpss 0)
99/03/16 13:25:12.80 spid3 flush_cache: timeout, data-in-motion, bp 0x118b340, pg 0x3c8, stat 0x100c/0x244000, obj 0xf0d453d, bpss 0)
99/03/16 13:26:52.80 spid3 flush_cache: timeout, data-in-motion, bp 0x118b340, pg 0x3c8, stat 0x100c/0x244000, obj 0xf0d453d, bpss 0)
View 2 Replies
ADVERTISEMENT
Aug 18, 2006
Right-clicking "Protocols for MSSQLSERVER" under the Sql 2005 Server Configuration Manager I
find the "Force Encryption" option. Right-clicking the SQL Native Client Configuration, Client Protocols,
I find "Force Protocol Encryption"
I believe these can be used together to force the connection between a client (running the SQLNC client) and a sql 2005 server to be encrypted. In other words, the data "in motion" can be encrypted.
1. Is my understanding correct?
2. Do I need to use a certificate to make this work?
TIA,
Barkingdog
View 6 Replies
View Related
Sep 17, 2007
Hi guys,
When I thought everything is okay with this script, I got a new problem...
I have a VBA's script from Excel 2003 that builds sql script and retrieves data from SQL SERVER 2000.
in order to make the sql running, I need to use a multi - batch processing, to pass and execute every command line once a time.
Up to here, I am using a test case with Account number = '123456' and getting the desire results.
The code below is running okay with the test case, but when changing the account number (mark as yellow in the code) to include all the accounts (or just one other account), I am getting the following ERROR:
run - time error '-2147217871 (80040e31)' - [Microsoft] [ODBC SQL Server Driver] time out expired.
Now, if I take the same code, with the condition that generates the ERROR, and try it into SQL Server, I get the results without errors.
Thanks in advance,
Aldo.
Below the code:
Code Snippet
Function QuerySalesAging()
'--------------------------------------------------------------
'MUST !!! References: Microsoft ActiveX Data Object 2.1 Library
'--------------------------------------------------------------
Dim ConnString As New ADODB.Connection
Dim RecordSet As New ADODB.RecordSet
'Setting Connection String
Driver = "{SQL Server}"
ServerName = "SERVER"
DB_Name = CompanyName
ConnString = "Driver=" & Driver & ";" & "Server=" & ServerName & ";" _
& "Database=" & DB_Name & ";" & "Uid=" & SQLLoginName & ";" & "Pwd=" & SQLPassword & ";"
'Report Criterias
Criteria05 = " AND " & "Accounts.ACCOUNTKEY Between " & AccountKeyAsRange
' -- ==> With AccountKeyAsRange = '123456' AND '123456' it works okay.
' -- ==> With any other value, in example AccountKeyAsRange = '123456' AND '9999999999' it get's ERROR.
CmdLine01 = " USE " & CompanyName
' Check and drop temporary table
TemporaryTableName = "CTE" ' The table is a regular one
CmdLine02 = " if object_id('" & TemporaryTableName & "') is not null exec('DROP TABLE " & TemporaryTableName & "') "
CmdLine03 = " SELECT ..."
CmdLine03 = CmdLine03 & " INTO " & TemporaryTableName
CmdLine03 = CmdLine03 & " FROM ..."
CmdLine03 = CmdLine03 & " WHERE " & "(" & Replace(Criteria05, "AND", "") & ")"
CmdLine03 = CmdLine03 & " ORDER BY ..."
CmdLine04 = CmdLine04 & " ALTER TABLE " & TemporaryTableName ...
CmdLine05 = CmdLine05 & " UPDATE " & TemporaryTableName ...
CmdLine06 = CmdLine06 & " SELECT ..."
CmdLine06 = CmdLine06 & " FROM ..."
ConnString.Open
ConnString.Execute CmdLine01
ConnString.Execute CmdLine02
RecordSet.Open CmdLine01, ConnString
RecordSet.Open CmdLine02, ConnString
RecordSet.Open CmdLine03, ConnString
RecordSet.Open CmdLine04, ConnString
RecordSet.Open CmdLine05, ConnString
RecordSet.Open CmdLine06, ConnString
ConnString.Execute CmdLine01
ConnString.Execute CmdLine02 ' The debbuger stops here:" if object_id('CTE') is not null exec('DROP TABLE CTE') "
ConnString.Execute CmdLine03
ConnString.Execute CmdLine04
ConnString.Execute CmdLine05
ConnString.Execute CmdLine06
ConnString.Execute CmdLine02
'Retrieve Field titles
For ColNr = 1 To RecordSet.Fields.Count
ActiveSheet.Cells(1, ColNr).Value = RecordSet.Fields(ColNr - 1).Name
Next
ActiveSheet.Cells(2, 1).CopyFromRecordset RecordSet
'Cleanup & Close ADO objects
ConnString.Execute "USE master"
ConnString.Close
Set RecordSet = Nothing
Set ConnString = Nothing
End Function
View 1 Replies
View Related
Apr 25, 2014
Sample Table
USE [Testing]
GO
/****** Object: Table [dbo].[Testing] Script Date: 4/25/2014 11:08:18 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
[Code] ....
It seems to work fine with one million records.
Each primary key is unique, but the begindate is non-unique, and i guess even if i use datetime2 and add nanoseconds, from what i have read, there is a chance that i could have a duplicate datetime since the date is imported via XML from multiple sources.
View 7 Replies
View Related
Oct 7, 2015
I have a table called employee_punch_record that we use to store employee time clock punches.
The columns are:
employeeid,
punch_timestamp,
punch_type (In / Out),
closed (bit used as status for open or closed pay periods),
ident
Here are some examples of a record:
bkingery62015-10-06 16:59:04.000In0
bkingery72015-10-06 16:59:09.000Out0
bkingery82015-10-06 16:59:13.000In0
bkingery92015-10-06 18:22:44.000Out0
bkingery102015-10-06 18:22:46.000In0
bkingery112015-10-06 18:22:48.000Out0
bkingery122015-10-06 18:22:51.000In0
tfeller52015-10-05 17:00:05.000In0
We are using SQL Server 2008 as our database and use Access as a GUI. I am looking to create a form in Access where employees can access their time card and request changes from management. I want to use the format from the attached screen shot for the form. I pretty much know how to do it all, the only point of complication is trying to figure out the easiest way to get the transaction punch record data on employee_punch_record into a format where I can easily populate the form in the horizontal format you see in the screen shot.
I am not super strong in SQL, but figure I can do it using a formatting table of some sort. quick and easy way to move transaction records into a more horizontally oriented record?
View 0 Replies
View Related
May 31, 2007
Hi, all experts here,
Thank you very much for your kind attention.
I encountered a very strange problem again. Why the time series displayed on the chart are so strange? The Key time column I chose for my time series algorithm is cal_month(e.g 199001...), but why the date displayed on the time series chart is like :05/06/2448? (it should be like 199001..?) What is that data? And where exactly did it come from? What is the exact cause of this?
Hope it is clear for your help.
I am really confused on this and thanks a lot for your kind advices and help and I am looking forward to hearing from you shortly.
With best regards,
Yours sincerely,
View 1 Replies
View Related
May 28, 2015
how I can load the CSV file data into the sql server table. I know there are ways like bulk insert and other to load the csv file data into the table. But in my case the table doesn't exist and has to be created at the run time. With simple insert in temp table we do like select * into #temp from tablename and that creates the temp table. So. I need something like that which create the temp table and load the data into it. because the CSV file would have different number of columns and names so I can not create the table structure in advance. I have to create the table at run time.
View 3 Replies
View Related
Aug 7, 2007
Hi all,
I have created a report in SSRS 2005 which is being viewed by users from different Time Zones.
I have a dataset which has a field of type datetime (UTC). Now I would like to display this Date according to the User Time Zone.
For example if the date is August 07, 2007 10:00 AM UTC,
then I would like to display it as August 07, 2007 03:30 PM IST if the user Time Zone is IST.
Similarly for other Time Zones it should display the time accordingly.
Is this possible in SSRS 2005?
Any pointers will be usefull...
Thanks in advance
sudheer racha.
View 5 Replies
View Related
Feb 2, 2007
I'm trying to learn about SQL databases and use them for my asp.net app sine I cant get the hang of MySQL in ASP. Every time I go to create a new SQL Database it saids: Would you like to place it in the App_Data folder basicly and I say yes. Then the error:Unable to find DbProivderFactory for type System.Data.SqlClient.SqlConnection
View 1 Replies
View Related
Jul 1, 2007
Hi all, Now i am using vs1.1 and ms sql 2000. Through a web page that i created, i got the error when the function runs. The funcation will run 9 store procedures. Also, in some store procedue, it will run other stored procedures.
But, sometimes, i got the database time out error, the error message return is
General network error. Check your network documentation.
I already check the query time out value which is 0. In machine.config, the execution time out is 90 which i support is quite enough. I really nervous about that. Please help me to find out the error.
Regards,
View 2 Replies
View Related
Oct 12, 2005
I get an error when trying to update abt 9 million records in my database.All the conenction objects are closed proeprly in the finally block, An error has occured: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.What could be the reason, ? Sometimes it works fine and then it suddenly gives me this error.I have set the connect timeout to 0 ( unlimited ) in the connection string, and also in the connection tab , of the server properties i have set the query timeout to 0(unlimited) .Is there any other setting in sql server 2000 to be changed ?Thanks
View 3 Replies
View Related
Sep 20, 2001
I am fairly new to the SQL language so if you could help me with what I am doing wrong I would greatly appreciate it.
I am using coldfusion and MSSQL I am using coldfusion to call a stored procedure.
I figure I am doing something really bad because I get a timeout error, which makes me think it is in a loop or trying to call a whole bunch of records.
What I am trying to do is display a record if the status code is M in LQSPERS or LQSMATE or LQSABUT this is how I was trying to do it.
Please help, thanks
SELECT LQSPERS_MEMBER_ID, LQSPERS_FIRST_NAME, LQSPERS_LAST_NAME, LQSPERS_FIRST_NAME, LQSPERS_AGE, LQSPERS_PROFESSION, LQSPHTO_FILE_NAME
FROM LQSPERS, LQSPHTO, LQSABUT, LQSMATE
WHERE (LQSPERS_MEMBER_ID IN
(SELECT LQSPERS_MEMBER_ID
FROM LQSPERS
WHERE LQSPERS_STUS_CODE = 'M')
OR LQSPERS_MEMBER_ID IN
(SELECT LQSABUT_MEMBER_ID
FROM LQSABUT
WHERE LQSABUT_STUS_CODE = 'M')
OR LQSABUT_MEMBER_ID IN
(SELECT LQSMATE_MEMBER_ID
FROM LQSMATE
WHERE LQSMATE_STUS_CODE = 'M'))
AND LQSPERS_MEMBER_ID = LQSPHTO_MEMBER_ID
AND LQSPERS_MEMBER_TYPE = 'PO'
AND LQSPHTO_PRIMARY_PHOTO = 'Y'
ORDER BY LQSPERS_MEMBER_ID DESC
Shawn
View 1 Replies
View Related
Oct 27, 2000
Hello Guys,
This query is running from the C++ application and gives time out error.
when I run this from Query Analyser I get
Msg 170, Level 15, State 1
Line 4: Incorrect syntax near '!'.
select CPV1.*, CPV2.Name, CPV2.Side, CPV2.Shares, CPV2.Price, CPV2.AllocatedTo
from CurrentPortfolioViewPT CPV1, CurrentPortfolioViewPT CPV2
whereCPV2.Name like '<(bPAll ? "%" : strPortName)>' and
CPV1.PortId <(!bPAll ? "!=" : (bTAll ? "<" : "="))> CPV2.PortId and
CPV1.Ticker like '<(bTAll ? "%" : strTicker)>' and
CPV1.Ticker = CPV2.Ticker and
CPV1.Side <(bCross ? '!' : ' ')>= CPV2.Side
order by CPV1.Name, CPV1.Side, CPV1.Ticker, CPV1.Acronym
View 1 Replies
View Related
Aug 7, 1998
When trying to enter SQL enterprise manager I get this error:
The SQLOLE OLE object could not be registered.
Class not registered (80040154)
If anyone knows how to fix this please call me
312 344 7709
microsoft has been contacted but i am under a time constraint.
thanks
marlene
View 1 Replies
View Related
Nov 29, 2007
Hey there, i'm a new programmer entering into DbScripting ... need u guyz expertize
View 1 Replies
View Related
May 2, 2006
:S Hello to all,
I am a beginner to intermediate user of SQL (the most dangerous kind) and am receiving the error of Server: Msg 11, Level 16, State 1, Line 0 while running a query.
I have been to Microsofts website and download SP4 with the hotfix and it did not seem to help.
Any advice?
Thanks
View 3 Replies
View Related
Feb 22, 2007
Hello All:
I am in desparate need of assistance. We are using an application called PaperVision Enterprise which takes scanned invoices and puts them into a database for the purpose of easy reference to any scanned invoice in the db. 2 weeks ago while trying to perform a 'match and merge' of the newly scanned docs, we received a Run-time error '-2147217871 (80040e31)": Timeout expired message. After being told by the company who supports this software that they couldn't help me since it is using a MS SQL Server Table Lookup I started googling the error with minimal success. I am not very proficient with SQL so I'm kind of stuck. I have narrowed this down to an ODBC run-time error, but looking for some kind of guidance as to how I can resolve it. Any info would be greatly appreciated. We are using MS SQL Server 2000.
View 4 Replies
View Related
Jun 21, 2007
Hi,
I am getting error while running SSIS package.
When i run as a job it fails and giving me error saying in history
--> The return value was unknown. and job fails!!
when i try to run by it self if fails giving error for fatal error messate. and in event viewer it says .Net run time reporting!!
-->
Faulting application dtexecui.exe, version 9.0.2047.0, stamp 443f5ad3, faulting module dtspipeline.dll, version 2005.90.2047.0, stamp 443f5a9c, debug? 0, fault address 0x0004c258.
does any one know why i am getting this!!
thanks!!
pat
View 4 Replies
View Related
Jul 10, 2007
I'm using SQL 2000 in my VB sales related application. Application will records daily consumption in the database. At the end of month, sales summary(.CSV format) is generated based on the data recorded in the database. Sales summary includes day by day total credits, profits, COGS, Grand Total etc....
The application takes much time (around 3 min for generating 3 reports) if item consumption is more..
During that time, All request to the server resulting an SQL timeout error.
Pls help me how to solve this problem..
Ive tried using secondary database for sales summary generation . But it is not work out..
Following is the part of my coding...
FromDate = Format(FromDate, "yyyy-mm-dd HH:MMs")
Todate = Format(Todate, "yyyy-mm-dd HH:MMs")
DoEvents
' Total Days
TotalDays = DateDiff("d", FromDate, Todate)
' Create View - View_totalDisputes - for a month (fromdate and ToDate)
adoConnection1.Execute ("if exists (select * from sysobjects where id = object_id(N'[dbo].[View_totalDisputes]') and OBJECTPROPERTY(id, N'IsView') = 1) drop view [dbo].[View_totalDisputes]")
adoConnection1.Execute ("create view View_totalDisputes as select sum(Price) + (Sum(Price) * Tax / 100 ) as Total , Date_Time from TblSalesReport where ItemId <> " & MyESafeId & " and Date_Time Between '" & FromDate & "' and '" & Todate & "' " & _
" group by Price ,Tax , Date_Time ")
DoEvents
TotalDays = TotalDays + 1
' Find Sum Total of each day
For i = 1 To TotalDays
DoEvents
Todate = CDate(FromDate) + 1
Todate = Format(Todate, "yyyy-mm-dd HH:MMs")
MyDays(i) = Format(FromDate, "MM-DD-YYYY")
FromDate = Format(FromDate, "yyyy-mm-dd HH:MMs")
' Days Total
Set rTot = adoConnection1.Execute("Select Sum(Total) as Tot from View_TotalDisputes where Date_Time Between '" & FromDate & "' and '" & Todate & "'")
If Not rTot.EOF Then
If Not IsNull(rTot!tot) Then
MyTotal(i) = Format(rTot!tot, "Fixed")
DoEvents
Else
MyTotal(i) = 0
Do_DoEvents
End If
DoEvents
Else
MyTotal(i) = 0
DoEvents
End If
DoEvents
' Disputes
Set rDispute = adoConnection1.Execute("Select sum(Price + ((price * tax) / 100)) as Tot from tblitemlog where ItemId <> " & MyESafeId & " and comments is Not null and TobeCharged = 0 and date_time between '" & FromDate & "' and '" & Todate & "' ")
If Not rDispute.EOF Then
If Not IsNull(rDispute!tot) Then
MyDisputes(i) = Format(rDispute!tot, "Fixed")
DoEvents
Else
MyDisputes(i) = 0
DoEvents
End If
DoEvents
Else
MyDisputes(i) = 0
DoEvents
End If
' profit column - added on 14/09/06
MyProfit(i) = Format(Val(MyTotal(i)) - Val(MyDisputes(i)), "Fixed")
' total occupancy
'' TotOccupancy = TotOccupancy + MyOccupancy(i)
' Date changing
FromDate = CDate(FromDate) + 1
Todate = CDate(Todate) + 1
Next i
DoEvents
DoEvents
' Total Rooms in the hotel
Set rRoms = adoConnection1.Execute("Select Count(*) as Tot from TblRooms")
If Not rRoms.EOF Then
If Not IsNull(rRoms!tot) Then
TotalRooms = rRoms!tot
DoEvents
Else
TotalRooms = 0
DoEvents
End If
DoEvents
End If
DoEvents
' Total and avg. of Gross Ttoal
Set rNet = adoConnection1.Execute("Select Sum(Total) as SumTotal From View_TotalDisputes ")
If Not rNet.EOF Then
If Not IsNull(rNet!SumTotal) Then SumToal = Format(rNet!SumTotal, "Fixed")
AvgTotal = Format(SumToal / TotalDays, "Fixed")
DoEvents
End If
DoEvents
DoEvents
revPar = Format(AvgTotal / TotalRooms, "Fixed")
AvgOccupancy = Format(TotOccupancy / TotalDays, "Fixed")
' 14/09/06
' Totals and Avg for Disput and profit columns
Dim GTotDispute As Double
Dim GTotProfit As Double
Dim AvgDispute As Double
Dim AvgProfit As Double
Dim inc As Integer
' G Total
For inc = 0 To TotalDays
GTotDispute = GTotDispute + Val(MyDisputes(inc))
GTotProfit = GTotProfit + Val(MyProfit(inc))
Next inc
DoEvents
DoEvents
' Avg Dispute and AvgProfit
AvgDispute = GTotDispute / TotalDays
AvgProfit = GTotProfit / TotalDays
View 4 Replies
View Related
Mar 24, 2008
I am pulling in data from a source table and converting datetime columns in that table into a nvarchar(50) datatype. When I execute just this segment / container, the script runs and pulls data. When I execute the entire package, I get the following error:
[DataReader Source [1]] Error: The data type of "output column "pt_part" (54)" does not match the data type "System.String" of the source column "pt_part".
I have been going around in circles trying to identify the source of this issue but in vain. Any one has any suggestions for me?
Thanks
Jagannathan Santhanam
View 5 Replies
View Related
Oct 4, 2006
Private Sub cmd_DeleteTables_Click()
MsgBox "Click yes when prompted to delete records"
Dim sqldel As String
sqldel = "DELETE tbl_physical_main.*, tbl_physical_main.[Material Number]
FROM tbl_physical_main WHERE (((tbl_physical_main.[Material Number]) Is Not
Null))"
DoCmd.RunSQL sqldel, no
sqldel = "DELETE tbl_noDataForTag.* FROM tbl_noDataForTag"
DoCmd.RunSQL sqldel, no
sqldel = "DELETE tbl_SAPmaterials.* FROM tbl_SAPmaterials"
DoCmd.RunSQL sqldel, no
MsgBox "All previous inventory data has been deleted and the next inventory
load may continue."
End Sub
--------------------------
Run-Time Error '94'
Invalid use of Null
Please help me!
View 3 Replies
View Related
Mar 31, 2008
Had a program installed in 9-07 ran fine. Tried using it last week and got
run time error 339 MSCOMCTZ.OCX or one of it's dependencies not correctly
registered: a file is missing or invalid.
Have tried to uninstall and reinstall a # of times. No go. Searched in system 32 dir no extention
there.
Called and talk to the company and thier programer. They spent days looking at an issue on
thier end. There is not an .ocx in the program.
They have gotten 3 complaints on this issue all from Vista uses.
Like I said it worked fine then the run time error. Must be from some kind of
Microsoft update.
Need the program
Please help
Jim
View 3 Replies
View Related
Dec 13, 2007
Hi,
I am running dts in Sql Server 2005 management studio from Management, Legacy and data Transformation Services.
Once the dts has run, I get this error message "Error Source : Microsoft Data Transformation Services (DTS) Package Error Description : Error accessing Windows Event Log."
Please help me
thanks in advance
Srinivas
View 1 Replies
View Related
Jun 22, 2007
I am using .Net 2005 and sql 2000. While hosting time i am getting this kind of error...Should i Change any setting in sql and .net
"Sql 2005 does not allow remote connection"
View 2 Replies
View Related
Sep 7, 2007
Hi, I get the below error (after clicking login in my home page, so home page works well) when I open my website for the first time after I restart my server or my client machine.
" Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
From the next time onwards it is connecting without any problems.
can anyone figure out what could be the problem here?
View 5 Replies
View Related
Oct 8, 2001
I have a problem with RT Error 3146. Running Sql 7 back end, Access 2000 front end. Inherited this problem would appreciate if anyone can help.
View 1 Replies
View Related
Dec 28, 2006
This is one strange situation I am facing, in SQL 2005 server-V.B 6.0 combination.
Here rsReport is an ADODB.Recordset and capturing data by sql 2005 connection string of adUseClient as cursor location.
strSql = sql string
rsReport.Open strSQL, Cn, adOpenDynamic, adLockOptimistic
rsReport!EXTRAFOREOS = 0
---at this point it gives the error - run-time error '2147217887(80040e21)
Multiple step opertion generated errors - check each value status
rsReport.Update
But if I use sql 2000 it is working fine..
So please suggest some way to execute it in sql 2005.
thanks & regards,
franco
View 1 Replies
View Related
Mar 18, 2004
I installed a program that put Microsoft SQL Server on my system, Windows XP. The next day I tried to load a MSDOS Database program, Nutplus (Ultrapls), now I get a Run-Time error, R6009. The program will not load. Please help!!!!!, Thank you in advance.
View 1 Replies
View Related
Feb 10, 2007
hi i am trying to insert time in my column which is in my table.my table has one column named as "intime" which has datatype as datetime.
i am doing thuis in vb.net.
i used this code in vb.net to get time:
dim dat as datetime=datetime.now.tostring("hh:mm:ss tt")
and i got time.but i am having this spc for insert:
create procedure sptimeinsert(@time datetime)
as
insert into time values:
An unhandled exception of type 'System.Data.SqlTypes.SqlTypeException' occurred in system.data.dll
Additional information: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM
please any one help to solve this error.
View 5 Replies
View Related
Mar 1, 2008
Hi,
While i am trying to connect to msdb in SSIS, i get teh following message
TCP/IP Provider TimeOut Error[258].
I am running MS Sql server 2005 on Windows XP SP2
View 2 Replies
View Related
Dec 20, 2005
What do you think of a query that generates aSystem.Data.SqlClient.SqlException when submitted via a application,but when run through QueryAnalyzer or EnterpriseManager doesn'tgenerate a error? Here are 2 examples of the query:SELECT table1.*,table2.field1,table2.field2,table2.field3 FROMtable1,table2 WHERE table1.field1 = table2.field1 ANDtable1.field2='103' ANDtable2.TStamp > '12/19/2005 12:20:14 PM' ORDER BY table2.TStampSystem.Data.SqlClient.SqlException: Line 1: Incorrect syntax near '12'.SELECT table1.*,table2.field1,table2.field2,table2.field3 FROMtable1,table2 WHERE table1.field1 = table2.field1 ANDtable1.field2='103' ANDtable2.TStamp > '12/8/2005 8:29:43 AM'ORDER BY table2.TStampSystem.Data.SqlClient.SqlException: Line 1: Incorrect syntax near '8'.I believe the error is referencing the hour portion of the timestamp.When I run these queries through QA/EM I don't get a result set ... somaybe those apps just trap the exception and ignore it. Still, seeanything wrong with the TStamp?
View 4 Replies
View Related
Jun 3, 2008
Hi all
My application having connection string which having Server Name --Erlier it is working fine.
Now IP got chaged Server name is same but now Iam unable to connect server.
Please help me regarding.
View 4 Replies
View Related
