The Call To WinSock Originated From Dbnetlib!ConnectionRead+3b6

Sep 12, 2006

Hi,

I have Problem of asp.net 1.1(win2003SerSP1) Hanging And Crushing Dail More than 5 times, Ok when i use debugdiag to trace errors i recieve those two errors. so it cames every debugdiag i generate.

The following threads in w3wp.exe__DefaultAppPool__PID__4684__Date__09_12_2006__Time_09_08_02AM__173__IIS Hang Dump.dmp are waiting on data to be returned from another server via WinSock.

The call to WinSock originated from dbnetlib!ConnectionRead+3b6

( 2 )

33.33% of threads blocked


when i go thread 2 it gives me this message
Thread 2 - System ID 5448





Entry point
mscorsvr!ThreadpoolMgr::intermediateThreadProc

Create time
9/12/2006 9:02:39 AM

Time spent in user mode
0 Days 0:0:0.328

Time spent in kernel mode
0 Days 0:0:0.203



This thread is waiting on data to be returned from another server via WinSock.

The call to WinSock originated from dbnetlib!ConnectionRead+3b6





Function
Source

ntdll!KiFastSystemCallRet


ntdll!NtWaitForSingleObject+c


mswsock!SockWaitForSingleObject+19d


mswsock!WSPRecv+203


ws2_32!WSARecv+77


wsock32!recv+31


dbnetlib!ConnectionRead+3b6


27c0829




27ba269







9 client connection(s) in w3wp.exe__DefaultAppPool__PID__4684__Date__09_12_2006__Time_09_08_02AM__173__IIS Hang Dump.dmp have been executing a request for more than 90 seconds.
Please see the Client Connections section of this report for more detailed information about the connection(s).



the socond one list some pages. but the problem for my side is how to solve the first error.

So, Please Any one who can give me hints where to go, i checked internet and i didn't find.

Thanks Feisal

View 3 Replies


ADVERTISEMENT

SSPI Context / [DBNETLIB][ConnectionRead (recv()).] General Network Error

Dec 28, 2006

Hello together,


since over a week I've been looking to
find out the reason for two error messages I get from our users and
servers, unfortunately without success up to now.



I really hope you can help me.



We are using Win 2k servers with active directory and SQL Server 2000,
clients are all Win XP with SP2. Versions of access are 2002 &
2003. The errors are userspecific and occur in both versions. The
SQL-Servers are accessed with an adp-file in 2002-format.



We have one usergroup which is member of specially many groups. This
affects the size of their windows access token which becomes constantly
larger. In order to enable those users to still access their mailboxes
on our Exchange servers, the DWORD entry "MaxTokenSize" with the
decimal value "65535" was made to the newly created key "Parameters" of
their registry branch
"HKLMSYSTEMCurrentControlSetControlLsaKerberos ".



Since then those users can not access any of our SQL Servers using the
windows authentification. One of them gets the error
"[DBNETLIB][ConnectionRead(recv().] General network error. Check your
network documentation.", the others the error "Check connection:
Failed: Cannot generate SSPI context".



In case of resetting the registry entries (by deleting them), the one
user receives the same error message as the rest while it doesn't make
any difference to those (but at least they can't connect to their
mailboxes).



After having researched the web, I realised in one of the SQL-Servers
logfiles the entry "Invalid buffer received from client.." which lead
me to start to believe it could have to do something with the kerberos
encryption in the first place. Therefore I asked if changes to the
tokensize had been made. I applied the change with "EXEC sp_configure
'network packet size', 65535 RECONFIGURE" on our testsystem and "EXEC
sp_configure" confirms that the value is run.



Consequence: The entry in the SQL Server log doesn't appear any longer, but the users still receive their error messages.





Do you have any hints?



Your comments will be highly appreciated!



Regards,

caracol

View 10 Replies View Related

[DBNETLIB][ConnectionRead (recv()).]General Network Error. Check Your Network Documen

Sep 30, 2004

Hello all,

We have a Windows 2003 Web Edition server serving a site through IIS. It connects to a Windows 2003 Standard Edition server running SQL 2000 SP3a.

This site receives the following error as seen in the topic:
[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.

We've configured the server network utility to only allow TCP/IP connections. The connection string for the site is as follows:

<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
MM_connSpankMSSQL_STRING = "Provider=sqloledb;Data Source=SERVER_IP,1433;Network Library=DBMSSOCN;Initial Catalog=ourmaindb_1;User ID=ourmaindb_1;Password=hotcookies;"
%>

Any ideas or tips on solving this issue? We've noticed it is due to larger queries as smaller ones do work with no problems.

The servers are behind a BSD box running iptables, has 1433,1434 along with standard web ports wide open. Anything outbound is allowed.

Some further testing via ODBC on the IIS server improved things. No more connection pooling for the SQL Server driver allows for 1/3 of the query to run. Still 2/3s of it doesn't show up, and that general network error message appears.

Should have 330 rows if it works right.

View 2 Replies View Related

ConnectionRead (WrapperRead())

Feb 8, 2005

When executing an sp from the Analyzer, I get the following:

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.

I don't get this with other procedures, nor do the eventlog from w2k or errorlog from SQLServer indicate something is wrong. The procedure that I call, calls another procedure which gives this error. When I call that procedure directly, I do not get this (or any other) error.

Any idea?

View 2 Replies View Related

ConnectionRead(recv()) Error Help

Nov 23, 2004

I keep getting this error while I run my application. I used to run the application but it was taking to long so I decided to add some stored procedures to it and this error started happening.

Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).

Does anyone know what this error is referring to?


Jose

View 1 Replies View Related

[TCP/IP Sockets] ConnectionRead (recv()) Error

Aug 9, 2001

Has anyone encountered this error and found a solution?
A batch process received this error for the first time last night.
We are running SQL 7 on an NT4 server, and the client machine is a Win2K box.
The process is a VB application, using ADO to connect to the database.
We are using TCP/IP protocol.
We were using the Named Pipes protocol in the past, but changed to TCP/IP a few weeks ago, because we kept getting a "ConnectionWrite(GetOverLappedResults)" error, and found information that stated the error was due to the Named Pipes protocol, and the solution was to switch to TCP/IP.
FYI, since switching protocols we have not seen the ConnectionWrite(GetOverLappedResults) error, and we used to get it everytime the process ran.

Any help or suggestions are appreciated.
If any further information about our systems or the process would help, let mw know and I will provide it.

Thanks.

View 2 Replies View Related

I Just Want One Entry For Each Call, With SLA Status 'Breach' If Any Of The Stages For The Call Were Out Of SLA.

Mar 19, 2008

Hi,

I am producing a php report using SQL queries to show the SLA status of our calls. Each call has response, fix & completion targets. If any of these targets are breached, the whole SLA status is set as 'Breach'.

The results table should look like the one below:





CallRef.

Description

Severity



ProblemRef

Logged
Date

Call
Status

SLA Status



C0001

Approval for PO€™s not received

2



DGE0014

05-01-06 14:48

Resolved

Breach


C0002

PO€™s not published

2



DGE0014

06-01-06 10:21

Resolved

OK


C0003

Approval for PO€™s not received from Siebel.

2



n/a

05-01-06 14:48

Investigating

OK



















Whereas I can pick the results for the first 6 columns from my Select query, the 'SLA Status' column requires the following calculation:

if (due_date < completed_date)
{ sla_status = 'OK';
}
else sla_status = 'Breach';

The Select statement in my query is looking like this...

Select Distinct CallRef, Description, Severity, ProblemRef, Logdate, Status, Due_date, Completed_date;

The problem is that my query is returning multiple entries for each stage of the call (see below), whereas I just want one entry for each call, with SLA status 'Breach' if any of the stages for the call were out of SLA.






CallRef.

Description

Severity



ProblemRef

Logged
Date

Call
Status

SLA Status



C0001

Approval for PO€™s not received

2



DGE0014

05-01-06 14:48

Resolved

Breach


C0001

Approval for PO€™s not received

2



DGE0014

05-01-06 14:48

Resolved

OK


C0001

Approval for PO€™s not received

2



DGE0014

05-01-06 14:48

Resolved

Breach



















Any help will be much much appreciated, this issue has been bothering me for some time now!!!




View 7 Replies View Related

Dbnetlib.dll ???

Dec 15, 2006

What is the meaning of "Can't find PInvoke DLL, dbnetlib.dll"??

I got this error message when trying to access the server, I'm developing SQL Mobile app.

How to solve this problem??

thx

 

I have two apps, with the same code on both app :
Dim ConnStrToServer As String = "Data Source=myIP,1433;Initial Catalog=mydatabase;User ID=sa;Password=;"
Dim connection As New SqlConnection(ConnStrToServer)
connection.Close()
MsgBox("This will take a minute")
Try
  connection.Open()    -->> ERROR!!
  Dim queryString As String = _
    "Update mytable set flag='PESAN'" & _
    ", username='" & tbIdNumber.Text.Trim & "'" & _
    ", tglpenyerahan='" & Now & "'" & _
    " Where KodeProyek='" & kodeProyek.Trim & "' And NoKavling='" & NoKavling.Trim & "'"
  Dim adapter As SqlDataAdapter = New SqlDataAdapter( _
  queryString, connection)
  Dim mstmap As New DataSet
  adapter.Fill(mstmap, "mytable")
  connection.Close()
Catch ex As Exception
  MsgBox(ex.Message)
End Try



the different is the first app is a SQL Mobile app, now when I try to open a connection from the first app is always shows that error with the above code (eventhough my replication not error), but when I try to execute (success open connection) the query with the second app (not SQL Mobile app) works!

View 1 Replies View Related

DBNETLIB Error

Mar 18, 2004

Hi All,

I have a problem with a specific query which causes the error below. It runs fine on the server but refuses to work on my Query Analyzer.

select a.cola
from tablea a
where a.cola not in (select b.cola from tableb b)


[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.

Connection Broken

I have MDAC 2.8 installed. SQL Server 2000. There are no entries in the logs, no backups running or deadlocks detected. My Collegues machine runs it fine?

Any Ideas please? All help gratefully received...

Thanks,
Jim

View 4 Replies View Related

DTS Package Fails: [DBNETLIB].....

May 19, 2005

SQL Server is running on my PC. The server name is 'ASPEN'. When I create a DTS package to export a local database to our live site, I must use 'LOCAL' for the server name, not 'ASPEN'. Everything runs fine the first time, but later, when I try to execute, or even view, the local package I saved, I get the following error:
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.

Can anyone explain this?

View 3 Replies View Related

[DBNETLIB]ConnectionCheckForData (CheckforData())

Jul 23, 2005

Hi...SQL SERVER 2000 SP3, WINDOWS 2K SERVER...If i run this command on a remote serverselect replicate(' ',190)i have the following error[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData(CheckforData()).Server: Msg 11, Level 16, State 1, Line 0General network error. Check your network documentation.Connection Brokenif i run select replicate(' ',60) on the same server it completessuccesfully...any ideas???...thanks...

View 2 Replies View Related

Can't Find PInvoke DLL 'dbnetlib.dll'.

Feb 9, 2007

every time when I opened the connection from my windows CE4.2 device to sql server I got the error "Can't find PInvoke DLL 'dbnetlib.dll'.

My OS is MS CE4.2, I've installed Compact Framework 2.0 and SQL client. It worked fine at OS CE5.0 but not at CE4.2. My application is working correctly, but when I started the connection I received this error.

Any idea?

thanks, Jan

View 1 Replies View Related

.Net CF 2.0 Error , Can't Find PInvoke DLL 'dbnetlib.dll'.

Jan 16, 2006

Hi All,

I'm developing Pocket Pc application, In that i have set of statement, which establishes connection with sql Server 2000 Database. When ever I try to open SqlConnection, I€™m getting error "Can't find PInvoke DLL 'dbnetlib.dll'.". Right now i am working in .Net Compact Framework 2.0 , But previously i worked in .Net CF 1.1 i didn€™t face problem while doing that. Can any one help me to solve this issue?

  My code exactly look like :

 

Private SqlCmd As New SqlCommand

Private SqlTrans As SqlTransaction

Private SqlConn As SqlClient.SqlConnection

Private SqlCmdBuilder As SqlCommandBuilder

Private SqlDataAdapter As SqlDataAdapter

Public Function Select_DocumentTemplate() As DataSetDocumentTemplate

Dim DocuMentTemplateDs As New DataSetDocumentTemplate

Try

SqlConn = New SqlConnection("Data Source=SERVERNAME;Initial Catalog=DATABASENAME;Persist Security Info=True;User ID=sa")

 If SqlConn.State = ConnectionState.Closed Then

SqlConn.Open()

End If

 SqlCmd = New SqlCommand

SqlCmd.CommandType = CommandType.StoredProcedure

SqlCmd.CommandText = New StringBuilder(500).Append("Select_documentTemplateDetails").ToString()

SqlCmd.Connection = SqlConn

SqlDataAdapter = New SqlDataAdapter(SqlCmd)

SqlCmdBuilder = New SqlCommandBuilder(SqlDataAdapter)

SqlDataAdapter.Fill(DocuMentTemplateDs.Ncm_DocumentTemplate)

Return DocuMentTemplateDs

Catch ex As Exception

Throw ex

Finally

SqlConn.Close()

End Try

End Function

' When Ever I try to call above method to retrive data from Db  , It's giving Missingmethod Exception and error message will be "Can't find PInvoke DLL 'dbnetlib.dll'."

Thanks ,

Jayakumar.A

 

 

 

 

View 36 Replies View Related

Fix DBNETLIB General Network Error

Mar 12, 2007

I have a friend at another company that is getting this error:

03/07/2007 16:03:49 Version 21.00.69 - UID - xxx - Error -2147467259 - [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.

I have checked around and found two potential fixes for this problem. The first one describes this as a problem specific to the Named Pipes protocol. The fix is listed as available from this site:

http://support.microsoft.com/default.aspx?scid=kb;en-us;827452

The second fix is listed as making an additional entry to the registry like this:

The problem arises on a busy SQL system and some requests will randomly seem
to be dropped with a General Network Error.

To fix:
HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServic esTcpipParameters
Add a new DWORD key SynAttackProtect with value of 0. Restart server.
Can someone tell me if either or both of these approaches is correct?

View 3 Replies View Related

[DBNETLIB][ConnectionWrite (send()).] Errors

May 23, 2007

We have a Dell 2950 running Windows 2003 connecting to SQL2005 Database.



Users accessing their SQL application are getting this error message after leaving the application open for a period when they are not accessing the system. We have run the application on two different servers and cannot re-create the errors, which might suggest a hardware problem with our server, but as yet we haven't identified the problem.



Does anyone have any ideas ?

View 4 Replies View Related

[DBNETLIB] ConntionRead.General Network Error

Apr 3, 2008

Hi All,

I have application desinged using VB.Net and sql server 2005. Its been deployed at remote site which is connected to my database server using VPN.

There are 2 machine at the remote site. One machine is working perfectly with all the reports and forms working. second machine is having problem runing one report. Reports is based on View which around 8 tables joined.

It shows the following eror

failed to openrowset
Microsoft OLD DB provider for sql server
DBNETLIB connectionread(recv()). General Network Error. Check your network doucmentation.

View 3 Replies View Related

Intermittent “[DBNETLIB][ConnectionOpen (Connect()).] Error

Apr 23, 2007

Hi,

I have a classic ASP app that loops through a record set and calls another query based on each record returned. Something like:

sSql = User Query

rsUser = conn.execute(sSql)

do while not rsUser.eof
sSql = Select [Type] From [User Types Display] Where UserId = rsUser(€œUserid€?)
rsType = conn.execute(sSql)
€˜ Put information into HTML table
rsType.Close
rsUser.MoveNext
loop

In general, at around 3575-4000 loops, the system kicks back :

Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
UserList.asp Line 300

I get no error message in the SQL Server Logs (according to the server, nothing happened), just this message on my ASP page. This happens about 90% of the time. 5% it runs completely, the other 5% bombs after 1-100 loops.

This only started happening when we took our app from a local Server 2000/SQL 2000 setup to separate Server 2003/SQL 2005 setup.

In SQL Profiler I see the loops hitting with only two reads per batch (TCP/IP). This seems very low compared to named pipes (when in a local server configuration) reads of 15-30 reads per batch.

I know it is not a hardware issue; this behavior is observed in both our test and production environments. All of our other ASP page queries work fine, just the 2 or 3 of hundreds that loop like above. cause the error.


Client Details (as best I could):

Connection String (in .inc file): conn.Open "Provider=SQLOLEDB;Network=DBMSSOCN;Data Source=10.0.1.100;Initial Catalog=€™TestDB';User ID='XXXX';Password='XXXX'"

The Client is Remote to the SQL machine and connects through TCP/IP only.

I force no encryption on the back and forth between the servers.

Server Details:
SQL Server 2005 Standard with SP1

Only Named Pipes and TCP/IP are enabled

I think this is all the info relative to my issue.
Thank you so much for any help,Smith

View 9 Replies View Related

Transactional Replication With Immediate Updation DBNETLIB Problem.

Mar 13, 2006

Hi,


I am trying to set up Transactional replication with immediate
updation.


The configuration is as follows:


1. Publisher is SQL server 2000 Enterprise Edition, and Distributor is
on the same server.
2. Publisher SQL server Standard Edition is installed on Windows 2003 with sp1.
3. Subscriber is an SQLServer 2000 Evaluation version on Windows
Professional 2000 with sp2.


When I set up the Publisher with transactional replication with
immediate updation only, the set up was successful.
I subscribed 2 instances of SQL server from Windows 2000 professional
on the local LAN in the same domain. The set up went fine.


When I update from the publisher end the updation is successfully
replicating to all the subscribers. But when I try to insert any
records in any one of the subscribers, I am getting the following
error:


[Microsoft] [ODBC SQL Server Driver ][SQL Server
][DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not exists or
access denied.


I am beginner to this replication technology, but I have to set up in
my organisation. Please anybody help me in figuring out the actual
problem and resolving it.


Thanks in advance.


Prashant N M

View 4 Replies View Related

[DBNETLIB]ConnectionWrite (send()) &&amp;&&amp; Communication Link Failure

Mar 12, 2007

Hi ALL

I am facing a strange problem using ADO to connect Sql Server that I can not resolve it.

My program connected to SqlServer when it started, the state of the connectionPtr was adoStateOpen.Then I disable the network card and enable it immeditately, the errors happened when I executed the sql query probably because of connectionPtr was invalid,but the state of connectionPtr was always adoStateOpen.

1)Msg: Unspecified error Source: Microsoft OLE DB Provider for ODBC Drivers Description: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).

2)Msg: Unspecified error Source: Microsoft OLE DB Provider for ODBC Drivers Description: [Microsoft][ODBC SQL Server Driver]Communication link failure.

Should I reconnect to SqlServer?How can I catch this error when the connection is valid except other errors?

Sorry,my english is poor and thanks for your response.

Thanks a lot.



Env:

1)OS : Windows 2000 Server

2)SqlServer:Sql Server 2000

View 1 Replies View Related

[DBNETLIB][ConnectionWrite (send()).] General Network Error.

Sep 20, 2007



Hi,
in our environment
- Windows XP
- SQL Server Express 2005
- Internet connection via TCP/IP protocol


The described network error occurs, when we unplug the network cable:
[DBNETLIB][ConnectionWrite (send()).] General network error.


The affected database resides on the locally installed SQLExpress, it doesn't use any network connections. The error doesn't occur immediately, in most cases there are up to 30 seconds where data can be (correctly!) written to the recordset, but after that timeout the connetion is broken.


We already tried out the described workarounds:
- disable named pipes protocol
- set SynAttackProtect=0 in HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesTcpipParameters


The error doesn't occur with MSDE (SQL 2000) or under Vista.


Thanks for help!

Mathias

View 5 Replies View Related

[DBNETLIB][ConnectionClient(SEDC.ClientHandshake()).] SSL Server Error

Jul 9, 2006

I am unable to connect to SQL Server, instead I get

Sql Server ErrorL 18

Handshake error as above

A connection was successfully established with the server, but then an error occurred during the pre-login handshake (provider: SSL Provider, error: 0- The token supplied to the function is invalid) (Microsoft SQL Server)

Any ideas?



View 4 Replies View Related

SEM V1.01 - Error Connecting To Database, Can't Find PInvoke DLL Dbnetlib.dll

Oct 1, 2006

I have an IPAQ 2795 and installed a program that emulates Enterprise
Manager on a Windows Mobile Device called SEM v1.01 from
Trianglepowers.com
http://www.trianglepowers.com/ppc6700/Default.aspx

I have installed the latest Net Compact Framework and service patches / updates
I have installed MS SQL Mobile Edition
I have installed Client CAB

But I still get this error when I try to run the program.

Can anyone suggest a solution?

Thanks

View 4 Replies View Related

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server Does Not Exist Or Access Denied.

Mar 2, 2007

I installed the SQL SERVER , Oracle
client on my computer, and I can connect to remote SQL server,oracle databases using wizards , however when I try to run application iam getting this error.
Server Error in '/shiva/datagrd' Application.


[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied. Description:
An unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the error and
where it originated in the code. Exception Details:
System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (Connect()).]SQL
Server does not exist or access denied.Source Error:



Line 40: //SqlDataAdapter da=new SqlDataAdapter("select * from sms",con);Line 41: DataSet ds=new DataSet();Line 42: da.Fill(ds,"tab");Line 43: DataGrid1.DataSource=ds.Tables[0].DefaultView;Line 44: DataGrid1.DataBind();Source
File: e:shivadatagrdwebform1.aspx.cs    Line: 42 Stack
Trace:



[OleDbException (0x80004005): [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.] System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) System.Data.OleDb.OleDbConnection.InitializeProvider() System.Data.OleDb.OleDbConnection.Open() System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) datagrd.WebForm1.Page_Load(Object sender, EventArgs e) in e:shivadatagrdwebform1.aspx.cs:42 System.Web.UI.Control.OnLoad(EventArgs e) System.Web.UI.Control.LoadRecursive() System.Web.UI.Page.ProcessRequestMain()

Version Information: Microsoft .NET Framework Version:1.1.4322.573;
ASP.NET Version:1.1.4322.573  please provide the solution. 

View 12 Replies View Related

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server Does Not Exist Or Access Denied

Apr 15, 2005

hello,
I hope someone can help me with the problem I am having, I get the following error:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied

I am trying to connect to my SQL
Server 2000 db via asp.net. The aspx file uses a DataGrid, the aspx.vb
code behind file gets the connection string from the web.config file. I
tested my connection via ODBC, or SQL Query Analyzer just fine so I
know the userid/password is correct.

this is the snipplet code from the aspx.vb code-behind file:

        Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) _
                Handles MyBase.Load
            Dim dbConn As OleDbConnection
            Dim dCmd As OleDbCommand
            Dim dReader As OleDbDataReader
            Dim strConnection As String
            Dim strSQL As String

            If (Not Page.IsPostBack) Then
                Try
                   
'get the connection string from web.config and open a connection
                   
'to the database
                   
strConnection = ConfigurationSettings.AppSettings("dbConnectionString")
                   
dbConn = New OleDb.OleDbConnection(strConnection)
                    dbConn.Open()

                   
'build the query string and get the data from the database
                   
strSQL = "SELECT Title, ISBN, Publisher " & _
                            
"FROM Book " & _
                            
"ORDER BY Title"
                   
dCmd = New OleDbCommand(strSQL, dbConn)
                   
dReader = dCmd.ExecuteReader()

                   
'set the source of the data for the datagrid control and bind it
                   
dgQuick.DataSource = dReader
                   
dgQuick.DataBind()

                Finally
                    'cleanup
                   
If (Not IsNothing(dReader)) Then
                       
dReader.Close()
                    End If

                   
If (Not IsNothing(dbConn)) Then
                       
dbConn.Close()
                    End If
                End Try
            End If
        End Sub  'Page_Load
    End Class 



this is the connection string inside the web.config file:

<!--add key="dbConnectionString"
value="Provider=SQLOLEDB;Data Source=localhost;Initial
Catalog=myDBName;UID=myUserID;PWD=myUserPssd" /-->
    <!--add
key="sqlConnectionString" value="Data Source=localhost;Initial
Catalog=myDBName;UID=myUserID;PWD=myUserPssd;persist security
info=False;" /-->


thanks,
arlena

View 1 Replies View Related

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server Does Not Exist Or Access Denied - PLEASE HELP!!

Aug 8, 2005

Hi have created an application in asp.net to connect to a sql database. The reason why I am sooooo very confused is because the connection to the database works if i keep the project on my local machine and connect to the database on the server, but as soon as I upload the project to the server, I get the following error when I try to connect to the database: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access deniedCan anyone tell me why this is happenning? - PLEASE - Any help will be appreciatedThanks, Danielle

View 1 Replies View Related

[DBNETLIB][ConnectionOpen(Connect()).] SQL Server Does Not Exist Or Access Denied

May 27, 2006

ok im a CS student, installed visual studio .net, and im trying to connect to a ms sql database (Northwind), but I keep getting a error that "[DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not exist or access denied" in visual studio whenever I try creating a new database connection.  How do I know if SQL server is installed on my system? cuz in my systray I see SQL server service manager, is that the same thing as SQL server? or do I need to download the full version or something? also could it be that a certain port on my system is not open that SQL server requires to be open?
Thanks
Ron

View 1 Replies View Related

[DBNETLIB] [Connection Read (recv).]General Network Error.

Nov 13, 2001

I am connecting a access database to SQL Server and lately I have been getting this error every once in a while. Any idea why?

View 1 Replies View Related

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server Does Not Exist Or Access Denied.

Apr 5, 2006

Hi all.

I'm running a large data transaction and get the next error :

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

In this case, I process over many, many records, and then it finally indicated the server doesn't exist. This only occurs sometime.

I have SQLServer 2000 on Windows 2003 Server

Some idea how to solve this.

Thanks advanced

Wil.

View 6 Replies View Related

[DBNETLIB] General Network Error - (I Have Included The Event Log Dump.)

Sep 6, 2006

I have a MS MSDE 2000 database that is serving 3 database clients. Intermittently, randomly, and more important daily, my clients receive a "SQL Database Connection Error", and they are kicked out of the database. This appears to be correlated when they are writing/retrieving a record.

MS MSDE then writes the following error in it's event log.

--------------------------------
Source: SORules.Gateway.LogErrors
Process ID: 2328

Database connection lost
Error #-2147467259
[DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.
(Source: Microsoft OLE DB Provider for SQL Server)
(SQL State: 08S01)
(NativeError: 11)
No Help file available

OpenRsRead
System.Runtime.InteropServices.COMException (0x80004005): [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.
at ADODB.RecordsetClass.Open(Object Source, Object ActiveConnection, CursorTypeEnum CursorType, LockTypeEnum LockType, Int32 Options)
at SORules.Gateway.OpenRsRead(Command& C, Boolean& ForwardOnlyCursor)
Stack trace:
at ADODB.RecordsetClass.Open(Object Source, Object ActiveConnection, CursorTypeEnum CursorType, LockTypeEnum LockType, Int32 Options)
at SORules.Gateway.OpenRsRead(Command& C, Boolean& ForwardOnlyCursor)
--------------------------------

Any help, suggestions, or thoughts would be greatly appreciated. This is for a small business line of business application that is critical for everyday business operations. These problems have resulted in lost work, short tempers, and a just frank frustration.

I am just getting started with MS SQL technologies and really need some quality help.

Thank you for your time, and have a great day.

Cheers,
Mark

View 1 Replies View Related

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server Does Not Exist Or Access Denied

Aug 17, 2007

hi all,

this is punya,

and i am having a problem which was encountered by youin the past. My actual proble is " I am having vs.net 2005 along with MS SQL Server 2000 (Server1) in my system. The MS SQL Server is database server for some of my collegues. Whenever i want to connect to my Server1 DBServer it is givng the following error message."


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


and the other guys are able to connect to the same DBServer. and one thing i am able to connect to other DBServers which are in Lan..

please Help me.

View 1 Replies View Related

SHowing Errror [DBNETLIB][ConnectionOpen (Connect()).]SQL Server Does Not Exist Or Ac

Oct 15, 2007

Hi frens

one of my site with the Databse workd fine while the other with the same database shows the following error:

Microsoft OLE DB Provider for SQL Server error '80004005'

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

/Connection.asp, line 6

View 3 Replies View Related

[DBNETLIB][ConnectionOpen(Connect()).]SQL Server Does Not Exist Or Access Denied

Dec 6, 2006



Hi Folks,

Lets get this out of the way first - I KNOW NOTHING ABOUT SQL SERVER, MSDE or MDAC

Sorry I don't mean to shout but I really don't know anything at all so please make your answers as simple as possible.

I have an application (Webmarshall) that has a SQL database from which certain reports are run. Whenever I try to run the reports it asks me for database details.

According to the application it is using LANCELOTWEBMARSHALLWebmarshall as the database

As this is all happening on one server, I presume it is local and not remote.

When I am presented with the dialogue box for the reporting module it asks for a server and a database, I have tried the following :

Server: local Auth: Windows

Server: local Auth: SQL

Server lancelot (both authorisation methods)

Server: lancelotwebmarshall (both authorisation methods)

Server: \lancelotwebmarshall (both authorisation methods)

Each time, I get the message

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

and I can't select a database.

Can someone help me please...its a long time since I went fishing in the dark (with no net) but thats how I feel right now!!!!



Thanks



View 3 Replies View Related

Error Message: Cannot Open Database.[DBNETLIB][ConnectionOpen(Connect()).] SQL Server Does Not Exist Or Access Denied.

Mar 20, 2008

I installed SQL 2005 including backward compatibility, MSDN libraries and SP2 a new Windows 2003 server (chose mixed mode authentication). Installation was successful and I then installed an off the shelf database with Windows authentication which also installed successfully.
I created a new group in AD, added the database users into the group and gave db-owner rights to the group in SQL as advised by the installation guide. However, when I try to open the database it gives an error message saying "Cannot open database.[DBNETLIB][ConnectionOpen(Connect()).] SQL server does not exist or access denied". I also tested it adding an individual user (myself) as a user to no avail.
When I set up DSN in ODBC on my computer I can successfully test the connection but can't run the application. The connection is via TCP/IP.
Any suggestions?

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved