I know there is a treat about this but it can 't solve my problem
I've got vb express on 2 computers now, en when I try to connect by add new datasource, one my laptop i'vr got give a connection string , on the other pc , I can browse to the access database.
I already removed the complete office and express editions and installed them again
the same problem occures
a simple question fot some but i can't find it
why is there a difference, and I'vr tried several connectionstring , nothing seems to work
Is there someone who can give me a push in the good direction
thanks in advance
greetz
ivo
access database
hye_heena
Hi Ivo,
I'll be happy to help with many access problems but quite frankly I don't have the faintest idea what your question is.
To help resources assist you, please read the, "How to receive the optimal answer for your question" at the top of the forum and rephrase your question.
hrubesh
Ivo,
What are you trying to do overall
aliar
Hi Ivo,
It sounds like you might be getting the dialog for ODBC connections instead of Access connections. After step 4 from the post above, try clicking the "Change..." button on the "Add Connection" dialog and choose "Microsoft Access Database File" on the "Change Data Source" dialog that comes up -- then click OK. That should switch you to the Add Connection dialog for Access database files.
I hope this helps.
cythe
Please see this thread:
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=479865&SiteID=1
Page 3 is all that's necessary.
Lucas Pasquali
Hi ReneeC
both the databases are local, and maybe I could better open them with code, no idea fist time ever using vb.
But it was a lttle strange to me why one one pc it works and on the other not
even reinstalled office and sqlexpress en vb express 2005.
thanks to take the time to help me out
ivo
Seraph_78
Ivods,
Many moderators here are less than enamored with the data connection wizard. If you'd like we could go over how to open this in code.
Am I to take it that there is a simgle Access dtabase on two node so to one computer it looks local and on the other it looks remote
kennm
Hi all,
Those are the steps i made on both computers, and on my laptop, i can't browse to the database as trucker describes in point 8.
On my laptop I get a window to type a connectionstring instead of the possibility to browse to the database, on the other computer it works like it should.
And Renee I'm trying to make an application with less load for the cpu and memory, so it can run on smaller computers, otherwise I should use the sql server for the databases.
this is the first time I'm using vb, before I used delphi.
ivo
WinFormsUser13232
it is xp,with sp2
.net framework 2.0 office 2003 proff.
the same config as the other pc
but I will try the code aproach, still to bad that the wizard doesn' work
for a beginner like me it was easy, and worked fine on tthe other pc
but als always in programming, there is always something that start to get your hair start going grey
regards
ivo
Ali Jannatpour
i' sorry
I try to access an .mdb database in vb 20005 express trough the new data connection wizard and on my laptop I always get a screen with the question for a connection string , on the other pc i can browse to the database and can see the database in the database explorer
on the laptop get the screen to input a connection string, i've tried several posted in yhis forums but it seems not to work.
regards
ivo
RyanB88
Ivods,
At least the code of pointed you to will be a good diagnostic.
What version of windows does the laptop have It's it's XP does it have SP2
If it is not XP does it have MDAC 2.8 installed/
Prasant Swain
dagfari
Hi Jay
I do just the same on both computers and you can read the result, and I select the access database connection , strangs but this is the fact, I 'm going to try to connect by code as supposed by ReneeC, but I hate the fact that I don't know why it doesn't work on that ... laptop.
ivo
re infecta
It sounds like you need to configure the connection on your laptop. From what you are saying (correct me if I'm wrong) , on your desktop PC, all you have to do browse the database because, it is already configured. You will have to follow the steps in the Database Connection Wizard in Visual Basic 2005 Express Edition and provide the information in the popup boxes. Here is what you do:
1.On the Right side of the screen select the Tab that says: Data Sources.
2. Select the Underlined words that say: ADD NEW DATA SOURCE.
3. You will get a new Popup Box Select DATABASE & then the NEXT Button.
4.Click on the NEW Connection Button on the right side of the popup box.
5.You will get another popup box that says: Choose Data Provider.
6. If you are using an ACCESS Database, Select the one for ACCESS.
7.Click Continue
8. On the next popup Box Browse to the Database you wish to connect to and select any table or tables that you wish to work with.
9. Click : TEST CONNECTION
10. (be sure to input any Passwords etc. that are needed.
11. Click OK.
12. You will be back to the Data Source Configuration Wizard Popup Box.
13. Click NEXT.
14.You may get a Popup telling you that the database file is not in the same folder as your project and asking you if you would like to make a copy of the database and put it in the Project Folder. I suggest you select: YES.
15. You will now get to the popup box, SAVE the Connection String to the Application Configuration File. Click NEXT.
16. In the next Popup Box you can select the Object(s) (Table(s) ) you wish to work with. Select the ones you want and then Click : FINISH.
From there you are on your own.
james
aka:Trucker
EWGoforth
http://msdn.microsoft.com/coding4fun/inthebox/dataenabled/default.aspx
Are you sure the steps you're taking are exactly the same Perhaps if you can describe them with reference to this URL, we can get an idea of where things are going awry