connect to server via intranet - how is it done (new to this)

Hi all!

I have msde2000 on one machine. want to connect to it from other machine. both machines are connected via a switch with integrated firewall.

Do I need to set up this firewall to enable connections? Like opening ports for msde in the virtual servers settings of the firewall?

If I do this, will that make my sql-server visible and accessible to the internet?

Or should I be able to find my sql server without such steps. And if so how?

networking is up and i can access folders of both machines via the intranet. Is that enough or do i need more settings here?

Let's say the machine and thus the server is called Alpha. What goes into my connectionstring from the other machine?

this wont be enough, right?
strconn = "Provider=SQLOLEDB;" & _
"Data Source="Alpha";"

Please shed some light on these questions.

tia

KumaFirst you will have to configure the ODBC settings in your machine. Make sure the datasource name is "alpha" , the same as the server name. You can then use "alpha" in the connection string. The code that is required is

'VB Code starts here

Set db = New ADODB.Connection

db.Properties("Data Source").Value = "alpha"
db.Properties("Initial Catalog").Value = "Northwind"
db.Properties("User ID").Value ="XXX"
db.Properties("Password").Value = "YYYYY"
db.Open

'ASP Code starts here
Set db = Server.CreateObject("ADODB.Connection")
db.Open "Provider=SQLOLEDB;Data Source=alpha;Initial Catalog=Northwind;User Id=XXX;Password=YYY"

'CODE ENDS HERE

Roshmi Choudhury

Connect to CE Remotely

If I have SQL 2005 Standard installed on a server and I log on locally to that server. Can I connect to other machines through Management Studio-->Object Explorer that have SQLCE installed and manage the CE DB?

I think you can only connect to either local .sdf files or ones located on a device attached by USB to the local machine, but I have had some difficulty finding a definitive statement on that.

Thanks

SQL CE is in process database (a bunch of DLLs loaded by your application) , it has no remote connectivity. There’s a very special remote provider which allows you to access files on device from desktop.

You also might be able to “connect” (quoted because you’re not really connecting to anything – SQL CE is within your process) to the database located on a file shares though it might have some issues like sharing.

conflict as the same row being changed at the same time by two sites

Hello
I made merge replication between 2 machines successfully.
BUT,
when a user on each machine insert a new row in the same table in the same
time,the insert for the publisher wins and the insert for subscriber
deleted.
I need to keep the two inserts in the database.
And that also happen with the update.
Thanks alot
Tamer,
it sounds like you need to partition the inserts, so an insert on the
publisher will have a different id to an insert on the subscriber. You can
do this in various ways, but probably the most common is to use identity
ranges to ensure the values don't overlap.
HTH,
Paul Ibison