Extend MSDE to Enterprise

I have a system that came with the MSDE database, because of the 2G limit I am trying to point it to the enterprise version of SQL 2000. All connection strings have been changed to the enterprise (With vendor help). The connection is established and acc
ording to a trace from Profiler, all queries are running and inserting the data in the right table. But there is no data in the tables! No errors either.
One of my tests was to point it to another MSDE and it worked fine. What is different between these two versions that will cause data not to be written to the tables.
Thanks
Hi,
Can you insert few records in to the tables manually and see what is
happening. I feel that application is
still pointing towards a different database.
Thanks
Hari
MCDBA
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:4937BB3E-CD2B-4DA1-9C83-2C03E8470989@.microsoft.com...
> I have a system that came with the MSDE database, because of the 2G limit
I am trying to point it to the enterprise version of SQL 2000. All
connection strings have been changed to the enterprise (With vendor help).
The connection is established and according to a trace from Profiler, all
queries are running and inserting the data in the right table. But there is
no data in the tables! No errors either.
> One of my tests was to point it to another MSDE and it worked fine. What
is different between these two versions that will cause data not to be
written to the tables.
> Thanks
|||It is pointing to the right DB because at first I pointed it to a DB that had records and from the front end the viewer showed the Data (but did not insert any) then, I pointed it to an empty DB and the viewer showed empty rows and still wouldn't insert a
ny records. Are there any differences between MSDE and SQL to cause such thing?
Thanks
"Hari Prasad" wrote:

> Hi,
> Can you insert few records in to the tables manually and see what is
> happening. I feel that application is
> still pointing towards a different database.
>
> Thanks
> Hari
> MCDBA
> "Niles" <Niles@.discussions.microsoft.com> wrote in message
> news:4937BB3E-CD2B-4DA1-9C83-2C03E8470989@.microsoft.com...
> I am trying to point it to the enterprise version of SQL 2000. All
> connection strings have been changed to the enterprise (With vendor help).
> The connection is established and according to a trace from Profiler, all
> queries are running and inserting the data in the right table. But there is
> no data in the tables! No errors either.
> is different between these two versions that will cause data not to be
> written to the tables.
>
>