(local) is supposed to work. SHow us your connection string (and code around) and tell us the error you get.


>Hi all,
>
>I'm attempting to set up an ADO connection to an installation on my -local machine- of SQL 2000. When I'm attempting to set the DataSource property of the connection string, what do I use for the name of the server? I've tried the word (local) that shows up in Enterprise Manager for the server name, a single dot(.), and a double dot(..) with no success.
>
>Anybody got any ideas?
>
>TIA,