Questions tagged [sqlapi++]

29 questions
4
votes
1 answer

View creation works in Firebird 3.0 but not in version 4.0

I created a music database application a few years ago in C++ (Code::Blocks + wxWidgets + SQLAPI++) and Firebird as the database server (running as a service in classic mode) on the Windows platform (v10). It creates a SQL database with tables,…
Ruud
  • 97
  • 6
3
votes
1 answer

NVARCHAR(MAX) - As SQL Stored Procedure Output Parameter

Display_Info is a SQL stored procedure,has three input parameters and three output parameters. info_Data(serialized information data may also contain unicode and null values) one of the output parameters is of type NVARCHAR(1000) previously. Since…
2
votes
4 answers

Connecting to SQLServer db from C++ console app using SQLAPI

I would like to connect to a SQLServer db from my console c++ application. I have used Microsoft SQL Server to create a db called "Test". I also have "installed" the sqlapi from sqlapi.com. For starters I just want to connect to that db using a…
Lumpi
  • 2,697
  • 5
  • 38
  • 47
1
vote
3 answers

Cannot open include file "sqlapi.h" in C++?

I am trying to connect c++ with SQLBase. After building my project I get an error as " Cannot open include file: 'SQLAPI.h': No such file or directory ". #include #include // main SQLAPI++ header #include Can…
digvijay
  • 189
  • 1
  • 5
  • 16
1
vote
1 answer

How do I read unicode characters from SQL server using SQLAPI++?

I'm using SQLAPI++ to build a backend application which needs to access a database (SQL Server 2014). When I try to read a string (nvarchar(50)) from a result set that contains non-ascii characters (specifically persian characters), the…
SMMB
  • 107
  • 6
1
vote
3 answers

SQLAPI++ Library use

Has anyone have good experience using SQLAPI++ Library? (connecting C++ and SQL) What do you recommend, I have a local server, SQL server 2008 and Windows XP. Do you have a funcional example to connect c++ and sql server?, just to do a simple …
edgarmtze
  • 24,683
  • 80
  • 235
  • 386
1
vote
1 answer

Chinese character gash when using SQLAPI++

I use SQLAPI++ to insert data into SQL Server 2005. When there are many Chinese characters, it will be garbled in database. IDE : MS 2005 IDE Character Set : Multi-Byte SQLAPI Lib : sqlapi.lib(dynamic release import library for MSVC++)
herbertluo
  • 59
  • 10
1
vote
1 answer

converting from std::string to SAString

I am using SQLAPI++ to insert values into my SQL DataBase, I am trying to extract actions from chess games and insert it as string in actions table in the database just like this (action_id=1, action_name=e4). here is my code: int main() { …
1
vote
0 answers

connecting a c++ application to an Oracle database with sqlapi++

I wrote an example application in C++(on Eclipse Luna) using sqlapi++ libraries to connect to an Oracle database I created with sqldeveloper. The program compiles without errors, but when I run it,nothing appears on the console. (I am using Windows…
aldoalpha
  • 163
  • 10
1
vote
2 answers

Sql connection?

Im using the SQLAPI++ to connect my program to a database. The following code does compile without errors. However it doesn't connect to the database. I get an error saying: A network-related or instance-specific error occurred while establishing a…
Blake Wills
  • 167
  • 2
  • 4
  • 13
1
vote
0 answers

How to execute the parameterized stored procedure in SQLExecDirect

I want to execute a stored procedure using SQLExecDirect(). So I am setting the input parameter using SQLBindParameter(). Also I am using SQL_PARAM_OUTPUT to bind the output parameter. But after executing the query, I am getting SQL_ERROR. Here…
Tausif
  • 117
  • 1
  • 3
  • 17
0
votes
1 answer

Connect to SQL Server with SQLAPI++

I am trying to write a C++ script, on a remote Ubuntu machine, that would connect to a database in order to retrieve some data. I created my database on Microsoft SQL Server on an other remote machine. I have installed SQLAPI++ and read the SQL…
0
votes
1 answer

Oracle Connection with SQLAPI++

I'm trying to connect my c++ code with oracle using SQLAPI++ but it gives me the error TNS:could not resolve the connect identifier specified My code is like so: con.Connect( "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=192.168.1.XXX)…
Recon
  • 1
  • 2
0
votes
0 answers

SQLAPI++ under CLion

I'm currently learning c++ and wanted to try something with Databases and ran into SQLAPI++. As I like the IDEs of JetBrains I use CLion. As a compiler I started using the Cygwin compiler and donwloaded the Visual Studio Compiler this week to get…
0
votes
0 answers

Visual Studio c++ no symbols loaded for dll after moving dll into proper code path

I am trying to create a simple application in Visual Studio 2019 that connects to SQL Server. I am using the sqlapi++ library to create the connection. I am trying to gain more experience with c++ and 3rd party libraries. My experience in c++ has…
xtryingx
  • 152
  • 7
1
2