Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Not available for mssql database

Nykeriab

Trying to connect to my computer database. The user is created, and through Management studio, I can go right in. When you try to do it, it's a mistake. One year ago, he contacted mssql, and that code was working normally, the only thing that wasn't there was an instance and just walked straight to the host.

import pytds
with pytds.connect(dsn='qwer\\qwer', database='qwer', user='sa', password='12345', autocommit=True) as conn:
    cur = conn.cursor()
    print('ok')
    conn.close()

The next mistake comes out.

pytds.tds_base.LoginError: ("Cannot connect to server 'KEFIR740': [WinError 10054] Удаленный хост принудительно разорвал существующее подключение", ConnectionResetError(10054, 'Удаленный хост принудительно разорвал существующее подключение', None, 10054, None))

I've tried differently, and as in qwer's documentation, but it's still a mistake.

R
rielyn last edited by
Try to check the following:
1. Spread the server from BDE: ping -a UP address
2. Check whether the port on which you want to be connected to the OBD system: telnet ÉIPres par vonomer port
3. See if your OBD ssl requires
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

S

Problems with the database
Software Programming • php mysqli • • shizuka

2

0
Votes

2
Posts

0
Views

The var_dump clearly shows that data are not coming $_POST:SELECT l.nombreLo, l.ubicacion, c.valoracion FROM locales l INNER JOIN comentario c ON l.idLocal = c.idLocal WHERE l.nombreLo='' OR l.ubicacion = '' OR c.valoracion= In cases like these it is always convenient to evaluate the POST data. This can be done by means of temporary operators, which allow at the same time to evaluate and save the data in a variable that you can then use for the query. This also brings clarity to the code.For example:if (isset($_POST['buscaLocal'])) { #Evaluamos con un ternario, si está vacío asignamos NULL #Si se permiten valores por defecto en alguno de estos campos #en vez de NULL pones ese valor por defecto $nombre= !empty($_POST["nombre"]) ? $_POST["nombre"] : NULL; $localiz=!empty($_POST["localiz"]) ? $_POST["localiz"] : NULL; $valorac=!empty($_POST["valorac"]) ? $_POST["valorac"] : NULL; #Verificamos que los tres datos fueron llenados #Esta parte sólo se ejecutará si hay datos en las tres variables #Si alguna es NULL te mostrará el mensaje del else #Esto puede adaptarse, según la lógica de tu contexto if ($nombre && $localiz && $valorac) { #El require aquí, porque estamos seguros de usar la consulta require("../conexionBaseDatos/admin.php"); #Nótese que usamos las variables $sqlBusc = "SELECT l.nombreLo, l.ubicacion, c.valoracion FROM locales l INNER JOIN comentario c ON l.idLocal = c.idLocal WHERE l.nombreLo='$nombre' OR l.ubicacion = '$localiz' OR c.valoracion= $valorac"; #Aquí el resto del código } else { echo "Hay datos vacíos en el post. Revise el llenado de datos"; } #Esto cierra el if del isset } I've made relevant comments. If there's something you don't understand, you can ask in comments. I hope it serves you.Why do data come empty?You must control in the customer (formulary or other) that three data are being submitted with the keys nombre, localiz and valorac. If you have a form this must have in the name of the respective elements those three values. If you pass the data by Ajax the same, the object you pass must have those three keys and the same if you pass the data by URL.NOTE ON SECURITY:Your way of launching the consultation carries a serious security risk known as SQL injection. A malicious user can manipulate POST data to run harmful code in your system. You should arm the code using prepared consultations. When it is possible to inform on the subject.
K

Problem when storing decimal values in SQL Server
Software Programming • c sharp sql server asp.net mvc entity framework • • kalena

2

0
Votes

2
Posts

0
Views

A

Check your Web.config has the following statement:<system.web> <globalization culture="pt-BR" uiCulture="pt-BR" /> ... </system.web>
O

Exporting certificate without private key
SQL, Database Testing • sql server sql server 2016 always enc languagerypted • • obi

2

0
Votes

2
Posts

0
Views

Then I export the certificate and import it into the machine where the SQL Server is running. That defeats the purpose of using Always Encrypted if the server that is running SQL Server also has the certificate to decrypt all the data. Please, please, please don't do this! Put it on the client machine or a "tools" or "intermediate loading" machine to get the data in and out. Then remove the key and keep it only on the client machines that are locked down. I'd also keep, in the back of your mind, a solution for when a client machine is lost/stolen/breached (laptop), or a server is compromised. How do you find out, how long do you have to rotate CMKs, do you know how to rotate CMKs, etc. I am wondering is there any cases where I may need to export only the certificate without the privet key in the context of Always Encrypted feature (as the work of this certificate it to protect the column encryption keys only) ? The private key is what keeps everything safe, so no private key then no decryption. I can't think of any times when this would be useful.
Maintaining the role in OBD
Software Programming • python sqlite discord discord py • • emmalee

2

0
Votes

2
Posts

0
Views

The problem is, you're setting up a table, but you don't keep it, and you're trying to make a record.Add. connection.commit() aftercursor.execute("""CREATE TABLE IF NOT EXISTS users ( role_id BIGINT, id BIGINT )""") In your code, in this line.if cursor.execute(f'SELECT role_id FROM users WHERE role.id = {member.id}').fetchone() is None: Replace the name of the column role_id used role.id♪Also, on the record, you're trying to write three columns:("{member}", {member.id}, 0 ) But you have only two in the table.
R

Unicode-decode error utf-8 for ñ on python
Software Programming • python unic languageode anac languageonda • • Raziyah00

2

0
Votes

2
Posts

0
Views

It seems that the characters do not ascii on the Anaconda installation route pose problems. There are several https://github.com/ContinuumIO/anaconda-issues/issues/1613 in Github on this matter, and no good solution, except to create a new user without those characters in the name (it doesn't seem to me an option), or to install Anaconda out of that user's route (this could be better option).In the https://docs.anaconda.com/anaconda/user-guide/faq/#installing-anaconda can be read (translation and bold is mine):What folder should Anaconda install on Windows?We recommend installing Anaconda or Minicoda in a folder containing only ASCII characters and without spacesLike, C:\anaconda. Do not install it on routes that contain spaces, like C:\Program Files or C:\Archivos de Programaor containing Unicode characters outside the 7-bit ASCII range. This helps ensure proper operation and absence of errors when using any open source tool, both in Python 2 conda environments and Python 3.And perhaps it may also be relevant:Should I add Anaconda to Windows PATH?When installing Anaconda, we recommend that you do not add Anaconda to the PATH of windows, because that can interfere with other software. Instead, open Anaconda from the Windows Start menu, selecting Anaconda Prompt, or use Anaconda Navigator.As an extra recommendation, after reinstalling Anaconda on the right route, I would recommend you to edit the Windows environment variables and look for if there is still any reference to your old folder on the route with eñes, to remove them too.
database backup
Software Programming • c sharp sql backup server • • briley

2

0
Votes

2
Posts

0
Views

D

On a Server it is common to use the SMO library to backup or restore. SMO | SQL Server Management Objects contains numerous classes that facilitated and much the management of a bank programmatically. If you are interested, see here: Here I came across two problems:Property Conexao.Database me returning null;DataTime.Now.ToString() generating syntax error;Note that I have a query name string commented that was my first attempt, where I came across the 2 problems.The solution I found was to use Application. StartupPath, to return the path to the db by adding your name soon afterwards. the 2 problem that affected the syntax were the date and time separators used in the return format.string query = $"BACKUP DATABASE [{Application.StartupPath}\\DATABASE1.MDF] TO DISK ='{textBox1.Text}\\Database1_{DateTime.Now.ToString("yyyyMMdd_HHmmss")}.bak'"; Note that it worked perfectly, in the image above on the desktop folder screen I have 3 backup, although 2 are a little more above. every click generates a new one, I do not fear how to overlay it DateTime will never return the msm nanossecond.
B

How do we check the database?
Software Programming • c sharp sql • • baileigh

2

0
Votes

2
Posts

0
Views

A

First, I don't know why in class. User Two IDs. If they really make sense, describe their purpose.I'd leave one thing alone. Id♪public class User { public int Id { get; set; } public string UserName { get; set; } public decimal Balance { get; set; } public decimal GeneralPay { get; set; } } Second, we'll change the method's signature.He adds one So the name should be AddUser♪Method SaveChangesAsync returns the number of recorded records. You don't have to ignore him, you better get him back from the method. It'll give him opportunity to control his work. Change Task ♪ Task<int>♪Method AddAsync It also has a return. T.K., in this particular case it is not used by us, we declare it clearly: _ = await db.Users.AddAsync(user); ♪ https://docs.microsoft.com/en-us/dotnet/csharp/discards ♪Thirdly, an exception will be made when trying to get a recording of a unique key. That's what we need to catch in the block. try-catch♪ There are two options.The method does not respond to possible exceptions. I'll just put it in the.public static async Task<int> AddUser(int userId, string userName, decimal balance) { User user = new User { Id = userId, UserName = userName, Balance = balance }; using var db = new DBTelegramContext(); _ = await db.Users.AddAsync(user); return await db.SaveChangesAsync(); } And the challenge to the method is... try-catch:try { _ = await DataBaseCommands.AddUser(1, "user1", 101); } catch (DbUpdateException e) { // Тут реакция на ошибки Console.WriteLine(e); } Another option. try-catch inside the method:public static async Task<int> AddUser(int userId, string userName, decimal balance) { User user = new User { Id = userId, UserName = userName, Balance = balance }; using var db = new DBTelegramContext(); try { _ = await db.Users.AddAsync(user); return await db.SaveChangesAsync(); } catch (DbUpdateException e) { Console.WriteLine(e); // Тут реакция на ошибку: логирование и т. п. return 0; } } There's no need to catch an exception to his challenge. Although, in any case, other exes may be thrown out, similar to the lack of connections, etc.In both cases, you don't just have to make a mistake, but somehow inform the user and try to fix the situation. It could be a disaster that the data are not uploaded and missing.int entriesWritten = await DataBaseCommands.AddUser(1, "user1", 101); if (entriesWritten != 1) // что-то пошло не так The most important thing is, why is it bad to do a hand-check before you get up?Let's say this line has been successfully completed, there's no record of that id in the table:if (!(await db.Users.AnyAsync(u => u.UserId == userId))) And there's another flow or process of entering this table with the same id value. And when it comes to the challenge. SaveChangesAsync In our flow, it' ends with a mistake.I mean, it's a very bad test! It is with great regret that this method is constantly produced in blogs, articles and hundreds of responses in different programming languages here, stackoverflow.Of course, sqlite is a principled one-user OBD and cannot be operated from several streams/processes. And that's why she's being tested. if It'll work correctly. But it's best to teach yourself to correctly handle all possible mistakes.And another note.Challenge AnyAsync Make a request for OBD. Challenge SaveChangesAsync - Another request. Two. And the most expensive thing to do with databases is sending inquiries. Their number should be minimized.
T

CodeIgniter - PostgreSQL database query (multi database)
Software Programming • mvc codeigniter framework • • tahishae

2

0
Votes

2
Posts

0
Views

Well, looking for some things related to CI and PostgreSQL, I found a guy with a similar doubt and decided to try something similar to what he did.For those interested, and perhaps the same problem, I solved the problem as follows:class Crud extends CI_Model { public function consulta($var) { $this->db->select('title, content, date'); $this->db->from('search_path.mytable'); $this->db->like('nome_coluna', $var['nome']); $result = $this->db->get(); } } Just put the name of the schema, or bank, in the line that specifies which table to be sought (in case: $this->db->from('search_path.mytable');).Thus, it is possible to insert the search_path PostgreSQL and other databases that authenticate the same system.
R

not available from the database
Software Programming • php mysql opencart • • Raziyah00

2

0
Votes

2
Posts

0
Views

K

You've got problems in the code:1.1. The data from several tables are better swept through JOIN http://dev.mysql.com/doc/refman/5.7/en/join.html SELECT * FROM products JOIN providers ON providers.id = products.provider_id WHERE providers.status = "active" 1.2. If there's a mass, you can make one request.// SELECT * FROM products WHERE id IN (1, 2, 3, 4, 5, 6) $idList = [1, 2, 3, 4, 5, 6]; $sql = sprintf( "SELECT * FROM products WHERE id IN (%s)", join(", ", $idList) ); (2) To format the design of the request line, the use of functions rather than the content. That would make it very easy to make a lot of syntastic mistakes and not to confuse in brackets. http://php.net/manual/en/function.sprintf.php $sql = sprintf( "SELECT * FROM %s.%s", DB_PREFIX, $tableName ); (3) Better use of Prepared Statements to transmit the parameter to the request. I'm not sure if your cult allows it to be used. http://php.net/manual/en/pdo.prepared-statements.php http://php.net/manual/en/pdo.prepare.php // Bonus: SQL Injection safe!!! $db->prepare("SELECT * FROM products WHERE name = ?"); $db->execute($GET['name']); // or $idList = [1, 2, 3, 4, 5, 6]; $qMarks = array_fill(0, count($idList), "?"); // SELECT * FROM products WHERE id IN (?, ?, ?, ?, ?, ?) $sql = sprintf( "SELECT * FROM products WHERE id IN (%s)", join(", ", $qMarks) ); $db->prepare($sql); $db->execute($idList); (4) It's better to split the code and the data.(5) You still have variables rolling.$vproducts = $vendor_products$data['products_list_vendor'] = $products_list_vendor♪That's the problem! Be careful with the copipast.
J

Fp(SQL) database is not available for errors
Software Programming • php mysql sql mysqli phpmyadmin • • jonetta

2

0
Votes

2
Posts

0
Views

O

I think it's a problem to transfer the variable to the SQL team.Try this:$count = mysqli_query($connection, "SELECT * FROM `users` WHERE(`Name` = '" . $name . "' AND `Password` = '" . $password . "') "); if (mysqli_num_rows($count) == 0) { mysqli_query("INSERT INTO users (Name, Password) VALUES ('" . $name . "', '" . $password . "')"); } Also notice if $name or $password will contain an astroph.'That SQL won't work.
K

In which file/direction is stored a local database with Room Database?
Software Programming • android sqlite android room • • kalena

2

0
Votes

2
Posts

0
Views

O

One way you can see the location of your BD is through the following line in which you save in a string the route where the .db file is located.String actualtDBPath=getDatabasePath("tuBaseDatos.db").getAbsolutePath(); But normally your database will be found on the following route, for that you must open the menu tab 'Device File explorer':data/data/your-application-package/databases
A

How do you make a screenshot and keep it variable?
Software Programming • python tkinter screenshots • • Anderson

2

0
Votes

2
Posts

0
Views

You just don't keep it, ImageTk.PhotoImage(screen) from tkinter import Tk, Button, Label, Toplevel from PIL import ImageGrab, ImageTk def capture(): global screen, screen_sh top = Toplevel() screen = ImageGrab.grab() screen_sh = ImageTk.PhotoImage(screen) label = Label(top, image=screen_sh) label.pack() root = Tk() root.title("Screenshot!") action = Button(root, text="Make screenshot!", command=capture) action.pack() root.mainloop() See. https://ru.stackoverflow.com/q/626508/255866 and https://ru.stackoverflow.com/q/767818/255866
K

licking two elements continuously from the iterator
Software Programming • python • • kalyn

2

0
Votes

2
Posts

0
Views

Looking for more-itertools windowed? https://more-itertools.readthedocs.io/en/stable/api.html#more_itertools.windowed import itertools from more_itertools import windowed for a in windowed(itertools.count(), 2): print(a) if a[0]>10: break
A

How to correctly transpose the matrix
Software Programming • python • • Amritpal

2

0
Votes

2
Posts

0
Views

C

Please help me drive.One mistake goes into the eye. What a variable. a into functions?rows_count = len(a) To variable a She had nothing to do with the main program. If you want to use the matrix. a From the main programme, two options:Explain on the list of parameters the functionExplain her global variableStart with this corrigendum because without it, it's pointless.
D

List intervals
Software Programming • python list • • derk

2

0
Votes

2
Posts

0
Views

Z

Mode 1:Just do in the forehead:arr = [0, 1, 0, -1, 0, 1, 0, 1, 0, 1, 2, 0] res = [] tmp = [] for i in arr: if i == 0: if tmp: res.append(tmp) tmp = [] else: tmp.append(i) if tmp: res.append(tmp) print(res) Mode 2:a may not be in the forehead or with a pervert :arr = [0, 1, 0, -1, 0, 1, 0, 1, 0, 1, 2, 0] res = [[int(j) for j in i.split(',') if j != ''] for i in (str(arr)[1:-1].replace(' ', '') + ',').split('0,') if i != ''] print(res) Mode 3:Same method 2, just a little from the other side and shorter:res = [list(map(int, i.split())) for i in (' ' + ' '.join(map(str, arr))).split(' 0') if i != '']

Not available for mssql database

Suggested Topics

Problems with the database Software Programming • php mysqli • • shizuka

Problem when storing decimal values in SQL Server Software Programming • c sharp sql server asp.net mvc entity framework • • kalena

Exporting certificate without private key SQL, Database Testing • sql server sql server 2016 always enc languagerypted • • obi

Maintaining the role in OBD Software Programming • python sqlite discord discord py • • emmalee

Unicode-decode error utf-8 for ñ on python Software Programming • python unic languageode anac languageonda • • Raziyah00

database backup Software Programming • c sharp sql backup server • • briley

How do we check the database? Software Programming • c sharp sql • • baileigh

CodeIgniter - PostgreSQL database query (multi database) Software Programming • mvc codeigniter framework • • tahishae

not available from the database Software Programming • php mysql opencart • • Raziyah00

Fp(SQL) database is not available for errors Software Programming • php mysql sql mysqli phpmyadmin • • jonetta

In which file/direction is stored a local database with Room Database? Software Programming • android sqlite android room • • kalena

How do you make a screenshot and keep it variable? Software Programming • python tkinter screenshots • • Anderson

licking two elements continuously from the iterator Software Programming • python • • kalyn

How to correctly transpose the matrix Software Programming • python • • Amritpal

List intervals Software Programming • python list • • derk

Problems with the database
Software Programming • php mysqli • • shizuka

Problem when storing decimal values in SQL Server
Software Programming • c sharp sql server asp.net mvc entity framework • • kalena

Exporting certificate without private key
SQL, Database Testing • sql server sql server 2016 always enc languagerypted • • obi

Maintaining the role in OBD
Software Programming • python sqlite discord discord py • • emmalee

Unicode-decode error utf-8 for ñ on python
Software Programming • python unic languageode anac languageonda • • Raziyah00

database backup
Software Programming • c sharp sql backup server • • briley

How do we check the database?
Software Programming • c sharp sql • • baileigh

CodeIgniter - PostgreSQL database query (multi database)
Software Programming • mvc codeigniter framework • • tahishae

not available from the database
Software Programming • php mysql opencart • • Raziyah00

Fp(SQL) database is not available for errors
Software Programming • php mysql sql mysqli phpmyadmin • • jonetta

In which file/direction is stored a local database with Room Database?
Software Programming • android sqlite android room • • kalena

How do you make a screenshot and keep it variable?
Software Programming • python tkinter screenshots • • Anderson

licking two elements continuously from the iterator
Software Programming • python • • kalyn

How to correctly transpose the matrix
Software Programming • python • • Amritpal

List intervals
Software Programming • python list • • derk