Re: Visual Studio 05 Express and Dataset Use

Carlos Guzmán Álvarez schrieb:

Hello:
  

thank you very much. That's the information I needed, because I didn't 
know that I had to install DDEX Provider to use Firebird in Visual 
Studio. _Now I got connection from VCSE to Firebird database._

Unfortunately, I got the *next problem.* Adding a connection via 
Firebird, the connection test is OK, but after clicking on OK VSCE 
gives an error: *"Fehler beim Laden eines Typs." (similar: "Error on 
loading a type")* Could anyone tell me, on which way I can find what 
data type could set this error?

    

Huummm what version of the provider are you using ?? how do you have the 
machine.config modified what version of the .reg file have you used to 
register the DDEX provider ??

  

Hello, Carlos and you all,

here are these informations (I used your previous tips):

Firebird NET Provider

Name:

FirebirdSql.Data.FirebirdClient, Version=2.0.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c

Firebird DDEX Provider

Name:

FirebirdSql.VisualStudio.DataTools, Version=2.0.1.0, Culture=neutral, PublicKeyToken=bae6c78ccb0fcdb3

machine.config

    <configSections>
        <section name="firebirdsql.data.firebirdclient" type="System.Data.Common.DbProviderConfigurationHandler,
                               System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />  
    </configSections>
    <system.data>
        <DbProviderFactories>
           <add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient"
                description=".Net Framework Data Provider for Firebird"
                type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient,
                Version=2.0.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c" />
        </DbProviderFactories>
    </system.data>

.reg file for VCSE

Please read the annex (renamed to .txt because the mail server mailed an error). I followed the instructions of Robert Simpson, but I changed "VisualStudio" to "VCSExpress" only in the registry keys, not in the registry strings.

Domains of my database

CREATE DOMAIN D_BOOL AS SMALLINT DEFAULT 0 NOT NULL CHECK (VALUE BETWEEN 0 AND 1);
CREATE DOMAIN D_DATE AS DATE;
CREATE DOMAIN D_JAHR AS CHAR(4) CHECK (VALUE BETWEEN '1000' AND '2999');
CREATE DOMAIN D_MEMO AS VARCHAR(300);
CREATE DOMAIN D_T_20 AS VARCHAR(20);
CREATE DOMAIN D_T_50 AS VARCHAR(50);
CREATE DOMAIN D_T_80 AS VARCHAR(80);
CREATE DOMAIN D_ZAHL AS INTEGER DEFAULT 0 NOT NULL;
CREATE DOMAIN D_ZEIT AS CHAR(5);

Each table field is defined via one of these domains.

Hope you can tell me why the "Error on loading a type" is set. Could it be the domain D_Memo as Varchar(300)?

Thank you very much! Juergen

--

Jürgen Thomas
Verlags-Software

Samländische Str. 3
13189 Berlin

Tel.     (030)      94 39 96 38
oder   (0700)    VS–POLIS
d.h.     (0700)  87 07 65 47
Fax     (030)      94 39 96 40

http://www.vs-polis.de

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VCSExpress\8.0\DataSources\{466CE797-67A4-4495-B75C-A3FD282E7FC3}]
@="Firebird Data Source"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VCSExpress\8.0\DataSources\{466CE797-67A4-4495-B75C-A3FD282E7FC3}\SupportingProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VCSExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}]
@=".NET Framework Data Provider for Firebird"
"DisplayName"="Provider_DisplayName,
FirebirdSql.VisualStudio.DataTools.Properties.Resources"
"ShortDisplayName"="Provider_ShortDisplayName,
FirebirdSql.VisualStudio.DataTools.Properties.Resources"
"Description"="Provider_Description,
FirebirdSql.VisualStudio.DataTools.Properties.Resources"
"CodeBase"="%Path%\FirebirdSql.VisualStudio.DataTools.dll"
"InvariantName"="FirebirdSql.Data.FirebirdClient"
"Technology"="{77AB9A9D-78B9-4ba7-91AC-873F5338F1D2}"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VCSExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\SupportedObjects]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VCSExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\SupportedObjects\DataConnectionSupport]

@="FirebirdSql.VisualStudio.DataTools.FbDataConnectionSupport"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VCSExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\SupportedObjects\DataConnectionProperties]

@="FirebirdSql.VisualStudio.DataTools.FbDataConnectionProperties"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VCSExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\SupportedObjects\DataConnectionUIControl]

@="FirebirdSql.VisualStudio.DataTools.FbDataConnectionUIControl"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VCSExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\SupportedObjects\DataObjectSupport]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VCSExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\SupportedObjects\DataSourceInformation]

@="FirebirdSql.VisualStudio.DataTools.FbDataSourceInformation"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VCSExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\SupportedObjects\DataViewSupport]

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@xxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider