Connect Exchange 2000 Server to SQL 2000

I need to populate a Public Contacts Folder on an Exchange Server with data in a SQL 2000 Table. What would be the best way to do this?
ThanksPublic Contact Folder? or Populate a GAL with contacts?

I had to do it for my company but put it in the GAL and also make groups for regions of members etc. Big pain in the butt.

Without getting into too much detail, basically have to write a script to pull data into LDIF strings, then run a DTS that puts the strings into a csv or Text file in LDIF. Then Import that into Active directory using LDIFDE. Again this takes a long time ;p, your best bet might be to find someway to create an LDAP directory to use but unfortanatley that wasnt an option for me because I had to create query based distribution lists for my company members regions etc.

Connect a report to an application database

I added a database named appdata to the app_data folder to hold temporary application data. I want to show this data in a report. I created a dataset and an object to select the data. I then created an report.fdlc and a report.aspx with a ReportViewer on it pointing to the dataset object. If I right click on the report.aspx and View in Browser, it work perfectly. But when I upload it to the server I get and browse to it I get (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified). The server does allow remote connections. So I am thinking it's my connection string of the fact that the server doesn't have Sql Server Express.?

Here's my connection string. What am I missing here?

<

addname="appdataConnectionString"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\appdata.mdf;Integrated Security=True;User Instance=True"providerName="System.Data.SqlClient" />

Set the Data Source attribute to the full SQL Instance name like 'machinename\SQLEXPRESS' and try again.