[Firebird-net-provider] SQL error - Different windows user accounts
Hi, I have very strange error with firebird .NET data provider. I have small .NET 2.0 application using Firebird 2.0.1 and Firebird .NET Data Provider 2.1.0.0 Beta 3. Database is on localhost. I have 2 windows user account on my machine (Win XP Prof), both are administrators. With first user account, application works as I expected. But if I run this app with second user account I get: 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 Thanks for any solution. - 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 stored procedure
I did what you posted and it works on some sprocs but not all... sometimes I
get a Dynamic SQL Error
parameter mismatch for procedure BE_LOCATION_INFO_INSERT.
I'll look more into this tomorrow with the DBA and post some more info.
On 5/13/07, Jiri Cincura <[EMAIL PROTECTED]> wrote:
Yes, you're right.
But if you want to use this statement as SP, use it like:
using (FbConnection conn = new FbConnection(cs))
{
conn.Open();
using (FbCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "test_insert"; // NO "test_insert(@id, ...)"
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@id", FbDbType.Integer).Value = 1;
...
cmd.ExecuteNonQuery();
}
}
So, not to place parameters into command text into braces (that is what
I've missed in your first mail). Then it will be working as you expect.
Sorry for confusion. ;)
--
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 syntax for inserting data into
Some extra info: I use ASP.NET 2.0 on the server and my globalization configuration is set to UTF-8 in requestEncoding, responseEncoding and fileEncoding. The FireBird Data Provider is version 2.1.0.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
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
You only need to reference provider for CF. You can download it from
firebirdsql.org site. The 1.7 isn't needed (it's for .NET FW 1.1).
--
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
[Firebird-net-provider] Compact Framework help
Hi I use VS2003 (Windows CE 4.2, CF 2). I would like to connect to a firebird database, but i can't. I have firebird.provider 1.7, and compact framework FirebirdSql.Data.FirebirdClient.dll. I can't add reference FirebirdSql.Data.FirebirdClient.dll, only FirebirdSql.Data.Firebird.dll... Oke. on the solution view => add existing item... ==>FirebirdSql.Data.FirebirdClient.dll, set content...oke. Build, deploy... I have these file on emulator: teszt.exe, FirebirdSql.Data.Firebird.dll, FirebirdSql.Data.FirebirdClient.dll But the FbConnection.Open() make exception :MissingMethodException. (ping oke) Any Suggestion,help Thanks -- 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] Provider 2.1.0.0 FBBackup Execute Method throws Object Ref Exception
Michele Lepri wrote:
> Hi, it's known and solved problem (look at the bug-tracker), but for
> now, the fix is un the svn ^^
> bye
> Michele
Ah, I was testing this against SuperServer. :) That was the problem. I
comletely forgot about embedded problem.
You should say this sooner. ;)
--
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] Provider 2.1.0.0 FBBackup Execute Method throws Object Ref Exception
Muthu Annamalai ha scritto: > I was using version 2.0.1.0 and backup method worked properly. Yesterday I > changed the provider to version 2.1.0.0. In the new version fbbackup execute > method I am getting Object Reference exception. Then I switched back to the > old one and there is no exception. I am using Firebird server version is > 2.0.0.12748. Hi, it's known and solved problem (look at the bug-tracker), but for now, the fix is un the svn ^^ bye Michele - 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
Carlos Guzmán Álvarez 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.
Looks like we have some woodoo in SPs. :)
--
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] Provider 2.1.0.0 FBBackup Execute
Hello: > b.Verbose = true; And if you are setting this option could you enable the event that outputs the work being done by the server, please (ServiceOutput event) - 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
Hello: > Jiri you are probably one of the people of this list that knows the most > about Firebird but I have to say (just for the record if anyone else see > this post) that your answer is incorrect. The right statement is > "execute procedure BE_BOOKING_INSERT(@BookingID, @UserID, @EventID, > @DateFrom, @DateTo, @TimeFrom, @TimeTo, @Comments, @LocationName, > @LocationAddress, @LocationZipcode, @LocationCity, @ContactName, > @ContactPhone, @ContactEmail, @EventContactName, @EventContactPhone)" > The first always gives a Dynamic SQL Error exception. 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
Re: [Firebird-net-provider] SQL syntax for inserting data into stored procedure
Yes, you're right.
But if you want to use this statement as SP, use it like:
using (FbConnection conn = new FbConnection(cs))
{
conn.Open();
using (FbCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "test_insert"; // NO "test_insert(@id, ...)"
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@id", FbDbType.Integer).Value = 1;
...
cmd.ExecuteNonQuery();
}
}
So, not to place parameters into command text into braces (that is what
I've missed in your first mail). Then it will be working as you expect.
Sorry for confusion. ;)
--
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] Provider 2.1.0.0 FBBackup Execute Method throws Object Ref Exception
Muthu Annamalai wrote:
> Thanks for replying, here is my code,
>
>
Hi,
I've rewrite your code into C#, because I'm not familiar with VB.NET,
but should be same:
if (backupPath == string.Empty)
{
return false;
}
try
{
FbBackup b = new FbBackup();
b.ConnectionString =
@"User=SYSDBA;Password=masterkey;Database=localhost:ucime;Dialect=3;Charset=NONE;Role=;Pooling=true;MinPoolSize=0;MaxPoolSize=50;PacketSize=8192;ServerType=0;";
b.BackupFiles.Add(new FbBackupFile(backupPath, 2048));
b.Verbose = true;
b.Options = FbBackupFlags.IgnoreLimbo;
b.Execute();
if (b.State == FbServiceState.Closed)
{
return true;
}
}
catch (Exception ex)
{
//HandleException(ex, "Backup Database");
return false;
}
return true;
when I try this with 2.0.1 (installed in my GAC, downloaded from site)
works fine. When I change reference to 2.1.0 (beta 3; downloaded from
site, compiled) works fine too. :o
Can you provide complete stack trace of exception?
--
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
