473,325 Members | 2,816 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

.NET configuration problem

37
Hi,
I have BIG BIG problem with .NET. I have an application on .NET 2.0 which connects to a local database. On my machine there were no problems and everything goes smooth. When I upload the application to the server ( windows is x64 bit) I get an error which tells that the .NET functions are restricted/disabled and I cannot connect to the DB. The connection string is 100% correct. I installed .NET SDK and set full access from these tools and compiled the application with security "full trust" but still no success. I have also a website on the same server which connects to the DB with the same connection string successfully. The error occures when I try to start executable files written on .NET 2.0. And this is the error:
Expand|Select|Wrap|Line Numbers
  1.  
  2. ************** Exception Text **************
  3. System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
  4. Invalid connection string attribute
  5.    at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
  6.    at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
  7.    at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
  8.    at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
  9.    at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
  10.    at System.Data.OleDb.OleDbConnection.Open()
  11.    at WindowsApplication1.Form1.button1_Click(Object sender, EventArgs e)
  12.    at System.Windows.Forms.Control.OnClick(EventArgs e)
  13.    at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
  14.    at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
  15.    at System.Windows.Forms.Control.WndProc(Message& m)
  16.    at System.Windows.Forms.ButtonBase.WndProc(Message& m)
  17.    at System.Windows.Forms.Button.WndProc(Message& m)
  18.    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
  19.    at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
  20.  
  21.  
  22. ************** Loaded Assemblies **************
  23. mscorlib
  24.     Assembly Version: 2.0.0.0
  25.     Win32 Version: 2.0.50727.42 (RTM.050727-4200)
  26.     CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
  27. ----------------------------------------
  28. System.Windows.Forms
  29.     Assembly Version: 2.0.0.0
  30.     Win32 Version: 2.0.50727.42 (RTM.050727-4200)
  31.     CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
  32. ----------------------------------------
  33. System
  34.     Assembly Version: 2.0.0.0
  35.     Win32 Version: 2.0.50727.42 (RTM.050727-4200)
  36.     CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
  37. ----------------------------------------
  38. System.Drawing
  39.     Assembly Version: 2.0.0.0
  40.     Win32 Version: 2.0.50727.42 (RTM.050727-4200)
  41.     CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
  42. ----------------------------------------
  43. System.Data
  44.     Assembly Version: 2.0.0.0
  45.     Win32 Version: 2.0.50727.42 (RTM.050727-4200)
  46.     CodeBase: file:///C:/WINDOWS/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
  47. ----------------------------------------
  48. System.Transactions
  49.     Assembly Version: 2.0.0.0
  50.     Win32 Version: 2.0.50727.42 (RTM.050727-4200)
  51.     CodeBase: file:///C:/WINDOWS/assembly/GAC_64/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
  52. ----------------------------------------
  53.  
  54. ************** JIT Debugging **************
  55. To enable just-in-time (JIT) debugging, the .config file for this
  56. application or computer (machine.config) must have the
  57. jitDebugging value set in the system.windows.forms section.
  58. The application must also be compiled with debugging
  59. enabled.
  60.  
  61. For example:
  62.  
  63. <configuration>
  64.     <system.windows.forms jitDebugging="true" />
  65. </configuration>
  66.  
  67. When JIT debugging is enabled, any unhandled exception
  68. will be sent to the JIT debugger registered on the computer
  69. rather than be handled by this dialog box.
  70.  
  71.  

Please help!
10x
Apr 2 '08 #1
4 1199
Plater
7,872 Expert 4TB
Did you give the user profile the program is running as permision to use the SQL server?
Apr 2 '08 #2
mynkow
37
How can I grand this access. Where should I add the user if I am using Windows Server 2003
Apr 2 '08 #3
Plater
7,872 Expert 4TB
Find out what user account is running the program and add them to the logins for the SQL server
Apr 2 '08 #4
mynkow
37
I get your point but the problem is not there because I use administrator account. I think that the framework is restricted somehow and don't know how to reverse that. If I use non .NET classes to connect to the DB everything is good.
Apr 2 '08 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: serge calderara | last post by:
dear all, I have problem accessing section group in my configuration application file. I got an error saying thta I can have only one section ???? here is my application configuration looks...
3
by: Robert | last post by:
I have an application with custom configuration sections in it's app.config file. Here's a shortened excerpt: <monitors> <monitor...
3
by: Florida Coder | last post by:
I have the need to store some application specific configuration data to be used by a class library and or a windows service. I would like to do this in a fashion similar to the way we do with...
6
by: chokk | last post by:
All, I am getting the following error when I try to run a form page. Can someone tell me what this is about and show me how to fix it. Thnaks. Server Error in '/' Application...
2
by: Terry Holland | last post by:
I posted a follow up to an earlier post but did not receive response so here it is again (with original post and response) > This could be because you are running the index service over this web...
0
by: Jorgas | last post by:
Hi! I try to use the configuration application block from the Enterprise Library and have done prework as specified from one of the hands-on labs from that package. When trying to get...
10
by: Rider | last post by:
Hi, simple(?) question about asp.net configuration.. I've installed ASP.NET 2.0 QuickStart Sample successfully. But, When I'm first start application the follow message shown. ========= Server...
0
by: metaperl | last post by:
A Comparison of Python Class Objects and Init Files for Program Configuration ============================================================================= Terrence Brannon bauhaus@metaperl.com...
7
by: Arno R | last post by:
Hi all, I am sending mail from my apps with CDO nowadays. However I have one client where this will not work until now. I am thinking this is related to the provider where the client has his...
3
by: Mike | last post by:
Hi I have problem as folow: Caught Exception: System.Configuration.ConfigurationErrorsException: An error occurred loading a configuration file: Request for the permission of type...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.