[AccessD] connecting to sql server using access 2000 adp

Eric Barro ebarro at afsweb.com
Wed Mar 17 16:37:20 CST 2004


I need help with connecting to a SQL server 2000 db using an ADP (Access 2000).

I know how to connect via the regular port (1433). Where do you change the value if the server uses a different port like 1049? I am assuming that Access ADPs connect and expect to find the specified SQL server at port 1433.

Any help or links will be appreciated.

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

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.593 / Virus Database: 376 - Release Date: 2/20/2004





More information about the AccessD mailing list