Visual Studio 2022 Database with SQLite

Question

Visual Studio 2022 Database with SQLite

Juergen Babenhauserheide 0

Hello,

I have a question about Visual Studio 2022 database with SQLite.

A few years ago (2017) I created a program with the "SQLite" database using Visual Studio 2015.

I can still start the program created with Visual Studio 2015 today. But when I call the old project with Visual Studio 2022 I get some error messages.

E1696 Cannot open source file: "stdio.h", "stdlib.h", "iosteam.h", "sqlite3.h".

Can I no longer use "SQLite" in the 2022 version and must use it as described in Create a database and add tables in Visual Studio?

https://learn.microsoft.com/de-de/visualstudio/data-tools/create-a-sql-database-by-using-a-designer?view=vs-2022#prerequisites

I installed SQLite on my WINDOWS 11 PC: SQLite - Installation

https://www.tutorialspoint.com/sqlite/sqlite_installation.htm

Unfortunately, my 2017 documentation for Visual Studio 2015 with SQLite is incomplete and the links shown are no longer valid: SQLite2.jpg, SQLite3.jpg, SQLite4.jpg

[http://sqlitebot.googlecode.com/files/sqlite2.jpg]

[http://sqlitebot.googlecode.com/files/sqlite3.jpg]

[http://sqlitebot.googlecode.com/files/sqlite4.jpg]

Kind Regards

Juergen

Juergen Babenhauserheide 0 Reputation points

2023-10-23T11:55:59.7133333+00:00
Hello,

here the C++ Program
Juergen Babenhauserheide 0 Reputation points

2023-10-23T11:58:59.15+00:00

Hello,

I don't why the C++ Code is not showing.

I have used the "code block" (<>).

Juergen
Tianyu Sun-MSFT 34,436 Reputation points Microsoft External Staff

2023-10-24T09:52:09.5433333+00:00

Hello @Juergen Babenhauserheide ,

Welcome to Microsoft Q&A forum.

Could you please share us the detailed C++/Windows SDK components and workloads that you have installed in VS?

Besides, could you try to share the code and the screenshots again, as it seems they are still unavailable.

Juergen Babenhauserheide 0

Hello Tianyu Sun,

The C++ Proram-Code:

#include "stdafx.h"
#include <stdio.h>
#include <stdlib.h>
#include <iostream>             // std::cout/cin
#include "sqlite3.h"

static int callback(void *NotUsed, int argc, char **argv, char **azColName) {
        int i;
        for (i = 0; i<argc; i++) {
                printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
        }
        printf("\n");
        return 0;
}

int main(int argc, char* argv[]) // argc = , argv = 
{
        sqlite3 *db;
        char *zErrMsg = 0;
        int rc, ende;
        char *sql;

        /* Open database */
        rc = sqlite3_open("test.db", &db);

        if (rc) {
                fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
                return(0);
        }
        else {
                fprintf(stdout, "Opened database successfully\n");
        }

        /* Create SQL statement */
        sql = "CREATE TABLE COMPANY("  \
                "ID INT PRIMARY KEY     NOT NULL," \
                "NAME           TEXT    NOT NULL," \
                "AGE            INT     NOT NULL," \
                "ADDRESS        CHAR(50)," \
                "SALARY         REAL );";

        /* Execute SQL statement */
        rc = sqlite3_exec(db, sql, callback, 0, &zErrMsg);

        if (rc != SQLITE_OK) {
                fprintf(stderr, "SQL error: %s\n", zErrMsg);
                sqlite3_free(zErrMsg);
        }
        else {
                fprintf(stdout, "Table created successfully\n");
        }
        sqlite3_close(db);
        std::cout << "Programm Ende";
        std::cin >> ende;
        return 0;
}

Workloads:

ASPNET und Webentwicklung, .NET Multi-Platform App UI-Entwicklung, Desktopentwicklung mit C++, Node.js-Entwicklung, .NET-Desktopentwicklung, Entwicklung für die universelle Windows-Plattform, Datenspeicherung und -verarbeitung

Screenshot

https://capture.dropbox.com/Z2rJC1ZMm8WLctWw

Kind Regards

Juergen

3 answers

Your answer

Juergen Babenhauserheide 0 Reputation points

2023-10-23T11:55:59.7133333+00:00

Hello,

here the C++ Program
Juergen Babenhauserheide 0 Reputation points

2023-10-23T11:58:59.15+00:00

Hello,

I don't why the C++ Code is not showing.

I have used the "code block" (<>).

Juergen
Tianyu Sun-MSFT 34,436 Reputation points Microsoft External Staff

2023-10-24T09:52:09.5433333+00:00

Hello @Juergen Babenhauserheide ,

Welcome to Microsoft Q&A forum.

Could you please share us the detailed C++/Windows SDK components and workloads that you have installed in VS?

Besides, could you try to share the code and the screenshots again, as it seems they are still unavailable.
Juergen Babenhauserheide 0 Reputation points

2023-10-24T11:09:52.8466667+00:00

Hello Tianyu Sun,

The C++ Proram-Code:

#include "stdafx.h" #include <stdio.h> #include <stdlib.h> #include <iostream> // std::cout/cin #include "sqlite3.h" static int callback(void *NotUsed, int argc, char **argv, char **azColName) { int i; for (i = 0; i<argc; i++) { printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL"); } printf("\n"); return 0; } int main(int argc, char* argv[]) // argc = , argv = { sqlite3 *db; char *zErrMsg = 0; int rc, ende; char *sql; /* Open database */ rc = sqlite3_open("test.db", &db); if (rc) { fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db)); return(0); } else { fprintf(stdout, "Opened database successfully\n"); } /* Create SQL statement */ sql = "CREATE TABLE COMPANY(" \ "ID INT PRIMARY KEY NOT NULL," \ "NAME TEXT NOT NULL," \ "AGE INT NOT NULL," \ "ADDRESS CHAR(50)," \ "SALARY REAL );"; /* Execute SQL statement */ rc = sqlite3_exec(db, sql, callback, 0, &zErrMsg); if (rc != SQLITE_OK) { fprintf(stderr, "SQL error: %s\n", zErrMsg); sqlite3_free(zErrMsg); } else { fprintf(stdout, "Table created successfully\n"); } sqlite3_close(db); std::cout << "Programm Ende"; std::cin >> ende; return 0; }

Workloads:

ASPNET und Webentwicklung, .NET Multi-Platform App UI-Entwicklung, Desktopentwicklung mit C++, Node.js-Entwicklung, .NET-Desktopentwicklung, Entwicklung für die universelle Windows-Plattform, Datenspeicherung und -verarbeitung

Screenshot

https://capture.dropbox.com/Z2rJC1ZMm8WLctWw

Kind Regards

Juergen

Answer 1

Hi @Juergen Babenhauserheide ,

Thanks for sharing us the code and the screenshot.

Did you try to retarget your project(right-click your project > Retarget Projects) and select the corresponding Windows SDK Version and Platform Toolset(right-click your project > Properties > Configuration Properties > General > Windows SDK Version, Platform Toolset)? If the corresponding version of Windows SDK is missing, you can install it from VS Installer > Modify > Individual components > SDKs, libraries, and frameworks.

If you have set the correct Windows SDK Version and Platform Toolset, then please try to close VS, delete the hidden .vs folder in your solution folder and rebuild your project.

Kind Regards,

Tianyu

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hello,

thank you for your information.

Deleting the .vs folder has already helped.

I can compile the program code without any error messages.

But when I create the program I get the following messages (for all SQLite functions):

LNK2019: Reference to unresolved external symbol 'sqlite3_close' in function 'main'.

I.e. the linker doesn't find the SQLite.lib or does it?

Where exactly does the LIB have to be located?

At the moment I have the “sqlite3.*” in the project directory:

SQLite_02\SQLite_02\sqlite3.h, sqlite3.c, sqlite3.lib, sqlite3.dll // is the source code directory SQLite_02\SQLite_02\include\sqlite3.c, sqlite3.h

SQLite_02\SQLite_02\lib\sqlite3.lib

Kind Regards

Juergen

Answer 3

Juergen Babenhauserheide 0

Hello,

I have solved my Problem:

delete the project-folder ".vs"
insert the file "sqlite3.lib" in: Projectmapp-Explorer -> Ressourcenfiles.

So I can create my old progam "sqlite_02" from the year 2017 (VS2015).

Good thing I asked.

Kind Regards

Juergen

Tianyu Sun-MSFT 34,436 Reputation points Microsoft External Staff

2023-10-27T08:30:34.9366667+00:00

Hi @Juergen Babenhauserheide ,

I'm glad to hear that this problem has been solved.

Thank you for sharing the solution here. If you have any further concerns, feel free to contact us.

Have a nice day.

Kind Regards,

Tianyu

Share via

Visual Studio 2022 Database with SQLite

3 answers

Your answer