[maiOHmai]

i've finished a system using vb 2008 with an access database. now my problem is that after publishing the project is get this certain error about JIT debugging. I've included the error that im saying. can anyone help me what does this mean?


 error.bmp (383.93K)
Number of downloads: 306

[modi123_1]

Looks like you hard coded a path in your code.. you should probably not do that.

[maiOHmai]

what do you mean by hard coded path?? i'm a bit confused. what can you suggest so that i can solve this error?

[modi123_1]

It says it can't find a file, right? I am just guessing that you have a path in your code (probably to your database) that has an absolute and direct path (not something that should be relative).. but then again I don't now what your code looks like so this is all guess work.

Instead of some chopped up image - why not copy all that information in the readonly textbox of the details section and paste that info here?

[maiOHmai]

sorry, i haven't noticed the chop image.. anyways here is the complete error details..

Quote

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Data.OleDb.OleDbException: Could not find file 'C:\Users\Maela\AppData\Local\Apps\2.0\6DXMCQ5E.OB5\QBEP7ARE.RXY\sample.accdb'.
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 LibraryStystem.Form1.txtPass_KeyDown1(Object sender, KeyEventArgs e)
at System.Windows.Forms.Control.onkeydown(KeyEventArgs e)
at System.Windows.Forms.Control.ProcessKeyEventArgs(Message& m)
at System.Windows.Forms.Control.ProcessKeyMessage(Message& m)
at System.Windows.Forms.Control.WmKeyChar(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.TextBoxBase.WndProc(Message& m)
at System.Windows.Forms.TextBox.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.OnMessage(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.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
LibraryStystem
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Users/Maela/AppData/Local/Apps/2.0/6DXMCQ5E.OB5/QBEP7ARE.RXY/libr..tion_1c65ff1860fbb5f4_0001.0000_866dd7b930f54294/LibraryStystem.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/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.

and in addition, i used this path

Quote

con.ConnectionString = "provider = Microsoft.ACE.OLEDB.12.0; data source = ..\sample.accdb"

. maybe it is looking for a database.

[torind_2000]

Quote

System.Data.OleDb.OleDbException: Could not find file 'C:\Users\Maela\AppData\Local\Apps\2.0\6DXMCQ5E.OB5\QBEP7ARE.RXY\sample.accdb'.

I'm gonna go out on a limb here and guess it can't find that file.

[maiOHmai]

sample.accdb is my database. its location is in the project's bin. why is that it cannot be found?

[modi123_1]

That's a good question. How are you referencing the database in your code?

[maiOHmai]

what do you mean by "referencing"? if your asking on how i connect / call my database, i use this command to do such,

Quote

con.ConnectionString = "provider = Microsoft.ACE.OLEDB.12.0; data source = ..\sample.accdb"

[torind_2000]

he wants to know if your code points to a specific target on your computer.
Post the section of code that has your database info in it.

[maiOHmai]

it is the only line that contains my database information.

[b2.f2]

replace

con.ConnectionString = "provider = Microsoft.ACE.OLEDB.12.0; data source = ..\sample.accdb"

with this

con.ConnectionString = "provider = Microsoft.ACE.OLEDB.12.0; data source =" & Application.StartupPath & "\sample.accdb"

and see if error persists

[maiOHmai]

thanks.. b2.f2
i've solved the problem. but i've got another one.
i'm getting this error when i tried to run my program on another pc.. it used same access 2007.

Quote

Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

can someone help me?

[modi123_1]

you need to install the redistribute pack.

https://www.microsof...s.aspx?id=13255

[maiOHmai]

is it applicable even i'm using access 2007? and which of these access database engine should i-install? is the AccessDatabaseEngine.exe or AccessDatabaseEngine_x64.exe? by the way, what's the difference between the two?