On Tue, Mar 23, 2010 at 17:25, Paluee <palme...@gmail.com> wrote: > Yes, I almost forgot about that. > DSN-less. Actually it is due to the fact that I never fully understood > the differences between ODBC (always thought that it had to have > datasource), > and confused DSN, DSN-less as though they were separate constructs, > and mixed up > OLEDB along with the mix.
You can see the ODBC with DSN like having a database available as a predefined reference in your application server. If you want to directly access the database you need the whole connection string rather than just the reference. An ODBC DSN is not more than a database registered to the system so that different application could share it (apart from user name and password for login that has to be specified separately in the connection string anyway). The only thing - that I also never understood - is: Why the hack is it so important to specify all the option in the right order as the driver wants it. (Well this is maybe to compare with a commandline application where you might also need to have specific option in a specific order.) > Now that you have cleared up the confusion, I now see that DSN and DSN- > less are different modes of ODBC. > Funny, how I learned COM based ideas from a Java group, instead of > from VB6 world, from where I originally came from. :-) Maybe it is because I am also coming from that field. I did about 15 years of Windows development (and before under MS DOS :-))) ). But enough is enough - and I am so happy in the Linux world. :-) BTW: Similar happens in Linux forums: They sometimes help with serious Windows problems also. I think that a lot of "old Windows experts" are found nowadays in the Linux world. > Thanks again. I can now research this out. Let us know the final exact ODBC connection string needed. Unfortunately it is not listed at http://www.connectionstrings.com/ nor on http://www.carlprothman.net/Default.aspx?tabid=81 Should be added there if found out. Live long and prosper, Martin. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-datab...@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
