StrataFrame Forum

The remote server returned an error: (500) Internal Server Error.

http://forum.strataframe.net/Topic25564.aspx

By Jeff Pagley - 1/16/2010

Hi SF Team,

I know it is Saturday, but I am trying to setup Enterprise Server to test.  I have taken the time to read several posts on the forum to resolve this error, but to no avail and I am lost.  One thing is I can successfully load the test website's default.htm page to make sure the site is up and running.  One of the posts suggest to test to see if ES is running by trying to access the status.aspx page.   I attempted to do this and I get this Server Error page:

 

Server Error in '/ES' Application.

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'InstantASP.Common' or one of its dependencies. The system cannot find the file specified. (C:\Inetpub\wwwroot\web.config line 80)

Source Error: 

Line 78: <httpModules> Line 79: <!-- HttpModule used to manage user authentication -->Line 80: <add type="InstantASP.Common.HttpModule.SecurityModule, InstantASP.Common" name="SecurityModule"/>Line 81: <!-- HttpModule used to perform dynamic URL rewriting -->Line 82: <add type="InstantASP.Common.HttpModule.RewriterModule, InstantASP.Common" name="RewriterModule"/>

Source File: C:\Inetpub\wwwroot\web.config    Line: 80

Version Information: Microsoft .NET Framework Version:2.0.50727.1873; ASP.NET Version:2.0.50727.1433

Before I go into anymore detail, I figure I need to make sure I can successfully load this page before anything else will start to work. What is the problem?

Thanks,

Jeff

By Jeff Pagley - 1/18/2010

Hi SF Team,

Any status on getting help with my error?

Thanks,

Jeff

By Dustin Taylor - 1/19/2010

Hey Jeff,

Sorry for the delay on this. That error looks to be related to loading components of an InstantASP product, not enterprise server. We don't use any InstantASP binaries or the like within Enterprise Server, so that particular error message is happening outside of the ES itself.

A couple quick questions just to get a lay of the land:

1) Did you use the .exe to install ES or the compressed .zip manuall install?

2) Did you load it on a server OS or a workstation OS?

3) Do you have any other sites running? That error looks like it is coming from a web.config created or modified to use with a web forum, FAQ, or the like.

Thanks!

Dustin

By Jeff Pagley - 1/19/2010

1) Did you use the .exe to install ES or the compressed .zip manuall install?

I used the compressed .zip manual install.

2) Did you load it on a server OS or a workstation OS?

I used an old Windows 2000 Terminal Server running IIS with a our forum running on it.

3) Do you have any other sites running? That error looks like it is coming from a web.config created or modified to use with a web forum, FAQ, or the like.

I thought the web.config supplied with ES is the one ES is using and not the web forum's web.config...right? I don't have any other sites running, but I do have an WindowXP machine I can install IIS on if this will work for testing purposes.

If I need to change machines then I will need my ES licenses reset.  Also, when I enter the URL for the license info, do I enter the www.mysite.com OR www.mysite.com/es (includes the virtual directory name)?

Thanks,

Jeff

By Dustin Taylor - 1/19/2010

The address you go to depends on how you configure ES, most likely the /es subdomain.

Can you post the full Web.config for me?  I just downloaded the web.config from the strataframe site, and below is the unconfigured file, with no mention of InstanASP. Sounds like they got mixed up somehow on your server.

Also, would loading from the .exe be an option? That might help everything get lined up without issue.

Here is my unconfigured, unaltered web.config file:

<?xml version="1.0"?>

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

<appSettings>

<add key="StatusIpAddresses" value="127.0.0.1" />

<add key="OtherEsServers" value="" />

<add key="SmtpFromAddress" value="es@domain.com" />

<add key="SmtpToAddresses" value="admin@mydomain.com;admin2@mydomain.com" />

<add key="SmtpServer" value="127.0.0.1" />

<add key="SmtpPort" value="25" />

<add key="SmtpAuth" value="False" />

<add key="SmtpUsername" value="user" />

<add key="SmtpPassword" value="password" />

<add key="UseCustomDataSerializer" value="False" />

</appSettings>

<system.web>

<!--

Set compilation debug="true" to insert debugging

symbols into the compiled page. Because this

affects performance, set this value to true only

during development.

Visual Basic options:

Set strict="true" to disallow all data type conversions

where data loss can occur.

Set explicit="true" to force declaration of all variables.

-->

<compilation debug="true" strict="false" explicit="true" />

<pages>

<namespaces>

<clear />

<add namespace="System" />

<add namespace="System.Collections" />

<add namespace="System.Collections.Specialized" />

<add namespace="System.Configuration" />

<add namespace="System.Text" />

<add namespace="System.Text.RegularExpressions" />

<add namespace="System.Web" />

<add namespace="System.Web.Caching" />

<add namespace="System.Web.SessionState" />

<add namespace="System.Web.Security" />

<add namespace="System.Web.Profile" />

<add namespace="System.Web.UI" />

<add namespace="System.Web.UI.WebControls" />

<add namespace="System.Web.UI.WebControls.WebParts" />

<add namespace="System.Web.UI.HtmlControls" />

</namespaces>

</pages>

<!--

The <authentication> section enables configuration

of the security authentication mode used by

ASP.NET to identify an incoming user.

-->

<authentication mode="Windows" />

<!--

The <customErrors> section enables configuration

of what to do if/when an unhandled error occurs

during the execution of a request. Specifically,

it enables developers to configure html error pages

to be displayed in place of a error stack trace.

-->

<customErrors mode="Off" defaultRedirect="GenericErrorPage.htm">

<error statusCode="403" redirect="NoAccess.htm" />

<error statusCode="404" redirect="FileNotFound.htm" />

</customErrors>

</system.web>

</configuration>
By Jeff Pagley - 1/20/2010

Hi Dustin,

The server we were going to use for testing is hosting our forum.  Since we are having a few problems with ES running on this server, I prefer to move ES to other another server we have decided to retired which is running Windows 2003 Server.  This way if something goes wrong with the setup and testing it would not effect one of our production server (i.e. our Forum).  Hopefully making this change will enable everything to go smoothly for setting up and testing ES since it is a Windows 2003 Server without an InstantASP product installed on it.

One thing I do need is for you to reset my license so I can assign the new MAC address to the licenses.

My goal is to get ES up and running in the next couple of days so we can start our testing as soon as possible.

Thank you for your help.

Jeff 

By Dustin Taylor - 1/20/2010

Ok, I've reset the license, so you should be free to move it to your new machine at your convenience.

Thanks!

Dustin

By Jeff Pagley - 1/20/2010

Hi Dustin,

I have setup ES on the Windows 2003 Server using the zip file.  I activated the license file and I have placed it in the \bin directory.

The status.aspx loaded successfully. 

Then I installed Windows 2003 Server Service Pack 2,  SQL Server Express 2005 and Express Management Studio. 

After those installations, I am now getting this error when I attempt to load the status.aspx page:

Server Error in '/ES' Application.

The type [MicroFour.StrataFrame.Data.SqlDataSourceItem, MicroFour StrataFrame Base, Version=1.6.0.0, Culture=neutral, PublicKeyToken=99fe9917f71608a7] could not be resolved.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.TypeLoadException: The type [MicroFour.StrataFrame.Data.SqlDataSourceItem, MicroFour StrataFrame Base, Version=1.6.0.0, Culture=neutral, PublicKeyToken=99fe9917f71608a7] could not be resolved.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace: 

[TypeLoadException: The type [MicroFour.StrataFrame.Data.SqlDataSourceItem, MicroFour StrataFrame Base, Version=1.6.0.0, Culture=neutral, PublicKeyToken=99fe9917f71608a7] could not be resolved.]   MicroFour.StrataFrame.Enterprise.Server.RemoteDataSource..cctor() +1017[TypeInitializationException: The type initializer for 'MicroFour.StrataFrame.Enterprise.Server.RemoteDataSource' threw an exception.]   MicroFour.StrataFrame.Enterprise.Server.Status.Status_PreInit(Object sender, EventArgs e) +48   System.Web.UI.Page.OnPreInit(EventArgs e) +2009852   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +521

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

By Edhy Rijo - 1/20/2010

Hi Jeff,



I have no experience with ES but based on the error message, the SF classes may not be updated, make sure you have the latest version 1.7.x
By Keith Chisarik - 1/20/2010

I believe the following has to be changed in your datasources.config

<TypeAssemblyVersion>1.6.0.0</TypeAssemblyVersion>

change it to 1.7.0.0

By Jeff Pagley - 1/21/2010

Hi Keith,

I believe the following has to be changed in your datasources.config

<TypeAssemblyVersion>1.6.0.0</TypeAssemblyVersion>

change it to 1.7.0.0

I did try to do this, but I was getting another error.  So I restored a fresh copy of the datasources.config, made the change, stop/started IIS and it worked!  Now that I can load the Status page successfully.  I will attempt to connect my application to it.

Thanks,

Jeff

By Keith Chisarik - 1/21/2010

Glad to hear, as long as your remotedatasourcekey param of the EnterpriseDataSourceItem matches what is in your DataSources.config you should be golden.

Just for fun here is my production datasources.config and the appmain code that connects to it:

<DataSources>
 <DataSource DataSourceKey="ILA">
  <ConnectionString>server=DS63293-1;User ID=xxxx;Password=xxxx;Database=ILAMembership;</ConnectionString>
  <TypeFullName>MicroFour.StrataFrame.Data.SqlDataSourceItem</TypeFullName>
  <TypeAssemblyName>MicroFour StrataFrame Base</TypeAssemblyName>
  <TypeAssemblyVersion>1.7.0.0</TypeAssemblyVersion>
  <TypeAssemblyCulture>neutral</TypeAssemblyCulture>
  <TypeAssemblyPublicToken>99fe9917f71608a7</TypeAssemblyPublicToken>
  <IsEncrypted>True</IsEncrypted>
  <IsCompressed>True</IsCompressed>
  <EncryptionKey>1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4</EncryptionKey>
  <EncryptionVector>1,2,3,4,5,6,7,8</EncryptionVector>
  <TransactionTimeout>3600</TransactionTimeout>
 </DataSource>
 <DataSource DataSourceKey="DASEF">
  <ConnectionString>server=DS63293-1;User ID=xxxxxx;Password=xxxxx;Database=DASEF;</ConnectionString>
  <TypeFullName>MicroFour.StrataFrame.Data.SqlDataSourceItem</TypeFullName>
  <TypeAssemblyName>MicroFour StrataFrame Base</TypeAssemblyName>
  <TypeAssemblyVersion>1.7.0.0</TypeAssemblyVersion>
  <TypeAssemblyCulture>neutral</TypeAssemblyCulture>
  <TypeAssemblyPublicToken>99fe9917f71608a7</TypeAssemblyPublicToken>
  <IsEncrypted>True</IsEncrypted>
  <IsCompressed>True</IsCompressed>
  <EncryptionKey>1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4</EncryptionKey>
  <EncryptionVector>1,2,3,4,5,6,7,8</EncryptionVector>
  <TransactionTimeout>3600</TransactionTimeout>
 </DataSource>
</DataSources>

Private Shared Sub SetDataSources()

' Assume want to use the enterprise server - unless the file C:\disablees.txt exists - if that files exist - then

' use the local connnection string via the connection manager

'

'enable flag file for debug mode (with warning)

If System.IO.File.Exists("C:\EnableDataSourceLog.txt") Then

MicroFour.StrataFrame.Data.DataBasics.DataSources("").SetDebugOn("C:\WINDOWS\Temp\DASEFSQLLog_.html", True)

MessageForm.ShowMessageByKey("genericMessage", "DataSource Debug Mode is ON")

End If

If System.IO.File.Exists("C:\DisableES.txt") Then

ConnectionManager.ApplicationKey = "DASEF"

ConnectionManager.ApplicationDefaultTitle = "DASEF Data Connection"

ConnectionManager.ApplicationDefaultDescription = "This application connection is used by DASEF"

'-- Set the required data source information so that the ConnectionManager can gather it

' SQL Connection

ConnectionManager.AddRequiredDataSourceItem("", "SQL Connection", _

DataSourceTypeOptions.SqlServer, "DASEF", "This connection is used by DASEF.")

'-- Make the call to SetConnections which will gather the connection information, show the connection wizard

' if needed and set the DataSources collection on the DataLayer class.

ConnectionManager.SetConnections()

Else

'-- Create the ES data source

Dim ds As New EnterpriseDataSourceItem("", "es.sigmadatainc.com", 80, "DASEF", New SqlDataSourceItem(""))

'use the enterprise server

'-- Configure the compression and encryption (optional)

ds.IsCompressed = True

ds.IsEncrypted = True

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}

'simple error display for testing

Try

'-- Add the EnterpriseDataSourceItem

DataLayer.DataSources.Add(ds)

Catch ex As Exception

MessageForm.ShowMessageByKey("genericErrorMessage", ex.ToString)

End Try

End If

End Sub
By Jeff Pagley - 1/21/2010

I am getting this error when attempting to connect to ES:

WebException
  The remote server returned an error: (500) Internal Server Error.

Source     : System

Stack Trace:
   at System.Net.HttpWebRequest.GetResponse()
   at MicroFour.StrataFrame.Data.Enterprise.EnterpriseDataSourceItem.SendRequestCore(BaseParams Params, RemoteDataSourceCommand Command)
   at MicroFour.StrataFrame.Data.Enterprise.EnterpriseDataSourceItem.ᜀ(DbCommand A_0, Boolean A_1, String A_2)
   at MicroFour.StrataFrame.Data.Enterprise.EnterpriseDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)
   at MicroFour.StrataFrame.Data.DataLayer.GetDataTable(DbCommand Command, Boolean RegisterNotification)
   at MicroFour.StrataFrame.Business.BusinessLayer.FillDataTable(DbCommand CommandToExecute)
   at ProspectHelper.SystemSettingsBO.FillAll() in C:\Documents and Settings\JPagley\My Documents\Projects\ProspectHelper\ProspectHelper\BusinessObjects\SystemSettingsBO.vb:line 68
   at ProspectHelper.AppMain.ConnectToEnterpriseServer() in C:\Documents and Settings\JPagley\My Documents\Projects\ProspectHelper\ProspectHelper\AppMain.vb:line 407
   at ProspectHelper.AppMain.SetDataSources() in C:\Documents and Settings\JPagley\My Documents\Projects\ProspectHelper\ProspectHelper\AppMain.vb:line 78
   at MicroFour.StrataFrame.Application.StrataFrameApplication.Raise_SetDataSources()
   at MicroFour.StrataFrame.Application.StrataFrameApplication.RunApplication()
   at ProspectHelper.AppMain.Main(String[] args) in C:\Documents and Settings\JPagley\My Documents\Projects\ProspectHelper\ProspectHelper\AppMain.vb:line 29
   at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
   at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
   at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()

Here is my datasource config and AppMain code and I am using the "ProspectHelper_Master" data source key:

<?xml version="1.0" encoding="utf-8" ?>

<DataSources>
 <DataSource DataSourceKey="MyDataSource">
  <ConnectionString>server=localhost;Integrated Security=SSPI;Database=MyDatabase;</ConnectionString>
  <TypeFullName>MicroFour.StrataFrame.Data.SqlDataSourceItem</TypeFullName>
  <TypeAssemblyName>MicroFour StrataFrame Base</TypeAssemblyName>
  <TypeAssemblyVersion>1.7.0.0</TypeAssemblyVersion>
  <TypeAssemblyCulture>neutral</TypeAssemblyCulture>
  <TypeAssemblyPublicToken>99fe9917f71608a7</TypeAssemblyPublicToken>
  <IsEncrypted>True</IsEncrypted>
  <IsCompressed>True</IsCompressed>
  <EncryptionKey>1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4</EncryptionKey>
  <EncryptionVector>1,2,3,4,5,6,7,8</EncryptionVector>
  <TransactionTimeout>3600</TransactionTimeout>
 </DataSource>
 <DataSource DataSourceKey="ProspectHelper_Master">
  <ConnectionString>server=TESTSERVER\SQLEXPRESS;User Id=xxxxxxx;password=xxxxxxx;Database=ProspectHelper;</ConnectionString>
  <TypeFullName>MicroFour.StrataFrame.Data.SqlDataSourceItem</TypeFullName>
  <TypeAssemblyName>MicroFour StrataFrame Base</TypeAssemblyName>
  <TypeAssemblyVersion>1.7.0.0</TypeAssemblyVersion>
  <TypeAssemblyCulture>neutral</TypeAssemblyCulture>
  <TypeAssemblyPublicToken>99fe9917f71608a7</TypeAssemblyPublicToken>
  <IsEncrypted>True</IsEncrypted>
  <IsCompressed>True</IsCompressed>
  <EncryptionKey>1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4</EncryptionKey>
  <EncryptionVector>1,2,3,4,5,6,7,8</EncryptionVector>
  <TransactionTimeout>3600</TransactionTimeout>
 </DataSource>
</DataSources>

Dim ds As New MicroFour.StrataFrame.Data.Enterprise.EnterpriseDataSourceItem("", _

"vpn.starktruss.com/es", 80, "ProspectHelper_Master", New SqlDataSourceItem(""))

'-- Configure the compression and encryption (optional)

ds.IsCompressed = True

ds.IsEncrypted = True

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}

MicroFour.StrataFrame.Data.DataLayer.DataSources.Add(ds)
By Dustin Taylor - 1/22/2010

What does the status page of ES show you? Is it up and connecting without issue? 

If so, do you have the SMTP settings for ES set up propery? If you do, what was the error message it e-mailed you related to that failed connection?

If not, I'd recommend setting up the SMTP than restarting the website. That way, ES will e-mail you the actual error, which will give us more to go on than a generic HTTP response.

By Jeff Pagley - 1/22/2010

What does the status page of ES show you? Is it up and connecting without issue?

My status page loads fine.  Here is the info below.  Notice it says one client is connected after I failed to connect from my client app.

Server Name (site name):Development SDK
Registered Name:Jeff Pagley
Registered Company:Stark Truss
Serial Number:1002B-5B927-D4438-A452B-78FD5
Server Hostname:vpn.starktruss.com/es
License Expiration Date:8/13/2010
Allowed Clients:2
Allowed Hosts to Status.aspx:127.0.0.1 / 173.122.220.75
Serialization Type:Standard
SMTP Settings
SMTP Server & Port:mail.starktruss.com:25
Email From Address:es@testserver.com
Email To Addresses:jeff@starktruss.com
SMTP AuthNo
Data Sources
MyDataSource (SqlDataSourceItem)
DataSourceKey:MyDataSource
Type:MicroFour.StrataFrame.Data.SqlDataSourceItem
Assembly:MicroFour StrataFrame Base, Version=1.7.0.0, Culture=neutral, PublicKeyToken=99fe9917f71608a7
Connection String:server=localhost;Integrated Security=SSPI;Database=MyDatabase;
Is Encrypted:Yes
Encryption Key:{ 1, 2, 3, 4, 5, 6, 7, 8, 9, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 0, 1, 2, 3, 4 }
Encryption IV:{ 1, 2, 3, 4, 5, 6, 7, 8 }
Is Compressed:Yes
Transaction Timeout:1h 0m 0s
ProspectHelper_Master (SqlDataSourceItem)
DataSourceKey:ProspectHelper_Master
Type:MicroFour.StrataFrame.Data.SqlDataSourceItem
Assembly:MicroFour StrataFrame Base, Version=1.7.0.0, Culture=neutral, PublicKeyToken=99fe9917f71608a7
Connection String:server=TESTSERVER\SQLEXPRESS;User Id=xxxxxxx;password=xxxxxxx;Database=ProspectHelper;
Is Encrypted:Yes
Encryption Key:{ 1, 2, 3, 4, 5, 6, 7, 8, 9, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 0, 1, 2, 3, 4 }
Encryption IV:{ 1, 2, 3, 4, 5, 6, 7, 8 }
Is Compressed:Yes
Transaction Timeout:1h 0m 0s
Recognized Client List
Unique Clients Connected1
Unique Client MAC Addresses:00-18-DE-92-76-59

Also, I setup the SMTP and here is the email error message I got back which makes no sense at all.

I have double check the MAC address to make sure it is correct. And the hostname is correct because I am able to view the status page from the client machine by adding the IP address to the web.config fiile.

Enterprise Server Error
Message:This server is not licensed to run on the requested hostname.
Client IP:173.122.220.75
Details:Exception
This server is not licensed to run on the requested hostname.

Source : MicroFour StrataFrame Enterprise Server

Stack Trace:
at MicroFour.StrataFrame.Enterprise.Server.RemoteDataSource.ᜀ(String A_0)
at MicroFour.StrataFrame.Enterprise.Server.RemoteDataSource.ProcessRequest(HttpContext context)
By Jeff Pagley - 1/25/2010

Hi Justin,

Any progress on getting my issue resolved?

Thanks,

Jeff

By Jeff Pagley - 1/26/2010

Hi Dustin,

I am just checking today to see if any progress has been made on my issue. Please let me know what is going on Smile

Thanks,

Jeff

By Dustin Taylor - 1/27/2010

Hi Jeff,

Sorry for the delay here. Two things to check:

1) The IP that came accross when you activates was 127.0.0.1. You did attatch the license to your external network card, not one used for your internal netowrk, correct? In other words, your external IP to your website will be attached to one of your network cards. That is the network card that you need to attach the ES license to. I've freed up your activation in case this is hte issue. If it is, re-activate enterprise server, this time being sure to attach it to your external network card.

2) It is possible that it is pulling licensing informaiton from an incorrect MicroFour License.dll. You may check to ensure you don't have any extra copies of that .dll in the GAC or in another folder that the ES might be grabbing unexpectedly. If so, remove them, restart the website, and see if that alleviates the issue.

Thanks,

Dustin

By Jeff Pagley - 1/27/2010

Hi Dustin,

1) The IP that came accross when you activates was 127.0.0.1. You did attatch the license to your external network card, not one used for your internal netowrk, correct? In other words, your external IP to your website will be attached to one of your network cards. That is the network card that you need to attach the ES license to. I've freed up your activation in case this is hte issue. If it is, re-activate enterprise server, this time being sure to attach it to your external network card.

Now that you mention this.  My server does NOT have 2 nic cards, but I think my network admin put the server behind a proxy/firewall.  I do not know a whole lot about this stuff, but I think this may be distorting the MAC Address/IP Address references.  Is this a probable cause?  I will discuss this with my admin.

2) It is possible that it is pulling licensing informaiton from an incorrect MicroFour License.dll. You may check to ensure you don't have any extra copies of that .dll in the GAC or in another folder that the ES might be grabbing unexpectedly. If so, remove them, restart the website, and see if that alleviates the issue.

I did not find MicroFour License.dll listed in the GAC.  Therefore, this should not be a problem.

Thanks,

Jeff

By Jeff Pagley - 1/28/2010

Hi Dustin,

I've freed up your activation in case this is hte issue.  If it is, re-activate enterprise server, this time being sure to attach it to your external network card.

My licenses have not been reset as you said so I can re-activate it with the settings I now have for my test server.  I have move the test server outside of the firewall/proxy and gave it a new URL to eliminate any problems caused by them.  Please reset the licenses so I can update it with the new URL.  The MAC address is still the same.

Thanks,

Jeff

By Trent L. Taylor - 1/28/2010

Jeff, I have reset your ES license again so that you can take another stab at it. Let me know if this doesn't get you going.
By Dustin Taylor - 1/28/2010

Sorry about that! I had the form pulled up but didn't press save Smile.

You should be good to re-register now.

By Jeff Pagley - 1/28/2010

Good news.  ES is finally up and running on my test server.w00t  I hope that once I get my testing done that my production server will be a lot easier to setup.BigGrin

One question I do have.  The database has a table with over 100,000 records that the client needs to see all at one time, but I got a timeout error when loading these records into a grid using a BO mapped to SQL Server View.  Where do I increase the timeout to adjust for loading these records using ES?

Thanks,

Jeff

By Trent L. Taylor - 1/30/2010

This would be on the SqlCommand, not the server timeout. So you would create the SqlCommand and set the timeout to a really high number or 0 for infinite.



However, let me suggest possible another route. Why would you need all 100,000 records at once? If you are trying to perform an incremental search, then you can create a threaded loader so that every time you type in a new character, it gets added to the queue, gets passed over to the server to s SPROC which executes the query, and sends back a TOP result set. Generally I limit my TOP results to 100 (or possible 1000) when I do something like this. This way you get a really fast, real-time search. To date, I have never needed or seen a reason for having 100,000 records client side.
By Jeff Pagley - 1/30/2010

Hi Trent,

I agree with you.  I am going to have to provide some filtering capabilities for the client that will meet his requirements as you suggested.  I have no experience with threading.  So would you provide me some code examples about how I can accomplish this incremental search.

Thanks,

Jeff

By Trent L. Taylor - 1/31/2010

To save you some time, I have created a sample showing how to do this.  I couldn't remember what language you used, so it is in C#.  It is easy to convert, though, and I will try to post a VB.NET sample later.  But either way, this should get you going and you can see what I was getting at.  Here is that sample:

http://forum.strataframe.net/FindPost25669.aspx

By Jeff Pagley - 1/31/2010

Hi Trent,

Thank you so much for the example. BigGrin I'm using VB.NET, but after looking at the example, I believe I can convert the C# code.

Jeff

By Trent L. Taylor - 1/31/2010

Glad it helped. Smile