how to publish a vb project?

  • (2 Pages)
  • +
  • 1
  • 2

15 Replies - 10455 Views - Last Post: 26 August 2012 - 07:36 AM Rate Topic: -----

#1 maiOHmai   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 86
  • Joined: 09-July 12

how to publish a vb project?

Posted 13 August 2012 - 08:34 AM

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?


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

Is This A Good Question/Topic? 0
  • +

Replies To: how to publish a vb project?

#2 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 14776
  • View blog
  • Posts: 59,070
  • Joined: 12-June 08

Re: how to publish a vb project?

Posted 13 August 2012 - 08:37 AM

Looks like you hard coded a path in your code.. you should probably not do that.
Was This Post Helpful? 0
  • +
  • -

#3 maiOHmai   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 86
  • Joined: 09-July 12

Re: how to publish a vb project?

Posted 13 August 2012 - 09:05 AM

what do you mean by hard coded path?? i'm a bit confused. what can you suggest so that i can solve this error?
Was This Post Helpful? 0
  • +
  • -

#4 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 14776
  • View blog
  • Posts: 59,070
  • Joined: 12-June 08

Re: how to publish a vb project?

Posted 13 August 2012 - 09:08 AM

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?
Was This Post Helpful? 0
  • +
  • -

#5 maiOHmai   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 86
  • Joined: 09-July 12

Re: how to publish a vb project?

Posted 13 August 2012 - 09:24 AM

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.
Was This Post Helpful? 0
  • +
  • -

#6 torind_2000   User is offline

  • D.I.C Regular

Reputation: 57
  • View blog
  • Posts: 293
  • Joined: 22-August 11

Re: how to publish a vb project?

Posted 13 August 2012 - 09:33 AM

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.
Was This Post Helpful? 1
  • +
  • -

#7 maiOHmai   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 86
  • Joined: 09-July 12

Re: how to publish a vb project?

Posted 13 August 2012 - 09:56 AM

sample.accdb is my database. its location is in the project's bin. why is that it cannot be found?
Was This Post Helpful? 0
  • +
  • -

#8 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 14776
  • View blog
  • Posts: 59,070
  • Joined: 12-June 08

Re: how to publish a vb project?

Posted 13 August 2012 - 10:01 AM

That's a good question. How are you referencing the database in your code?
Was This Post Helpful? 0
  • +
  • -

#9 maiOHmai   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 86
  • Joined: 09-July 12

Re: how to publish a vb project?

Posted 13 August 2012 - 10:23 AM

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"

Was This Post Helpful? 0
  • +
  • -

#10 torind_2000   User is offline

  • D.I.C Regular

Reputation: 57
  • View blog
  • Posts: 293
  • Joined: 22-August 11

Re: how to publish a vb project?

Posted 13 August 2012 - 10:42 AM

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.
Was This Post Helpful? 0
  • +
  • -

#11 maiOHmai   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 86
  • Joined: 09-July 12

Re: how to publish a vb project?

Posted 13 August 2012 - 11:00 AM

it is the only line that contains my database information.
Was This Post Helpful? 0
  • +
  • -

#12 b2.f2   User is offline

  • D.I.C Head

Reputation: 11
  • View blog
  • Posts: 76
  • Joined: 21-May 07

Re: how to publish a vb project?

Posted 16 August 2012 - 02:46 AM

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
Was This Post Helpful? 0
  • +
  • -

#13 maiOHmai   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 86
  • Joined: 09-July 12

Re: how to publish a vb project?

Posted 25 August 2012 - 06:16 PM

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?
Was This Post Helpful? 0
  • +
  • -

#14 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 14776
  • View blog
  • Posts: 59,070
  • Joined: 12-June 08

Re: how to publish a vb project?

Posted 25 August 2012 - 08:17 PM

you need to install the redistribute pack.

https://www.microsof...s.aspx?id=13255
Was This Post Helpful? 0
  • +
  • -

#15 maiOHmai   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 86
  • Joined: 09-July 12

Re: how to publish a vb project?

Posted 26 August 2012 - 03:21 AM

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?
Was This Post Helpful? 0
  • +
  • -

  • (2 Pages)
  • +
  • 1
  • 2