DSN Less ODBC Connection
Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2007-11-06
12:49 AM
- last edited on
‎2024-09-24
10:05 AM
by
Doreena Deng
‎2007-11-06
12:49 AM
Hello All
Is it possible to connect the AC ODBC dsn-less? Does anyone have an example or suggest a resource?
Many thanks
Mark
Is it possible to connect the AC ODBC dsn-less? Does anyone have an example or suggest a resource?
Many thanks
Mark
Labels:
- Labels:
-
Discussion
6 REPLIES 6

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2007-11-06 04:08 AM
‎2007-11-06
04:08 AM
image_engine wrote:Not to my knowledge.
Hello All
Is it possible to connect the AC ODBC dsn-less?
Karl
AC 28 USA and earlier • macOS Sequoia 15.4, MacBook Pro M2 Max 12CPU/30GPU cores, 32GB
Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2007-11-06 04:11 AM
‎2007-11-06
04:11 AM
Thanks Karl
Makes it pretty messy with large number of projects without programatic access.
Regs
Mark
Makes it pretty messy with large number of projects without programatic access.
Regs
Mark

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2007-11-06 05:14 PM
‎2007-11-06
05:14 PM
image_engine wrote:You're welcome; and I agree.
Thanks Karl
Makes it pretty messy with large number of projects without programatic access.
Regs
Mark
I just did a Google on 'programmatic system dsn' and among other things came up with this:
and the registry hack seems like a potentially reasonable work around.
On my XP Pro system, the system DSN entries are found at:
\HKLM\Software\ODBC\ODBC.INI\
Screenshot below shows the contents of an old DSN called "ODBC test" from the AC 9 version of the driver. Note that the key "ODBC Data Sources" must also contain a link (index) to point to this entry.
Maybe this will work? Report back here if so to help the next guy...
Thanks,
Karl
AC 28 USA and earlier • macOS Sequoia 15.4, MacBook Pro M2 Max 12CPU/30GPU cores, 32GB
Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2007-11-06 11:20 PM
‎2007-11-06
11:20 PM
Hi Karl
Got it sorted but I'm just in the office...those typos!!. Youcan do a standard dsn less connection...its just that I copied the connection string example from the help file which is "V1.0" not "V10.0" and so it went under the radar for a little while.
This codes works well for auto dsn generation when attached to the form open command;
http://www.vbforums.com/showthread.php?t=358864
and its quite terse. I discovered also that there is direct registry editing throught the getsettings of vba. More than one way to skin an archicat!
Standard ADO with connection string is by far the best alternative though.
Regs
Mark
Got it sorted but I'm just in the office...those typos!!. You
This codes works well for auto dsn generation when attached to the form open command;
http://www.vbforums.com/showthread.php?t=358864
and its quite terse. I discovered also that there is direct registry editing throught the getsettings of vba. More than one way to skin an archicat!
Standard ADO with connection string is by far the best alternative though.
Regs
Mark

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2007-11-07 12:53 AM
‎2007-11-07
12:53 AM
image_engine wrote:Are you saying that standard ADO does work, Mark? (Or that that would be your wish?) That would be great, as it is how I usually do things in VB in Access...
Standard ADO with connection string is by far the best alternative though.
Thanks,
Karl
AC 28 USA and earlier • macOS Sequoia 15.4, MacBook Pro M2 Max 12CPU/30GPU cores, 32GB
Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2007-11-07 01:10 AM
‎2007-11-07
01:10 AM
Hi Karl
Seems to be working fine. Just working on some timestamping but I get
State = adStateOpen on conn open.
Regs
Mark
Seems to be working fine. Just working on some timestamping but I get
State = adStateOpen on conn open.
Regs
Mark