StrataFrame Forum / Enterprise Server / How do I?

CAL's is this concurrent users or ??

David Kozikowski — Thu, 28 Jan 2010 10:22:07 GMT

How is this licensed?
I’m evaluating if this is a option for a system.
Still looking and trying to understand the architecture of both the framework and the ES.

Let’s says I have 2000 users of a system however the data transfer is minimal.
If I was building a application that had both a web UI (internet / intranet) and a WinForm UI (network down usability, then sync when network up , local database on client machines) would I need a CAL for each user or could the system be designed to only allow 25 connections at a time? (thus the cheaper license)?

Thanks

SQLBulkCopy and ES

Marcel Heitlager — Sat, 24 Oct 2009 02:53:49 GMT

Can SQLBulkCopy be implemented with ES? Something tells me I can't because of a connection string issue. But if it is possible, how?

I'm looking for a way to speed up bulk insert in a table in server database (2000 + records)

Thanks as always,

Marcel

ES down after IP change

Keith Chisarik — Mon, 12 Oct 2009 14:47:59 GMT

I cannot connect, the test site simply says "Access Denied". We had to change the IP address of the ES, MAC is the same, name is the same. Please help.

Method fillbyparentprimarykey with composite index

Felix M Avendano — Mon, 31 Aug 2009 15:31:21 GMT

I´m using a Combobox and the fill table has a compound index related with a parent table.

Im using exactly that in my combos but as the fill method I use a custom one instead of one that came with the framework because I have a compound index and as I see the methods don´t take care of the business rules (i've put the relationship with the parent on the child BO) nor the PK's on the tables (or may be yes but I don't know how).

So, can I use fillby... or another standard method if I had to pass a compound index?

Messaging editor questions

dgsoft — Tue, 21 Jul 2009 04:57:35 GMT

Hi,
I have a lot of questions about messaging editor.. but one is main.
1) I prepare TPE file, and my clients translate TPE file on German Language. Now I need to import it and I am doing
- Start Localization and Messaging Editor
- Open Project
- Click Translations - > Import Translation Package...
- New Dialog appears - I select TPE file click "FINISH"
- I'v got Successfully Imported! and Import Result: Success.. but Keys Imported: 0 !!!
The same happens if I.. - have all keys for German language, If I remove keys from German language, if I delete German language from configuration..
Import Translation package not works for me. - What do I wrong?

2) How to make Multiselect and delete more then one TextValue? How can I delete all text values for selected language?

Thanks for help!
Denis

ConnectionString error

Marcel Heitlager — Tue, 07 Jul 2009 22:03:07 GMT

Hi guys,

When I call the function below, I get a "Format of the initialization string does not conform to specification starting at index 0." error at the line where I set the connection string. I'm trying to clear the SQL Server Tables on the server through ES. Since it works on a local database, what do I need to change so it will play nice with ES? Thanks.

Public Function ClearPPMTables(ByVal dbName As String) As Boolean

Using conn As New SqlConnection

conn.ConnectionString = MicroFour.StrataFrame.Data.DataLayer.DataSources(me.DataSourceKey).ConnectionString
conn.Open()

Using cmd As New SqlCommand
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "dbo.sp_ClearTables"
cmd.Parameters.Add("@dbname", SqlDbType.NVarChar, 128)
cmd.Parameters("@dbname").Value = dbName.Trim
cmd.Connection = conn
Me.ExecuteNonQuery(cmd)

End Using
End Using
End Function

Using ES to sync tables

Marcel Heitlager — Mon, 15 Jun 2009 12:32:52 GMT

We have an older application using VFP tables. We have a website that's been migrated from VFP tables to SQL Server. Before when we pushed/pulled data we would just Secure FTP it the local drive and then import it into app.

The tables have anywhere from 400-30,000 records, about 20 fields. We we're thinking of using ES to handle the transfer, over a fast connection. It involves clearing the server tables, and then creaing new records in BO with VFP data, and when done, save all the records to server. With the given scenario would that be something within the capabilities of ES?

Also, to add one more variable to the mix, the SQL Server tables are more normalized than the VFP tables. So new keys have to be generated for the SQL server tables, and there are some parent child relationships. In this case would it be better to just use GUID's for those fields (I've read up on them in the forum already), so that it will avoid a round trip to the server to get the AutoIncrement values, or would AutoInc's not be much of an issue because of the size of the tables? We're trying to minimize the length of time this takes so it can be completed within about 15 minutes (at the most no more than 30, but quicker is better;) )

Thanks,

Marcel

P.S. - Is it common practice to use GUID's as ForeignKeys or do they usually only use GUID's for the parent tables and all child tables contain INT keys? INT's might cause issues for me, so that's why I'm asking.

Error messages localization keys?

dgsoft — Wed, 10 Jun 2009 09:39:13 GMT

Hi,
I develop a web application and evaluate StrataFrame security dialogs for my web application.
For example.. when I want to change a password.. and my new password value brake a business rules I'v got an excelption on

Here little code block
[code]
loSFSUserBO.us_PasswordPlainText = lcNewPassword
loSFSUserBO.us_ConfirmPassword = lcNewPassword
Try
If loSFSUserBO.Save() = MicroFour.StrataFrame.Data.SaveUndoResult.Success Then
Response.Redirect("~/PenSolutionOffice.aspx")
Else
Me.mmks_ShowNotification(Error_ChangePassword)
End If
Catch ex As Exception
Me.mmks_ShowNotification(ex.InnerException.Message)
End Try

[/code]

So.. I'v got a Catch block... and ex.InnerException.Message = The specified key [SFST_PasswordComplexityRequirements] was not found within the localization database.

I understand - the broken rule password is simple.. but where can I get SFST_PasswordComplexityRequirements ? Should I create in my localization XML ? but there a lot of diffrent SFST_ keys when diffrent rules are broken.

So, the question is - how can I get a valid error message instead SFST_PasswordComplexityRequirements...

Thanks!
Denis

Move ES server to a new box?

Greg McGuffey — Sun, 24 May 2009 10:16:56 GMT

We recently had a server fail and this is resulting in the need to move ES server to a new box. This would mean that it would have the same machine name, the same IP, same host name but new MAC addresses. How do I go about handling the license change for this? I have a MAC address of the new machine.

ES update procedure

Keith Chisarik — Tue, 17 Mar 2009 08:34:18 GMT

Can you please outline the procedure to update. I have ES set up, clients using it daily, I set it up months ago and havent much thought of it since. Thanks. I am going from 1.6.5 to 1.6.7 on the production server that hosts ES and 4 SF web applications. I have to recompile all the BO libraries at the same time as well for these projects that are currently in production (ouch).?

Server:

Do I just unzip the contents to the ES site directory and restart the app pool?

Client:

On the client do I just need to make sure Microfour Stratafrma Enterprise Client gets updated?

*******************************************************************************

Changed enterprise server to account for UTC time when passing parameters to commands.
This is a breaking change. The server and client must both be upgraded or this change will break communication between the ES and the clients.
Before this change, the ES would not consider UTC time when passing parameters on commands, but would use UTC to return the results of a query back to the client (through .NET's serialization of the data table). Now, UTC is taken into account when passing parameters.
If the CustomDataSerializer is used, UTC is not considered when passing parameters or when returning results back to the client.

Server Times Out

Marcel Heitlager — Fri, 06 Mar 2009 02:45:14 GMT

When trying to connect to ES it times out. Also when I check status.aspx it says no clients have connected to this server. It is in a directory that requires SSL connection.

The test form does a simple query:

[codesnippet]

'-- Build the Query
loSQLCmd.CommandText = "SELECT * FROM pws_Statements"

'-- Fill the business object using the command
me.FillDataTable(loSQLCmd)

[/codesnippet]

The connection is as follows:

[codesnippet]

Dim ds As New EnterpriseDataSourceItem("", _
"www.aeswebaccess.com/aes/es", 443, "myKey", _
New SqlDataSourceItem(""))

'-- Configure the compression and encryption (optional)
ds.IsCompressed = True
ds.IsEncrypted = False
ds.EncryptionKey = New Byte() {1, 2, 3, 4, 5, 6, 7, 8, 9, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 0, 1, 2, 3, 4}
ds.EncryptionVector = New Byte() {1, 2, 3, 4, 5, 6, 7, 8}

'-- Add the EnterpriseDataSourceItem
DataLayer.DataSources.Add(ds)

[/codesnippet]

I turned encryption off for testing. "myKey" matches the key that status.aspx shows. So does the host address. The virtual directory is matches the physical path. Trying ports 80 and 8080 gives me an error, because it requires 443.

When I click submit it seems to send the query. Then my harddrive gets busy for a while and finally within about a minute it times out. (timeout is set at default)

I do have another oleDB connection that is on local drive to visual foxpro database that is handled through connection manager and has its own DataSourceKey.

Any thoughts on what I'm missing? Could this be a problem with the connection string to the database? I made sure I have read/write permissions through NT AUTHORITY/Network account. The connection string is:

[codesnippet]

<ConnectionString>server=MyServer\SQLEXPRESS;integrated security=SSPI;database=test_database</ConnectionString>

[/codesnippet]

OK that's all I got! I'll shut up and listen now.:P

ES licensing Question Again

Marcel Heitlager — Sun, 15 Feb 2009 01:36:54 GMT

Just so I get this...(apparently I'm very slow),

If I want to set up a smart client application where I have, let's say, 30 clients accessing SQL Server 2005 on our machine (I know I need 30 licenses).

Does that mean, though, getting your ES license packs as well as the User CALs from Microsoft (60 licenses)? Thus about $150 per license from them and about $25 per license from you?

And I guess the ES license has to be renewed every year but the User CALs don't?

Thanks

How to modify Source for UI

Mike Rogers — Mon, 01 Dec 2008 12:08:21 GMT

I finally moved over to Visual Studio 2008. I installed the StrataFrame 1.6.6 and Source code and the new devexpress 8.3. I then ran the Devexpress tool to update the StrataFrame Source code to 8.3. I then ran the AfterBuild.bat.

Am I missing a step? When I go and create an new project it is looking for DevExpress 7.3 when I check the references in the project.

Please help!!!!

Enterprise Server Host Name

Chris Diesel — Tue, 18 Nov 2008 09:52:32 GMT

I'm having a hard time testing our project using ES. I created and installed a SDK CAL with the server name srv09. I access the status page via: http://srv09/strataframees/status.aspx. Should I have activated the licenses using srv09/strataframees instead? I keep getting a message: "The remote server returned an error: (500) Internal Server Error." when I try to run in developer mode on srv09.

How do you tell if ES is running?

Greg McGuffey — Wed, 04 Apr 2007 18:34:50 GMT

I've got ES installed (I think). I have the data sources set. Web.config is set. I've restarted IIS. How do I tell if the derned thing is working? I tried updating my client to use it, but it says that is can't find the server. I'm thinking I need to see if it is running first. Do I have to turn it on (I wouldn't think so...but...)?

how to run the sample

Jerry Yang — Tue, 07 Oct 2008 18:20:43 GMT

I'm a VFP programmer for decades, no experience with SQLServer, I want to switch to VB.NET.

I have installed Visual Studio 2008, SQLServer 2008, Strataframe and StrataFlix sample.

I tried to run the StrataFlix sample, but I have no idea how to:

* Included in the extracted archive are two SQL Server files, StrataFlix.mdf and StrataFlix_Log.ldf. Use SQL Server Management Studio to attach the StrataFlix.mdf file to the SQL Server of your choice.
* Open the desired language source in Visual Studio.

can someone give me a simple guidance...

thanks in advanced.

regards,

Jerry

Enterprise Server in OLTP environments, high loads

Emre Ozer — Thu, 17 Apr 2008 02:28:00 GMT

Hi,

Can anyone share their experiences with Enterprise Server in OLTP environments?

How does ES behave under high loads, heavy use of transactions?

Does ES forward transactions accurately with hardware NLBs?

Thanks already for any feedback.

Regards,

Emre

Any ideas on cause of this error?

Greg McGuffey — Fri, 11 Jan 2008 10:04:41 GMT

I have a user that is intermittently getting this error. The error occurs when doing various tasks. I'm pretty sure there is a problem with his machine or connection (though others within the same network are not having this problem). I just have no idea what could be causing it... :blush: Any help would be appreciated.

Here is the exception:
[quote]IOException
Unable to write data to the transport connection: An established connection was aborted by the software in your host machine.
SocketException
An established connection was aborted by the software in your host machine

Source : System

Stack Trace:
at System.Net.Sockets.Socket.Send(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.PooledStream.Write(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.ConnectStream.InternalWrite(Boolean async, Byte[] buffer, Int32 offset, Int32 size, AsyncCallback callback, Object state)
at System.Net.ConnectStream.Write(Byte[] buffer, Int32 offset, Int32 size)
at MicroFour.StrataFrame.Data.Enterprise.EnterpriseDataSourceItem.SendRequestCore(BaseParams Params, RemoteDataSourceCommand Command)
at MicroFour.StrataFrame.Data.Enterprise.EnterpriseDataSourceItem.b(DbCommand A_0, Boolean A_1, String A_2)
at MicroFour.StrataFrame.Data.Enterprise.EnterpriseDataSourceItem.ExecuteScalar(DbCommand Command)
at MicroFour.StrataFrame.Business.BusinessLayer.ExecuteScalar(DbCommand CommandToExecute)

[gpm] from here up is common in all cases...the lines below depend on what he was trying to do...

at FOXSystems.RAMS.BusinessObjects.Project.AlternateOutlineBO.GetProjectIDByID(Int32 altOutlineID)
at FOXSystems.RAMS.Shared.DataTreeProviders.AlternateOutlineProvider.set_AlternateOutlineID(Int32 value)
at FOXSystems.RAMS.Testing.TestFunctionForm..ctor(Int32 projectID)
...etc.[/quote]

How to ensure that install uses the latest .net redistributable

Greg McGuffey — Thu, 13 Dec 2007 09:52:12 GMT

I'm fighting a proxy issue and in investigating that, I realized that the .net framework I'm distributing with the app isn't even close to being the same I'm developing against. Searched the web to attempt to get the latest and that was...er...more confusing.

-My ClickOnce install is using 2.0.50727.42, from september 23, 2005 (build off the machine with a much newer version).
-The redistributable on the web is dated 1/22/2006 ([url]http://www.microsoft.com/downloads/details.aspx?FamilyID=0856EACB-4362-4B0D-8EDD-AAB15C5E04F5&displaylang=en[/url])
-The dlls on my machine are 2.0.50727.832, dated april 13 2007, I'm assuming updated with VS sp1.

Anyone have any ideas about this?

How does ES handle proxy servers?

Greg McGuffey — Wed, 07 Nov 2007 18:53:58 GMT

What happens, if the user of an application that is using ES, has a proxy server between them and the ES server? How is this handled?

I have a user who can't connect and thought (give his situation) this would be the first thing to look into.

Question on ES Server machine configuration

Stephen M. Klump — Tue, 02 Oct 2007 07:50:28 GMT

We are recommending the purchase of Enterprise Server (2 licenses) to one of our customers for use with their StrataFrame-based .Net application.

Our question pertains to hardware resources required for the Enterprise Server box.

This customer typically has about 200 concurrent connections for the application at any given time.

I understand that Micro4 supports thousands of connections with Enterprise Server for their own customers, so I would think you would have some good metrics on machine resources required.

I would like to get on a phone call with a technical rep. to discuss this. Could you please give me a phone number to call and a time so that I can discuss this with you?

Thank you.

Steve

Does ES support DB2?

Keith Chisarik — Tue, 25 Sep 2007 22:55:53 GMT

I have a new project that will need to run at my clients multiple office locations, currently they use thin clients via a VPN, but I don't think I want to rely on it. Will ES work here for a Winform application using DB2 on OS/400 on the backend?

Thanks.

Some questions that relate to ES

Ben Hayat — Thu, 24 May 2007 19:00:49 GMT

After the training class, I met with a client and told him about the ES in more detail and we have decided to split the project into two sections: a) WinForm b) WebForm.

a) The winform is responsible to allow the employees in different cities to create new records. These employees will be connected to the main Database via ES. The employee will be entering text data and taking images of objects and maybe, small videos per record.

b) The Webform is responsible to show those data and pictures and videos from the server to public who serf the web via bowser.

Questions:
a) Since the images are ultimately going to be consumed by webserver, should each image be stored as a single file or should it be stored in database as BLOB field?
a1) If stored as BLOB field, at the time of showing it on the web, does it need to be converted into a single image file for Webserver to use it?
a2) If the images is stored as single file to begin with, will ES stream the image from the client to the server and store it for me?

b) The second part is, if the user with Winform, records a video clip, can the video clip get transfered to the server via ES?

I guess my main question here is, can ES provide service to get images and videos from client to the server with WinForm?

Once you answer, then I'll follow a few more questions depending on the answer.
Thanks!

References to ES

Greg McGuffey — Wed, 04 Apr 2007 18:17:07 GMT

My app is broken into several assemblies. I'm sure I need to set a reference to the Enterprise (ES) namespace in my main EXE (were AppMain is and were the ES data source will be set). I'm pretty sure I'll need to set it in the assembly that contains my BOs. Any were else?

Clarification of which MAC address, and about domain for ES 2 CAL SDK license

Greg McGuffey — Wed, 04 Apr 2007 14:54:49 GMT

I'm about to install ES and give it a try. I'm hopeful this will solve a lot of issues. However, I have some questions! :hehe:

1. The MAC address is for which nic specifically. I.e. The computer I'm going to use it on has two nics and it sits behind a firewall, so there is also the firewall nic that the rest of the world interacts with. Which one?

2. So, the domain required is just the domain right (or the computer name or an IP), not the full path to were ES is installed, right? I.e. I install it at www.myapp.com/tools/es, then the domain I need is www.myapp.com, right?

3. I might have to install ES to a temporary server, then move it to another one (dedicated just to my app). How big of a pain is it going to be to invalidate the old license file and get a new license file? (I'm trying to just get the decidated machine now, but...)

Thanks!

ES Documentation

Larry Caylor — Tue, 13 Mar 2007 13:02:41 GMT

Looking at the SF help file, I find that it doesn’t really contain any information installing ES or configuring an application to use it. I’ve got as far as installing the ES server on at test machine and activating a development license. However when I go to download the license file, I receive an error (see attached). Is there some more detailed documentation of ES?

-Larry

How can I evaluate ES?

Greg McGuffey — Mon, 12 Mar 2007 13:17:14 GMT

I'm thinking that ES will solve a bunch of problems I'm facing. Many of them are related to the use of a VPN to access the database over all sorts of interesting (read slow and unreliable) connections.

However, before I recommend this to the execs, I need to actually test it. I need to install it and access it remotely and compare the access times to those of using the VPN.

I know the SDK is included with SF, but I'm not clear how to test it.

- Can I do initial testing all locally as it stands now (i.e. single user testing locally, just to see if the code works)
- Do you have a special trial license available?

Thanks!

Synchronization from remote client

Larry Tucker — Wed, 21 Feb 2007 06:19:21 GMT

ES apparently allows a remote client to access data via HTTP, then run disconnected from the central database. So, I assume a salesperson could pull down a customer list on his or her laptop and work on it without further internet connection.

My question is what kind of support does ES offer for synchronizing any changes made to the data once an internet connection is re-established?

For example, if the salesperson changes a customer's phone number while working disconnected, how does this new phone number get applied to the main database when the salesperson reconnects to the internet?

Are the synchronization tools built in to ES, or would I have to write it all by hand? At reconnection, is there an opportunity to open both the local and the central (ES) tables simultaneously and do the needed comparison and updates?

TIA,

Larry