Publishing Office chart Error

[Abobakr_Nasr]

i've an office chart with a SQL 2000 data source (Provider=SQLOLEDB). When
publishing it the following error occured:

Failed to get data. If available, errors returned from the provider are
listed below.
* Data provider could not be initialized.
* [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
Any suggestions wil be appreciated. Thanks

 

[David Berry]

Check with your web host and make sure they haven't moved the SQL Server and
that your connection string is still correct.

 

[Abobakr_Nasr]

Thanks for reply,
here is my connection string & i really think that it is the cause of problem:

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=True;Initial Catalog=<Database>;Data Source=193.227.13.223;Use Procedure
for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation
ID=<MachineName>;Use Encryption for Data=False;Tag with column collation when
possible=False

look to <Data Source> part, am I suppose to write Sever IP address as above
or write ServerName or WHAT?
Thanks a lot.

Check with your web host and make sure they haven't moved the SQL Server and
that your connection string is still correct.

i've an office chart with a SQL 2000 data source (Provider=SQLOLEDB). When
publishing it the following error occured:

Failed to get data. If available, errors returned from the provider are
listed below.
* Data provider could not be initialized.
* [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access
denied.
Any suggestions wil be appreciated. Thanks