Python and Access

Question

Python and Access

Navigation

#1 by (1 votes)
#2 by (0 votes)

0

Help please, my class does not connect in Access at all .. I'm using: PyCharm, win10 (x64), office 2007 and 2016, python 3.6 (x86). I thank the attention. follows the class example:

class Banco(object):
def __init__(self):
    conStr = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=D:\BDFone\AgMesaIB.mdb"
    conxn = pyodbc.connect(conStr)
    self.cursor = conxn.cursor()


class Cadastro(object):

def __init__(self, controle="", nome="", nome2="", email="", telefone=""):
    self.info = {}
    self.cod = controle
    self.nome = nome
    self.nome2 = nome2
    self.email = email
    self.telefone = telefone

def selectCad(self, pnome):

    banco = Banco()
    try:
        c = banco.cursor()
        c.execute("select * from Geral WHERE Primeiro_nome='" + pnome + "'")

        for linha in c:
            self.cod = linha[0]
            self.nome = linha[1]
            self.nome2 = linha[2]
            self.email = linha[3]
            self.telefone = linha[4]
        c.close()

        return "Busca feita com sucesso!"
    except:
        return "Ocorreu um erro na busca do Cadastro"

python

asked by anonymous 05.07.2018 / 22:25

2 answers

SQL - Changing Field Names within a Column Laravel - View [.site.Home.index] not found

score 1 · Answer 1

Start by checking to see if you have the Access driver installed:

#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""Verificando se o driver está instalado"""
import pyodbc

print([x for x in pyodbc.drivers() if x.startswith('Microsoft Access Driver')])

The print above should return something similar to:

['Microsoft Access Driver (*.mdb, *.accdb)']

If you return an empty list [] you will have to install the diver:

Driver Access 2010 :

link

Driver Access 2016 :

link

Remembering that:

*.accdb : Format used by Access 2007 onwards.
*.mdb : Format used by Access 97, Access 2000, Access 2002 or Access 2003.

*.mdb files may have limited resources and may not function properly.

The code below was tested with a *.accdb file and 2016 driver:

#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""Conectando no banco do MS Access"""
import pyodbc


class ConectarDB:
    def __init__(self):
        # Criando conexão.
        self.con = pyodbc.connect(r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};'
                                  r'DBQ=C:\Caminho\para\o\banco.accdb;')
        # Criando cursor.
        self.cur = self.con.cursor()

    def exibir_tabelas(self):
        for tabela in self.cur.tables(tableType='TABLE'):
            print(tabela.table_name)

    def consultar_registros(self):
        return self.cur.execute('SELECT * FROM NomeDaTabela').fetchall()


if __name__ == '__main__':
    banco = ConectarDB()
    banco.exibir_tabelas()
    # print(banco.consultar_registros())

score 0 · Answer 2

I do not understand much of Acces or python, but I managed to get my (simple) code to connect to SqLite3, creating its tables and columns. I do not know if it will help, but, by the way, by no ... Code is underneath:

import sqlite3

import time import datetime

connection = sqlite3.connect ('IMDC_DB.db') c = connection.cursor ()

def create_table (): c.execute ('CREATE TABLE IF NOT EXISTS student_data (name text, age integer, \ number text, text subject, cpf text, email text, date text) ')

create_table ()

def dataentry ():

c.execute('INSERT INTO dados_alunos (name, idade, numero, materia, cpf, email, data)VALUES \
          (?,?,?,?,?,?,?)', (nome_aluno, idade_aluno, numero_aluno,\
                             materia_aluno, cpf_aluno, email_aluno, date))

connection.commit()

print ("Welcome to the first test of the IMDC System using the Database!") op_menu_aluno = 1 while op_menu_aluno! = 0: print ("=========") print ("IMDC MENU") print ("=========") print ("[1] REGISTER STUDENT") print ("[0] EXIT") op_menu_aluno = int (input ())

if op_menu_aluno == 1:
    nome_aluno = input("Digite o nome do aluno(a): ")
    idade_aluno = int(input("Digite a idade do aluno(a): "))
    numero_aluno = input("Digite o telefone do aluno(a): ")
    materia_aluno = input("Digite a(s) matérias(s) que o aluno quer se matricular: ")
    cpf_aluno = input("Digite o CPF do aluno(a): ")
    email_aluno = input("Digite o Email do aluno(a): ")
    date = str(datetime.datetime.fromtimestamp(int(time.time())).strftime('%Y-%m-%d %H:%M:%S'))
    dataentry()
elif op_menu_aluno == 0:
    print("Tchau")
else:
    print("Opção inválida")