How do I access a SQL Server database
Posted on 1999-07-12
OK, the situation is this. There is a company setting up a SQL Server database. I am developing a Web site that needs access to this database using ASP. The database is held at site A, but the Web site is served from site B. I am familiar with setting up DSN's and referencing them in ASP to connect to MS Access database.
However, when I try to create a DSN for a SQL server database, I get an empty drop-down box to specify the SQL server. How do I specify the remote SQL server machine at site B. Also, what do they need to have done at site B to make the SQL Server database accessible in this way.
Thanks for any help