error using jupter notebook

Question

not sure if this is in the right area

What is wrong with this line when using juypter notebook

conn = sqlite3.connect(C:\Users\aussi\OneDrive\Documents\Google Colab\SQL BDMs.rmgc)

which is where my database is stored

Any help appreciated

Answer 1

The issue is the way the Windows path string is written in Python.

In Python, backslashes in strings are escape characters, so this:

conn = sqlite3.connect(C:\Users\aussi\OneDrive\Documents\Google Colab\SQL BDMs.rmgc)

will be parsed incorrectly and also lacks quotes around the path (it must be a string).

Use one of these correct forms instead:

1. Raw string literal:

conn = sqlite3.connect(r"C:\Users\aussi\OneDrive\Documents\Google Colab\SQL BDMs.rmgc")

2. Escape backslashes properly:

conn = sqlite3.connect("C:\\Users\\aussi\\OneDrive\\Documents\\Google Colab\\SQL BDMs.rmgc")

3. Use forward slashes (Python accepts them on Windows):

conn = sqlite3.connect("C:/Users/aussi/OneDrive/Documents/Google Colab/SQL BDMs.rmgc")

Also ensure that the file actually exists at that path and that OneDrive sync is not interfering. If running in a different environment (for example, a remote Jupyter server), that local Windows path will not be accessible and the database file must be on a path visible to the Jupyter runtime.

---

References:

• Quickstart: Connect to a SQL database from a Jupyter Notebook
• Quickstart: Connect to a SQL database in Fabric from a Jupyter Notebook
• 'Path of this file or folder is too long' error in OneDrive