HELP! DAta source property

[emuti]

We are building an Access to SQL Server ADP application. We have installed SQL Server 2000 not using default naming conventions. Therefore, the name of the server has ended up with what lools like the (prompted for) directory in the path (CAL_SQL\DDSQLSERVER). Thus, the Data Source property needs be "CAL_SQL\DDSQLSERVER". But because there is an embedded slash, the Data Source Property of the ADO Connection never recognizes the full name of the server when the full name is assigned it, and instead, interprets the name assigned up to the slash (In this example, the Data Source will display as "CAL_SQL&quot. This is forcing the user to continually select the datasource (Server) list box on Login, rather than me supplying it in the connectionstring. How can I force acceptance of the proper full name of the server by this driver (SQLOLEDB ver 2.6)?

 

[tlbroadbent]

Multiple instances of SQL Server 2000 can be installed on a server so you will likely see more naming like you describe. Open the Client Network Utility on the client machine and give the instance of SQL Server an alias like "CA_CAL". Check the port that the instance of SQL Server listens on and make sure the client setup matches. Terry

http://members.home.net/tlbroadbent/index.htm