944,117 Members | Top Members by Rank

Software Development > Visual Basic 4 / 5 / 6 > VB: Connect to Access database via ODBC datasource name
Ad:
You are currently viewing page 3 of this multi-page discussion thread; Jump to the first page
Permalink
Mar 3rd, 2007
0

Re: VB: Connect to Access database via ODBC datasource name

Click to Expand / Collapse  Quote originally posted by vihang1 ...
I am new to VB.Net and have a question. I am trying to connect VB.Net to Access. What I want to do is , when i select the database name, I want to popup the tables in the database...when one of the table is seleted, then the fields in the table should pop up...Can someone tell me how to go about it .

thanks in advance

Vihang
You might have better luck posting this in the VB.NET forum.
Reputation Points: 10
Solved Threads: 3
Light Poster
mjwest10 is offline Offline
27 posts
since Feb 2007
Permalink
Dec 13th, 2007
0

Re: VB: Connect to Access database via ODBC datasource name

is good forum for me
Reputation Points: 10
Solved Threads: 0
Newbie Poster
fahrul_1983 is offline Offline
2 posts
since Dec 2007
Permalink
Dec 13th, 2007
0

Re: VB: Connect to Access database via ODBC datasource name

i want to conect vb to crytal report 9

otomatitation path. n nothing install vb to komputer client
Reputation Points: 10
Solved Threads: 0
Newbie Poster
fahrul_1983 is offline Offline
2 posts
since Dec 2007
Permalink
Feb 11th, 2009
0

Connecting ms access database to a vb program

hi, cscgal,
i wanna know how to connect MS Access Database to a Visual Basic 6 program.
i hav little knowledge about it and i will list wht i did:

1. Project menu > References... > select Microsoft DAO object 3.6 > ok
2. Since i beginner to vb and database connectivity i start with VB Data Connection Wizard;
3. When i go with the wizard and selecting the prepaired MS Access database with Visual basic it gives me error:
"The Unrecognised Data source.."
What should i do.
Im using Visual Basic 6 and MS Access 2003.
Please help me. im on a project to my degree.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
BraveHeart2009 is offline Offline
1 posts
since Feb 2009
Permalink
Feb 11th, 2009
0

Re: VB: Connect to Access database via ODBC datasource name

Hey... Wingnut. How about you not post to threads that are like 2 years old.... start a new thread.
Team Colleague
Reputation Points: 361
Solved Threads: 214
Taboo Programmer
Comatose is offline Offline
2,413 posts
since Dec 2004
Permalink
Jul 31st, 2009
0

Re: VB: Connect to Access database via ODBC datasource name

Try the different connection options on www.connectionstrings.com to find one that works.
Reputation Points: 3
Solved Threads: 0
Newbie Poster
maxwik is offline Offline
3 posts
since Jul 2009
Permalink
Jan 20th, 2010
0
Re: VB: Connect to Access database via ODBC datasource name
my friend are you using rdo? or not?
if yesyou should make your code like this

Set rcon = rdoEngine.rdoEnvironments(0).OpenConnection _
("db1", rdDriverNoPrompt, , "UID=;PWD=Mypassw")

if not it should be like this
con.connectionstring="DSN=(name of your database here);Uid=;pwd=Mypassw"

ok let me know if it works just email me ok
thank you
Last edited by pjlacsamana; Jan 20th, 2010 at 8:27 pm. Reason: change of senetces
Reputation Points: 10
Solved Threads: 0
Newbie Poster
pjlacsamana is offline Offline
1 posts
since Jan 2010
Permalink
Mar 12th, 2010
0

hello,

hai. iam a final year student. i am doing my project. In that project i have one doubt in connection. How to connect visualbasic 6 with oracle 8i database by using odbc connection? please help me for this question. and my request is to please reply the answers in step by step.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
anithasivarajan is offline Offline
1 posts
since Mar 2010
Permalink
Sep 5th, 2010
0
Re: VB: Connect to Access database via ODBC datasource name
Click to Expand / Collapse  Quote originally posted by ChristinaOrchid ...
Hi Expert,

I already create a datasource name for my Access database. However, I failed to connect to that database using this code:

Set db = DBEngine.Workspaces(0).OpenDatabase("dbsourcename", ,"DSN=dbsourcename;UID=MyUID;PWD=Mypassw")

Could anyone help me please. Thank.
it will be a greet help
Reputation Points: 10
Solved Threads: 0
Newbie Poster
zainab saleem is offline Offline
1 posts
since Aug 2010

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Skin Vista In VB6
Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: showing specific records using vb6 datareport





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC