Microsoft Desktop Engine
-
Hello , I just finished developing a program using Microsoft Desktop Engine with C# as the front end. Everything is okay on my system. But, on trying to deploy it on a different system it gives an error message that it can open the database. This is my first time in using the Microsoft Desktop engine. All this while I have been using Access as my database engine and normally what I do after developing a program is to transfer the Database file in Access after installation to the client’s system and everything will be okay. But with the Desktop Engine what I did was to 1) Install it on the client computer 2) Transfer the Database file to the client’s system. On running it was giving me message that it can’t open it. I would be glad if anybody can show me how Microsoft Desktop Engine is deployed together with a program developed using it as the database engine. Thanks in anticipation.
-
Hello , I just finished developing a program using Microsoft Desktop Engine with C# as the front end. Everything is okay on my system. But, on trying to deploy it on a different system it gives an error message that it can open the database. This is my first time in using the Microsoft Desktop engine. All this while I have been using Access as my database engine and normally what I do after developing a program is to transfer the Database file in Access after installation to the client’s system and everything will be okay. But with the Desktop Engine what I did was to 1) Install it on the client computer 2) Transfer the Database file to the client’s system. On running it was giving me message that it can’t open it. I would be glad if anybody can show me how Microsoft Desktop Engine is deployed together with a program developed using it as the database engine. Thanks in anticipation.
I don't think you can just up and transfer the database file. Try doing this instead: osql -U[username] -P[upass] -S[database] -Q "BACKUP DATABASE [database] to DISK='c:\blah.backup'" Move blah.backup to the new system, then run the same command with statement "RESTORE DATABASE [database] from DISK='c:\blah.backup'" This should move the data + schema. You'll probably want to run it as sa, so a sample command is: osql -Usa -Ppassword -SCOMPNAME\DBNAME -Q "BACKUP test01 TO DISK='C:\backup'" HTH -earl-
-
Hello , I just finished developing a program using Microsoft Desktop Engine with C# as the front end. Everything is okay on my system. But, on trying to deploy it on a different system it gives an error message that it can open the database. This is my first time in using the Microsoft Desktop engine. All this while I have been using Access as my database engine and normally what I do after developing a program is to transfer the Database file in Access after installation to the client’s system and everything will be okay. But with the Desktop Engine what I did was to 1) Install it on the client computer 2) Transfer the Database file to the client’s system. On running it was giving me message that it can’t open it. I would be glad if anybody can show me how Microsoft Desktop Engine is deployed together with a program developed using it as the database engine. Thanks in anticipation.
I'm guessing the user/login you're using on the production system lacks the access you have on your development system. Check user priviledges in the production database.
-
Hello , I just finished developing a program using Microsoft Desktop Engine with C# as the front end. Everything is okay on my system. But, on trying to deploy it on a different system it gives an error message that it can open the database. This is my first time in using the Microsoft Desktop engine. All this while I have been using Access as my database engine and normally what I do after developing a program is to transfer the Database file in Access after installation to the client’s system and everything will be okay. But with the Desktop Engine what I did was to 1) Install it on the client computer 2) Transfer the Database file to the client’s system. On running it was giving me message that it can’t open it. I would be glad if anybody can show me how Microsoft Desktop Engine is deployed together with a program developed using it as the database engine. Thanks in anticipation.