|
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 6.9K
|
One other thing to consider here is adjusting the timeout. You can do this directly on the SqlCommand when you send it down the pipe as well as adjust the defaults on the server. The first thing I would check would try would be setting the command timeout on the SqlCommand to get around this. Also, like Greg mentioned, you may be pulling back more information that you need. Also, if you are saving large amounts of data such as bitmaps, etc. then you could also use a Blob push (which is another thread and topic) to save this asynchrously. There are a lot of options here, but before we dive into something more complex, just adjust the timeout on the SqlCommand and see if that resolves your issue.
|
|
Group: Forum Members
Posts: 2K,
Visits: 6.6K
|
If a lot of data is returned by your test command, you might try limiting the data, using TOP (e.g. Select TOP 10....). If it returns, then you know you have a simple time out issue and need to figure out how to change that setting. I see nothing obviously wrong here (but then I'm no expert on the subtleties of ES)
|
|
Group: StrataFrame Users
Posts: 84,
Visits: 835
|
Oh, one more thing. I lifted the mac address from the server using ipconfig /all I double checked it and seems to be correct. OK, that it! I think.
|
|
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.
|