[windows] unable to open database file with absolute path

[hidu]

OS: windows 11

package main

import (
	"database/sql"
	"log"
	"os"
	"path/filepath"

	_ "github.com/ncruces/go-sqlite3/driver"
)

func main() {
	wd, _ := os.Getwd()

	filename := filepath.Join(wd, "demo.db")
	// filename := "demo.db" // is ok
	log.Println("filename=", filename)

	db, err := sql.Open("sqlite3", filename)
	if err != nil {
		log.Fatalln("sql.Open failed:", err)
	}
	var version string
	err = db.QueryRow(`SELECT sqlite_version()`).Scan(&version)
	log.Println("version=", version, "err=", err)
}

version= err= sqlite3: unable to open database file: The system cannot find the path specified.

[ncruces]

I will test if this is something on my end, but most likely, this is working as intended.

SQLite needs to distinguish between file paths and file: URIs, and likely the C: makes it go to the wrong place.

But, particularly with database/sql, you should really always use file: URIs, so you can fix this with:

sql.Open("sqlite3", "file:"+filepath.ToSlash(filename))

If you don't do this, you won't be able to specify PRAGMAs etc, which are URI parameters.

[ncruces]

It would help if you showed your filename (and made sure the working directory exists).

I don't see anything on my end that could break this for an existing path like C:\Work\demo.db where C:\Work\ exists.

[hidu]

yes, i have temporarily avoided this by using relative paths.