Re: [Firebird-net-provider] Compact Framework help
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
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
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
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
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
> 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
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
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