Publishing Office chart Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Check with your web host and make sure they haven't moved the SQL Server and
that your connection string is still correct.
 
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.

David Berry said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top