Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Connectivity » View Thread |
Messages 1 to 3 of 3 total |
Stumped |
Fri, Oct 11 2013 2:02 PM | Permanent Link |
Terry Swiers | This isn't specifically a ElevateDB issue, but I'm hoping that someone here
has run into this and has a solution. I'm moving a working .NET application from one server to another, Server 2003 to Server 2008, IIS6 to IIS 7.5, and I'm getting an error that I just can't figure out. In short, I'm using a SqlDataSource object to pull data from a EDB Table and it's throwing the following error: Keyword not supported: 'name'. [ArgumentException: Keyword not supported: 'name'.] System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) +5112852 System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) +98 System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) +64 System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) +24 System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) +150 System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) +59 System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) +4 System.Web.UI.WebControls.SqlDataSource.CreateConnection(String connectionString) +34 System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +117 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +21 This web application works perfectly on the old server as well as on my Windows 7 development system with IIS 7.5. I know that the ElevateDB data provider is working as I can create a Elevate.ElevateDB.Data.EDBCommand and associated Reader to read from the same table that the SqlDataSource is pulling from. And if I create a new SqlDataSource, set the connection string and select query, and then attempt to retrieve the data using the Select method, I get the same error. I am running EDB 2.14B1, but I don't think this makes any difference since it works on two systems, but not the third. Anyone have any suggestions on how to resolve this? --------------------------------------- Terry Swiers Millennium Software, Inc. http://www.1000years.com http://www.atrex.com --------------------------------------- |
Wed, Oct 16 2013 3:09 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Terry,
<< I'm moving a working .NET application from one server to another, Server 2003 to Server 2008, IIS6 to IIS 7.5, and I'm getting an error that I just can't figure out. In short, I'm using a SqlDataSource object to pull data from a EDB Table and it's throwing the following error: Keyword not supported: 'name'. >> I think that the SQLDataSource is using the wrong type of connection (SQLConnection) instead of EDBConnection. I think this is caused when the ProviderName for the SQLDataSource isn't set properly: http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.providername.aspx Why it works on one machine and not the other escapes me, though. Tim Young Elevate Software www.elevatesoft.com |
Wed, Oct 23 2013 10:59 PM | Permanent Link |
Terry Swiers | Hi Tim,
> I think that the SQLDataSource is using the wrong type of connection > (SQLConnection) instead of EDBConnection. I think this is caused when the > ProviderName for the SQLDataSource isn't set properly: You are absolutely correct. There was some corruption in the aspx file that was causing the ProviderName to be read as blank on the 64bit system but was somehow readable on the 32bit system. It looked fine from the designer side, but the corruption was only visible when you viewed the HTML source for the aspx file. Once I deleted the garbage from the source it started working as expected. --------------------------------------- Terry Swiers Millennium Software, Inc. http://www.1000years.com --------------------------------------- |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |