moving vb.net exe file to other computer w/o VB-help!

Question

jzlonely 0 Newbie Poster

14 Years Ago

I am very new to vb 2008 and have create a simple window forms application which link to microsoft access 2007 database.

I build the application exe file already. The exe file is run well on my computer, but when i transfer it by copy and paste the whole folder to another computer it cannot run. I am wondering why this happen? the error is as below :

"selected collating sequence not supported by the operating system".

Can the exe run without installing vb?

Hopefully can get help here...Thanks a lot.

vb.net

6 Contributors
18 Replies
4K Views
2 Weeks Discussion Span
Latest Post 14 Years Ago Latest Post by jzlonely

kdion1024 12 Light Poster

14 Years Ago

This link might help you out. I believe its more of an issue with Access than VB. Since you are getting this error I would say its safe to say the .NET Framework is installed and the program is working.

http://www.xtremevbtalk.com/archive/index.php/t-221944.html

Kenny

Oxiegen 88 Basically an Occasional Poster

14 Years Ago

If you Release-compiled your program, then there is no need to install "vb".
You do, however, need to install the .NET Framework version for which your program is developed with.

Other then that, just make sure that your Access database is in the same folder as your exe.

Netcode 33 Veteran Poster

14 Years Ago

it sure wont work. the .exe file is more like a compiled copy of your program and definitely when it runs, its gonna search for your MS Access database, when it does not find it, it gives you the error

meffe 0 Light Poster

14 Years Ago

Try installing Ms access database and .net framework on the other systems

Oxiegen 88 Basically an Occasional Poster

14 Years Ago

Here's an idea I posted in another thread.
Create a folder in your project folder and put the access database file in it.
Then, include that folder in your project.

Use that folder as a reference in the connection string: ".\<databasefolder>\<database file>", instead of "C:\<somefolder>\<databasefile>". (Notice the dot in the beginning).

When you rebuild the project, that folder containing the database file will be copied to the build output folder along with the exe.
Then just copy the files and folder to where ever you want.

When you run the program, it will always know that the database is in a sub-folder from where it's running. Be it on a hard-drive or a USB memory stick.

You shouldn't need to install the complete MS Access program in order to make this work.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

jzlonely 0 Newbie Poster · Answer 1 · 2010-06-16T09:09:23+00:00

Hello Kenny,
Thanks for your reply. I had try this before, but the problem is still same. I don't really know what's going on with my application...

the application only run well on another computer which VB is installed.

jzlonely 0 Newbie Poster · Answer 2 · 2010-06-17T06:56:27+00:00

If you Release-compiled your program, then there is no need to install "vb".
You do, however, need to install the .NET Framework version for which your program is developed with.
Other then that, just make sure that your Access database is in the same folder as your exe.

If no mistaken, the .NET framework version is the same. The other compyter contain a folder of .NET framework 3.5 SP1. Somemome, there will be a access dile in the release folder with .exe file.

Try installing Ms access database and .net framework on the other systems

The computer already installed with MS Access. But it is a trial version which already expired. will this affect to my software?

Use that folder as a reference in the connection string: ".\<databasefolder>\<database file>", instead of "C:\<somefolder>\<databasefile>". (Notice the dot in the beginning).

my connection string is like this : "|DataDirectory|\RMA.accdb"

Oxiegen 88 Basically an Occasional Poster Featured Poster · Answer 3 · 2010-06-17T12:20:54+00:00

The computer already installed with MS Access. But it is a trial version which already expired. will this affect to my software?

It doesn't matter. You can uninstall it.

my connection string is like this : "|DataDirectory|\RMA.accdb"

Then your connectionstring should look something like this:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=.\DataDirectory\RMA.accdb;Persist Security Info=False;

If you get any problems with the connectionstring, then have a look at this: ConnectionStrings.com

jzlonely 0 Newbie Poster · Answer 4 · 2010-06-22T08:00:09+00:00

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=.\DataDirectory\RMA.accdb;Persist Security Info=False;

Sorry for late reply. I tried to build file with this connection string but it could not work on other pc too...I dont really know what's going on now, even the pc was installed with vb and Ms access it cant work too...

Oxiegen 88 Basically an Occasional Poster Featured Poster · Answer 5 · 2010-06-22T09:07:00+00:00

Did you create that database folder inside your projectfolder?
Did you move the database file into that folder?
Did you include that folder in your project?
Does the path part of the connectionstring start with a dot slash (.\)?

jzlonely 0 Newbie Poster · Answer 6 · 2010-06-29T07:00:42+00:00

Did you create that database folder inside your projectfolder?
Did you move the database file into that folder?
Did you include that folder in your project?
Does the path part of the connectionstring start with a dot slash (.\)?

ya...the database file has been created automatically when i build the system. I just copy the whole project folder to another computer but it couldnt work.
Yup...I changed the connection string to Provider=Microsoft.ACE.OLEDB.12.0;Data Source=.\|DataDirectory|\RMA.accdb;Persist Security Info=False;
but it show me a new error when i tried to debug it...OleDb was unhandled - not a valid file name on this line of code:

Me.Table1TableAdapter.Fill(Me.RMADataSet.Table1)

in my Form1

and when I changed the connectionString to
the error become this

'C:\Users\Kaccy\Documents\Visual Studio 2008\Projects\RMA Tracking System\RMA Tracking System\bin\Debug\DataDirectory\RMA.accdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

the path name automatically change to this...it should be 'C:\Users\Kaccy\Documents\Visual Studio 2008\Projects\RMA Tracking System\RMA Tracking System\bin\Debug\RMA.accdb' ...

jzlonely 0 Newbie Poster · Answer 7 · 2010-06-29T07:25:32+00:00

oopS! I found my mistake....the connectionstring should be Provider=Microsoft.ACE.OLEDB.12.0;Data Source=.\RMA.accdb;Persist Security Info=False;

After that I publish the system by using publish wizard. It can install and run well under my computer...
Then i try to install on another computer, it can be install but when i try to use the system , the same error as before show, "selected collating sequence not supported by the operating system"

hirenpatel53 -1 Posting Whiz in Training · Answer 8 · 2010-06-29T08:54:42+00:00

just take that exe file to other comp and istall there but u must be sure that the .NET framwork is installed into that comp try it will be work
and if works dont forgate to tick solved

jzlonely 0 Newbie Poster · Answer 9 · 2010-06-29T09:01:11+00:00

I already install the system to another computer ...If i not mistaken, the computer is installed with .NET Framework since i had installed VB.
but it cant work...

Oxiegen 88 Basically an Occasional Poster Featured Poster · Answer 10 · 2010-06-29T09:14:46+00:00

That errormessage indicates that something's hinky with the database file itself.
I found this articel in the MS KB.
http://support.microsoft.com/kb/184988

jzlonely 0 Newbie Poster · Answer 11 · 2010-06-29T09:28:11+00:00

I had tried this before...the New Database Sort Order now is general.
Isn't windows XP support multilanguage?

jzlonely 0 Newbie Poster · Answer 12 · 2010-06-29T09:51:18+00:00

this is the error when i trying to save a record...

jzlonely 0 Newbie Poster · Answer 13 · 2010-06-30T08:01:22+00:00

Thank you guys....I found the solution already. Actually just because of the version of the VB software that I use before. Before this I created the system with VB 2008 express, so that all the build application cant be support by other computer, after that I change to Visual studio 2008 and re-create the system, it can work well now.

Thank you for help ~ ^^ experience a lot from u all...