server=somewhere.com;uid=sa;password=sa;database=myDB
or:
server=66.33.11.123;uid=sa;password=sa;database=myDB
However, now I am dealing with a remote MSDE database. What is the format to connect to a remote MSDE database? Is it:
server=<IPADDRESS>\<INSTANCENAME>;uid=sa;password=sa;database=myDB
Where <IPADDRESS> is the Ip address of the remote machine and <INSTANCENAME> is the MSDE instance name. Is this correct? If not, what am I doing wrong?I've used the <MACHINENAME>\<INSTANCENAME> successfully before, but I'm not sure about the <IPADDRESS>\<INSTANCENAME> combo.|||I would only think that I can use the <MACHINENAME>\<INSTANCENAME> way if the machine was on my local area network. But the machine is not, it's on a remote network on the internet. So I couldn't use <MACHINENAME>\<INSTANCENAME> because how would it find that machine unless it had an IP address?|||you need the ip address, and have that msde server accessible through their firewall.|||So,... in other words,.. I was right,... the correct way to access it is:
server=<IPADDRESS>\<INSTANCENAME
correct?
No comments:
Post a Comment