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
ADVERTISEMENT
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
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
Feb 28, 2008
hai
I have deployed an application on mobile and when i run the application on mobile it shows this error
"can't find PInvoke DLL'sqlceme30.dll'"
What's the problem pls explain
thanks.
View 2 Replies
View Related
Jan 16, 2007
Hi all,
i am creating one database file <name>.sdf using SQL CE in visual studio 2005 IDE, and its giving this error "Can't find PInvoke DLL 'sqlceme30.dll'." at run-time whenever i am initialising the the SqlCeEngine. what could be the problem ? i have already installed "sql.phone.wce5.armv4i.CAB" file on my emulator from path "C:Program FilesMicrosoft SQL Server Compact Editionv3.1SDKinClientv2.0wce500armv4i".
can anybody help me ?
Thanks
View 1 Replies
View Related
May 25, 2006
I create a smll app that should created a database in the hand held, it compiles without problem but when I debugg it
I ge the error message: Cannot find PInvoke DLL SqlCeMe30.dll
I found such dll to be located in:C:Program FilesMicrosoft SQL Server 2005 Mobile EditionDeviceMobilev3.0wce500x86 among other folders.
Why then is "not found"?
View 4 Replies
View Related
Aug 3, 2006
I am using an O2 XDA II mini running Windows Mobile 2003 SE. Tried creating a Windows Mobile 5.0 Pocket PC project but during deployment, I get this error.
Can't find PInvoke sqlceme30.dll
I have searched thru the forums and found something similar. I tried all their recommendations but no luck. Is there anything I am doing wrong? I copied the DLL files in the device's Windows directory (sqlceme30.dll, sql*.dll...around 5 DLLs)
I would appreciate any assistance
View 12 Replies
View Related
Apr 6, 2006
I am developing for an ipaq handheld. I just upgraded to Windows Mobile 5.0 and tried to run my application and I get this message.
Can't find PInvoke DLL 'sqlceme30.dll'
I am using a sql Mobile DB and vs2005
View 9 Replies
View Related
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
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
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
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
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
Mar 10, 2007
Hi guys,
I created a database using SQL Server EXpress edition but now i need to use SQL Server Development edition. I cant connect to the database now?
Anyone tell me what the problem is.
View 2 Replies
View Related
Oct 11, 2007
When i am trying to connect to SQL Server(Express edition) on production server i am getting the following error.
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.)" My SQL connection string is like this which i wrote in web.config.
<add key="conn1" value="Data Source=xxx.xxx.x.xxxyz,1433;Initial Catalog=abcdef_xyz;persist Security Info=true;User ID=xx;Password=xxxxxx"/>
string constr = ConfigurationManager.AppSettings["conn1"]; SqlConnection con = new SqlConnection(constr);
con.Open();
When i searched microsoft help to resolve this error, it suggested me to enable TCP/IP protocol for SQL server, i did that, but even after doing that i am still not able to connect to the database. Could any one please tell me what else i need to configure in order to connect to the database.
Thanks
View 2 Replies
View Related
Nov 21, 2007
I get the following error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
How do I correct it?
View 2 Replies
View Related
Sep 7, 2005
Hi Again,I have MSDE on ASP1.1 on a PC and have a logon page that uses a stored procedure to check my auth_user table, if logon and password exist then it returns (1) else returns (0).I used objparams.return to pick up the returned value and either server.transfer to opening page or label text message 'login not valid'. This is insde a try and the catch is another label, 'cannot connect to database'.Running on my local PC all is fine, transferred SP and table to hosting server, along with web.comfig set to the host servername, uid, password and database. On the host server all errors messages are returned. I have created a connection in my VS7 database manager to the remote host and the same happens after amending my connection string to run on the remote server.It clearly is the connection string, I am using the <appsettings> add Key to connect as I thought it would mean no change of coding in my pages when moving from Dev PC to Server. I have checked the hosting server setup and used the server name associated with the database (mssql3.securedc.com) , checked uid, password and database settings. Is there something I have missed like permissions, specific security settings on the host server (I have to go through a third party as the hosting is done through a friend of my client)?? Many thanksEarle
View 2 Replies
View Related
May 8, 2007
Hi there
i have a problem connecting creating a data source to SQL server express.
I am running winXP with service pack2
My machine is APOLLOSQLEXPRESS
i AM USING AN ODBC CONNECTION.
i GET THE FOLLOWING ERRORS:
SQL SERVER ERROR 1231
AND
SQL SERVER ERROR 17.
Having done a google search and looked at the local security settings i am not sure what to add to the object names.
Can anybody please help.Gino
View 3 Replies
View Related
May 19, 2015
I've remoted into our domain controller which houses our SQL database. From there I've been using the Microsoft SQL Database manager to run queries. However, I would prefer to do this from my desktop and not have to remote in whenever I need to look something up. I've found that Microsoft Visual Studio Express 2013 can create a connection where I can do my work. I've created the connection (or I believe so). "Testing the connection" is successful and in the Database Explorer window I can see my database and the folders of tables, views, etc. However, all of these folders are empty..When I choose the database everything in the settings pops up and I use the same authetication I use on the domain controller..
View 4 Replies
View Related
Apr 10, 2008
Hi
Am developing a web application in asp.net ,c# and Sql server 2005(management studio express). Am using VS 2008 version. Getting the following error while connecting to database.
plz help me
"Cannot open database "Form" requested by the login. The login failed.
Login failed for user 'SUNS-97A7CC82A0Suns Solutions'."
Thanks in advance
View 3 Replies
View Related
Jun 26, 2007
Dear All,
I am trying to connect to a .sdf database. I am building a console application. First I got an error "Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)". Then I manage to solve "Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)". So wat is the possible error on my side ?
View 5 Replies
View Related
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
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
Oct 18, 2007
Hi,
I am getting the following error when i am trying to connect to the database server installed on different box.
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"
When i searched google, some postings suggested to enable the TCP/IP and Named Pipes Protocols from SQL Server configuration Manager. I did so and also ran mofcomp command. But even after doing this i am not able to connect to the server. Following is my connection string.
<add key="conn2" value="Data Source=xxxxxxxx;Initial Catalog=xxxxxx_xxxxxx;User ID=xx;Password=xxxxxx;"/>
Could any one please tell me what else the configuration settings i need to do in order to connect to the database from my application.
View 1 Replies
View Related
May 11, 2008
Hello,
I'm tyring a simple piece of code to conenct to my database: SqlConnection con = new SqlConnection("Data Source=localhost; Initial Catalog=OrderingSystem; Integrated Security=SSPI");
try
{
// Try to open the connection.
con.Open();
label1.Text = "<b>Server Version:</b> " + con.ServerVersion;
label1.Text += "<br /><b>Connection Is:</b> " + con.State.ToString();
}
catch (Exception err)
{
// Handle an error by displaying the information.
label1.Text = "Error reading the database. " + err.Message;
}
finally
{
// Either way, make sure the connection is properly closed.
// Even if the connection wasn't opened successfully,
// calling Close() won't cause an error.
con.Close();
label1.Text += "<br /><b>Now Connection Is:</b> " +
con.State.ToString();
}
When I try this, I get an error:"Error reading the database. Cannot open database "OrderingSystem" requested by the login. The login failed. Login failed for user 'NT AUTHORITYNETWORK SERVICE'."
The strange thing is, this code works perfectly If I use it in a Windows Forms application.
Is it a problem with SQL server, IIS or my code?I'm using SQL Server 2005 (SP2) 32bit developer edition + IIS 6.0 + Visual Studio 2008 Pro all runnign on my Windows XP x64 PC.
Thankyou
View 2 Replies
View Related
Apr 25, 2006
I have been successfully using SQL Server 2005 developer
edition for a couple of months now. However,
when I started Microsoft SQL Server Management Studio this morning I could not
connect to the €œDatabase Engine€? (I€™m using Windows Authentication). I can still connect with the €œIntegration
Services€? and €œAnalysis Services€? on the same server. The server running on my local machine, so
there shouldn€™t be any problems with the network. I am also able to connect with it through
ODBC, it just seems to be the Server Management Studio which can€™t connect, and it only has
problems with the €œDatabase Engine.€? Any
help would be appreciated.David
The detailed error message says:
An error has occurred while establishing a connection to the
server. When connecting to SQL Server
2005, this failure may be caused by the fact that under the default settings SQL
Server does not allow remote connections. (provider: TCP Provider, error: 0 -
No connection could be made because the target machine actively refused it.)
(.Net SqlClient Data Provider)
------------------------------
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10061&LinkId=20476
------------------------------
Error Number: 10061
Severity: 20
State: 0
------------------------------
Program Location:
at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,
Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at
System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner,
Boolean& failoverDemandDone, String host, String failoverPartner, String
protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean
encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection
owningObject, Boolean aliasLookup)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
owningConnection, DbConnectionPoolGroup poolGroup)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at
System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo
ci, IServerType server)
at
Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
View 6 Replies
View Related
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
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
Feb 15, 2007
Hi everyone, i have already created posts about this problem and im aware theres millions of replys, but i still cant get this to work and its driving me mad. The posts i have seen i dont understand?
Im using the standard ASPNETDB Database, i have never opened up SQL Server Management studio, although i do have the express edition.
i have tried everything and i am totally stumped as to what to do. Heres my web.config.
It works in VWD 2005 Express, but not in WWWROOT or on webserver?
PLEASE PLEASE PLEASE Can someone help me!!!!!!!!!
Dan :)
<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<appSettings/>
<connectionStrings>
<add name="northwindsConnectionString1" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
<add name="ConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|MyDatabase.mdb;Persist Security Info=True"
providerName="System.Data.OleDb" />
</connectionStrings>
<system.web>
<profile>
<properties>
<add name="FullName" defaultValue=""/>
</properties>
</profile>
<roleManager enabled="true" />
<compilation debug="false" />
<authentication mode="Forms" />
</system.web>
</configuration>
View 6 Replies
View Related
Feb 10, 2008
when i am running both sql server management studio and beb developer and i try to connect to a database in web developer simultaneously it gives me errorfile used by another process file located on UNC sharebut if i am only running web developer it gives me no errorso please tell me how to connect to a same database simultaneously
View 1 Replies
View Related
Mar 8, 2006
Newbie strikes again.. I'm attempting to connect to a SQL Server database (using VS 2005). My code generated no errors in the build but when I tried to access the database, I got the following message:"The ConnectionString property has not been initialized."My connection string is stored in my web.config file. My code goes as follows:Dim strSQL As String = "SQL string stored here"Dim objConnection as SqlConnection = New SQLConnection(ConfigurationManager.AppSettings("name of connection string is here"))Dim objCommand as SQLCommand = New SqlCommand(strSQL, objConnection)objConnection.Open()Then I go on to open my reader and such. Where should I be initializing the ConnectionString property?TIA,Lesley
View 1 Replies
View Related
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
Feb 11, 2005
I've got code that on my own machine (visual studio .net 2003 and iis and sql server all exist on this box) works great. I display my test page, which loads a dropdownlist on page_load. This works great on my own machine.
When I move the code to our dev environment. Web server and database servers on separate boxes. I get the error "Object reference not set to an instance of an object" when i try to open the connection to the database. I thought it had to do with permissions and I check all through sql server and everything looks great. I then thought it was the connection string. I still haven't ruled this out, but I wrote a quick vbscript app to attach to the database and try to pull a record. The vbscript worked fine. So, the code works fine on my computer, but not on the web server. The connection does work with vbscript, but through my asp.net web app I get the "object reference" error.
All code below...
ASP.NET webpage:
private void Page_Load(object sender, System.EventArgs e)
{
if( !IsPostBack )
{
// Create a command object for the query
string mySelectQuery = "select id from vw_abcd order by ID";
SqlCommand myCommand = new SqlCommand(mySelectQuery,sqlConnection1);
sqlConnection1.Open();
DropDownList1.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
DropDownList1.DataBind();
sqlConnection1.Close();
RangeValidator1.MinimumValue = "1";
RangeValidator1.MaximumValue = DropDownList1.Items.Count.ToString();
}
}
Connection string on my machine:
workstation id=wXXXXXX01;packet size=4096;user id=testuser;password=testpass;integrated security=SSPI;data source=wXXXXXX01;persist security info=False;initial catalog=TestDB"/>
Connection string on web server:
network library=DBMSSOCN;data source=xxx.xx.xxx.xxxinstance1;user id=testuser;password=testpass;initial catalog=TestDB
vbscript:
Dim connConnection, rstresultset
strConnectionString = "driver={Sql Server};server=xxx.xx.xxx.xxxinstance1;user id=testuser;password=testpass;database=TestDB"
Set connConnection = CreateObject("ADODB.Connection")
connConnection.Open strConnectionString
Set rstresultset = createobject("ADODB.Recordset")
rstresultset.ActiveConnection = connConnection
rstresultset.Open "select id, comment from testtable", connConnection
msgbox rstresultset(0)
msgbox rstresultset.Fields(0).Value
Error message and stack trace:
Object reference not set to an instance of an object.
at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at Web2.Drilldown.Page_Load(object sender, System.EventArgs e)
Any ideas what's going on?????
View 1 Replies
View Related
