 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Java Forum / General / October 2007DSN for Ms Access
What is Data Source Name for MS Access database? "driver={Microsoft Access Driver (*mdb)};dbq=c:\myDataBase.mdl;" doesnt work Thanx :-) > What is Data Source Name for MS Access database? > [quoted text clipped - 5 lines] > > :-) Its easy: Driver={Microsoft Access Driver (*.mdb)};DBQ=C: \myDataBase.mdb;UID=;PWD=; Im the best :-) > What is Data Source Name for MS Access database? > [quoted text clipped - 5 lines] > > :-) A trick that used to work for me for stuff like this was create a new text file named "test.dsn". Then double-click it and Windows will prompt you with a dialogue to fill in the DSN details. Then after that, you open it up in Notepad again and read the connection string. But I can't test that right now because my current workstation keeps opening the file with VIM. On Oct 26, 2:53 am, lord.zol...@gmail.com wrote: > > On Oct 25, 2:27 pm, Grzesiek <grzesiek.wilanow...@gmail.com> wrote: > > What is Data Source Name for MS Access database? [quoted text clipped - 8 lines] > But I can't test that right now because my current workstation keeps > opening the file with VIM. Which version of Windows are you talking about? I'm using Windows XP, while .dsn has an icon defined, there's no default program to open it. > On Oct 26, 2:53 am, lord.zol...@gmail.com wrote: > [quoted text clipped - 13 lines] > Which version of Windows are you talking about? I'm using Windows XP, > while .dsn has an icon defined, there's no default program to open it. Hmm... I thought it was just my workstation here. Well, you could try creating the file, then going to Control Panels -> Admin Tools -> Data sources (ODBC) and then create a DSN from a file and choose the test.dsn you created. The connection string should be in the file. On Thu, 25 Oct 2007 11:27:04 -0700, Grzesiek <grzesiek.wilanowski@gmail.com> wrote, quoted or indirectly quoted someone who said : >What is Data Source Name for MS Access database? see http://mindprod.com/jgloss/jdbc.html#CONNECTING  SignatureRoedy Green Canadian Mind Products The Java Glossary http://mindprod.com Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.