deadlock/blocking in sql server

Hi,
My application using foxpro sometimes seems like hang and when connect to
sql server. I directly go to the sql server and use sp_lock to check whether
there is any thread is waiting and find out there is indeed one thread is
waiting and i use sp_who and can see one process got blocking. But these
things not happen in foxpro database. How i need to troubleshoot this
problem, what i can do so that i can prevent from blocking/deadlock. I have
a profiler and the profiler save the procedure. So, how i can check and
provent by using this profiler?
Thanks a lot.
regards,
florenceMaybe this article will help you:
http://www.sql-server-performance.com/sf_block_prevention.asp
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Florencelee" <florencelee@.visualsolutions.com.my> wrote in message
news:O6oIkQavEHA.536@.TK2MSFTNGP11.phx.gbl...
> Hi,
> My application using foxpro sometimes seems like hang and when connect
to
> sql server. I directly go to the sql server and use sp_lock to check
whether
> there is any thread is waiting and find out there is indeed one thread is
> waiting and i use sp_who and can see one process got blocking. But these
> things not happen in foxpro database. How i need to troubleshoot this
> problem, what i can do so that i can prevent from blocking/deadlock. I
have
> a profiler and the profiler save the procedure. So, how i can check and
> provent by using this profiler?
> Thanks a lot.
> regards,
> florence
>

deadlock/blocking in sql server

Hi,
My application using foxpro sometimes seems like hang and when connect to
sql server. I directly go to the sql server and use sp_lock to check whether
there is any thread is waiting and find out there is indeed one thread is
waiting and i use sp_who and can see one process got blocking. But these
things not happen in foxpro database. How i need to troubleshoot this
problem, what i can do so that i can prevent from blocking/deadlock. I have
a profiler and the profiler save the procedure. So, how i can check and
provent by using this profiler?
Thanks a lot.
regards,
florence
Maybe this article will help you:
http://www.sql-server-performance.co...prevention.asp
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Florencelee" <florencelee@.visualsolutions.com.my> wrote in message
news:O6oIkQavEHA.536@.TK2MSFTNGP11.phx.gbl...
> Hi,
> My application using foxpro sometimes seems like hang and when connect
to
> sql server. I directly go to the sql server and use sp_lock to check
whether
> there is any thread is waiting and find out there is indeed one thread is
> waiting and i use sp_who and can see one process got blocking. But these
> things not happen in foxpro database. How i need to troubleshoot this
> problem, what i can do so that i can prevent from blocking/deadlock. I
have
> a profiler and the profiler save the procedure. So, how i can check and
> provent by using this profiler?
> Thanks a lot.
> regards,
> florence
>
sql

deadlock/blocking in sql server

Hi,
My application using foxpro sometimes seems like hang and when connect to
sql server. I directly go to the sql server and use sp_lock to check whether
there is any thread is waiting and find out there is indeed one thread is
waiting and i use sp_who and can see one process got blocking. But these
things not happen in foxpro database. How i need to troubleshoot this
problem, what i can do so that i can prevent from blocking/deadlock. I have
a profiler and the profiler save the procedure. So, how i can check and
provent by using this profiler?
Thanks a lot.
regards,
florenceMaybe this article will help you:
http://www.sql-server-performance.c..._prevention.asp
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Florencelee" <florencelee@.visualsolutions.com.my> wrote in message
news:O6oIkQavEHA.536@.TK2MSFTNGP11.phx.gbl...
> Hi,
> My application using foxpro sometimes seems like hang and when connect
to
> sql server. I directly go to the sql server and use sp_lock to check
whether
> there is any thread is waiting and find out there is indeed one thread is
> waiting and i use sp_who and can see one process got blocking. But these
> things not happen in foxpro database. How i need to troubleshoot this
> problem, what i can do so that i can prevent from blocking/deadlock. I
have
> a profiler and the profiler save the procedure. So, how i can check and
> provent by using this profiler?
> Thanks a lot.
> regards,
> florence
>

DBxtra Data explorer

DBxtra Data explorer
DBxtra version 1 is ready.
You can connect to unlimited MS Access, MS SQL Server, Paradox, PDF and Excel tables and queries.
Get the sense out of your data!1
1. Connect to your data
2. Explore your data
3. Design and deploy your reports
4. Export your data
5. Send your data by E-mail
6. Schedule reports and alerts
Try the free Download!
http://www.dbxtra.comADVERTISING

I think i am going to post ads for commercial items that i believe in

"hey you got you chocolate in my peanut butter"
"You got your peanut butter on my chocolate"
"two great tastes that taste great together"
reeses peanut butter cups :eek:|||Hey...whats with the dead chick on the couch?

http://www.dbxtra.com/images/p1.jpg|||I've got another idea for a great commercial venture.

Gasoline powered "adult" toys!

What a marketing opportunity! We can all get rich, very quickly... Live lives of leisure, travel the world, sample the best of everything. We can be rich I tell you, just rich if we all work together to tap this as yet unexplored marketing opportunity!!!

On a (very slightly) more serious note, will an admin please move this thread to the Marketplace (http://www.dbforums.com/f188) where it belongs?

-PatP|||But if will have to marketed for outdoor use only...

Maybe the chick on the couch was using one of your products and passed out from the exhaust...|||pat i hate to tell you this but we already have gasoline powered adult toys.

porsche
ferrari
jaguar
lamborghini
etc.|||pat i hate to tell you this but we already have gasoline powered adult toys... and look at the money that people will spend on them! I tell you, there is a fortune to be made here if we can just find the right products and advertising medium!!!

Somebody, PLEASE move this to the MarketPlace (http://www.dbforums.com/f188)!

-PatP

DBPROCESS is dead or not enabled

why the error message "DBPROCESS is dead or not enabled" appear frequently , but when i run the application again ,it can connect to the server.

What can i do to solve the problem?

SERVER 2000 enterprise edition (not sp4)

Hi,

this is a very generic one, indicating mainly that the communication between the server and the client failed, due to problems like a lost connection, problems in the used protocol, timeouts, or simply a SQL Server error which should be protocolled in the SQL Server log and/or event log (depending on the severity). In addition make sure that you enabled remote connections for named Pipes / TCP.
HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||The version of the sql server is enterprise edition, not at the level sp4.
But is there any problems, when i update the sql server to sq4, will the problem be resolve?
Is this sql server's bug or the network problems or client application's problem.
Anyone can help?|||Anybody has the same problem with me?|||

J'ai exactement le même problème au bout d'un certain temps d'inactivit. Je cherche à le rsoudre. J'ai ce problème depuis que je suis pass à SQL Server 2005. J'accède à SQL Server par l'intermdiaire d'un accès natif dans mes applications Windev. A bient?t avec la solution, j'espère

|||

also check whether the Auto close property of the database is on ... if it is on .. set it OFF and try

select DATABASEPROPERTY ('somedatabase' , 'isAutoClose' ) run this statement and if it returns 1 set this property off and see

Madhu

|||

Je rencontre galement ce problème seulement sur un ordinateur client parmi une dizaine sous Windev en accs natif ( l'ancien ) : j'attends le nouveau avec impatience mais si quelqu'un a une solution ?.

Idem : somedy has solved this problem ?

DBPROCESS is dead or not enabled

why the error message "DBPROCESS is dead or not enabled" appear frequently , but when i run the application again ,it can connect to the server.

What can i do to solve the problem?

SERVER 2000 enterprise edition (not sp4)

Hi,

this is a very generic one, indicating mainly that the communication between the server and the client failed, due to problems like a lost connection, problems in the used protocol, timeouts, or simply a SQL Server error which should be protocolled in the SQL Server log and/or event log (depending on the severity). In addition make sure that you enabled remote connections for named Pipes / TCP.
HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||The version of the sql server is enterprise edition, not at the level sp4.
But is there any problems, when i update the sql server to sq4, will the problem be resolve?
Is this sql server's bug or the network problems or client application's problem.
Anyone can help?|||Anybody has the same problem with me?|||

J'ai exactement le même problème au bout d'un certain temps d'inactivit. Je cherche à le rsoudre. J'ai ce problème depuis que je suis pass à SQL Server 2005. J'accède à SQL Server par l'intermdiaire d'un accès natif dans mes applications Windev. A bient?t avec la solution, j'espère

|||

also check whether the Auto close property of the database is on ... if it is on .. set it OFF and try

select DATABASEPROPERTY ('somedatabase' , 'isAutoClose' ) run this statement and if it returns 1 set this property off and see

Madhu

|||

Je rencontre galement ce problème seulement sur un ordinateur client parmi une dizaine sous Windev en accs natif ( l'ancien ) : j'attends le nouveau avec impatience mais si quelqu'un a une solution ?.

Idem : somedy has solved this problem ?

DBPROCESS is dead or not enabled

why the error message "DBPROCESS is dead or not enabled" appear frequently , but when i run the application again ,it can connect to the server.

What can i do to solve the problem?

SERVER 2000 enterprise edition (not sp4)

Hi,

this is a very generic one, indicating mainly that the communication between the server and the client failed, due to problems like a lost connection, problems in the used protocol, timeouts, or simply a SQL Server error which should be protocolled in the SQL Server log and/or event log (depending on the severity). In addition make sure that you enabled remote connections for named Pipes / TCP.
HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||The version of the sql server is enterprise edition, not at the level sp4.
But is there any problems, when i update the sql server to sq4, will the problem be resolve?
Is this sql server's bug or the network problems or client application's problem.
Anyone can help?|||Anybody has the same problem with me?|||

J'ai exactement le même problème au bout d'un certain temps d'inactivit. Je cherche à le rsoudre. J'ai ce problème depuis que je suis pass à SQL Server 2005. J'accède à SQL Server par l'intermdiaire d'un accès natif dans mes applications Windev. A bient?t avec la solution, j'espère

|||

also check whether the Auto close property of the database is on ... if it is on .. set it OFF and try

select DATABASEPROPERTY ('somedatabase' , 'isAutoClose' ) run this statement and if it returns 1 set this property off and see

Madhu

|||

Je rencontre galement ce problème seulement sur un ordinateur client parmi une dizaine sous Windev en accs natif ( l'ancien ) : j'attends le nouveau avec impatience mais si quelqu'un a une solution ?.

Idem : somedy has solved this problem ?

DBPROCESS is dead or not enabled

why the error message "DBPROCESS is dead or not enabled" appear frequently , but when i run the application again ,it can connect to the server.

What can i do to solve the problem?

SERVER 2000 enterprise edition (not sp4)

Hi,

this is a very generic one, indicating mainly that the communication between the server and the client failed, due to problems like a lost connection, problems in the used protocol, timeouts, or simply a SQL Server error which should be protocolled in the SQL Server log and/or event log (depending on the severity). In addition make sure that you enabled remote connections for named Pipes / TCP.
HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||The version of the sql server is enterprise edition, not at the level sp4.
But is there any problems, when i update the sql server to sq4, will the problem be resolve?
Is this sql server's bug or the network problems or client application's problem.
Anyone can help?|||Anybody has the same problem with me?|||

J'ai exactement le même problème au bout d'un certain temps d'inactivit. Je cherche à le rsoudre. J'ai ce problème depuis que je suis pass à SQL Server 2005. J'accède à SQL Server par l'intermdiaire d'un accès natif dans mes applications Windev. A bient?t avec la solution, j'espère

|||

also check whether the Auto close property of the database is on ... if it is on .. set it OFF and try

select DATABASEPROPERTY ('somedatabase' , 'isAutoClose' ) run this statement and if it returns 1 set this property off and see

Madhu

|||

Je rencontre galement ce problème seulement sur un ordinateur client parmi une dizaine sous Windev en accs natif ( l'ancien ) : j'attends le nouveau avec impatience mais si quelqu'un a une solution ?.

Idem : somedy has solved this problem ?

DBNULL is giving me a headach!

Could someone please help with this:
I'm trying to connect to a sql server 2000 that to web service. When i run
the service i get:
System.InvalidCastException: Specified cast is not valid.
at wsStudents.Service1.GetStudent(String studentlastname) in
C:\Inetpub\wwwroot\wsStudents\Service1.asmx.vb:line 82
and a throws a similar error (Cast from type 'DBNull' to type 'String' is
not valid) when i try to consume it. This code accepts one input and one
output paramer. The value returned from the output paramter seems be Nothing
"
!!
Here's the code:
<WebMethod()> _
Public Function GetStudent(ByVal studentlastname As String) As String
Dim dsResult As New DataSet
Dim strSQL As String
Dim result_outParam As String
'strSQL = "SELECT @.StuFee FROM dbo.Student WHERE
dbo.Student.LastName = @.StuLName and dbo.Student.FirstName =@.StuFName"
strSQL = "SELECT @.StuFee FROM dbo.Student WHERE dbo.Student.LastName
= @.StuLName"
Dim cmd As New SqlCommand(strSQL, conn)
'Add the first input paramter
cmd.Parameters.Add("@.StuLName", SqlDbType.VarChar)
cmd.Parameters("@.StuLName").Direction = ParameterDirection.Input
cmd.Parameters("@.StuLName").Value = studentlastname
'Add the output paramter
cmd.Parameters.Add("@.StuFee", SqlDbType.VarChar, 50)
cmd.Parameters("@.StuFee").Direction = ParameterDirection.Output
If cmd.Connection.State <> ConnectionState.Open Then
conn.Open()
End If
cmd.ExecuteNonQuery()
result_outParam = cmd.Parameters("@.StuFee").Value
Return result_outParam
conn.Close()
I tried to rewrite the last code like this:
result_outParam =
System.DBNull.Value.ToString(cmd.Parameters("@.StuFee").Value)
but no luck
UKok, that is not possible if the value returned is DBNull.
result_outParam = cmd.Parameters("@.StuFee").Value == DBNull.Value ?
string.Empty : cmd.Parameters("@.StuFee").Value.ToString();
This is the long way :-)
HTH, Jens Suessmeyer.|||Thanks Jens
This suggested code i assume is in C# (mine was in vb .net). I'm not
familiar with using "?" symbol. Can you please translate this into VB .net.
Thanks. Execuse my ignorance.
Is this suggested code one line or two lines:
result_outParam = cmd.Parameters("@.StuFee").Value == DBNull.Value ?
string.Empty : cmd.Parameters("@.StuFee").Value.ToString()
UK
"Jens" wrote:

> ok, that is not possible if the value returned is DBNull.
> result_outParam = cmd.Parameters("@.StuFee").Value == DBNull.Value ?
> string.Empty : cmd.Parameters("@.StuFee").Value.ToString();
> This is the long way :-)
> HTH, Jens Suessmeyer.
>|||Nab (Nab@.discussions.microsoft.com) writes:
> This suggested code i assume is in C# (mine was in vb .net). I'm not
> familiar with using "?" symbol. Can you please translate this into VB
> .net.
?: is the C# equivalent of the Iif function in Visual Basic. That is
condition ? true-return : false-return
So Jens's example would read:
result_outParam = Iif(cmd.Parameters("@.StuFee").Value == DBNull.Value, _
string.Empty, _
cmd.Parameters("@.StuFee").Value.ToString())
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|||Thanks. i'll try this and let you know. What I don't understand is that
sometime ago i wrote similar code but never had to to deal with an issue lik
e
this.
I had deleted SQL Servre 2000 since and re-installed it again but never
installed any service packs this time. Could this have something to do with
it?
"Erland Sommarskog" wrote:

> Nab (Nab@.discussions.microsoft.com) writes:
> ?: is the C# equivalent of the Iif function in Visual Basic. That is
> condition ? true-return : false-return
> So Jens's example would read:
> result_outParam = Iif(cmd.Parameters("@.StuFee").Value == DBNull.Value,
_
> string.Empty, _
> cmd.Parameters("@.StuFee").Value.ToString())
>
> --
> 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
>|||
"Erland Sommarskog" wrote:

> Nab (Nab@.discussions.microsoft.com) writes:
> ?: is the C# equivalent of the Iif function in Visual Basic. That is
> condition ? true-return : false-return
> So Jens's example would read:
> result_outParam = Iif(cmd.Parameters("@.StuFee").Value == DBNull.Value,
_
> string.Empty, _
> cmd.Parameters("@.StuFee").Value.ToString())
>
> --
> 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
>|||In addition to what others have posted...
I encounter this often enough that I created a function that I call whenever
I retrieve a value from the database in VB. It saves the time of having to
write an IF statement every time you need to retrieve a value from the
database.
After you have the function your code would read:
result_outParam = nvl(cmd.Parameters("@.StuFee").Value)
Public Shared Function nvl(ByVal strValue As Object) As String
'***************************************
********************************
' Public method
' returns empty strign in place of DB nulls
' prevents errors caused by type discrepencies
'***************************************
********************************
If strValue Is DBNull.Value Then
Return ""
Else
Return strValue
End If
End Function
"Nab" <Nab@.discussions.microsoft.com> wrote in message
news:AC678A4A-BE76-4884-AA65-8D1BFB3697CB@.microsoft.com...
> Could someone please help with this:
>
> I'm trying to connect to a sql server 2000 that to web service. When i
run
> the service i get:
> System.InvalidCastException: Specified cast is not valid.
> at wsStudents.Service1.GetStudent(String studentlastname) in
> C:\Inetpub\wwwroot\wsStudents\Service1.asmx.vb:line 82
> and a throws a similar error (Cast from type 'DBNull' to type 'String' is
> not valid) when i try to consume it. This code accepts one input and one
> output paramer. The value returned from the output paramter seems be
Nothing"
> !!
> Here's the code:
> <WebMethod()> _
> Public Function GetStudent(ByVal studentlastname As String) As String
> Dim dsResult As New DataSet
> Dim strSQL As String
> Dim result_outParam As String
> 'strSQL = "SELECT @.StuFee FROM dbo.Student WHERE
> dbo.Student.LastName = @.StuLName and dbo.Student.FirstName =@.StuFName"
> strSQL = "SELECT @.StuFee FROM dbo.Student WHERE
dbo.Student.LastName
> = @.StuLName"
> Dim cmd As New SqlCommand(strSQL, conn)
> 'Add the first input paramter
> cmd.Parameters.Add("@.StuLName", SqlDbType.VarChar)
> cmd.Parameters("@.StuLName").Direction = ParameterDirection.Input
> cmd.Parameters("@.StuLName").Value = studentlastname
> 'Add the output paramter
> cmd.Parameters.Add("@.StuFee", SqlDbType.VarChar, 50)
> cmd.Parameters("@.StuFee").Direction = ParameterDirection.Output
> If cmd.Connection.State <> ConnectionState.Open Then
> conn.Open()
> End If
> cmd.ExecuteNonQuery()
> result_outParam = cmd.Parameters("@.StuFee").Value
> Return result_outParam
> conn.Close()
> I tried to rewrite the last code like this:
> result_outParam =
> System.DBNull.Value.ToString(cmd.Parameters("@.StuFee").Value)
> but no luck
> --
> UK|||Nab (Nab@.discussions.microsoft.com) writes:
> Thanks. i'll try this and let you know. What I don't understand is that
> sometime ago i wrote similar code but never had to to deal with an issue
> like this.
> I had deleted SQL Servre 2000 since and re-installed it again but never
> installed any service packs this time. Could this have something to do
> with it?
The installation of SQL 2000 cannot affect ADO .Net or VB .Net, as they
are separate products. Maybe you didn't have to deal with any NULL values
the first time?
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|||Thanks for all your replies. Jim's function-based code seems to have worked
better for me!
Cheers.
--
UK
"Jim Underwood" wrote:

> In addition to what others have posted...
> I encounter this often enough that I created a function that I call whenev
er
> I retrieve a value from the database in VB. It saves the time of having t
o
> write an IF statement every time you need to retrieve a value from the
> database.
> After you have the function your code would read:
> result_outParam = nvl(cmd.Parameters("@.StuFee").Value)
> Public Shared Function nvl(ByVal strValue As Object) As String
> '***************************************
********************************
> ' Public method
> ' returns empty strign in place of DB nulls
> ' prevents errors caused by type discrepencies
> '***************************************
********************************
> If strValue Is DBNull.Value Then
> Return ""
> Else
> Return strValue
> End If
> End Function
>
> "Nab" <Nab@.discussions.microsoft.com> wrote in message
> news:AC678A4A-BE76-4884-AA65-8D1BFB3697CB@.microsoft.com...
> run
> Nothing"
> dbo.Student.LastName
>
>|||Apologies. In fact, all suggested solutions worked fine now. Thanks to all.
--
UK
"Jim Underwood" wrote:

> In addition to what others have posted...
> I encounter this often enough that I created a function that I call whenev
er
> I retrieve a value from the database in VB. It saves the time of having t
o
> write an IF statement every time you need to retrieve a value from the
> database.
> After you have the function your code would read:
> result_outParam = nvl(cmd.Parameters("@.StuFee").Value)
> Public Shared Function nvl(ByVal strValue As Object) As String
> '***************************************
********************************
> ' Public method
> ' returns empty strign in place of DB nulls
> ' prevents errors caused by type discrepencies
> '***************************************
********************************
> If strValue Is DBNull.Value Then
> Return ""
> Else
> Return strValue
> End If
> End Function
>
> "Nab" <Nab@.discussions.microsoft.com> wrote in message
> news:AC678A4A-BE76-4884-AA65-8D1BFB3697CB@.microsoft.com...
> run
> Nothing"
> dbo.Student.LastName
>
>

DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Native Code17.

I installed SQL Server 2005 on a station which acts as a Server(Windows XP SP2) and I am getting the Following Error while trying to connect to SQL Server from the SAME Station:

DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Native Code17.

Source Microsoft OLEDB Provider for SQL Server.

I will be waiting for your reply.

Thank you for your support.

Do you have Remote connections enabled ? See the screencast on my site for more information about that.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Thank you for your support.

I have checked your website

But I still havent understood what do you mean by ScreenCast? Can you Elaborate.

What do you mean by Remote connections?

I need an urgent solution to this problem so your help is highly appreciated.

|||See the link below:

http://sqlserver2005.de/SQLServer2005/Screencasts/tabid/60/Default.aspx

Jens K. Suessmeyer

http://www.sqlserver2005.de
|||

After furthur testing, this error has remained, I am still getting this error on SQL Server 2005

I am also facing it with a PC having SQL Server 2000 ?

How can I solve it ?

dbnetlib problem when connecting to sql server through vb6

hi,
I am getting this error message when trying to connect to sql server through vb-sqldmo
-2147467259 (80004005)
DEBNETLIB connection open connect() sql server not found.
please help me out of this problem.
vinod.Can u post your connection string here?|||this is the connection string:
note: this was working alright till yesterday since last two years.

ConStr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Pharma;Data Source=" & lServerName & ";Connect Timeout=15"|||Originally posted by bvmantos
Can u post your connection string here?

this is it:

ConStr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Pharma;Data Source=" & lServerName & ";Connect Timeout=15"|||have you tried both network libraries in your connection string?|||Originally posted by ms_sql_dba
have you tried both network libraries in your connection string?

please explain which libraries u r refererring to, i am using sqldmo.dll

dbmssocn bug?

sometimes, if I connect DNS name for localhost running sql2000, (go to the
router and back) at a simple "SELECT * FROM table" statament I get a long
delay (application hangs for 10-20 second), and drops the connection.
When I change the datasource to "netbios" name, the same statament works
without trouble.
where is the bug? In dbmssocn? in ADO events (I use them...)?
cursorlocations? Why only sometimes?
What did you mean use DNS name and NetBIOS name ?
Are you connecting from a client PC? Does it work with Query Analyser ? Does
it timeout all the time.
"SRINGER Zoltn" <kecskemetisrac@.free-mail.hu> wrote in message
news:O7hVZOiBFHA.3840@.tk2msftngp13.phx.gbl...
> sometimes, if I connect DNS name for localhost running sql2000, (go to the
> router and back) at a simple "SELECT * FROM table" statament I get a long
> delay (application hangs for 10-20 second), and drops the connection.
> When I change the datasource to "netbios" name, the same statament works
> without trouble.
> where is the bug? In dbmssocn? in ADO events (I use them...)?
> cursorlocations? Why only sometimes?
>
|||another relevant information:
if I change cursorlocation to adUseClient, works...
... but I need serverside cursor especially via internet!
|||From the earlier posts, it sounds like you are could just
have some DNS issues in your network. Have you checked the
event logs for such? Have you tried an alias using the IP
address?
-Sue
On Mon, 31 Jan 2005 16:13:33 +0100, "SRINGER Zoltn"
<kecskemetisrac@.free-mail.hu> wrote:

>another relevant information:
>if I change cursorlocation to adUseClient, works...
>
>... but I need serverside cursor especially via internet!
>

dbmssocn bug?

sometimes, if I connect DNS name for localhost running sql2000, (go to the
router and back) at a simple "SELECT * FROM table" statament I get a long
delay (application hangs for 10-20 second), and drops the connection.
When I change the datasource to "netbios" name, the same statament works
without trouble.
where is the bug? In dbmssocn? in ADO events (I use them...)?
cursorlocations? Why only sometimes?What did you mean use DNS name and NetBIOS name ?
Are you connecting from a client PC? Does it work with Query Analyser ? Does
it timeout all the time.
"SRINGER Zoltn" <kecskemetisrac@.free-mail.hu> wrote in message
news:O7hVZOiBFHA.3840@.tk2msftngp13.phx.gbl...
> sometimes, if I connect DNS name for localhost running sql2000, (go to the
> router and back) at a simple "SELECT * FROM table" statament I get a long
> delay (application hangs for 10-20 second), and drops the connection.
> When I change the datasource to "netbios" name, the same statament works
> without trouble.
> where is the bug? In dbmssocn? in ADO events (I use them...)?
> cursorlocations? Why only sometimes?
>|||another relevant information:
if I change cursorlocation to adUseClient, works...
... but I need serverside cursor especially via internet!|||From the earlier posts, it sounds like you are could just
have some DNS issues in your network. Have you checked the
event logs for such? Have you tried an alias using the IP
address?
-Sue
On Mon, 31 Jan 2005 16:13:33 +0100, "SRINGER Zoltn"
<kecskemetisrac@.free-mail.hu> wrote:

>another relevant information:
>if I change cursorlocation to adUseClient, works...
>
>... but I need serverside cursor especially via internet!
>

Db-library network communications layer not loaded

I have an application that needs to to talk to MS SQL Server 2000.
When I connect from a client machine, I am getting db-library network
communications layer not loaded.
What component is it missing?
--
Cathy BIs the file Ntwdblib.dll in the system32 directory?
Ntwdblib is used for db-lib communications usually found in
older applications. It's not installed with MDAC.
-Sue
On Fri, 28 Jul 2006 07:43:02 -0700, Cathy Boehm
<CathyBoehm@.discussions.microsoft.com> wrote:

>I have an application that needs to to talk to MS SQL Server 2000.
>When I connect from a client machine, I am getting db-library network
>communications layer not loaded.
>What component is it missing?

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