Deadlock error(-2147467259) + SQL Server

Hello,
I have a window-less VB application running as a SQL server job.
The application is very simple and it just picks up the blob file from
filesystem and inserts into the database. I am using SQL Server 2000
running on Windows server 2003 standard edition.
Most of the time my application works fine, but sometimes the
following error is thrown and then and the application terminates.
"Transaction (Process ID 56) was deadlocked on lock resources with
another process and has been chosen as the deadlock victim. Rerun the
transaction. Error Number : -2147467259."
I am unable to trace the problem. I have all the latest servicepacks
and updates installed on my system. Please help me on this.
Regards,
Anil K Gupta.Hi
There are a few chapters in the BOL about DEADLOCKs ,have you read them?
"Anil K. Gupta" <anylcumar@.gmail.com> wrote in message
news:2770ae9d.0504262034.14d69c91@.posting.google.com...
> Hello,
> I have a window-less VB application running as a SQL server job.
> The application is very simple and it just picks up the blob file from
> filesystem and inserts into the database. I am using SQL Server 2000
> running on Windows server 2003 standard edition.
> Most of the time my application works fine, but sometimes the
> following error is thrown and then and the application terminates.
> "Transaction (Process ID 56) was deadlocked on lock resources with
> another process and has been chosen as the deadlock victim. Rerun the
> transaction. Error Number : -2147467259."
> I am unable to trace the problem. I have all the latest servicepacks
> and updates installed on my system. Please help me on this.
> Regards,
> Anil K Gupta.|||As above +
Sounds like your VB code needs error trapping IE On Error GoTo ...
OR
Inline error checking where you check Err.Number after every statement of
significance. A good method is On error goto ... for general code blocks
that could produce an error and to use the inline checking for lines where
you expect you may get an error and handle it there and then specifically.
EG.
sub MyUpdater()
dim ....
On error goto MU_Error
... general code.
... avoid zero divides as always
... prevent preventable errors as always
... now for somethin error prone
On error resume next
err= 0
rs.Update
if err <> 0 then
.. error handler specific to the above.
end if
On error goto MU_Error
...
...
Exit sub
MU_Error:
msgbox "Error:" & err.description
... possibly log the error to a disc file so you can add specific handlers
end sub
"Anil K. Gupta" <anylcumar@.gmail.com> wrote in message
news:2770ae9d.0504262034.14d69c91@.posting.google.com...
> Hello,
> I have a window-less VB application running as a SQL server job.
> The application is very simple and it just picks up the blob file from
> filesystem and inserts into the database. I am using SQL Server 2000
> running on Windows server 2003 standard edition.
> Most of the time my application works fine, but sometimes the
> following error is thrown and then and the application terminates.
> "Transaction (Process ID 56) was deadlocked on lock resources with
> another process and has been chosen as the deadlock victim. Rerun the
> transaction. Error Number : -2147467259."
> I am unable to trace the problem. I hav
e all the latest servicepacks
> and updates installed on my system. Please help me on this.
> Regards,
> Anil K Gupta.

Deadlock : What the meaning of associatedObjectId

In 2005, when 1222 trace flag is activated, I get in the error log file, among other very useful informations, this kind of message
keylock hobtid=xxxxxxx dbid=XX indexname=...objectname=... id=lock13c50480 mode=S associatedObjectId=72057594039304192
or
pagelock fileid=X pageid=xxxx dbid=XX objectname=.... id=lock5f69480 mode=IX associatedObjectId=72057594378518528
What is the meaning of associatedObjectId?
It always starts with 72057594xxxxx and does not look like it is related to the locked object
In my case, OBJECT_NAME and OBJECT_ID did not return any relevant information
Thanks
Med
Hi
This should match a waitresource in the process list and in the waiter list,
you should also should also see that database id for this which is probably 2
ie tempdb.
Check out Bart Duncan Blog
http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx
John
"Med Bouchenafa" wrote:

> In 2005, when 1222 trace flag is activated, I get in the error log file, among other very useful informations, this kind of message
> keylock hobtid=xxxxxxx dbid=XX indexname=...objectname=... id=lock13c50480 mode=S associatedObjectId=72057594039304192
> or
> pagelock fileid=X pageid=xxxx dbid=XX objectname=.... id=lock5f69480 mode=IX associatedObjectId=72057594378518528
>
> What is the meaning of associatedObjectId?
> It always starts with 72057594xxxxx and does not look like it is related to the locked object
> In my case, OBJECT_NAME and OBJECT_ID did not return any relevant information
> Thanks
> Med
>
|||Med,
I don't know if the associatedObjectId will help you any, although you do
have the dbid and the objectname to focus your attention. From the Books
Online article "Detecting and Ending Deadlocks"
http://msdn2.microsoft.com/en-us/library/ms178104.aspx :
associatedObjectId. Represents the HoBT (heap or b-tree) ID.
RLF
"Med Bouchenafa" <com.hotmail@.bouchenafa> wrote in message
news:%23znq0EVTIHA.5516@.TK2MSFTNGP02.phx.gbl...
In 2005, when 1222 trace flag is activated, I get in the error log file,
among other very useful informations, this kind of message
keylock hobtid=xxxxxxx dbid=XX indexname=...objectname=...
id=lock13c50480 mode=S associatedObjectId=72057594039304192
or
pagelock fileid=X pageid=xxxx dbid=XX objectname=....
id=lock5f69480 mode=IX associatedObjectId=72057594378518528
What is the meaning of associatedObjectId?
It always starts with 72057594xxxxx and does not look like it is related to
the locked object
In my case, OBJECT_NAME and OBJECT_ID did not return any relevant
information
Thanks
Med
|||You're right...
That's the way it is documented in the books online.
To have the object name, I run a query like this
SELECT OBJECT_NAME(object_id) FROM sys.partitions WHERE partition_id =
@.associatedObjectId
and it worked
What surprised me is the fact that they all started with 72057594xxxxx
It looks like partion_id is a component of two or more values...
Thanks again
Med
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:uSgP$qVTIHA.5404@.TK2MSFTNGP03.phx.gbl...
> Med,
> I don't know if the associatedObjectId will help you any, although you do
> have the dbid and the objectname to focus your attention. From the Books
> Online article "Detecting and Ending Deadlocks"
> http://msdn2.microsoft.com/en-us/library/ms178104.aspx :
> associatedObjectId. Represents the HoBT (heap or b-tree) ID.
> RLF
> "Med Bouchenafa" <com.hotmail@.bouchenafa> wrote in message
> news:%23znq0EVTIHA.5516@.TK2MSFTNGP02.phx.gbl...
> In 2005, when 1222 trace flag is activated, I get in the error log file,
> among other very useful informations, this kind of message
> keylock hobtid=xxxxxxx dbid=XX indexname=...objectname=...
> id=lock13c50480 mode=S associatedObjectId=72057594039304192
> or
> pagelock fileid=X pageid=xxxx dbid=XX
> objectname=.... id=lock5f69480 mode=IX
> associatedObjectId=72057594378518528
>
> What is the meaning of associatedObjectId?
> It always starts with 72057594xxxxx and does not look like it is related
> to the locked object
> In my case, OBJECT_NAME and OBJECT_ID did not return any relevant
> information
> Thanks
> Med
>
>

Deadlock : What the meaning of associatedObjectId

In 2005, when 1222 trace flag is activated, I get in the error log file, amo
ng other very useful informations, this kind of message
keylock hobtid=xxxxxxx dbid=XX indexname=...objectname=...
id=lock13c50480 mode=S associatedObjectId=72057594039304192
or
pagelock fileid=X pageid=xxxx dbid=XX objectname=....
id=lock5f69480 mode=IX associatedObjectId=7205759437851852
8
What is the meaning of associatedObjectId?
It always starts with 72057594xxxxx and does not look like it is related to
the locked object
In my case, OBJECT_NAME and OBJECT_ID did not return any relevant informatio
n
Thanks
MedHi
This should match a waitresource in the process list and in the waiter list,
you should also should also see that database id for this which is probably
2
ie tempdb.
Check out Bart Duncan Blog
http://blogs.msdn.com/bartd/archive...
-1.aspx
John
"Med Bouchenafa" wrote:

> In 2005, when 1222 trace flag is activated, I get in the error log file, a
mong other very useful informations, this kind of message
> keylock hobtid=xxxxxxx dbid=XX indexname=...objectname=...
id=lock13c50480 mode=S associatedObjectId=72057594039304192
> or
> pagelock fileid=X pageid=xxxx dbid=XX objectname=...
. id=lock5f69480 mode=IX associatedObjectId=72057594378518
528
>
> What is the meaning of associatedObjectId?
> It always starts with 72057594xxxxx and does not look like it is related
to the locked object
> In my case, OBJECT_NAME and OBJECT_ID did not return any relevant informat
ion
> Thanks
> Med
>|||Med,
I don't know if the associatedObjectId will help you any, although you do
have the dbid and the objectname to focus your attention. From the Books
Online article "Detecting and Ending Deadlocks"
http://msdn2.microsoft.com/en-us/library/ms178104.aspx :
associatedObjectId. Represents the HoBT (heap or b-tree) ID.
RLF
"Med Bouchenafa" <com.hotmail@.bouchenafa> wrote in message
news:%23znq0EVTIHA.5516@.TK2MSFTNGP02.phx.gbl...
In 2005, when 1222 trace flag is activated, I get in the error log file,
among other very useful informations, this kind of message
keylock hobtid=xxxxxxx dbid=XX indexname=...objectname=...
id=lock13c50480 mode=S associatedObjectId=72057594039304192
or
pagelock fileid=X pageid=xxxx dbid=XX objectname=....
id=lock5f69480 mode=IX associatedObjectId=72057594378518528
What is the meaning of associatedObjectId?
It always starts with 72057594xxxxx and does not look like it is related to
the locked object
In my case, OBJECT_NAME and OBJECT_ID did not return any relevant
information
Thanks
Med|||You're right...
That's the way it is documented in the books online.
To have the object name, I run a query like this
SELECT OBJECT_NAME(object_id) FROM sys.partitions WHERE partition_id =
@.associatedObjectId
and it worked
What surprised me is the fact that they all started with 72057594xxxxx
It looks like partion_id is a component of two or more values...
Thanks again
Med
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:uSgP$qVTIHA.5404@.TK2MSFTNGP03.phx.gbl...
> Med,
> I don't know if the associatedObjectId will help you any, although you do
> have the dbid and the objectname to focus your attention. From the Books
> Online article "Detecting and Ending Deadlocks"
> http://msdn2.microsoft.com/en-us/library/ms178104.aspx :
> associatedObjectId. Represents the HoBT (heap or b-tree) ID.
> RLF
> "Med Bouchenafa" <com.hotmail@.bouchenafa> wrote in message
> news:%23znq0EVTIHA.5516@.TK2MSFTNGP02.phx.gbl...
> In 2005, when 1222 trace flag is activated, I get in the error log file,
> among other very useful informations, this kind of message
> keylock hobtid=xxxxxxx dbid=XX indexname=...objectname=...
> id=lock13c50480 mode=S associatedObjectId=72057594039304192
> or
> pagelock fileid=X pageid=xxxx dbid=XX
> objectname=.... id=lock5f69480 mode=IX
> associatedObjectId=72057594378518528
>
> What is the meaning of associatedObjectId?
> It always starts with 72057594xxxxx and does not look like it is related
> to the locked object
> In my case, OBJECT_NAME and OBJECT_ID did not return any relevant
> information
> Thanks
> Med
>
>

deadlock

hello
im inserting some records from access file to sql server table with for loop
but oafter inseting some records i get this error
please help me
thank you
[Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 87)
was deadlocked on lock | communication buffer resources with another process
and has been chosen as the deadlock victim. Rerun the transaction.Hi
Any activities during the inserting? How do you perform this batch?
"javad ebrahimnezhad" <sorena@.parskhazar.net> wrote in message
news:eCwO15KIGHA.516@.TK2MSFTNGP15.phx.gbl...
> hello
> im inserting some records from access file to sql server table with for
> loop
> but oafter inseting some records i get this error
> please help me
> thank you
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 87)
> was deadlocked on lock | communication buffer resources with another
> process and has been chosen as the deadlock victim. Rerun the transaction.
>|||javad ebrahimnezhad (sorena@.parskhazar.net) writes:
> im inserting some records from access file to sql server table with for
> loop but oafter inseting some records i get this error
> please help me
> thank you
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 87)
> was deadlocked on lock | communication buffer resources with another
> process and has been chosen as the deadlock victim. Rerun the
> transaction.
Apparently there is other activitity on the server that your insert process
collides with. You should contact your DBA. If he already have enabled
deadlock tracing, you might be enable to identify the issue by checking
the error log.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||It might work better bulk inserting the MS Access data using a DTS package.
"javad ebrahimnezhad" <sorena@.parskhazar.net> wrote in message
news:eCwO15KIGHA.516@.TK2MSFTNGP15.phx.gbl...
> hello
> im inserting some records from access file to sql server table with for
> loop
> but oafter inseting some records i get this error
> please help me
> thank you
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 87)
> was deadlocked on lock | communication buffer resources with another
> process and has been chosen as the deadlock victim. Rerun the transaction.
>

Dead Lock Error in Replication

Hello All,
As I was going trough the log file generated (as a result of -Output <filepath> -OutputVerboseLevel 2). I saw some error lines which I would like to share:

Percent Complete: 4
Downloading data changes to the Subscriber
The process could not enumerate changes at the 'Publisher'.
Percent Complete: 0
The process could not enumerate changes at the 'Publisher'.
Percent Complete: 0
Category:NULL
Source: Merge Replication Provider
Number: -2147200999
Message: The process could not enumerate changes at the 'Publisher'.
Percent Complete: 0
Category:COMMAND
Source: Failed Command
Number: 0
Message: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
Percent Complete: 0
Category:SQLSERVER
Source: SERVER_PUBLISHER
Number: 1205
Message: Transaction (Process ID 54) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Disconnecting from Publisher 'SERVER_PUBLISHER'
Disconnecting from Subscriber 'SERVER_SUBS'
Disconnecting from Publisher 'SERVER_PUBLISHER'
Disconnecting from Publisher 'SERVER_PUBLISHER'
Disconnecting from Publisher 'SERVER_PUBLISHER'
Disconnecting from Publisher 'SERVER_PUBLISHER'
Disconnecting from Subscriber 'SERVER_SUBS'
Disconnecting from Subscriber 'SERVER_SUBS'
Disconnecting from Subscriber 'SERVER_SUBS'
Disconnecting from Subscriber 'SERVER_SUBS'
Disconnecting from Publisher 'SERVER_PUBLISHER'
Disconnecting from Distributor 'SERVER_PUBLISHER'

I am using Merge Replication. I understand the process failed due to some DeadLocking. How do I further investigate this process and avoid it happening again in the future.

Thanks
AnandTry restarting the Merge Agent and check the query timeout value.|||I have encountered the same problem. Could you tell me how to set the query timeout value? Run command "sp_configure 'remote query timeout', 0" ?|||Hi,

1.Open SQL Enterprise Manager
2.Expand the SQL Server Group > Select your server
3.Right click on your server > Properties
4.Go to the Connections Tab
5.Enter the Query Timeout Value ( bottom ).

DDL file to convert from mySQL to SQLServerXXX

We want to migrate a mySQL database to sql server 2000 or sql Server 2005. I have been given a DDL file to perform the conversion, but I don't know what to do with the file? Can anyone help me out? From what I can conclude, the DDL files is a script. So how do I run this script? Where do I place the file, before I run it?

Please help !

IF its a small file (with few tables/storedprocs/views..etc) I would go through the script to check for syntax errors. You could even to a "syntax check" from the query analyzer of SQL Server. Get the script fixed if there are any issues. Then create a database on SQL Server and compile the scripts against the DB.I believe there are SQL Server upgrade/migrate advisors. you can always google and check out any tips.|||

Try this blog and if it work let me know

http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

dbnmpipe.exe for MS-DOS

I recently purchased sql 2000.
I need connectivity for an old DOS program.
I see that I need the file DBNMPIPE.EXE
I can't find this file anywhere on my CD's or on
Microsofts website.
Where can I get it?
"Cash Woodward" <cash@.grandtarghee.com> wrote in message
news:1f67801c457c1$bfc79810$a501280a@.phx.gbl...
> I recently purchased sql 2000.
> I need connectivity for an old DOS program.
> I see that I need the file DBNMPIPE.EXE
> I can't find this file anywhere on my CD's or on
> Microsofts website.
> Where can I get it?
I believe you are in non-supported territory here (from the SQL Server web
site):
Client Support:
.. Windows 955, Windows 98, Windows Me, Windows NT Workstation 4.0, Windows
2000 Professional, Windows XP Professional, and Windows XP Home Edition are
supported.
Steve
|||Actually it states that older clients will still work with sql 2000.
"Steve Thompson" wrote:

> "Cash Woodward" <cash@.grandtarghee.com> wrote in message
> news:1f67801c457c1$bfc79810$a501280a@.phx.gbl...
> I believe you are in non-supported territory here (from the SQL Server web
> site):
> Client Support:
> .. Windows 955, Windows 98, Windows Me, Windows NT Workstation 4.0, Windows
> 2000 Professional, Windows XP Professional, and Windows XP Home Edition are
> supported.
> Steve
>
>
|||Sent by email
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforu...?SRV=MSDevApps
(faqxxx.zip in lib 7)
or http://www.ntfaq.com/Articles/Index...partmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq
|||Older DOS based clients? Can you send a reference?
Thanks, Steve
"Cash Woodward" <Cash Woodward@.discussions.microsoft.com> wrote in message
news:7ECE2A36-195D-4120-9D4F-A94142E311A0@.microsoft.com...[vbcol=seagreen]
> Actually it states that older clients will still work with sql 2000.
> "Steve Thompson" wrote:
web[vbcol=seagreen]
Windows[vbcol=seagreen]
are[vbcol=seagreen]
|||See the reply #4 from Neil Pike.
This is from archive file SQL7DBLIBSUPPORT.TXT
This is what I have read from Microsofts website also.
Q. Does SQL 7/2000 support DB-Library? What about 16-bit clients - DOS
etc.?
A. Yes it does, but DB-Library is functionally stabilised at the 6.5
level. Therefore if a DB-Library client on whatever platform worked
against a 6.5 database it should work against the same database migrated
to SQL 7.0/2000.
None of the SQL 7.0 features like unicode, character columns greater
than 255 characters etc. are in DB-Library though. So if you utilise
any SQL 7.0 features then these can only be accessed by ODBC 3.7 or
OLE-DB clients.
Similarly for 16-bit clients. These are supported, but only with the
6.5 levels of ODBC/DB-Library code. 16-bit clients cannot access new
SQL 7.0 features either.
The 16-bit client code is not supplied with 7.0/2000 - you will have to
get it from the 6.5 CD-ROM. This includes DOS and Win 3.x drivers.
===
v1.03 2000.04.28
Applies to SQL Server versions : 7.0, 2000
FAQ Categories : Connectivity
Related FAQ articles : n/a
Related Microsoft Kb articles : n/a
Other related information : n/a
Authors : Neil Pike
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
|||Thank you Cash -- very interesting!
"Cash Woodward" <cash@.grandtarghee.com> wrote in message
news:%23ggDDuSWEHA.1164@.tk2msftngp13.phx.gbl...
> See the reply #4 from Neil Pike.
> This is from archive file SQL7DBLIBSUPPORT.TXT
> This is what I have read from Microsofts website also.
> Q. Does SQL 7/2000 support DB-Library? What about 16-bit clients - DOS
> etc.?
> A. Yes it does, but DB-Library is functionally stabilised at the 6.5
> level. Therefore if a DB-Library client on whatever platform worked
> against a 6.5 database it should work against the same database migrated
> to SQL 7.0/2000.
> None of the SQL 7.0 features like unicode, character columns greater
> than 255 characters etc. are in DB-Library though. So if you utilise
> any SQL 7.0 features then these can only be accessed by ODBC 3.7 or
> OLE-DB clients.
> Similarly for 16-bit clients. These are supported, but only with the
> 6.5 levels of ODBC/DB-Library code. 16-bit clients cannot access new
> SQL 7.0 features either.
> The 16-bit client code is not supplied with 7.0/2000 - you will have to
> get it from the 6.5 CD-ROM. This includes DOS and Win 3.x drivers.
> ===
> v1.03 2000.04.28
> Applies to SQL Server versions : 7.0, 2000
> FAQ Categories : Connectivity
> Related FAQ articles : n/a
> Related Microsoft Kb articles : n/a
> Other related information : n/a
> Authors : Neil Pike
>
>
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!

DBNETLIB error

Platform:
Windows 2003 ent ed, SQL Server 2000 sp3a enterprise
We tried to bcp file into our Failover Cluster SQL Server database, but with
serious error:
SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or access denied.
SQLState = 01000, NativeError = 5
Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect()).
How can I resolove this? Do I need reboot server to perform failover or
change SQL Server Network Library setting?
Thanks.
Maggie
Hi,
do you have Named Pipes enabled?
Danijel
"Maggie" <Maggie@.discussions.microsoft.com> wrote in message
news:F210EFB0-2E65-48F2-8BE7-0EFCAA7847A8@.microsoft.com...
> Platform:
> Windows 2003 ent ed, SQL Server 2000 sp3a enterprise
> We tried to bcp file into our Failover Cluster SQL Server database, but
> with
> serious error:
> SQLState = 08001, NativeError = 17
> Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
> exist or access denied.
> SQLState = 01000, NativeError = 5
> Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
> (Connect()).
> How can I resolove this? Do I need reboot server to perform failover or
> change SQL Server Network Library setting?
> Thanks.
> Maggie
|||Yes. We have both named pipes and tcpip.
"Danijel Novak" wrote:

> Hi,
> do you have Named Pipes enabled?
> Danijel
> "Maggie" <Maggie@.discussions.microsoft.com> wrote in message
> news:F210EFB0-2E65-48F2-8BE7-0EFCAA7847A8@.microsoft.com...
>
>
|||Try to disable or even remove Named Pipes from the Server Network utility.
It helped in two cases I had in last two months. Maybe it will help you.
take a look at the Q below. It describes the problem with backup but in the
boot there is some words about windows 2003 having some problem with Named
Pipes in connection with MDAC 2.8.
http://support.microsoft.com/kb/827452
Danijel
"Maggie" <Maggie@.discussions.microsoft.com> wrote in message
news:BDD7D99D-77E5-4FFF-8DB2-04BD530EB96E@.microsoft.com...[vbcol=seagreen]
> Yes. We have both named pipes and tcpip.
> "Danijel Novak" wrote:
but[vbcol=seagreen]
not[vbcol=seagreen]
or[vbcol=seagreen]

DB-LIBRARY error, pls help !

Hello,
i work on a simulationsprogramme. it reads data from a server and then use
it for the simulation. then puts the result in a file. i have a big
problem. i have this error and have no idea what should i do...
please anybody help me .
this is a piece of the output in the file within the error is contained:
..
..
..
LA 07.01.2004 07:59:20 auft_id=28
id | bezeichnung | vari_id | stueckzahl
P 07.01.2004 -842150451:-842150451:-842150451 Ende der Pause
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
P 07.01.2004 -842150451:-842150451:-842150451 Anfang der Pause
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
Auftragsende fuer auft_id = 29
LA 07.01.2004 00:06:45 auft_id=29
id | bezeichnung | vari_id | stueckzahl
Auftragsende fuer auft_id = 30
..
..
..
thanks in advance
lyuboe
Looks like the data and time in the data does not confirm to valid datetime
values.
Speak to the software vendor who wrote your application.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"lyuboe via droptable.com" <forum@.nospam.droptable.com> wrote in message
news:445fef15717a4976845e73f8f7b93a76@.droptable.co m...
> Hello,
> i work on a simulationsprogramme. it reads data from a server and then use
> it for the simulation. then puts the result in a file. i have a big
> problem. i have this error and have no idea what should i do...
> please anybody help me .
> this is a piece of the output in the file within the error is contained:
> .
> .
> .
> LA 07.01.2004 07:59:20 auft_id=28
> id | bezeichnung | vari_id | stueckzahl
> P 07.01.2004 -842150451:-842150451:-842150451 Ende der Pause
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> P 07.01.2004 -842150451:-842150451:-842150451 Anfang der Pause
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> Auftragsende fuer auft_id = 29
> LA 07.01.2004 00:06:45 auft_id=29
> id | bezeichnung | vari_id | stueckzahl
> Auftragsende fuer auft_id = 30
> .
> .
> .
> thanks in advance
> lyuboe

DB-LIBRARY error, pls help !

Hello,
i work on a simulationsprogramme. it reads data from a server and then use
it for the simulation. then puts the result in a file. i have a big
problem. i have this error and have no idea what should i do...
please anybody help me .
this is a piece of the output in the file within the error is contained:
.
.
.
LA 07.01.2004 07:59:20 auft_id=28
id | bezeichnung | vari_id | stueckzahl
P 07.01.2004 -842150451:-842150451:-842150451 Ende der Pause
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
SQL Server.
P 07.01.2004 -842150451:-842150451:-842150451 Anfang der Pause
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
SQL Server.
Auftragsende fuer auft_id = 29
LA 07.01.2004 00:06:45 auft_id=29
id | bezeichnung | vari_id | stueckzahl
Auftragsende fuer auft_id = 30
.
.
.
thanks in advance
lyuboeLooks like the data and time in the data does not confirm to valid datetime
values.
Speak to the software vendor who wrote your application.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"lyuboe via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in message
news:445fef15717a4976845e73f8f7b93a76@.SQLMonster.com...
> Hello,
> i work on a simulationsprogramme. it reads data from a server and then use
> it for the simulation. then puts the result in a file. i have a big
> problem. i have this error and have no idea what should i do...
> please anybody help me .
> this is a piece of the output in the file within the error is contained:
> .
> .
> .
> LA 07.01.2004 07:59:20 auft_id=28
> id | bezeichnung | vari_id | stueckzahl
> P 07.01.2004 -842150451:-842150451:-842150451 Ende der Pause
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
> SQL Server.
> P 07.01.2004 -842150451:-842150451:-842150451 Anfang der Pause
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
> SQL Server.
> Auftragsende fuer auft_id = 29
> LA 07.01.2004 00:06:45 auft_id=29
> id | bezeichnung | vari_id | stueckzahl
> Auftragsende fuer auft_id = 30
> .
> .
> .
> thanks in advance
> lyuboe

DB-LIBRARY error, pls help !

Hello,
i work on a simulationsprogramme. it reads data from a server and then use
it for the simulation. then puts the result in a file. i have a big
problem. i have this error and have no idea what should i do...
please anybody help me .
this is a piece of the output in the file within the error is contained:
.
.
.
LA 07.01.2004 07:59:20 auft_id=28
id | bezeichnung | vari_id | stueckzahl
P 07.01.2004 -842150451:-842150451:-842150451 Ende der Pause
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
P 07.01.2004 -842150451:-842150451:-842150451 Anfang der Pause
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
Auftragsende fuer auft_id = 29
LA 07.01.2004 00:06:45 auft_id=29
id | bezeichnung | vari_id | stueckzahl
Auftragsende fuer auft_id = 30
.
.
.
thanks in advance
lyuboeLooks like the data and time in the data does not confirm to valid datetime
values.
Speak to the software vendor who wrote your application.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"lyuboe via droptable.com" <forum@.nospam.droptable.com> wrote in message
news:445fef15717a4976845e73f8f7b93a76@.SQ
droptable.com...
> Hello,
> i work on a simulationsprogramme. it reads data from a server and then use
> it for the simulation. then puts the result in a file. i have a big
> problem. i have this error and have no idea what should i do...
> please anybody help me .
> this is a piece of the output in the file within the error is contained:
> .
> .
> .
> LA 07.01.2004 07:59:20 auft_id=28
> id | bezeichnung | vari_id | stueckzahl
> P 07.01.2004 -842150451:-842150451:-842150451 Ende der Pause
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> P 07.01.2004 -842150451:-842150451:-842150451 Anfang der Pause
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> Auftragsende fuer auft_id = 29
> LA 07.01.2004 00:06:45 auft_id=29
> id | bezeichnung | vari_id | stueckzahl
> Auftragsende fuer auft_id = 30
> .
> .
> .
> thanks in advance
> lyuboe

Dbf To Ms Sql Server 2000

:eek: HI ALL
I m having my data in DBF file format. now i want to use my .Dbf files Data in to SQL Server 2000. so i can use SQL query on that and extract data from that. i want to use my DBF data in SQL. tell me how it is possible. plz give me soloution ...
Thanx
Manu VermaDo you still have a database server that will read the dbf files? If so, you can connect to it from SQL Server using DTS and import the data.|||Do you still have a database server that will read the dbf files? If so, you can connect to it from SQL Server using DTS and import the data.

we can read DBF files even in Excel or in VFoxpro. tell me the way to Import the data. i tried in SQL Server 2000. I select the Visual Foxpro ODBC Driver it gave the error. How can i import data via using DTS?|||we can read DBF files even in Excel or in VFoxpro. tell me the way to Import the data. i tried in SQL Server 2000. I select the Visual Foxpro ODBC Driver it gave the error. How can i import data via using DTS?

Follow this...
Open EM>Right click on Database>All Tasks>Import data>Select Microsoft Visual Foxpro Driver as data source>Select User/SystemDSN>New>System data source>Visual foxpro driver>Give data source name>Browse the database>Select the created DSN> and you are through...:cool:|||I select the Visual Foxpro ODBC Driver it gave the error.The error? Believe it or not, there are actually several errors you can get. Care to post the message you received?|||Hi,

You might need to download the latest drivers for Foxpro/Dbf.
Thanks

RN|||When i import the data from Foxpro .dbf file to sql, there is error:

Insert error, Column 47 ('mrlvbd',DBType_DBTimeStamp),status 6: Data Overflow.

Then i found out that it might be because of the date field of the data is blank. What can i do to solve this?

Thanks in advance|||I have found the solution.

1 ) In the Select Source Dialog Box,select the Transform Button.

2) Change the Destination Datatype of the related field from SmallDateTime to DateTime

Thanks

DBF to be attached in sqlserver2000/2005

Hi, Everybody

Please tell me the detailed procedure for having a *.DBF file attached to sqlserver 2000 or 2005.

I just want this file which is of visualfoxpro - DBF to be in sqlserver...........

thanks and regards,

Vishwanath.

Hey,

I don't believe SQL can import new database structures. You may, through DTS/SSIS, be able to copy the structure/data over, and that would create a SQL-compliant structure, depending on what was in the tables. I thought foxpro was more of an object-oriented database, which is not what SQL is...

|||

Hi Vishu

A lot depends on what you mean by "attached." You can use a linked server to access Fox data in SQL Server. You will need the FoxPro and Visual FoxPro OLE DB data provider, downloadable from a link at http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx . If you have a DBC (Database Container) in the directory where the Fox tables are then point your connection string to it. Otherwise, use the "Free Table" option and just point the connection string to the directory where the DBFs are. When you select data from the linked server use code like Select MyField From MyLinkedServer...MyTableName without using ".dbf" on the end of the table name.

|||

Hi!

Visual FoxPro is both an ODBC/OLE DB compliant database and a fully object-oriented development tool. In addition to using DBFs (Fox tables) as the data store you can use an Access MDB or SQL Server. In either the case of SQL Server it would be used as a front end in the same way as VB or C#.

dbf in network location

I tried to connect my *.mdf (using path like this: \\Server\infotec.mdf) file to MSSQL EXpress 2005 engine using MSS Management Studio Express but I get message that attaching databases from network paths is impossible. Is there any possibility to do this?

thx, Tom

Attaching database files in a network location is not recommended. The reason being that SQL Server needs exclusive access to the files, and also needs to ensure that reads and writes are of sufficient speed. The reads and writes also need to follow guaranteed sequence. Very few network devices can satisfy these requirements.

Here's an article that describes the issue in great detail: http://support.microsoft.com/kb/304261/en-us