Hi,
I have a couple of SQL queries that I use in .NET to update some tables in my database. After I replicate the database, one of the queries no longer works.
The first query updates the parent table. The second query uses the RECORDNUM from the first query and updates the child table but when running the .ExecuteNonQuery I get a 'Cannot Open Database' error.
If I resort back to my non-replicated database everything works fine.
Any ideas of what is happening here??
I have a couple of SQL queries that I use in .NET to update some tables in my database. After I replicate the database, one of the queries no longer works.
The first query updates the parent table. The second query uses the RECORDNUM from the first query and updates the child table but when running the .ExecuteNonQuery I get a 'Cannot Open Database' error.
If I resort back to my non-replicated database everything works fine.
Any ideas of what is happening here??
