I was having the same issue. I used the following connection string. "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=<User ID>;Initial Catalog=pubs;Data Source=<YourDataSourceName>;Network Library=dbnmpntw" http://support.microsoft.com/kb/238949 HTH, W