Wrox Programmer Forums
|
Pro VB Databases Advanced-level VB coding questions specific to using VB with databases. Beginning-level questions or issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 24th, 2007, 08:03 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

two things...

did you add the mdb to the P&D so it will go with the exe file??
is your path hardcoded or you build it on the fly?? can you just write the code you use to access the mdb?? (where you point out the path to it)...

the exe is not builded by the P&D, is builded by the IDE... there is a lot of software to make deploys, but the P&D is just enough for your needs at least at this point.. I will ask again.. did you add the mdb file when you builded the setup program??

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========
 
Old August 24th, 2007, 08:59 PM
Authorized User
 
Join Date: Jun 2007
Posts: 87
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to ivanlaw Send a message via Yahoo to ivanlaw
Default

My coding as below:
Private Sub Form_Load()
Set conDatabase = New ADODB.Connection
Set rsDatabase = New ADODB.Recordset
conDatabase.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"persist Security Info=false;Data Source=" & App.Path & "\database.mdb"

conDatabase.Open
With rsDatabase
    .CursorLocation = adUseClient
    .CursorType = adOpenDynamic
    .LockType = adLockOptimistic
    .Open "Name", conDatabase, , , adCmdTable
End With
End Sub

Then I got add the mdb into the program when I builded the setup program.Then I face that kind of problems also.Is it deploys can help us to create a product ID or CD key for the program.
Sorry about that keep asking questions,but actually I really do not know about all of them.So I will wait for your advice...

Thank you.

 
Old August 25th, 2007, 11:32 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

when the program is installed.. the database is there???

I don't fully understand now where is your problem... you still can't find the database???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========
 
Old August 27th, 2007, 01:45 AM
Authorized User
 
Join Date: Jun 2007
Posts: 87
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to ivanlaw Send a message via Yahoo to ivanlaw
Default

After I installed the program,database does not in the program file.
So in this case I also do not know where my program got error or the package & deployments wizard got problem.Or you got any software that can build vb code to the .exe file which is a freeware also.Waiting for your advice...

Thank you.

 
Old August 27th, 2007, 07:24 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

so you are not sending the database with P&D.. did you add it to P&D?? (not your project exe, your installs project!)
there is a lot of that in google.. if you are not satisfy with P&D (that's works very good unless you use crystal reports) you can search for it....

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========
 
Old August 28th, 2007, 01:54 AM
Authorized User
 
Join Date: Jun 2007
Posts: 87
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to ivanlaw Send a message via Yahoo to ivanlaw
Default

Ok.I say what I did during my project to you more clearly.That's very simple.Firstly I have type down all the coding into the Microsoft visual basic 6.0,then confirm that my program has connect to the database.After that,I just used the Package & Deployment Wizard which is provided by the Microsoft visual basic 6.0 Tools to build up a setup.That's all.
So is it any step need to change or add,please teach me...
Waiting for your advice~

Thank you.

 
Old August 28th, 2007, 07:02 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

I will try to explain this more carefully...

you are in the right path, the only thing you need to add is when you build the P&D there is a step that let you add files to the setup project, in that step you should add your database, and then it will be installed with your exe. are you doing this???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========
 
Old August 28th, 2007, 08:05 PM
Authorized User
 
Join Date: Jun 2007
Posts: 87
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to ivanlaw Send a message via Yahoo to ivanlaw
Default

Sorry...I'm keeping disturb you.Actually I'm not very familiar to do that thing.
So could you tell me how to add the database to the setup project,please?I used the Microsoft visual basic 6.0 for coding.
Waiting for your advice...

Thank you.

 
Old August 29th, 2007, 07:59 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

hi there..

there is a step named included files.. in that step you should choose the database you want to include... that's all...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========
 
Old August 31st, 2007, 08:09 PM
Authorized User
 
Join Date: Jun 2007
Posts: 87
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to ivanlaw Send a message via Yahoo to ivanlaw
Default

Hi there~
Thank you for your all advices.I already solve the problem.

Thank you very much guy.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Urgent: Excel and Vb 6.0 ivanlaw Pro VB 6 5 October 22nd, 2007 03:34 AM
Urgent:VB coding ivanlaw Pro VB Databases 9 September 7th, 2007 07:06 AM
Urgent :VB 6 and Database ivanlaw Pro VB Databases 10 August 23rd, 2007 07:35 AM
New to VB/Database (Urgent) FrancisEnem VB Databases Basics 3 December 11th, 2006 03:11 PM
urgent (in vb.net) renjininair_2000 BOOK: Beginning VB.NET 2nd Edition/Beginning VB.NET 2003 12 March 31st, 2006 11:56 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.