Tim

Okay I am finally using (or trying to use) my ElevateDB Database...V1.09 (if I can get this to work properly I'll most likely uprade to 2.0)

below is my c# code (2005)

I migrarate or Create a new database...into the folder below and run this code and I keep getting

"Error 401 - Database ListBuilder does not exist"

And whats weird is that if I intentionally screw up the ID or PWD it detects that has happened and the error changes to Invalid ID or PWD!  So that
tells me he is "seeing" the database configuration...so what is wrong

I have attached the references elevate.elevatedb.data and elevate.elevatedb.visualstudio

using Elevate.ElevateDB.Data;
using Elevate.ElevateDB.VisualStudio;


           EDBConnectionStringBuilder csb = new EDBConnectionStringBuilder();
           csb.Type = "LOCAL";
           csb.ConfigPath = @"C:\Documents and Settings\Pete\My Documents\Visual Studio 2005\Projects\ListBuilder\ListBuilder\ElevateDB";
           csb.Database = "ListBuilder";
           csb.CatalogName = "";
           csb.UID = "Administrator";
           csb.PWD = "EDBDefault";

           EDBConnection conn = new EDBConnection(csb.ConnectionString);
           try
           {
               conn.Open();
               MessageBox.Show("Connection Open!");
           }
           catch (Exception ex)
           {
               MessageBox.Show(ex.Message);
           }
           finally
           {
               conn.Close();
               conn.Dispose();
           }

Pete,

<< below is my c# code (2005)

I migrarate or Create a new database...into the folder below and run this
code and I keep getting  >>

How did you create the ListBuilder database ?  You need to make sure that
when you create the database, either in code or via the EDB Manager, that
you do so while using the same configuration path.  That way the database is
created in the configuration file that you desire.  In the EDB Manager, you
can change the configuration path by using the Edit Session option (Edit
Session/Local Configuration/File Folder).

<< I have attached the references elevate.elevatedb.data and
elevate.elevatedb.visualstudio >>

You don't need the Elevate.ElevateDB.VisualStudio reference.  Using it will
possibly cause dependencies on the VS IDE assemblies, and you don't want
that.

--
Tim Young
Elevate Software
www.elevatesoft.com

Yes...I was on that trail...
So now in the Manger I set the Session Path to c:\ElevateDB  then create the DB using that SAME folder...Migrate my ODBC V4 tables into the
Database...When I do this using the Unicode I get an error but the other Migration dll works good.

I altered my code (removed the Using VisualStudio dll)

and rereun my code...

I now get

Elevate DB #100 There is an error in the Metadata for the configuration EDBConfig (signature, password, characer set (ansi/unicode), or version
number mismatch

Pete

Yes...I was on that trail...
So now in the Manger I set the Session Path to c:\ElevateDB  then create the DB using that SAME folder...Migrate my ODBC V4 tables into the
Database...When I do this using the Unicode I get an error but the other Migration dll works good.

I altered my code (removed the Using VisualStudio dll)

and rereun my code...

I now get

Elevate DB #100 There is an error in the Metadata for the configuration EDBConfig (signature, password, characer set (ansi/unicode), or version
number mismatch

Pete

Seaching on this error... I found this assembly entries...here are mine...do they need to be changed?

Pete


<runtime>
      <assemblyBinding>
         <dependentAssembly>
            <assemblyIdentity name="Elevate.ElevateDB.Data" publicKeyToken="cf9bc1202c75e9e2"/>
            <codeBase version="1.9.4.0" href="file:///C:\Program Files\ElevateDB DAC Standard\Version 1
\assemblies\edbprovider\Elevate.ElevateDB.Data.dll"/>
         </dependentAssembly>
         <dependentAssembly>
            <assemblyIdentity name="Elevate.ElevateDB.VisualStudio" publicKeyToken="009e2f3c00f33fa3"/>
            <codeBase version="1.9.4.0" href="file:///C:\Program Files\ElevateDB DAC Standard\Version 1
\assemblies\edbprovidervs\Elevate.ElevateDB.VisualStudio.dll"/>
         </dependentAssembly>
      </assemblyBinding>
   </runtime>

Pete,

<< So now in the Manger I set the Session Path to c:\ElevateDB  then create
the DB using that SAME folder...Migrate my ODBC V4 tables into the
Database...When I do this using the Unicode I get an error but the other
Migration dll works good. >>

What is the error message that you're seeing ?

<< I altered my code (removed the Using VisualStudio dll)

and rereun my code...

I now get >>

Did you create the previous configuration file using the ANSI EDB Manager ?
Remember, .NET is 100% Unicode, so you have to use all of the Unicode
utilities, migrators, etc.  If the configuration file is ANSI, then you need
to delete it, and then use the Unicode EDB Manager to create a new database
again (you may need to migrate the database over using the Unicode ADO
migrator again).  Then you should be able to access the Unicode
configuration and database using your C# code.

--
Tim Young
Elevate Software
www.elevatesoft.com

Your a Genius!

Worked like a champ!!

I did not kncw .net was Unicode!  

Thanks
Pete

Hey Tim

I just upgraded from ElevateDB 1 to ElevateDB 2....how long does it take before I can download the product? In my download screen I can only
download the ADD products for 2.02B14, when will it activate my downloading of the actual Product?

Pete

Pete,

<< I just upgraded from ElevateDB 1 to ElevateDB 2....how long does it take
before I can download the product? In my download screen I can only download
the ADD products for 2.02B14, when will it activate my downloading of the
actual Product? >>

Sorry about that - today was our son's birthday, so both Sam and I skipped
out a little early to get ready for a party.  We're back now, so I'll have
her process right away.

--
Tim Young
Elevate Software
www.elevatesoft.com

No Worries...