|
Hi, I have made a small application in VB.Net/MSAccess. I want to install this application on a different machine. I have made the setup as per the instructions and installed the application on my machine itself. However, an error message pops up when I run the application. The error message is related to database connectivity. The MS Access DB is located in a folder named database within the application folder.
I need to know what steps are needed to be carried out with respect to the MS Access Database. Do I have to copy the MS Access DB to the specified folder as mentioned in the error message. (It points to C:\Program Files\Database)
Thnx for any help.
With Best Regards,
Mayur
|
|
|
|
|
Try using 'Application.StartupPath'
Dim path As String = Application.StartupPath
Dim cnStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& " Data source= " & path & "\Database\YourDBname.mdb"
Dim strSelect As String = SelectString
Dim cn As New OleDb.OleDbConnection(cnStr)
Dim cmd As New OleDb.OleDbCommand(strSelect, cn)
Dim da As New OleDb.OleDbDataAdapter(cmd)
|
|
|
|
|
Hey Richard,
Thnx for your help. I have been using the same. please refer to the connection string below.
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & Application.StartupPath & "\..\Database\XYZ.mdb"
This works fine when run on the development machine. However, I need to install this application on another machine. It displays an error message regarding the database connection. Please help me out with this. thnx
With Best Regards,
Mayur
|
|
|
|
|
Hi Mayur
Did you put the actual database connection lines in a Try...Catch block - then you can see exactly what the error is by using MessageBox.Show(ex.message). Post the exact message and maybe I can help.
IS MDAC installed on the target machine?
Try<br />
cn.Open()<br />
da.FillSchema(dt, SchemaType.Source)<br />
Return True<br />
Catch ex As Exception<br />
MessageBox.Show(ex.Message) 'WHAT MESSAGE DO YOU GET?<br />
Return False<br />
Finally<br />
cn.Close()<br />
End Try<br />
|
|
|
|
|
Hey Richard, right now i will not be able to provide you with the exact error message since I am busy with some critical work. However, the error message as far as I remember was something like this "Unable to find the database in C:\Program Files\Database". This has got me stumped. Why does it search in C:\Program Files\Database. Also, can you please tell me how the MS Access database has to be deployed on the client machine.
With Best Regards,
Mayur
|
|
|
|
|
hi all
i have used an ActiveX control in my VB project.
when i run it there are no errors and the forms are displayed.but in design time when i switch to form view(i.e View Object) from code view it displays an error msg "errors during load..refer to log for details".when i referred to the corresponding log file it says "license not found"..
what could be the reason behind it?
-- modified at 6:45 Monday 6th February, 2006
|
|
|
|
|
It's because the design-time license for whatevery control your using doesn't have a design-time license installed on your dev machine. This mieans that you're not authorized to use the control in your own applications. I really can't tell you more than that without knowing which control your trying to use.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
-- modified at 10:02 Monday 6th February, 2006
|
|
|
|
|
Hello,
I am working on an Excel application which is sometimes triggered via OLE by another application. The application sends an OLE-command, which calls a macro inside Excel. This works in most cases.
Sometimes, by hitherto unknown reasons, the OLE command does not arrive to Excel.
Does anybody know possible reasons for this?
Are there possibilities to reestablish the OLE communication?
Regards
Michael
|
|
|
|
|
hi
i want to make addin for outlook thats catches the mouse click on the mailitem(means when i click on any mail in my inbox).
thanks in advance
Ankit Patial
|
|
|
|
|
I havn't seen anything like that, but here is a link to OutlookCode.com
that has a lot of outlook programming stuff.
http://www.outlookcode.com/[^]
progload
|
|
|
|
|
hi my website is done and now i want it to upload to the web. i saved it in c:\inetpub\wwwroot. how do i upload my file to my domain name "www.mydomain.com"
-- modified at 5:11 Monday 6th February, 2006
|
|
|
|
|
Why don't you ask them? You're paying for the space and support, so use it.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hello Everyone !
I am fine and hoping the same for you.
I need your help in builing and "scrolling text" application. Actually i want to make an application in which i need to scroll my text (from Database) vertically upward, like we see some websites with Current news etc.
Thanx in advance for helping me.
Bye
Arfan Qadir
|
|
|
|
|
|
I want to make a Connection to a Password protected Access 2003 Database.
I tried to make a "Data Connection" in "Server Explorer" tab. In the "Data link properties" dialog box, I select "Microsoft Jet 4.0 OLE DB Provider" in the Provider tab, and in the Connection tab, I select my Database location and default checked "Blank Password" with username "Admin" (Default). It works fine if the Database has no password set.
But when I set password on Database and unchecked "Blank Password" and enter my password in the field "Password" and then click on "Test Connection", it failed to make a connection to Database.
Please help me solve this problem.
Also i have to give a complete location of database, is there any way to give the location of database to the same of executable, e.g. in the Bin folder both files (Database and MyProgram.exe) present, it automatically collect the location of executable file.
Iftikhar Ali
|
|
|
|
|
Select ”Microsoft Jet 4.0 OLE DB Provider”
Select your database location
Do not change anything.
Select “All” tab
Select “Jet OLEDB:Database Password”
Type your password.
Click OK.
chatura
|
|
|
|
|
I have to change/apply password to Access database by opening it in Exclusive mode and then change/apply password to it.
I then close database file and close Access, and even I restarted my computer and try your instructions but on Test Connection got this error.
"Test connection failed because of an error in initializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user."
I did the same process as you describe before asking this question, but the error above mentioned occured.
So, tell me now what should I do.
|
|
|
|
|
I do not know what your error is, but it worked when I did so. I will try to find it. Try to do kostasdiktia2's example.
chatura
|
|
|
|
|
Nonetheless, thanks.
I'll try kostasdiktia2's example.
|
|
|
|
|
temp = System.IO.Path.GetFullPath("Data.mdb")
temp = "Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=" & temp & ";Mode=ReadWrite;Extended Properties="""";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Database Password="""";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="####";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False"
OleDbConnection1.ConnectionString = temp
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
This is an example with a database from data.mdb file (Access file)!
First, I put in temp the path.
Next, I put in temp the connection string of database (in field #### you must write the password)
*I am not 100% sure if it wants password there or in first line! Make combinations!
And finally, I change the connecion string of my OledbConnection..
-- modified at 19:16 Monday 6th February, 2006
|
|
|
|
|
I'll try your solution.
At this moment, I'm building my software without database password. I'll try your solution and then inform you. While please tell me, in your solution, you use Password string many times and in the end advice me to enter my password in place of ####, tell me I only have to enter password in place of #### or everywhere you use Password.
|
|
|
|
|
Look..
I am not sure 100%,that I told you..so, make some combinations for the "where", but you can find informations for this in Web..Sorry for my incomplete help..but i dont want make mistakes and make difficult your job..  
Friendly..
|
|
|
|
|
OK I'll try different combinations.
Tell me how this line of code will work.
temp = System.IO.Path.GetFullPath("Data.mdb")
What I understand is this:
>>First you declare temp as string
Now tell me how VB.NET knows where is Data.mdb, I mean did you include it in project as something & if you did tell me how? All steps in detail please of the above line.
|
|
|
|
|
Ok listen...
First of all:
Imports System.IO 'on the top of your code
Dim temp as string 'in your code
Next step, is to add the .mdb file (Access file) (for example Data.mdb) to your project! Because in the future, you may built a setup to install this program in other computers, its good this file have the path of your .exe, so you must add it in C:\...\EXAMPLEPROJECT\bin if you have Visual Studio 7 or in C:\...\EXAMPLEPROJECT\bin\Debug\ if you have Visual Studio 8!
So this code line [temp = System.IO.Path.GetFullPath("Data.mdb")] take the path of your .exe and add in the end of this string the "\Data.mdb"..so you have the path of your Access file, which now is in folder with your .exe!
If you have more questions..tell me...
I hope I help you... ;)
-- modified at 16:26 Friday 10th February, 2006
|
|
|
|
|
Thanx a lot.
Sorry for late reply.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
