Datastore not available - SQL 2000

Trying to connect to my Citrix Metaframe presentation server 3.0 and it says
that my datastore is not available. This is a SQL Server 2000 database
installed on another system and when I open the Enterprise manager, I am
unable to see the databases. But, it looks that the database is available in
D:\program files\Microsoft SQL server\MSSQL\Data.
What could be wrong? Has my SQL Server 2000 been corrupted or ?
Is it possible that the databases go detached. Connect to the master
database using Query Analyzer and run the following query:
Select * from sysdatabases.
Verify that the databases you are looking fo are listed.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Correcting typos:
Is it possible that the databases got detached? Connect to the master
database using Query Analyzer and run the following query:
Select * from sysdatabases.
Verify that the databases you are looking fo are listed.
Rand
This posting is provided "as is" with no warranties and confers no rights.
sql

Datastore not available - SQL 2000

Trying to connect to my Citrix Metaframe presentation server 3.0 and it says
that my datastore is not available. This is a SQL Server 2000 database
installed on another system and when I open the Enterprise manager, I am
unable to see the databases. But, it looks that the database is available in
D:\program files\Microsoft SQL server\MSSQL\Data.
What could be wrong? Has my SQL Server 2000 been corrupted or ?Is it possible that the databases go detached. Connect to the master
database using Query Analyzer and run the following query:
Select * from sysdatabases.
Verify that the databases you are looking fo are listed.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Correcting typos:
Is it possible that the databases got detached? Connect to the master
database using Query Analyzer and run the following query:
Select * from sysdatabases.
Verify that the databases you are looking fo are listed.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Datastore not available - SQL 2000

Trying to connect to my Citrix Metaframe presentation server 3.0 and it says
that my datastore is not available. This is a SQL Server 2000 database
installed on another system and when I open the Enterprise manager, I am
unable to see the databases. But, it looks that the database is available in
D:\program files\Microsoft SQL server\MSSQL\Data.
What could be wrong? Has my SQL Server 2000 been corrupted or ?Is it possible that the databases go detached. Connect to the master
database using Query Analyzer and run the following query:
Select * from sysdatabases.
Verify that the databases you are looking fo are listed.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Correcting typos:
Is it possible that the databases got detached? Connect to the master
database using Query Analyzer and run the following query:
Select * from sysdatabases.
Verify that the databases you are looking fo are listed.
Rand
This posting is provided "as is" with no warranties and confers no rights.

DataSet rows being deleted, but after the update , the sql database is not updated. The de

Stepping thru the code with the debugger shows the dataset rows being deleted.

After executing the code, and getting to the page presentation. Then I stop the debug and start the

page creation process again ( Page_Load ). The database still has the original deleted dataset rows.

Adding rows works, then updating works fine, but deleting rows, does not seem to work.

The dataset is configured to send the DataSet updates to the database. Use the standard wizard to create the dataSet.

cDependChildTA.Fill(cDependChildDs._ClientDependentChild, UserId);

rowCountDb = cDependChildDs._ClientDependentChild.Count;

for (row = 0; row < rowCountDb; row++)
{

dr_dependentChild = cDependChildDs._ClientDependentChild.Rows[0];
dr_dependentChild.Delete();


//cDependChildDs._ClientDependentChild.Rows.RemoveAt(0);

//cDependChildDs._ClientDependentChild.Rows.Remove(0);
/* update the Client Process Table Adapter*/
// cDependChildTA.Update(cDependChildDs._ClientDependentChild);
// cDependChildTA.Update(cDependChildDs._ClientDependentChild);

}

/* zero rows in the DataSet at this point */

/* update the Child Table Adapter */
cDependChildTA.Update(cDependChildDs._ClientDependentChild);

Hi,

You should use AcceptChanges method after using delete in order to update the data. The following link may be helpful to you.

http://msdn2.microsoft.com/en-us/library/ms233823(VS.80).aspx

Thanks.