|
Group: StrataFrame Users
Posts: 84,
Visits: 835
|
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: '-- Build the Query
loSQLCmd.CommandText = "SELECT * FROM pws_Statements"'-- Fill the business object using the command
me.FillDataTable(loSQLCmd) The connection is as follows: 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) 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: <ConnectionString>server=MyServer\SQLEXPRESS;integrated security=SSPI;database=test_database</ConnectionString> OK that's all I got! I'll shut up and listen now.
|