or perhaps from the SQL server itself?
That's simple, run this query:
select @@SERVERNAME
ODBC SERVER NAME EXTRACTION
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 63%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Dan Bowler
41
Reputation points
I have a desktop application that connects to varying server computers' SQL databases based on the ODBC server name I manually plug into the ODBC DataSource. I'd like to display that server name in my application. Can someone help me figure out how to retrieve the 'connect to' server name from either the ODBC DataSource or perhaps from the SQL server itself?
Windows for business | Windows Client for IT Pros | User experience | Other
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
-
Viorel 127K Reputation points2022-07-22T08:43:11.98+00:00 If you are writing in C# and have an OdbcConnection object, then consider the DataSource property, which should work even if the server is unavailable.
-
Dan Bowler 41 Reputation points
2022-07-23T18:55:28.267+00:00 The code is written in Visual FoxPro. I will explore this option, however, using FoxPro's SQL pass thru technology I can pull the servername straight off the server itself w/select @@SERVERNAME (as advised from another responder) was very straightforward. I'm presuming the same tactic can be applied to C# as well. THANK YOU for answering!
Sign in to comment
Answer accepted by question author
Olaf Helper
47,621
Reputation points
-
Dan Bowler 41 Reputation points
2022-07-23T18:42:19.383+00:00 WORKS JUST GREAT! EXACTLY WHAT I WAS LOOKING FOR. THANK YOU!
Sign in to comment