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 16th, 2007, 08:46 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 Urgent :VB 6 and Database

Hi all Pros,
I need to know that how to solve the "Could not find the installable ISAM" problems???
When I install Microsoft office 2000 and 2003 also face that kind of problems...
Please teach me...

Thank you.

 
Old August 17th, 2007, 08:00 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.. this could be a connection string problem.. has you tested 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 17th, 2007, 09:48 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

So as normally what should I coding for it to solve the connection string problem???

Thank you.

 
Old August 20th, 2007, 04:30 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

Hello there,my coding is like 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 Sourse=" & App.Path & "\database.mdb"

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

The error is at the "conDatabase.Open" there.
So how to solve it,please teach me...


Thank you.

 
Old August 20th, 2007, 12:57 PM
Friend of Wrox
 
Join Date: Nov 2004
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts
Default

Could it be that “Data Sour[u]s</u>e=" ” should be “Data Sour[u]c</u>e=" ”?
(Only guessing)
 
Old August 20th, 2007, 10:41 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 BrianWren,

Thank you very much that you can catch me up my careless.
Lolx

 
Old August 21st, 2007, 01:48 PM
Friend of Wrox
 
Join Date: Nov 2004
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts
Default

Did that fix it?
 
Old August 22nd, 2007, 01:50 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

Yes...Thank you.
But after I convert the program to the .exe file then I face could not find the database error.Why???Please help me again...

Thank you.

 
Old August 22nd, 2007, 03:58 PM
Friend of Wrox
 
Join Date: Nov 2004
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts
Default

My suspicion (having nothing else to go on) would be that App.Path & "\database.mdb" does not point to where database.mdb actually is. (It also could be that the process running the .exe does not have autorization to read/execute that .mdb, so it appears to not exist.)
 
Old August 23rd, 2007, 04:21 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 follow your advice also got error which is error "53".Actually I did not found my database in the program file after I install it.That is what kind of the error???Why it will happened???Please teach me...

Thank you.






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 ivanlaw Pro VB Databases 19 August 31st, 2007 08:09 PM
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.