MonoTouch connection strings

Feb 14, 2011 at 10:48 PM
Hello,
I'm trying to connect to a db using MonoTouch, the connections tring is:

Initial Catalog=/Users/chriserickson/Library/Application Support/iPhoneSimulator/4.2/Applications/3AF4674D-23DD-4EF4-B2B3-169062B33E3C/Documents/Library/Caches/db/test/Test/data; Connection Type=File; User=sa; Password=;

I'm getting a useless error:

Can anyone point me in a direction?

Thanks,

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

chris@cartopac.com

(970) 692-5191



Feb 14, 2011 at 11:26 PM

Try samples.

Feb 15, 2011 at 3:21 AM
They don’t work as provided…

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

chris@cartopac.com

(970) 692-5191



From: bogga <notifications@codeplex.com>
Reply-To: "EffiProz@discussions.codeplex.com" <EffiProz@discussions.codeplex.com>
Date: Mon, 14 Feb 2011 19:26:17 -0500
To: Chris Erickson <chris@cartopac.com>
Subject: Re: MonoTouch connection strings [EffiProz:246018]

From: bogga

Try samples.

Feb 15, 2011 at 3:32 AM
I just tried with the simplest of connection strings:

Initial Catalog=Test; Connection Type=File; User=sa; Password=;

Same result….

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

chris@cartopac.com

(970) 692-5191



From: bogga <notifications@codeplex.com>
Reply-To: "EffiProz@discussions.codeplex.com" <EffiProz@discussions.codeplex.com>
Date: Mon, 14 Feb 2011 19:26:17 -0500
To: Chris Erickson <chris@cartopac.com>
Subject: Re: MonoTouch connection strings [EffiProz:246018]

From: bogga

Try samples.

Mar 14, 2011 at 8:10 AM

Are you using Simulator or a real device? Wich Effiproz MT version are you using?

Because on simulator I got to work both 1.2 and 1.5 versions, but on a real device just 1.2 works.... din't contacted EffiGuys yet.

Karl

Mar 15, 2011 at 12:13 AM

Try samples. They work.

Mar 15, 2011 at 3:37 PM
Edited Mar 15, 2011 at 3:42 PM

Samples work fine just on iOS Simulator.

If you create an AppID for the sample, and compiles it to a real device for debug, you get an error on the first efzConnection.Open() found on sample code and it doesn't run. Effiproz MT 1.5 unfortunelly is unusable. If you go back to Effiproz MT 1.2 you can run it but it doesn't save data on files.

Both version run OK on iOS Simulator.

We has developed all the framework with Effiproz due to more flexibility and compatibility with SQL language, but now we move back to Sqlite that is more supported and stable (and maybe quickly - comparing in iOS Simulator, Effiproz took 23 seconds to download 40 tables from SQL Server via a webservice, and Sqlite took 18 seconds).

For now, Effiproz still is a good dream.

And if you have a problem on Mono.Data.Sqlite, you just post a filebug on Bugzilla and their work for find it. On Effiproz if you have a problem inside System.Data.Effiproz or Effiproz.Core, thei charge you 5000 dollars per month, or if they think that you work on a big company/project, they suggest you to contract onsite support charging 5000 dollars per day.............

Karl

Mar 15, 2011 at 11:16 PM

They made it working on iPad after purchasing a support contract. It was quite expensive but worth it.

Mar 18, 2011 at 10:47 PM
For what it's worth,

I tried contacting them about monotouch support in person, and they wouldn't answer the phone. I wasn't (and still am not) convinced that they're not a front. They tried to pitch the $5k/month support contract, and I laughed because I couldn't believe they wanted me to pay that much before they could even demonstrate that it worked.

I found that SQLite was several thousand times faster on my desktop than effiproz, so at this point we abandoned them completely as a fraud.

I wonder at your definition of 'worth it'…

From: Entrocolla <notifications@codeplex.com>
Reply-To: "EffiProz@discussions.codeplex.com" <EffiProz@discussions.codeplex.com>
Date: Tue, 15 Mar 2011 19:16:08 -0400
To: Chris Erickson <chris@cartopac.com>
Subject: Re: MonoTouch connection strings [EffiProz:246018]

From: Entrocolla

They made it working on iPad after purchasing a support contract. It was quite expensive but worth it.

Mar 19, 2011 at 1:16 PM

They offered to us this $5k/month support to make Effiproz to run on device too, and when I explained a bit more of the dimension of the project, they offered an onsite plan of $5k/DAY for 3 to 5 days...........

On iOS simulator (since do not run on device for comparation) Sqlite was more faster than Effiproz to load 40 tables from Server...but no more comparations was made in the time of test and decision to wich database to use.