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
- ************** Exception Text **************
- System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
- Invalid connection string attribute
- at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
- at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
- 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.OleDb.OleDbConnection.Open()
- at WindowsApplication1.Form1.button1_Click(Object sender, EventArgs e)
- at System.Windows.Forms.Control.OnClick(EventArgs e)
- at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
- at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
- at System.Windows.Forms.Control.WndProc(Message& m)
- at System.Windows.Forms.ButtonBase.WndProc(Message& m)
- at System.Windows.Forms.Button.WndProc(Message& m)
- at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
- at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
- ************** Loaded Assemblies **************
- mscorlib
- Assembly Version: 2.0.0.0
- Win32 Version: 2.0.50727.42 (RTM.050727-4200)
- CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
- ----------------------------------------
- System.Windows.Forms
- Assembly Version: 2.0.0.0
- Win32 Version: 2.0.50727.42 (RTM.050727-4200)
- CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
- ----------------------------------------
- System
- Assembly Version: 2.0.0.0
- Win32 Version: 2.0.50727.42 (RTM.050727-4200)
- CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
- ----------------------------------------
- System.Drawing
- Assembly Version: 2.0.0.0
- Win32 Version: 2.0.50727.42 (RTM.050727-4200)
- CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
- ----------------------------------------
- System.Data
- Assembly Version: 2.0.0.0
- Win32 Version: 2.0.50727.42 (RTM.050727-4200)
- CodeBase: file:///C:/WINDOWS/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
- ----------------------------------------
- System.Transactions
- Assembly Version: 2.0.0.0
- Win32 Version: 2.0.50727.42 (RTM.050727-4200)
- CodeBase: file:///C:/WINDOWS/assembly/GAC_64/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
- ----------------------------------------
- ************** JIT Debugging **************
- To enable just-in-time (JIT) debugging, the .config file for this
- application or computer (machine.config) must have the
- jitDebugging value set in the system.windows.forms section.
- The application must also be compiled with debugging
- enabled.
- For example:
- <configuration>
- <system.windows.forms jitDebugging="true" />
- </configuration>
- When JIT debugging is enabled, any unhandled exception
- will be sent to the JIT debugger registered on the computer
- rather than be handled by this dialog box.
Please help!
10x