No DSN!
-
Can anyone help me connect to a database ( an .mdf) and modify it and stuff without using a DSN? I'm not sure why this program that I'm trying to interface with doesn't use a DSN, but it doesn't seem to. Should I create my own DSN in order to access it? Any ideas would be helpful. halblonious
-
Can anyone help me connect to a database ( an .mdf) and modify it and stuff without using a DSN? I'm not sure why this program that I'm trying to interface with doesn't use a DSN, but it doesn't seem to. Should I create my own DSN in order to access it? Any ideas would be helpful. halblonious
Check the specs for the ODBC driver you're using. The access driver, for instance, allows DSN-less connections via ODBC by specifying the DBQ=database-path-to-file and Driver={Microsoft Access (*.mdb} connection substrings, in addition to any others you might want. Generally you need to provide at least the driver name, and the path to the data for 'local' (non-server) access. Steve S
-
Check the specs for the ODBC driver you're using. The access driver, for instance, allows DSN-less connections via ODBC by specifying the DBQ=database-path-to-file and Driver={Microsoft Access (*.mdb} connection substrings, in addition to any others you might want. Generally you need to provide at least the driver name, and the path to the data for 'local' (non-server) access. Steve S
Thank you very much for you response, but can you please give me a little more in-depth syntax on how to do this? Maybe an example? Thanks again. Evan halblonious