Re: [Firebird-net-provider] Special symbols getting converted to something else
Thanks guys. I changed the character set to ISO8859_1, and everything
works great now!
-Joe
On Wed, Nov 26, 2014 at 3:09 AM, Hernán Martínez <
hernan.marti...@obi-corp.com> wrote:
> www.destructor.de/firebird/charsets.htm
>
> Hernán MF S
>
> El 26/11/2014, a las 5:04, Joseph Martinez
> escribió:
>
> Ok, I was able to dump it into a file. From the auto-detection that I ran
> it through, it looks like it's either ISO-8859-1 or Windows-1252.
>
> What exact strings would I put in my connection string to use one of those?
>
> Here's my original line of code:
>
> entityBuilder.ProviderConnectionString =
> string.Format("character set=NONE;data source={0};initial catalog={1};;user
> id={2};password={3};isolationlevel=ReadCommitted", connparams.server,
> connparams.path, connparams.userid, connparams.password);
>
> If I replace "NONE" with "ISO-8859-1" or "Windows-1252", I get an
> exception saying:
>
> The underlying provider failed on Open.
> Invalid character set specified
>
> Is there a list of valid character set constants that it will accept?
>
> -Joe
>
>
> On Tue, Nov 25, 2014 at 11:26 PM, Jiří Činčura wrote:
>
>> Study http://www.firebirdsql.org/refdocs/langrefupd25.html .
>>
>> --
>> Mgr. Jiří Činčura
>> Independent IT Specialist
>>
>> --
>> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
>> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
>> with Interactivity, Sharing, Native Excel Exports, App Integration & more
>> Get technology previously reserved for billion-dollar corporations, FREE
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
>> ___
>> Firebird-net-provider mailing list
>> Firebird-net-provider@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>
>
>
> --
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
>
> http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
>
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
>
> --
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
>
> http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Special symbols getting converted to something else
Ok, I was able to dump it into a file. From the auto-detection that I ran
it through, it looks like it's either ISO-8859-1 or Windows-1252.
What exact strings would I put in my connection string to use one of those?
Here's my original line of code:
entityBuilder.ProviderConnectionString =
string.Format("character set=NONE;data source={0};initial catalog={1};;user
id={2};password={3};isolationlevel=ReadCommitted", connparams.server,
connparams.path, connparams.userid, connparams.password);
If I replace "NONE" with "ISO-8859-1" or "Windows-1252", I get an exception
saying:
The underlying provider failed on Open.
Invalid character set specified
Is there a list of valid character set constants that it will accept?
-Joe
On Tue, Nov 25, 2014 at 11:26 PM, Jiří Činčura wrote:
> Study http://www.firebirdsql.org/refdocs/langrefupd25.html .
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> --
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
>
> http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Special symbols getting converted to something else
I am not experienced with ISQL. Do you have an example of a command that would output the value of a VARCHAR field as hex? -Joe On Tue, Nov 25, 2014 at 11:06 PM, Jiří Činčura wrote: > isql > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > > -- > Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server > from Actuate! Instantly Supercharge Your Business Reports and Dashboards > with Interactivity, Sharing, Native Excel Exports, App Integration & more > Get technology previously reserved for billion-dollar corporations, FREE > > http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Special symbols getting converted to something else
What tool could I use to dump it from the database in hex to a file? -Joe On Tue, Nov 25, 2014 at 10:44 PM, Jiří Činčura wrote: > Absolutely. Put there some text. Dump it in hex to file. Open it in some > “smart” editor – a lot of editors have a feature to guess encoding. > > You can also do it to with encoding tables. But that’s manual and slow. :) > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > -- > Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server > from Actuate! Instantly Supercharge Your Business Reports and Dashboards > with Interactivity, Sharing, Native Excel Exports, App Integration & more > Get technology previously reserved for billion-dollar corporations, FREE > > http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Special symbols getting converted to something else
Would there be a way to deduce the character that is being used by the C++ application by putting certain characters in, and then somehow examining what is actually stored in the database? -Joe On Tue, Nov 25, 2014 at 10:25 PM, Jiří Činčura wrote: > Hard to say what charset the C++ is actually using. But using NONE on > database was *very* bad choice. The encoding might be pretty screwed in. > Use UTF8 in .NET, but I expect you’re going to do manual transliteration > because of NONE charset used. > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > > -- > Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server > from Actuate! Instantly Supercharge Your Business Reports and Dashboards > with Interactivity, Sharing, Native Excel Exports, App Integration & more > Get technology previously reserved for billion-dollar corporations, FREE > > http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Special symbols getting converted to something else
The database was created with character set of "NONE". In my C++/IBObjects project, the CharSet is Null. In my .NET project, the connection string has the character set as "NONE". So what wouldn't be matching? I can't really change the database or the C++ project at this point. Too many users with many years of data stored the way it is now. What can I change in my .NET project to fix the issue that I'm having? -Joe On Tue, Nov 25, 2014 at 9:17 PM, Jiří Činčura wrote: > You have very likely mismatch in charsets. To prevent it, basically, just > use UTF8, everywhere. > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > > -- > Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server > from Actuate! Instantly Supercharge Your Business Reports and Dashboards > with Interactivity, Sharing, Native Excel Exports, App Integration & more > Get technology previously reserved for billion-dollar corporations, FREE > > http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Special symbols getting converted to something else
I'm having a strange problem. When special symbols are stored in my database, if the record is edited, it gets written back to the database as a different symbol or several symbols. Here's an example: I have a Firebird application that uses C++ and IBObjects. If I enter or paste into a database field some text containing the Trademark symbol ™ (typed alt-0153. Bytes are e2 84 a2), it shows correctly in the database, on the screen, etc. Now, if I access the same database record using .NET, the Firebird .NET provider, and Entity Framework, and edit that record, even if I don't modify the field containing the trademark symbol, when I save the record, it writes the trademark symbol back as: â„¢ (bytes are c3 a2 e2 80 9e c2 a2). Here is the code that I'm using: PRODUCT p = db.PRODUCTS.FirstOrDefault(pp => pp.PRODBARCODE == ecp.PRODBARCODE && pp.STOREID == _storeid); p.PRODWEBDIRTY = "F"; db.Entry(p).State = EntityState.Modified; db.SaveChanges(); Note that PRODWEBDIRTY is not the field containing the trademark symbol. I guess it's just writing back the entire record to the database, but with the special characters converted. Why does it do this? How can I prevent it? -Joe -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Entity Framework woes (cannot update model from database)
When I try to do "Update model from database", I get the following error: An exception of type 'Microsoft.VSDesigner.Data.Local.ConnectionStringConverterServiceException' occurred while attempting to update from the database. The exception message is: ''. I searched this error, and I find a reply from Jiri from about a year ago that says, "DDEX not installed correctly." I then performed the following steps: 1) Uninstalled the Firebird DDEX provider and the Firebird ADO.Net provider 2) Replaced machine.config in the following folders with the machine.config.default file: C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config 3) Reinstalled ADO.NET provider from NETProvider-4.1.0.0.msi 4) Reinstalled DDEX provider from DDEXProvider-3.0.1.0.msi However, I still get the same error. I can open the .EDMX file and view the entities, but I cannot update the model from the database. Here is my connection string: metadata=res://*/TRS11Model.csdl|res://*/TRS11Model.ssdl|res://*/TRS11Model.msl;provider=FirebirdSql.Data.FirebirdClient;provider connection string='initial catalog="C:\Program Files (x86)\TRS11\Data\DATA1100.FDB";user id=sysdba;password=masterkey;data source=localhost' The database path, userid, and password are all correct. Does this still sound like an issue with DDEX not being installed correctly? If so, what else should I do to install it correctly, if my above steps are not sufficient. -Joe -- Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Using FBConnect to retrieve TWO output parameters from stored procedure
Ok, I didn't realize that FBCommand wasn't something completely specific
to Firebird. I see now that it implements IDBCommand. I looked that up,
and found the docs and some sample code for using IDBCommand with output
parameters online, and I am now able to run my stored procedures, and
they're now working as expected!
Thank you Jiri for all your help this week. You have helped get me over a
major hurdle. I really appreciate it.
-Joe
On Fri, Jan 11, 2013 at 11:03 AM, Jiri Cincura wrote:
> On Fri, Jan 11, 2013 at 4:24 PM, Joseph Martinez
> wrote:
> > How would I call the above SP and retrieve both the values of NEW_QTY and
> > AVG_COST?
>
> Define output parameters, as with any other ADO.NET. Nothing specific
> here for Firebird.
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> --
> Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
> much more. Get web development skills now with LearnDevNow -
> 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
> SALE $99.99 this month only -- learn more at:
> http://p.sf.net/sfu/learnmore_122812
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122412___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Using FBConnect to retrieve TWO output parameters from stored procedure
I've figured out how to use FBConnect to call ExecuteScalar() to retrieve a
singe output parameter from a stored procedure that returns only one value,
like this:
FbCommand cmd = new FbCommand("PREDICT_COST_1");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@BARCODE", barcode);
cmd.Parameters.Add("@STOREID", storeid);
using (cmd.Connection = new FbConnection(ConnString))
{
cmd.Connection.Open();
var result = cmd.ExecuteScalar();
thecost = Convert.ToDouble(result);
}
I also have a stored procedure defined as follows:
create procedure PRODUCT_OUT_1
(BARCODE VarChar(25), QTY Double Precision, QTY_IS_DIFF Char(1))
returns (NEW_QTY Double Precision, AVG_COST Double Precision)
as
...
How would I call the above SP and retrieve both the values of NEW_QTY and
AVG_COST?
-Joe
--
Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
much more. Get web development skills now with LearnDevNow -
350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122812___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Trouble retrieving stored procedure result with ExecuteStoreQuery
Ok, thanks. Is there any way possible in .NET to call a stored procedure
and retrieve the output parameter?
-Joe
On Thu, Jan 10, 2013 at 9:43 PM, Jiri Cincura wrote:
> On Thu, Jan 10, 2013 at 6:24 PM, Joseph Martinez
> wrote:
> > Ok, so you're saying that without changing the SP, there's no way to
> > retrieve the result via ExecuteStoreQuery? If that's the case, do you
> know
> > of any other method to run the query and retrieve the scalar result from
> > .NET?
>
> This is not a scalar result. It's result it output parameter.
>
> > By the way, do you think this could also be the issue with me being
> unable
> > to import the SP's into Entity Framework (see other thread)?
>
> Yes.
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> --
> Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
> much more. Get web development skills now with LearnDevNow -
> 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
> SALE $99.99 this month only -- learn more at:
> http://p.sf.net/sfu/learnmore_122812
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
much more. Get web development skills now with LearnDevNow -
350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122812___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Trouble retrieving stored procedure result with ExecuteStoreQuery
Ok, so you're saying that without changing the SP, there's no way to
retrieve the result via ExecuteStoreQuery? If that's the case, do you
know of any other method to run the query and retrieve the scalar result
from .NET?
By the way, do you think this could also be the issue with me being unable
to import the SP's into Entity Framework (see other thread)?
-Joe
On Thu, Jan 10, 2013 at 2:39 AM, Jiri Cincura wrote:
> The procedure needs to be selectable.
>
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> --
> Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
> MVPs and experts. ON SALE this month only -- learn more at:
> http://p.sf.net/sfu/learnmore_122712
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122712___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Trouble retrieving stored procedure result with ExecuteStoreQuery
I have a stored procedure in my database that returns a scalar value (a
double). I am trying to figure out how to get the results via
ExecuteStoreQuery, using Entity Framework. Here is my c# code:
var db = new MyEntities();
var oc = ((IObjectContextAdapter)db).ObjectContext;
string myquery = "execute procedure PREDICT_COST_1 ('12345',1)";
var result = oc.ExecuteStoreQuery(myquery);
double thecost = result.First();
If I set a breakpoint before the last line and inspect the result variable,
it is an empty ObjectResult. So, the last line raises an exception when I
call First() because it is empty.
I know that the stored procedure should be returning a value, because if I
execute it directly against the database with the same parameters, it
returns the correct value.
Here's the source for my stored procedure:
create procedure PREDICT_COST_1 (BARCODE VarChar(25), STOREID INTEGER)
returns (THE_COST Double Precision) as
DECLARE VARIABLE TEMP_COST Double Precision;
BEGIN
select first 1 itemcost from orderitems A inner join orders B on A.orderid
= B.orderid
where A.itembarcode = :BARCODE and A.itemqtyordered > A.itemqtyreceived
and A.itemcost > 0 order by B.orderdate desc into :TEMP_COST;
if (TEMP_COST is null) then
BEGIN
select first 1 A.vpcost from vendorproducts A inner join products B
on A.VPUPC = B.PRODBARCODE and A.VPVENDOR = B.PRODSOURCE
where B.prodbarcode = :BARCODE and A.STOREID = :STOREID and A.vpcost > 0
into :TEMP_COST;
if (TEMP_COST is null) then
BEGIN
select first 1 vpcost from vendorproducts
where vpupc = :BARCODE and STOREID = :STOREID and vpcost > 0 into
:TEMP_COST;
END
END
THE_COST = TEMP_COST;
END
What am I doing wrong?
-Joe
--
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612 ___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Framework not importing stored procedures
Just in case it helps, here's the source for one of my SPs:
create procedure PREDICT_COST_1 (BARCODE VarChar(25), STOREID INTEGER)
returns (THE_COST Double Precision) as
DECLARE VARIABLE TEMP_COST Double Precision;
BEGIN
select first 1 itemcost from orderitems A inner join orders B on A.orderid
= B.orderid
where A.itembarcode = :BARCODE and A.itemqtyordered > A.itemqtyreceived
and A.itemcost > 0 order by B.orderdate desc into :TEMP_COST;
if (TEMP_COST is null) then
BEGIN
select first 1 A.vpcost from vendorproducts A inner join products B
on A.VPUPC = B.PRODBARCODE and A.VPVENDOR = B.PRODSOURCE
where B.prodbarcode = :BARCODE and A.STOREID = :STOREID and A.vpcost > 0
into :TEMP_COST;
if (TEMP_COST is null) then
BEGIN
select first 1 vpcost from vendorproducts
where vpupc = :BARCODE and STOREID = :STOREID and vpcost > 0 into
:TEMP_COST;
END
END
THE_COST = TEMP_COST;
END
Do you see anything about it that may cause it to not get imported?
-Joe
On Wed, Jan 9, 2013 at 9:03 AM, Joseph Martinez wrote:
> Jiri,
>
> I'm not familiar with Trace API. What output log would I look at, and how?
>
> -Joe
>
>
> On Wed, Jan 9, 2013 at 5:13 AM, Jiri Cincura wrote:
>
>> Without any further clue, it's hard to guess. Is the database queried
>> for SPs? Do you see the query (TraceAPI, Output log, ...)?
>>
>> --
>> Jiri {x2} Cincura (x2develop.com founder)
>> http://blog.cincura.net/ | http://www.ID3renamer.com
>>
>>
>> --
>> Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
>> and much more. Keep your Java skills current with LearnJavaNow -
>> 200+ hours of step-by-step video tutorials by Java experts.
>> SALE $49.99 this month only -- learn more at:
>> http://p.sf.net/sfu/learnmore_122612
>> ___
>> Firebird-net-provider mailing list
>> Firebird-net-provider@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>
>
>
--
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612 ___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Framework not importing stored procedures
Jiri,
I'm not familiar with Trace API. What output log would I look at, and how?
-Joe
On Wed, Jan 9, 2013 at 5:13 AM, Jiri Cincura wrote:
> Without any further clue, it's hard to guess. Is the database queried
> for SPs? Do you see the query (TraceAPI, Output log, ...)?
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> --
> Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
> and much more. Keep your Java skills current with LearnJavaNow -
> 200+ hours of step-by-step video tutorials by Java experts.
> SALE $49.99 this month only -- learn more at:
> http://p.sf.net/sfu/learnmore_122612
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612 ___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Framework not importing stored procedures
Jiri,
There are no messages in the Error window.
The only thing in the Output window is:
Generated model file: TRS11Model.edmx.
Loading metadata from the database took 00:00:00.5293632.
Generating the model took 00:00:20.3206378.
-Joe
On Tue, Jan 8, 2013 at 11:13 PM, Jiri Cincura wrote:
> On Tue, Jan 8, 2013 at 6:55 PM, Joseph Martinez
> wrote:
> > Ok, I found the SSDL file, and there are no references to the stored
> > procedures in it.
>
> Then SPs were not imported. Probably there's a message in error/output
> window.
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> --
> Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
> and much more. Keep your Java skills current with LearnJavaNow -
> 200+ hours of step-by-step video tutorials by Java experts.
> SALE $49.99 this month only -- learn more at:
> http://p.sf.net/sfu/learnmore_122612
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612 ___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Framework not importing stored procedures
Ok, I found the SSDL file, and there are no references to the stored
procedures in it.
-Joe
On Tue, Jan 8, 2013 at 4:10 AM, Jiri Cincura wrote:
> SSDL part of EDM.
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> --
> Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
> and more. Get SQL Server skills now (including 2012) with LearnDevNow -
> 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
> SALE $99.99 this month only - learn more at:
> http://p.sf.net/sfu/learnmore_122512
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Framework not importing stored procedures
Jiri,
I'm not sure what you mean by "in store model".
-Joe
On Mon, Jan 7, 2013 at 9:31 PM, Jiri Cincura wrote:
> Are the SPs in store model?
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> --
> Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
> and more. Get SQL Server skills now (including 2012) with LearnDevNow -
> 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
> SALE $99.99 this month only - learn more at:
> http://p.sf.net/sfu/learnmore_122512
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Entity Framework not importing stored procedures
I previously created an Entity Framework model for a Firebird 2.5 database in Visual Studio 2012 Professional. At the time, I imported the tables only, and not the stored procedures. Now, I need to access some of my stored procedures. I right-click on the .edmx diagram, and selected "Update Model from Database". On the "Add" tab, it correctly shows me the list of stored procedures in the database. I select the ones I want and click "Finish". The output window shows the following: Generated model file: TRS11Model.edmx. Loading metadata from the database took 00:00:00.3591910. Generating the model took 00:00:18.1822456. However, it doesn't seem like it did anything. I can't find anything about the stored procedures in the diagram. Also, if I go to "Update Model...", and go to the "Refresh" tab, the stored procedures section is empty. If I right-click on the diagram and select "Add New->Function Import", the "Stored Procedure / Function Name" combo box is empty. I have been using Firebird for a long time, but I am very new at ADO.NETand Entity Framework, so I think I must be just missing something. What might I be doing wrong? -Joe -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122412___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird ADO.NET Data Provider 3.0.2 - installation ossue over VS 2010
When I've had trouble getting it installed correctly on a non-virgin machine, the following steps usually work for me: 1) Uninstall DDEX Provider 2) Uninstall Firebird ADO.Net Provider 3) Uninstall Visual Studio Professional 4) Reboot 5) Search the computer for all copies of machine.config in any .net framework folder. For each copy I find, I rename it to machine.config.BeforeDefaulting. Then, copy machine.config.default to machine.config (be sure to use the one in the same folder). Repeat for each copy of machine.config that was found. 6) Reboot again 7) Reinstall Visual Studio Professional 8) Reboot again 9) Reinstall Firebird ADO.Net Provider from the MSI 10) Reinstall DDEX Provider from the MSI 11) Reboot again Some of those reboots may not be necessary, but I do them all just to be sure. -Joe On Thu, Dec 27, 2012 at 6:48 AM, karasi wrote: > Thank your for answering. Really, i tryed installing Driver with that > sequesnce i've given above... First, MSI, then manually edited machine.cfg > and importing REGs. But without manually installing after running MSIs > actually there was no "Firebird Data Source" in "New data source" dialog in > VS. And only manual i found was readme.txt in DDEX. > > > > -- > View this message in context: > http://firebird.1100200.n4.nabble.com/Firebird-ADO-NET-Data-Provider-3-0-2-installation-issue-over-VS-2010-tp4632552p4632572.html > Sent from the firebird-net-provider mailing list archive at Nabble.com. > > > -- > Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, > MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current > with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft > MVPs and experts. ON SALE this month only -- learn more at: > http://p.sf.net/sfu/learnmore_122712 > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > -- Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and much more. Get web development skills now with LearnDevNow - 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122812___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
