Re: [Firebird-net-provider] Visual Studio 2005, .NET Framework 2.0
I had the same error when i was using IB Expert to create my tables. The solutions was to start using Database Workbench :) I've cteated new database file and then imported all tables, generatora and triggers from previous one, created by IB Expert. Now, everything is working fine :) Martin Uzytkownik ""Carlos Guzmán Álvarez"" <[EMAIL PROTECTED]> napisal w wiadomosci news:[EMAIL PROTECTED] > Hello: >> Dynamic DQL Error >> SQL Error Code =3D-104 >> Token unknown - line 1, char 411 >> "CHARACTER_LENGTH" >> >> also I get the same error when I drag GridView, DataList or any other=20 >> component of ASP.NET WebForm and try to configure data source. >> >> any ideas? > > The problem is with this line on the sql statement of the columns schema: > > cast(fld.rdb$character_length AS integer) AS "CHARACTER_LENGTH", > > looks like dialect 1 database didn't support quoted identifiers ... > > We can't left it without quotes, and i don't like the idea of chaning=20 > the column name at this stage > > --=20 > Carlos Guzm=E1n =C1lvarez > Vigo-Spain > > http://carlosga.blogspot.com/ > > > > --- > This SF.Net email is sponsored by xPML, a groundbreaking scripting > language > that extends applications into web and mobile media. Attend the live > webcast > and join the prime developer group breaking into this new coding > territory! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&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] Some questions about NetProvider and
No, It's Windows Application. Uzytkownik ""Carlos Guzmán Álvarez"" <[EMAIL PROTECTED]> napisal w wiadomosci news:[EMAIL PROTECTED] > Hello: >> Hi again :) >> >> I formatted my hard drive and then installed everything ( VS2005Prof +=20 >> VsSDKMarch2006 + NetProviderRC1) again. And now, it REALLY works :) >> >> I've found one strange thing - I'm using Emebeded version. If I set up=20 >> working connection to my database in "Server Explorer" tab and I run my= > =20 >> program i will receive an error - "I/O error for file C:\MYDATABASE.FDB= > .=20 >> Error while trying to open file" > The program is in ASP.NET ?? > > --=20 > Carlos Guzm=E1n =C1lvarez > Vigo-Spain > > http://carlosga.blogspot.com/ > > > > --- > This SF.Net email is sponsored by xPML, a groundbreaking scripting > language > that extends applications into web and mobile media. Attend the live > webcast > and join the prime developer group breaking into this new coding > territory! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&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] Visual Studio 2005, .NET Framework 2.0 RC1, Token unknown - line 1, char 411,"CHARACTER_LENGTH"
Hello: Dynamic DQL Error SQL Error Code =-104 Token unknown - line 1, char 411 "CHARACTER_LENGTH" also I get the same error when I drag GridView, DataList or any other component of ASP.NET WebForm and try to configure data source. any ideas? The problem is with this line on the sql statement of the columns schema: cast(fld.rdb$character_length AS integer) AS "CHARACTER_LENGTH", looks like dialect 1 database didn't support quoted identifiers ... We can't left it without quotes, and i don't like the idea of chaning the column name at this stage -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Visual Studio 2005, .NET Framework 2.0 RC1, Token unknown - line 1, char 411,"CHARACTER_LENGTH"
Visual Studio 2005, .NET Framework 2.0 RC1, Firebird 1.0.3 SQL dialect 1, Employee.gdb. I was able to create a conection and I can see the tables in Server Expolorer. But when I click on tables I get : Dynamic DQL Error SQL Error Code =-104 Token unknown - line 1, char 411 "CHARACTER_LENGTH" also I get the same error when I drag GridView, DataList or any other component of ASP.NET WebForm and try to configure data source. any ideas? --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&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] EXECUTE PROCEDURE in a script
Hello: I downloaded v1.7.1 of the provider with the ability to execute a procedure from a script. The procedure is executed properly but the following statements in the script raise an error. Can you send a sample test case to my private email please. ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] EXECUTE PROCEDURE in a script
Hi Carlos, I downloaded v1.7.1 of the provider with the ability to execute a procedure from a script. The procedure is executed properly but the following statements in the script raise an error. Imagine this script : CREAPE PROCEDURE MyProc ... END !! EXECUTE PROCEDURE MyProc !! DROP PROCEDURE MyProc!! When the script reaches the DROP PROCEDURE statement : an exception is thrown n exception was thrown when executing command: DROP PROCEDURE MyProc Batch execution abortedThe returned message was: Dynamic SQL ErrorSQL error code = -104Token unknown - line 1, char 19DROP regards Julien Ferraro - WilLow 6, chemin Fontbrune - 97490 La Bretagne 0262 24 98 85 - 0692 28 85 43