Julien Ferraro | 1 Apr 10:03 2006
Picon

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 aborted
The returned message was: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 19
DROP
 
regards
 
Julien Ferraro - WilLow
6, chemin Fontbrune - 97490 La Bretagne
0262 24 98 85 - 0692 28 85 43
 
 
Carlos Guzmán Álvarez | 1 Apr 11:23 2006
Picon

Re: 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
Raigo | 1 Apr 18:57 2006
Picon

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
Carlos Guzmán Álvarez | 1 Apr 21:45 2006
Picon

Re: 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
Maciak | 2 Apr 00:01 2006
Picon

Re: 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"" <carlosga@...>
napisal w 
wiadomosci news:442ED851.4000507@...
> 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@...
> 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
Maciak | 1 Apr 23:55 2006
Picon

Re: Some questions about NetProvider and

No, It's Windows Application.

Uzytkownik ""Carlos Guzmán Álvarez"" <carlosga@...>
napisal w 
wiadomosci news:442D097E.4080400@...
> 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@...
> 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
Carlos Guzmán Álvarez | 2 Apr 11:29 2006
Picon

Re: Some questions about NetProvider and

Hello:
> No, It's Windows Application.

Huummmm and the the database file exists in that path in the firebird 
server machine ??

--

-- 
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
Carlos Guzmán Álvarez | 2 Apr 15:47 2006
Picon

Re: ObjectDataSource and Firebird.Provider

Hello:
>
> I'm trying to use an ObjectDataSource and a TableAdapter where I have 
> builded some queries and I'm not able to see the querie on the 
> ObjectDataSource.
>
> How do I use the ObjectDataSource with the FirebirdClientProvider?
>
> I'm using VS2005 Pro + RC1
>
Have you done a test using Sql Server and the queries get shown ??
>

--

-- 
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
Charles Urbina | 2 Apr 20:09 2006
Picon

Re: ObjectDataSource and Firebird.Provider

Carlos,

I found  the problem. The reason was  some bug in VS 2005 with the table adapter name. I changed my  tableadptername  to a shorter one and the problem was gone.

 

Thanks for your reply

Charles



 

From:  Carlos Guzmán Álvarez <carlosga-XnAhQTnVLytMqUckJh7upg@public.gmane.org>
Reply-To:  firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
To:  firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Subject:  Re: [Firebird-net-provider] ObjectDataSource and Firebird.Provider
Date:  Sun, 02 Apr 2006 15:47:54 +0200
>Hello:
>>
>>I'm trying to use an ObjectDataSource and a TableAdapter where I
>>have builded some queries and I'm not able to see the querie on the
>>ObjectDataSource.
>>
>>How do I use the ObjectDataSource with the FirebirdClientProvider?
>>
>>I'm using VS2005 Pro + RC1
>>
>Have you done a test using Sql Server and the queries get shown ??
>>
>
>
>
>--
>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-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
>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

Maciak | 2 Apr 20:49 2006
Picon

Re: Some questions about NetProvider and

> Huummmm and the the database file exists in that path in the firebird=20
> server machine ??
>
My database's file is "C:\mydb.fdb". That file exists.

I created new Windows Application. I placed "FbConnection1" on a Form1 and 
configurated its "ConnectionString" property - Data Source = localhost, 
Database = "C:\mydb.fdb", Servet Type = "Embedded Server". I hit "Test" 
button and the message was - Connection successful.

Then I placed "FbDataAdapter1", configured it ( i chose FbConnection1 as 
connection, "Use SQL",  "Select * from PEOPLE") and then, using 
FbDataAdapter,  I generated new DataSet "DS1".

Next, I placed "DataGridView1" on my form. I set up its properties - 
DataSource = "DS1", DataMember = "Table".

Finally i wrote a code for Form1_Load event:

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As 
System.EventArgs) Handles MyBase.Load
        FbDataAdapter1.Fill(DS, "Table")
End Sub

I started debugging my program and it worked fine :) All the data from my 
table appeared  in the grid.

I closed my program, returned to VisualStudio and in the "Server Explorer" 
tab I chose Data Connection "localhost(MYDB)" by clicking on a "+" and 
expanding that nod. Next, i debugged my program and i received that error - 
"I/O error for file C:\MYDB.FDB. Error while trying to open file"

I've found 2 more (possibly) bugs...

1) When I placed FbDataAdapter and it generated DataSet - in "Generate 
DataSet" window i couldn't choose existing Dataset ( that option is always 
gray and inactive, even i've got another DataSet on my form) and, in bottom 
section of thet window, there are 3 CheckBoxes - the first one says - "Add 
this DataSet to the"  To the... what? The sentence is cut in a half...

2) If in my table a column has a name like "PEOPLE_I_LIKE", in DataSet the 
name will be changed to PEOPLEILIKE. So that column won't be displayed in 
DataGrid... I must change that name in DataSet manually...

Martin 

-------------------------------------------------------
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

Gmane