OD 13.3 database setup

This forum is for programmers who have questions about the source code.
Post Reply
Bogdan
Posts: 8
Joined: Thu Jun 27, 2013 1:06 pm
Location: Le Chesnay, France
Contact:

OD 13.3 database setup

Post by Bogdan » Thu Jun 27, 2013 1:40 pm

Hi

I have just started to use OD, by compiling the version from trunk. At execution however, the existing database, created with the trial version of OD, cannot be accessed. I have deleted the database and I am wondering what is the easiest procedure to setup a new database for the latest OD version. This might be also useful for custom setups.

Also,it seems to me that OD 13.3 cannot be compiled in Release mode (one Build fails), while Debug mode works.

regards
Bogdan Cristea

jackcraig66
Posts: 12
Joined: Tue Apr 09, 2013 12:24 pm

Re: OD 13.3 database setup

Post by jackcraig66 » Fri Jun 28, 2013 12:17 am

Which build fails?

Bogdan
Posts: 8
Joined: Thu Jun 27, 2013 1:06 pm
Location: Le Chesnay, France
Contact:

Re: OD 13.3 database setup

Post by Bogdan » Fri Jun 28, 2013 12:19 am

OpenDental build fails with the error: error : Mixed mode assembly is built against version 'v1.1.4322' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information.
Bogdan Cristea

jackcraig66
Posts: 12
Joined: Tue Apr 09, 2013 12:24 pm

Re: OD 13.3 database setup

Post by jackcraig66 » Fri Jun 28, 2013 1:05 am

OD 13.3 builds OK in debug and release for me...
...have you seen the information on the Mixed Mode Assembly error here: http://www.opendental.com/manual/sourcecode.html?
You might find this post helpful too: viewtopic.php?f=3&t=3964

Should add that I'm a new OpenDental user too :)

Bogdan
Posts: 8
Joined: Thu Jun 27, 2013 1:06 pm
Location: Le Chesnay, France
Contact:

Re: OD 13.3 database setup

Post by Bogdan » Fri Jun 28, 2013 1:08 am

ok, thanks, how about the database creation ?
Bogdan Cristea

jackcraig66
Posts: 12
Joined: Tue Apr 09, 2013 12:24 pm

Re: OD 13.3 database setup

Post by jackcraig66 » Fri Jun 28, 2013 1:25 am

Did you run the Trial Version and successfully access the demo database before compiling the code and having problems? Might be worth trying that first if not?

After verifying that the Trial Version worked ok with the demo database what I did was:
1. Stopped the MySQL service
2. Copied the demo database and saved as "demoOriginal"
3. Restarted the MySQL service
4. Built the code and ran it - chose the demo database again and saw that it upgraded successfully
If I ever run in to problems and want to start with a fresh database I just copy and rename the demoOriginal database
...but this is not an official OD procedure and you obviously wouldn't do this with live data...it's just something that worked for me!

Bogdan
Posts: 8
Joined: Thu Jun 27, 2013 1:06 pm
Location: Le Chesnay, France
Contact:

Re: OD 13.3 database setup

Post by Bogdan » Fri Jun 28, 2013 2:53 pm

I have been able to backup OD database from MySQL Workbench as an sql dump file. Now I am able to create my own OD database from scratch.

The sources from trunk, v 13.3, still don't compile in Release mode with VS 2010, however everything works fine in VS2012 (not all projects are converted, but OD exe is generated)
Bogdan Cristea

Post Reply