How to retrieve the DSN name from VBA in MS Access

[dockwingleong]

Is this even possible, retrieve the DSN name from VBA in MS Access?
Any sample code, suggestions are appreciated. I thought about reading
the registry but couldn't find a function to do that in Access VBA.

Is it possible to execute a VBScript from VBA?

Thanks,
-Dock

 

[dockwingleong]

Just to be clear, I am trying to retrieve the SQL Server name in Access
VBA. This is simple in SQL Analyzer, select @@servername, but Access
doesn't like this. The last resort for me is to use Windows APIs to
read from the registry. But hate to use Win APIs unless I really need
to.

-Dock

 

[SJ]

what about a pass thru query with "select @@servername"

 

[dockwingleong]

I finally used Windows Scripting Host inside VBA to retrieve the SQL
Server name from the registry, very easy and simple compare to any of
the previous thoughts.

Thanks,
-Dock