[AccessD] Urgent SQL Server

Martin,

If you're talking about what connection string to use then this might be helpful...

ConnectString As String = "Provider=SQLOLEDB.1" _
                   & ";User ID= userid" _
                   & ";Password= pwd" _
                   & ";Initial Catalog= tablename" _
                   & ";Data Source= IP_Address_of_SQL_Server"

SQL server should be set up to listen on port 1433.

---
Eric Barro
Senior Systems Analyst
Advanced Field Services
(208) 772-7060
http://www.afsweb.com 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Martin Reid
Sent: Saturday, June 21, 2003 2:56 AM
To: accessd
Subject: [AccessD] Urgent SQL Server


I need to permit Access to My sql server 2000 from a server in the USA. Cant
seem to get SQL Server configured correctly. No firewall etc this end but
very tight security from the USA server end but they say it dosnt matter.

Anyone any ideas re settings from my side to open the server up for internet
access. Will be using a mixture of XML and  .NET in both directions if that
matters. SQL Server must be using Mixed Security.

Martin

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.489 / Virus Database: 288 - Release Date: 6/10/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.489 / Virus Database: 288 - Release Date: 6/10/2003