SQL connection strings

I cannot connect to my sql2000 dbase with the following string:

StrConn="Driver={SQLServer};Server=mssql02.discountasp.net;Database=DB_292589_ufcpp;Uid=DB_292589_ufcpp_user;Pwd=xxxx;"

I get a "Data source not found " error.

Using the Provider method:<!--StartFragment --> Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password; gives me a "elements not valid" error.

I'm wondering if the username "DB_292589_ufcpp_user" discountasp assigned me is bad, but it works when I connect to the MyLittle sql manager.

???

 

ASP for right now( but eventually I will be using some .net )


thanks