sql create database path issue

Hi,

I have a vb application, that uses as sql server database,
I install an Instance of sql server, using MSDE sp3.
The instance name is Nexus, so on a default machine, it should install to
c:\Program Files\Microsoft SQL Server\MSSQL$NEXUS\, which is working fine.

I also run this query, using Osql afterwards to create a new database in that instance, but
the problem is that the path to the data directory, is hard coded, so when a user installs
his program files on his D drive for example, the create database statement will fail!


is there any way to do the part in red, with out using a physical path, but still specifying
it to go the the MSSQL$NEXUS\ folder?

Any ideas and references is appreciated.

Thanx in advance.

noFriends

Is there a good reason it has to be on MSSQL$NEXUS folder. Also, can you run the SQL database creation script from a VB app? Then you can make a nice little front end and make the user choose what directories they want to use and run the database creation script from the VB app.

Also, assuming that everything is on the same path/drive might be incorrect. In our case, we make the data stay on one drive and indexes on another drive and the log file on a third. So you could make the user specify where they want all three of them and default them to the same location.

yes there is

because some of the users already have sql server installed on their machines, and we would like the whole instance to be seperate from existing servers, and the client application uses the nexus instance to connect to, any ideas?