Re: [Firebird-net-provider] Compact Framework help

2007-05-14 Thread Carlos Guzmán Álvarez
Hello:

> So, how can i use FirebirdSQL.Data.Firebirdclient.dll ??

That assembly is for the .net compact framework 2.0

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] SQL syntax for inserting data into

2007-05-14 Thread Jon Ege Ronnenberg

Not sure how this works, but if I set the Charset to NONE with a db with
Charset NONE I can insert/extract none ASCII characters. Possible the
provider translate all the characters.

On 5/13/07, Jon Ege Ronnenberg <[EMAIL PROTECTED]> wrote:


Probably yes, but I have to talk to the DBA. Also another problem was that
the data sent from the web server was in UTF-8 and the db wasn't. We changed
that by using IBExpert to copy everything to a new UNICODE_FSS database and
the connection string I changed to have Charset=UNICODE_FSS;.But now I don't
get special danish characters when I query the db, they disappear between
the db and server. Any ideas to why that might happen?

On 5/13/07, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote:
>
> The First example you have sent has a valid syntax too, and should work
> fine too, the query should be changed by the provider adding the execute
> procedure before executing the query.
>
> Could you send a sample database to my private email please ??
>
>
> -
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> ___
> 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 DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Compact Framework help

2007-05-14 Thread Jiri Cincura
Tomozi Peter wrote:
> Hi
> 
> Oke, but whene i want to add that dll
> (FirebirdSQL.Data.Firebirdclient.dll), the vs2003 says this dll is not
> a assembly, so i can't add.
> "Data Provider for .NET Compact Framework 2.0 (.exe) (107kb) "
> 
> So, how can i use FirebirdSQL.Data.Firebirdclient.dll ??

I'm not sure, but VS2003 has no support for .NET FW 2.0.

-- 
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Compact Framework help

2007-05-14 Thread Tomozi Peter
Hi

Oke, but whene i want to add that dll
(FirebirdSQL.Data.Firebirdclient.dll), the vs2003 says this dll is not
a assembly, so i can't add.
"Data Provider for .NET Compact Framework 2.0 (.exe) (107kb) "

So, how can i use FirebirdSQL.Data.Firebirdclient.dll ??
-- 
Tomozi Péter
http://tomozipeter.blogspot.com
http://tomozi.uw.hu

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] SQL error - Different windows user accounts

2007-05-14 Thread Mercea Paul
If u can't debug, put into a log file  and write every step!

Regards,
Paul

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf
> Of [EMAIL PROTECTED]
> Sent: Monday, May 14, 2007 12:50 PM
> To: For users and developers of the Firebird .NET providers
> Subject: Re: [Firebird-net-provider] SQL error - Different windows user
> accounts
> 
> The error happens during application startup, there are many SELECT
>  from (only SELECT), but I don't know which one, because error
> message don't show them. On my development machine, where I can debug,
> is everything ok
> 
> >  Původní zpráva 
> > Od: Jiri Cincura <[EMAIL PROTECTED]>
> > Předmět: Re: [Firebird-net-provider] SQL error - Different windows
> user accounts
> > Datum: 14.5.2007 10:58:59
> > 
> > Jiří Neužil wrote:
> > > Dynamic SQL error
> > > SQL error code = -104
> > > Token unknown - line 1, char 35
> > > 35
> > >
> > > That's all.
> > >
> > > Could someone tell me how is this possible? Same application, same
> > > database
> >
> > How the statement looks like?
> >
> > --
> > Jiri {x2} Cincura
> > http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
> >
> > -
> 
> > This SF.net email is sponsored by DB2 Express
> > Download DB2 Express C - the FREE version of DB2 express and take
> > control of your XML. No limits. Just data. Click to get it now.
> > http://sourceforge.net/powerbar/db2/
> > ___
> > 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 DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> ___
> 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 DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] SQL error - Different windows useraccounts

2007-05-14 Thread Dean Harding
> The error happens during application startup, there are many SELECT 
> from (only SELECT), but I don't know which one, because error message
> don't show them. On my development machine, where I can debug, is
> everything ok

In that case, I would suggest logging each statement *just before* it is
executed, and find out the one that causes the error that way.

If you create a third account, does it happen with that one? What is
different about the two accounts (for example, usernames, group memberships,
etc)?
 
Dean.



-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] SQL error - Different windows user accounts

2007-05-14 Thread Meuzil
The error happens during application startup, there are many SELECT  from 
(only SELECT), but I don't know which one, because error message don't show 
them. On my development machine, where I can debug, is everything ok

>  Původní zpráva 
> Od: Jiri Cincura <[EMAIL PROTECTED]>
> Předmět: Re: [Firebird-net-provider] SQL error - Different windows user 
> accounts
> Datum: 14.5.2007 10:58:59
> 
> Jiří Neužil wrote:
> > Dynamic SQL error
> > SQL error code = -104
> > Token unknown - line 1, char 35
> > 35
> > 
> > That's all.
> > 
> > Could someone tell me how is this possible? Same application, same 
> > database
> 
> How the statement looks like?
> 
> -- 
> Jiri {x2} Cincura
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
> 
> -
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> ___
> 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 DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] SQL error - Different windows user accounts

2007-05-14 Thread Jiri Cincura
Jiří Neužil wrote:
> Dynamic SQL error
> SQL error code = -104
> Token unknown - line 1, char 35
> 35
> 
> That's all.
> 
> Could someone tell me how is this possible? Same application, same 
> database

How the statement looks like?

-- 
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider