Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Stumped
Fri, Oct 11 2013 2:02 PMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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. Smile

Tim Young
Elevate Software
www.elevatesoft.com
Wed, Oct 23 2013 10:59 PMPermanent 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
---------------------------------------


Image