Re: [Firebird-net-provider] Problem with DDEX
Hello: > Hi Carlos! Thank you for your answer! First I load the connection string > example from www.connectionstrings.com. The connection string is valid for usage with FbConnection, for the ddex provider you must give the Data Source name, the port number, user, password, character set, dialect because they are required for the ddex provider. > But I couldn't connect with this constr to the database. Then I've red > somware in Firebird forums that for FB 2.0 I must set "Provider" property. What provider property ?? > Then I tried to set them as adodb. It douldn't work as you are using a ddex provider for an ado.net provider not an oledb one. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with DDEX
Dnia 26-12-2006 o 15:40:46 Carlos Guzmán Álvarez <[EMAIL PROTECTED]> napisał: > Hello: >> Database: >> Server Type: Embeded >> User: SYSDBA >> Password: masterkey > What happens if you set localhost as the DataSource/Server ?? > It works, thank you ;) -- Używam programu pocztowego Opery: http://www.opera.com/mail/ - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with DDEX
> Hello: > > Database: > > Server Type: Embeded > > User: SYSDBA > > Password: masterkey > What happens if you set localhost as the DataSource/Server ?? > -- Hi Carlos! Thank you for your answer! First I load the connection string example from www.connectionstrings.com. But I couldn't connect with this constr to the database. Then I've red somware in Firebird forums that for FB 2.0 I must set "Provider" property. Then I tried to set them as adodb. This helps me to connect but when the first constructor FbCommand() will be risen, I've got exception "Method Dispose() havn't it;s implementation", as I remember. Is my English well enough for describe the problem? Thank you again, Carlos. If you can, please help me with solving this strange problem. Vlad - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with DDEX
Hello: > Database: > Server Type: Embeded > User: SYSDBA > Password: masterkey What happens if you set localhost as the DataSource/Server ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with DDEX
Dnia 25-12-2006 o 11:36:06 Carlos Guzmán Álvarez <[EMAIL PROTECTED]> napisał: > Hello: >> In readme im read that PublicKeyToken must be equal to Key form assemby >> in >> GAC. My assembly has key = 3750abcc3150b00c. > That is the right one. >> But when im enter it in machine.config OK button is disabled. Why ? > What fields has you filled in the dialog ?? > > Database: Server Type: Embeded User: SYSDBA Password: masterkey Test Connection succeeded. OK button disabled. -- Używam programu pocztowego Opery: http://www.opera.com/mail/ - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with DDEX
Hello: > In readme im read that PublicKeyToken must be equal to Key form assemby in > GAC. My assembly has key = 3750abcc3150b00c. That is the right one. > But when im enter it in machine.config OK button is disabled. Why ? What fields has you filled in the dialog ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with DDEX
Dnia 24-12-2006 o 16:50:37 sho <[EMAIL PROTECTED]> napisał: > Dnia 21-12-2006 o 21:58:59 Carlos Guzmán Álvarez > <[EMAIL PROTECTED]> napisał: > >> Hello: >>> FB DDEX provider works for me just like before SP1. If it isn't enough >>> what registry key I have to look for? >> Nice to hear, don't worry if it's working fine the registry entries are >> correct :) >> >> > > Can you tell my why i have OK button disabled in Add Connection dialog ? > > OK i change PublicKeyToken to b77a5c561934e089 in machine config and OK button is enabled. But now when im click OK then i have exception: "Exception has ben throw by the target of a invocation". In readme im read that PublicKeyToken must be equal to Key form assemby in GAC. My assembly has key = 3750abcc3150b00c. But when im enter it in machine.config OK button is disabled. Why ? -- Używam programu pocztowego Opery: http://www.opera.com/mail/ - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with DDEX
Dnia 21-12-2006 o 21:58:59 Carlos Guzmán Álvarez <[EMAIL PROTECTED]> napisał: > Hello: >> FB DDEX provider works for me just like before SP1. If it isn't enough >> what registry key I have to look for? > Nice to hear, don't worry if it's working fine the registry entries are > correct :) > > Can you tell my why i have OK button disabled in Add Connection dialog ? -- Używam programu pocztowego Opery: http://www.opera.com/mail/ - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with DDEX
Hello: > > Please help me!. > 1. What version of the .net provider are you using ?? 2. What version of the .reg file are you using ?? 3. Are you using express editions of Visual Studio ?? 4. How do you have modified the machine.config file ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with DDEX
Hi everybody! I tried to install DDEX many times, but it dont work. I run setup, DDEXProvider-2.0.1.exe, Config machine.config, change CodeBase and Path. (see attach file) Please help me!. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Miroslav Hrázský Sent: Thursday, December 21, 2006 22:06 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Problem with DDEX FB DDEX provider works for me just like before SP1. If it isn't enough what registry key I have to look for? On 21/12/06, Carlos Guzmán Álvarez < [EMAIL PROTECTED]> wrote: Hello: > It maybe a new build of the ddex provider is needed with the SP1 i > will try to release a new version as soon as possible. Could somebody confirm if the SP1 install has deleted the ddex provider registry entries ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php <http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV> &p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Miro Hrázský <> - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with DDEX
Hello: > FB DDEX provider works for me just like before SP1. If it isn't enough > what registry key I have to look for? Nice to hear, don't worry if it's working fine the registry entries are correct :) -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with DDEX
FB DDEX provider works for me just like before SP1. If it isn't enough what registry key I have to look for? On 21/12/06, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote: Hello: > It maybe a new build of the ddex provider is needed with the SP1 i > will try to release a new version as soon as possible. Could somebody confirm if the SP1 install has deleted the ddex provider registry entries ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Miro Hrázský - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with DDEX
Hello: > It maybe a new build of the ddex provider is needed with the SP1 i > will try to release a new version as soon as possible. Could somebody confirm if the SP1 install has deleted the ddex provider registry entries ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with DDEX
Hello: It maybe a new build of the ddex provider is needed with the SP1 i will try to release a new version as soon as possible. -- Un saludo Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with DDEX
I have same problem > Původní zpráva > Od: sho <[EMAIL PROTECTED]> > Předmět: [Firebird-net-provider] Problem with DDEX > Datum: 19.12.2006 19:27:12 > > Hello, > I have installed: > FirebirdClient-2.0.1 > Firebird-2.0.0.12748-0_embeded > DDEXProvider-2.0.1 > > When I'm add new Data Connection in Server Explorer in VS2005 with SP1 i > dont have OK button enabled. > I'm fill textboxes with this parameters: > > Database: > Dialect : 3 > Server Type: Embeded > Usser and pass > > Test connection are succeeded but OK button is disabled. > > To test im fill all parameters but OK button is still disabled. > > Sorry for my english. > > -- > sho > > - > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Problem with DDEX
Hello, I have installed: FirebirdClient-2.0.1 Firebird-2.0.0.12748-0_embeded DDEXProvider-2.0.1 When I'm add new Data Connection in Server Explorer in VS2005 with SP1 i dont have OK button enabled. I'm fill textboxes with this parameters: Database: Dialect : 3 Server Type: Embeded Usser and pass Test connection are succeeded but OK button is disabled. To test im fill all parameters but OK button is still disabled. Sorry for my english. -- sho - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
> In the data type of the IS_NULLABLE column returned in the GetSchema = > > calls ... > Oh not easy to find it ! - 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
Hello: > Yes it works fine now where was the problem ? In the data type of the IS_NULLABLE column returned in the GetSchema calls ... > thanks a lot ! :) -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
Carlos Guzmán Álvarez avait soumis l'idée : > Hello: >> I have a problem with the tableadapter and the ddex provider i will try t= > o = > >> explain you with an exemple : > I think i have this fixed in my local tree > Yes it works fine now where was the problem ? thanks a lot ! - 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
> I think i have this fixed in my local tree > I can do some tests if you want ? where i can found the new source ? - 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
Hello: > I have a problem with the tableadapter and the ddex provider i will try to > explain you with an exemple : I think i have this fixed in my local tree -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
Hello: > But the insert command didn't get generated ... looks weird ... I will try to check if it could be something related to the FbCommandBuilder class. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
dimaaan wrote:
> Hi.
>
> I have a problem with procedure. Execute of this produce no effect
>
> ET TERM ^ ;
>
> CREATE PROCEDURE CLEAR_TEMP_DATA
> as
> begin
> DELETE FROM connected_players;
> DELETE FROM sel_nositeli;
> DELETE FROM sel_nositeli2;
> DELETE FROM sel_vvt;
> DELETE FROM sel_vvt2;
> end^
>
> SET TERM ; ^
>
> GRANT SELECT,DELETE ON CONNECTED_PLAYERS TO PROCEDURE CLEAR_TEMP_DATA;
>
> GRANT SELECT,DELETE ON SEL_NOSITELI TO PROCEDURE CLEAR_TEMP_DATA;
>
> ...and no errors.
>
And how it's related to DDEX?
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
Hi. I have a problem with procedure. Execute of this produce no effect ET TERM ^ ; CREATE PROCEDURE CLEAR_TEMP_DATA as begin DELETE FROM connected_players; DELETE FROM sel_nositeli; DELETE FROM sel_nositeli2; DELETE FROM sel_vvt; DELETE FROM sel_vvt2; end^ SET TERM ; ^ GRANT SELECT,DELETE ON CONNECTED_PLAYERS TO PROCEDURE CLEAR_TEMP_DATA; GRANT SELECT,DELETE ON SEL_NOSITELI TO PROCEDURE CLEAR_TEMP_DATA; ...and no errors. - 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
Hello: > Huummm setting FAC_CODE ( As a test ) as primary key ... makes it to be > enabled selecting only two fields ... But the insert command didn't get generated ... looks weird ... -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
Hello: > It doesn't help as well > > But it looks like when selecting only the two first columns in the > TableAdapter wizard the GenerateDBDirectmethods option > is disabled ... the problem comes on knwing what can be the reasons > that makes this to be disabled ... Huummm setting FAC_CODE ( As a test ) as primary key ... makes it to be enabled selecting only two fields ... -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
Hello: > I will try to do a debug and looks what exceptions are being raised ( if > there are any ) It doesn't help as well But it looks like when selecting only the two first columns in the TableAdapter wizard the GenerateDBDirectmethods option is disabled ... the problem comes on knwing what can be the reasons that makes this to be disabled ... -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
Else i have found a ddex for sqlite database and it is very simple. in this one this problem is'nt present so maybe can help you ? you can find it at http://sourceforge.net/projects/sqlite-dotnet2 - 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
Hello: > what is a concept mapper ? It could be part of DDEX provider, it allows to map the field data type to DbType, the Framework Type, etc ... but looks like the problem isn't there I will try to do a debug and looks what exceptions are being raised ( if there are any ) > And you think that the problem is in the ddex provider or in the ado .net > provider ? I don't know ... in fact it could be a problem in one of them or not, there are things in the suage that visual studio makes of them that aren't correct, for example the FbDataAdapter class has a hack to avoid one of them when working withe SqlDataSource component ... anyway more than probably it's a problem in one of the Firebird providers. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
> I'm thinking if it could be a matter of data type mapping ... i'm = > > thinking on try to implement a concept mapper ... and give it a try ... > what is a concept mapper ? And you think that the problem is in the ddex provider or in the ado .net provider ? - 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
Hello: > Yes in the property window this propertie is good but not in the genrated > code so VS seems to take the information elsewhere but where i don't know :( I'm thinking if it could be a matter of data type mapping ... i'm thinking on try to implement a concept mapper ... and give it a try ... -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
> AllowDbNull looks correct to me at least in the properties window. > Yes in the property window this propertie is good but not in the genrated code so VS seems to take the information elsewhere but where i don't know :( - 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
Hello: > If we look the different parameter we can see that AllowDbNull is always set > to "False" or only the FAC_CODE Column should set to "False". Maybe the > problem is here ? AllowDbNull looks correct to me at least in the properties window. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
Hello: > NOTE: Carlos, is there any description of DDEX architecture (to understand > the code and data flow there)? There are the documentation that comes with the Visual Studio SDK ... but the problem is not only what the DDEX provider does ... is in how Visual Studio is using it and what information is trying yo get from the DDEX to do the work. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
le roy arnaud wrote:
> but i will try with this :
> CREATE TABLE ACH_FAM (
> FAC_CODE SMALLINT NOT NULL,
> FAC_NOMVARCHAR(30) DEFAULT 'test',
> FAC_SELECTION SMALLINT DEFAULT 1
> );
>
> and i have the same problem and i will try with an access database and it's
> works fine.
You're right, adding default value has no impact on generated statements. :D
When I try to force generating methods, I get "The type of the database
object does not allow to set GenerateDBDirect to true."
And the MS SQL works fine.
NOTE: Carlos, is there any description of DDEX architecture (to understand
the code and data flow there)?
>
> If we look the different parameter we can see that AllowDbNull is always set
> to "False" or only the FAC_CODE Column should set to "False". Maybe the
> problem is here ?
I've already found this. Maybe Carlos knows where's the bottleneck when
comunicating with VS.
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
> It could be i have done some changes some days that should help on that = > > ( While it's not possible to know what is being done by the VS to = > > generate the commands ... and what information is being used for that = > > ... :P ) > What version of the provider ( DDEX and ADO.NET ones )are you using ?? > i use the 2.0.1.0. - 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
Hello: > If we look the different parameter we can see that AllowDbNull is always set > to "False" or only the FAC_CODE Column should set to "False". Maybe the > problem is here ? It could be i have done some changes some days that should help on that ( While it's not possible to know what is being done by the VS to generate the commands ... and what information is being used for that ... :P ) What version of the provider ( DDEX and ADO.NET ones )are you using ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
>
> IMHO it's because FAC_SELECTION doesn't have default value, so VS is not
> able to be 100% sure whether the insert will be OK (i.e. generator in
> trigger can "fix" this, but VS doesn't know this).
>
thanks jiro for the rapidity,
but i will try with this :
CREATE TABLE ACH_FAM (
FAC_CODE SMALLINT NOT NULL,
FAC_NOMVARCHAR(30) DEFAULT 'test',
FAC_SELECTION SMALLINT DEFAULT 1
);
and i have the same problem and i will try with an access database and it's
works fine.
More over when i put all column in the select command the insert command is
generated and the code is :
INSERT INTO "ACH_FAM" ("FAC_CODE", "FAC_NOM", "FAC_SELECTION")
VALUES (@FAC_CODE, @FAC_NOM, @FAC_SELECTION)
If we look the different parameter we can see that AllowDbNull is always set
to "False" or only the FAC_CODE Column should set to "False". Maybe the
problem is here ?
-
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with ddex and tableadapter
le roy arnaud wrote:
> CREATE TABLE ACH_FAM (
> FAC_CODE SMALLINT NOT NULL,
> FAC_NOMVARCHAR(30),
> FAC_SELECTION SMALLINT
> );
>
> when i create a tableadpter with this sql command :
> "SELECT FAC_CODE,FAC_NOM,FAC_SELECTION FROM ACH_FAM".
> All the command are generated but if i create a tableadapter with :
> "SELECT FAC_CODE,FAC_NOM FROM ACH_FAM".
> The insert command it's not generated.
IMHO it's because FAC_SELECTION doesn't have default value, so VS is not
able to be 100% sure whether the insert will be OK (i.e. generator in
trigger can "fix" this, but VS doesn't know this).
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Problem with ddex and tableadapter
Hello, I have a problem with the tableadapter and the ddex provider i will try to explain you with an exemple : I have this table : CREATE TABLE ACH_FAM ( FAC_CODE SMALLINT NOT NULL, FAC_NOMVARCHAR(30), FAC_SELECTION SMALLINT ); when i create a tableadpter with this sql command : "SELECT FAC_CODE,FAC_NOM,FAC_SELECTION FROM ACH_FAM". All the command are generated but if i create a tableadapter with : "SELECT FAC_CODE,FAC_NOM FROM ACH_FAM". The insert command it's not generated. if someone can try with the same exemple ? thanks - 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
