Maybe was not really dropped last time. Check with a database manager. Maybe some commit?
Luck!


________________________________
From: mathewabraham68007 <mathewabraham68007@...>
To: firebird-support@yahoogroups.com
Sent: Saturday, September 8, 2012 4:27 AM
Subject: [firebird-support] Crystal Report loading pblm from client ODBC



 

i am developing a vb.net application with Firebird(Superserver)along with crystal report.
Application works on multiple computers connected in LAN.

One computer will be server, means the database will be in this computer only ( say its computer name as SERVER).

Rest of the computers will be working as clients. But they will be able to select, insert, update, delete , view crystal report..etc.. like everything. The only difference is that the database is only in SERVER.

The problem is with crytal reporting.. I installed Firebird ODBC, designed report and implemented.

Note: I am using VIEW inf firebird for reporting.
Each time Report is run the view is altered ( i.e DROPPED and CREATED again)

I gave DSN name and all in ODBC.. In database field in ODBC I gave like following in different computers..

1) In Server computer(SERVER) I gave the path as D:\App\Database.FDB
2) In client computer i gave the path as SERVER:D:\App\Database.FDB

When i run a report using view in Server it runs ok..
But when i run the same in client it runs ok for the first time.. when i run for the second time the firebird says
" unsuccessful metadata update Object View is already in use"
this error is coming when trying to drop that view..

I tried to add computername in front of the connection string in ODBC of SERVER computer..i.e
(SERVER:D:\App\Database.FDB)
then this problem shows in server also..

Kindly help me..
If any further information is needed i will send.




[Non-text portions of this message have been removed]