Question get or set the instance name on local system

[pooya1072]

hi
in my program there is a database of sql .so this program need (at least) a sql server compact edition for execute.i want to get or set the instance server name of sql server compact edition in vb.net
how can i do it?

 

[jmcilhinney]

There is no instance name for SQL Server CE. The whole point of CE is that it's file-based rather than server based. There's only an instance name if you're using SQL Server or SQL Server Express.

 

[pooya1072]

thanks
so...in my program i need to set replication . for setting replication i need a server name that must be created on system which my program is installed.please tell me what should i do to get it when i have sql CE?

 

[jmcilhinney]

please tell me what should i do to get it when i have sql CE?

There's nothing you can do. If you want replication then you must use a server-based database, which SQL Server CE is not.

 

[pooya1072]

ok...thanks