>Has anyone gotten SQL to work with MM?
>Not just your tables & views, but the MM specific tables & views?
>
>I've searched and read every thread on this site, but they seem to only cover 3 topics: How to flip the switch from local to remote, How to make & use connection strings, and how to use remote views. (Some of those threads were good though...especially James' CreateView Program!)
>
>I have already made all my tables & views in SQL, and they seem just fine. What I'm having trouble with is converting the Mere Mortal specific tables and views. For instance, the first thing I noticed was that I couldn't use guids for the IID's. Turns out that there is some foundation-specific code that actually references the IID's as integers. (Whoops--looks like a small oversite in the foundation, IID's shouldn't be actually used FOR anything else)
>
>So then I changed the IID's to integers and made them Identity Fields. So that error is gone. However, the projects still won't start...I seem to get some type of integer-to-character conversion error (Sorry, I know it's a bad description of the problem, but it bombs pretty hard on me)
>
>So has anyone ever made a FULL SQL conversion, including Mere Mortal specific tables? (groups, mmcntrls, mmsctype, mmsecure, states, users, usgrlink). Did you have to do anything special? Is it possible to share what field attributes you used to make it work?
>
>Thanks.
>Dustin
I converted ALL the tables to SQL Server and have been running fine. I do remember I had problems with working with the builders with views and Kevin emailed me a fix. I will be glad to email you any information you need.
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi