Hi,

I use the following code to find the servername in MS SQL Server.

y = SQLEXEC(1,"SELECT @@SERVERNAME", "cursor_servername") && get server name

Paul

>Hi All,
>
>I'm trying to find out which server an ODBC data source is pointing at. I can get the DSN that a connection uses with DBGetProp as well as the database, userID and password. However, to make sure that the Crystal Report I'm automating is pointing at the server on which I've created the temporary table that it uses as its primary data source, I need to know the server name.
>
>The ConnectionString property is empty (because I've used the DSN route for the connection definition).
>
>I've been scouring the MSDN docs for an appropriate SQLGet* function, but to no avail.
>
>Any hints anyone (I'd love to hear that I've missed something obvious)?
>
>Cheers,
>
>Andrew