Hi,

I've been playing with the server and have sucessfully imported ~1GB of data, it looks fine so far, but...

I'm having problems connecting using the ADO.NET driver ("DAC Trial - Version 1.09 Build 3") in numerous environments.
(I have tried Server 2003 VS2005/2008 and Server 2008 VS2008)

As an example of one of my trials.

Windows Server 2003 (VS2005)
-------------------------------------
If I try creating a connection in the Server Explorer I can manually type the connectionstring
(note: only ConnectionString is shown in the dialog box)
example
 'TYPE=REMOTE;ADDRESS=192.168.n.nnn;DATABASE=SomeDatabase;'

Clicking on "Test connection" returns "The connection succeded."
but when I click OK I get the following error

"Failed to find or load the registered .Net Framework Data Provider"
and I'm stuck.

If I add a Reference to the assembly in my project "C:\Program Files\....\edbprovider\elevate.elevatedb.data.dll"
I get the full "Add Connection" dialog box with all fields.
Changing the default settings to Remote etc. (as above) I get an error testing the connection.

"Error #1100 A connection to the server at '192.168....' cannot be established, an existing connection was forcibly closed by the remote host."
As a result, I'm not able to save the connectionstring.

Note:
I know the server is working as the ElevateDB Manager connects to the remote server and the database in question.

Now, If I create a ConnectionString in Web.Config
e.g.
<add name="SomeConnectionString"   
connectionString="TYPE=REMOTE;PING=TRUE;PINGINTERVAL=60;PORT=12010;DATABASE=SomeDatabase;ENCRYPTED=FALSE;ADDRESS=192.1
68.2.109;UID=XXX;PWD=XXXX;" providerName="Elevate........." />

and manually type the select statement in the SqlDataSource
 "select * from sometable"

Viewing the web page I get the following error:
"Database schema could not be retreived for this connection. Please make sure the connection settings are correct and that the database is online.
ElevateDB Error #1100 A connection to the server at 'ip address' cannot be established (An existing connection was forcibly closed by the remote
host)

I have attached the stack trace from this error message.


What am I missing here.

Jan-Erik

I forgot the Stack trace

Jan-Erik

Jan,

<< If I try creating a connection in the Server Explorer I can manually type
the connectionstring
(note: only ConnectionString is shown in the dialog box)
example
 'TYPE=REMOTE;ADDRESS=192.168.n.nnn;DATABASE=SomeDatabase;'

Clicking on "Test connection" returns "The connection succeded."
but when I click OK I get the following error

"Failed to find or load the registered .Net Framework Data Provider" and
I'm stuck. >>

Could you email me your machine.config file from here:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG

and the registry settings from these keys:

VS2005:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\8.0\DataProviders
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\8.0\DataSources

VS2008:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\9.0\DataProviders
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\9.0\DataSources

There's something wrong with the configuration, especially if you don't see
the connection string properties as separate properties in the grid.  More
than likely the Visual Studio design-time assembly is not installed
properly.

<< If I add a Reference to the assembly in my project "C:\Program
Files\....\edbprovider\elevate.elevatedb.data.dll"
I get the full "Add Connection" dialog box with all fields.
Changing the default settings to Remote etc. (as above) I get an error
testing the connection.

"Error #1100 A connection to the server at '192.168....' cannot be
established, an existing connection was forcibly closed by the remote host."
>>

Are you running the Unicode version of the ElevateDB Server ?  If not, then
that is the problem.  .Net is 100% Unicode, so you need to use the Unicode
version of the ElevateDB Server instead of the ANSI version.

--
Tim Young
Elevate Software
www.elevatesoft.com

This is exactly the same error message that I got when I used the
non-unicode driver by mistake as well.

Chris Holland

>
>  "Error #1100 A connection to the server at '192.168....' cannot be
> established, an existing connection was forcibly closed by the remote host."
>  >>
>

"Chris Holland [Team Elevate]" wrote:

"This is exactly the same error message that I got when I used the
non-unicode driver by mistake as well."

You are both right, I can't see how I could miss it.

Well, it's ok now Thanks!

Just one thing, I had to add the assembly to the GAC, otherwise I got the following error in Windows 2008 Server / VS2008.

"Could not load file or assembly 'elevate.elevatedb.data, version 1.9.3.0, Culture=neutral, PublicKeyToken=cf9bc1202c75e9e2' or one of its
dependencies. The system can not find the file specified."

One last issue is that the number of connections is a bit limited for testing.
If I use the Server Explorer + Designer in VS + ElevateDB Manager + Preview in ASP.NET it reaches the maximum number of connections so I
have to close the EDB Manager, well, I know it's a trial but anyway.

I'll let you know how it works I'm testing with DevExpress and Telerik components at the moment and so far it looks good

Jan-Erik

Jan-Erik,

<< Just one thing, I had to add the assembly to the GAC, otherwise I got the
following error in Windows 2008 Server / VS2008.

"Could not load file or assembly 'elevate.elevatedb.data, version 1.9.3.0,
Culture=neutral, PublicKeyToken=cf9bc1202c75e9e2' or one of its
dependencies. The system can not find the file specified." >>

Is this a straight Windows app, or a web app (ASP.NET) ?  If a web app, then
that issue is described here:

http://www.elevatesoft.com/newsgrp?action=openmsg&group=16&msg=5257&page=1#msg5257

(Thanks to Chris for his input on this).

<< One last issue is that the number of connections is a bit limited for
testing. >>

Yes, I'm thinking of possibly bumping it up a little further.  I just bumped
it up to 3, but I'm thinking 5 might be the best limit.

<< I'll let you know how it works I'm testing with DevExpress and
Telerik components at the moment and so far it looks good >>

Thanks, please keep us posted on your progress.

--
Tim Young
Elevate Software
www.elevatesoft.com

>
> Is this a straight Windows app, or a web app (ASP.NET) ?  If a web app, then
> that issue is described here:
>
> http://www.elevatesoft.com/newsgrp?action=openmsg&group=16&msg=5257&page=1#msg5257

If this is a Windows Forms application, did you add the file to the
references and set the "Copy Local = true"?

Chris Holland

"Chris Holland [Team Elevate]" wrote:

<
If this is a Windows Forms application, did you add the file to the
references and set the "Copy Local = true"?
>

It's a ASP.NET application.
IMHO, installing to the GAC is cleaner and easier.
That way you won't get error messages, before one starts using the product

For the Server Explorer to work (without an open project) one needs to add it to the GAC.

Anyway, there are very few issues so far, one of them being the lack of a "Database Workbench" like product, which is essential imho.
I'm spending too much time converting/migrating data and a tool like that would have saved me days evaluating the DAC.
Is there nothing that compares to DBW that supports ElevateDB?

Jan-Erik

Jan-Erik,

<< For the Server Explorer to work (without an open project) one needs to
add it to the GAC. >>

Are you sure about that ?  I use it with the Server Explorer with no
problems without an open project, and I've got the data provider set up in
the machine.config in the same way that our installation program installs
it:

<runtime>
 <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
  <dependentAssembly>
   <assemblyIdentity name="Elevate.ElevateDB.Data"
publicKeyToken="cf9bc1202c75e9e2"/>
   <codeBase version="1.9.1.0"
href="file:///m:\products\source\edb1\edbprovider\Elevate.ElevateDB.Data.dll"/>
  </dependentAssembly>
  <dependentAssembly>
   <assemblyIdentity name="Elevate.ElevateDB.VisualStudio"
publicKeyToken="009e2f3c00f33fa3"/>
   <codeBase version="1.9.1.0"
href="file:///m:\products\source\edb1\edbprovidervs\Elevate.ElevateDB.VisualStudio.dll"/>
  </dependentAssembly>
 </assemblyBinding>
</runtime>

<< Anyway, there are very few issues so far, one of them being the lack of a
"Database Workbench" like product, which is essential imho.  I'm spending
too much time converting/migrating data and a tool like that would have
saved me days evaluating the DAC.  Is there nothing that compares to DBW
that supports ElevateDB? >>

There is the Context Database Designer:

http://www.contextsoft.com/products/dbdesign/index.jsp

which supports ElevateDB.

As for converting/migrating data - you should have been able to convert your
existing data to EDB in one shot using a migrator.  Or was the main issue
the fact that you migrated the data to ANSI instead of Unicode initially and
needed to move it over to Unicode ?

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

<<<
<< For the Server Explorer to work (without an open project) one needs to
add it to the GAC. >>

Are you sure about that ?  I use it with the Server Explorer with no
problems without an open project, and I've got the data provider set up in
the machine.config in the same way that our installation program installs
it:

<runtime>
 <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
  <dependentAssembly>
   <assemblyIdentity name="Elevate.ElevateDB.Data"
publicKeyToken="cf9bc1202c75e9e2"/>
   <codeBase version="1.9.1.0"
href="file:///m:\products\source\edb1\edbprovider\Elevate.ElevateDB.Data.dll"/>
  </dependentAssembly>
  <dependentAssembly>
   <assemblyIdentity name="Elevate.ElevateDB.VisualStudio"
publicKeyToken="009e2f3c00f33fa3"/>
   <codeBase version="1.9.1.0"
href="file:///m:\products\source\edb1\edbprovidervs\Elevate.ElevateDB.VisualStudio.dll"/>
  </dependentAssembly>
 </assemblyBinding>
</runtime>
>>

Well, I'm quite sure on my system (Server 2008, VS2008), I have reinstalled several times (using vmware this takes minuttes)
Without regestering it in the GAC I got the following error:
"Could not load file or assembly 'elevate.elevatedb.data, version 1.9.3.0, Culture=neutral, PublicKeyToken=cf9bc1202c75e9e2' or one of its
dependencies. The system can not find the file specified."

I'll retest just to make sure.

<<<
<< Anyway, there are very few issues so far, one of them being the lack of a
"Database Workbench" like product, which is essential imho.  I'm spending
too much time converting/migrating data and a tool like that would have
saved me days evaluating the DAC.  Is there nothing that compares to DBW
that supports ElevateDB? >>
>>>

There is the Context Database Designer:
http://www.contextsoft.com/products/dbdesign/index.jsp
which supports ElevateDB.

As for converting/migrating data - you should have been able to convert your
existing data to EDB in one shot using a migrator.  Or was the main issue
the fact that you migrated the data to ANSI instead of Unicode initially and
needed to move it over to Unicode ?
>>>


I'll have a look at Context Database Designer.

Is there a migrator included in ElevateDB?

As for the time it took to convert,
sure there was some time lost converting to ANSI instead of Unicode.
(not all of the time was a waste, as I got aquainted with your programs and the database script was quite a part of the process)
I'm used to click on a few menues and the DBW takes care of the rest. (creating the scripts + transferring the data)
Converting 150-200 tables manually naturally takes some time
Using CSV was initially just to prove that your provider works, and it does work really well
But, using CSV means that I'm not able to convert blobs (rtf, images, pdf's ....) so I'll try to create a small app for converting those tables later
today.

Jan-Erik