Where is the error with this db creation code & the 'conn' variable?

[pcsailor]

Hi Larz,

Thanks for the time with your answer, again ;>

I made the changes and I'm still getting that same error:

2.6.0
2.6.0
Error: Can not create the database connection

Here is my updated code:

'''
[SqliteTutorial.net](http://www.sqlitetutorial.net/sqlite-python/creating-database/)
'''
import sqlite3
from sqlite3 import Error

# Create database
def create_connection(db_example):
    ''' create a db connection to a sqlite db '''
    try:
        conn = sqlite3.connect(db_example) # write to hard disk
        # conn = sqlite3.connect(':memory:') # write to RAM only
        print(sqlite3.version)
    except Error as err:
        print('Error: ', err)
    # finally:
        # conn.close()
# if __name__ == '__main__':
    # create_connection('D:\\Software\db\sqlite\example.db')
    # create_connection() # use when writing to RAM only

# create tables
def create_table(conn, create_table_sql):
    """ create a table from the create_table_sql statement
    :param conn: Connection object
    :param create_table_sql: a CREATE TABLE statement
    :return: 
    """
    try:
        c = conn.cursor()
        c.execute(create_table_sql)
        print('connection to \'example.db\' established')
    except Error as err:
        print('Error: ', err)

# create main() function to create the named tables.
def main():
    database = 'D:\Software\db\sqlite\example.db'

    sql_create_csv01_table = '''CREATE TABLE IF NOT EXISTS csv01 (
        id integer PRIMARY KEY,
        name text NOT NULL,
        begin_date text,
        end-date text
    ); '''

    sql_create_csv02_table = ''' CREATE TABLE IF NOT EXISTS csv02 (
        id integer PRIMARY KEY,
        name text NOT NULL,
        priority integer,
        status_id integer NOT NULL,
        project_id integer NOT NULL,
        begin_date text NOT NULL
        end_date text NOT NULL
        FOREIGN KEY (project_id) REFERENCES csv01 (id)
    ); '''

# create a db connection
    conn = create_connection(database)
    if conn is not None:
        # create csv01 table
        create_table(conn, sql_create_csv01_table)
        # create csv02 table
        create_table(conn, sql_create_csv02_table)
    else:
        print('Error: Can not create the database connection')

if __name__ == '__main__':
    create_connection('D:\\Software\db\sqlite\example.db')
    main()