"every time you use sql server for more than crud then you are married to sql serve" And that is still absolutism. Which in practical programming does not work.

Based on Accept purchase - FONDY Documentation[^] I think you are not setting the signature correctly. based on your code you set signature wrong, I think, it's hard to read. They are expecting a sha1 hash of password|amount|currency|merchant_id|order_id|order_desc. Maybe I am not reading your post correctly because it is all lumped together, but it seems to me that the problem is the signature is not being set to a sha1 hash of those items based on result_2 = cursor.fetchone() and signature = str(result_2[0]) it is set to payment_id.

Code4Ever wrote: could it handle 500 read/write requests No sorry that is not a valid question based on your original post. Exactly how are 2000 users supposed to generate that many messages at one time?

Thanks Richard, thats really great. A little correction to the following line: using (SQLiteCommand dbCom = new SQLiteCommand("INSERT INTO Dateien (Pfad, Datei) VALUES ($Pfad, $Datei)")) to using (SQLiteCommand dbCom = new SQLiteCommand("INSERT INTO Dateien (Pfad, Datei) VALUES ($Pfad, $Datei)", dbConn, dbTrans)) And now it works perfectly. And wow, it's done in 12 seconds !!! Very impressive !!! THANKS!

Alex Wright 2022 wrote: public string Password { get; set; } You appear to be storing your users' passwords in plain text. Don't do that! Secure Password Authentication Explained Simply[^] Salted Password Hashing - Doing it Right[^] ASP.NET already provides a built-in authentication system which does the right thing for you: Introduction to Identity on ASP.NET Core | Microsoft Learn[^] "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

if you are looking for portability without having to install software on the host machine and do not need to share the DB with another process, go with SQLite. it works fantastic, most languages have support baked in, and you can still pass structured queries. last I read I think there is a 4TB limit. if the *.mdb gives you something more that SQLite doesn't have, choose that. to be honest I haven't touched an Access db from code in a couple decades, so I'm not all sure what it offers currently. if you are not worried about portability use SQL express, or a no-SQL DB for document storage. both are good, it all depends on what you plan to do with the data.

In what respect? Russian and Chinese players invariably use mod menus as do quite a lot of Germans. And I see no problem with blocking anyone from a given country being able to connect to my computer through the game, do you? It’s not as if it will affect their game as all that will happen is I won’t be in the same server as them.

mo1492 wrote: I Knew if I asked the question I would get it to work. That's the way if goes, sometimes - it's known as Rubber Duck Debugging[^] :laugh: "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt AntiTwitter: @DalekDave is now a follower!

I have been using libre office for years. I only use MSOffice at work when I have tooo. To err is human to really elephant it up you need a computer

raddevus wrote: I need to actually insert a System.DbNull.Value into the databse -- that's a true DBNull -- not the String null which the db chokes on. That statement makes no sense. Given a string/text value in a database it can have one of the following values. 1. Null 2. Empty string. Some databases do not allow this 3. Any other non-empty value. That list does not include 'DBNull'. The 'DBNull' value is usually a value that is intended as a stand in for results for the first item in the list above. Perhaps your real problem is that you need to represent the following 1. A value that is not null 2. User did not 'choose' anything. So you need to represent 'no value', but you cannot use 'null'. In the above you then use a magical value. If your database supports it and there NO chance it will be needed then an empty string can be used. But otherwise some nonsensical value is chosen. For example say you need to provide a customer telephone number. So you allow numbers. But for your special value you allow 'xxx-xxx-xxxx'. Naturally you must special case the code. HOWEVER, this is not an idea solution. And you should first examine the requirements that state that 'null' cannot be used in the first place. That the database does not allow it is NOT a argument for that. Because that to is just code and it must meet the needs of the business and not arbitrary developer opinions.

Did you forget to enable the blurbinator on this post? What do you get when you cross a joke with a rhetorical question? The metaphorical solid rear-end expulsions have impacted the metaphorical motorized bladed rotating air movement mechanism. Do questions with multiple question marks annoy you???

Ahh, I think I have found it: SQLite: sqlite_master (internal schema object)[^]

After consideration I have rewritten the Functions with just this one. Still testing but I believe it will correct the issue when the year changes. Function FourthTueOfNextMonth(dt As Date) As Date ' Start with the First Day of the Month, from the date passed in. ' Add one Month to that to get the first Day of the NEXT month. Dim currDate As Date = (New Date(dt.Year, dt.Month, 1)).AddMonths(1) 'Dim currDate As Date = (New Date(2022, 1, 1)).AddMonths(1) 'LINE ABOVE for testing set it to todays DATE ' Find the First Tuesday of the Month While currDate.DayOfWeek <> DayOfWeek.Tuesday currDate = currDate.AddDays(1) End While ' Add three more Weeks to jump to Fourth Tuesday Return currDate.AddDays(21) End Function

Assuming you mean SQLite: Appropriate Uses For SQLite[^]: SQLite works great as the database engine for most low to medium traffic websites (which is to say, most websites). The amount of web traffic that SQLite can handle depends on how heavily the website uses its database. Generally speaking, any site that gets fewer than 100K hits/day should work fine with SQLite. The 100K hits/day figure is a conservative estimate, not a hard upper bound. SQLite has been demonstrated to work with 10 times that amount of traffic. Note that writing to the database will lock the entire database file. Concurrent writes will not be supported. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

when is ODBC driver needed ? diligent hands rule....

How about FileSeek: Lightning Fast File Search by Binary Fortress Software[^]

It looks to me like the query string should be the SELECT query that pulls the data you want to transfer. The difficult we do right away... ...the impossible takes slightly longer.