Problem in storing into ms-access as unicode

I have one JSP page which has one text field. I'm entering some kannada characters. I'm able to encode it in UTF-8 format and I'm passing this value to another JSP. In an alert box, I'm getting...

Logon failed, Crystal Reports 9, VB6 , sql server, sqlncli

i'm trying to build a setup package for a legacy vb6 software. the software itself connects to a sql server via sqlncli (native client). i've packaged all the dependencies and deploy them to a new...

Disabling SSIS Package Validation when Loading a Package in the VS Designer

I have a few SSIS packages that are deployed to a SQL 2005 Server and are subsequently designed and maintained in Visual Studio 2003. When I open any of the BIDS projects, followed by one of the...

How to connect Ms access 2010 (.accdb ) database with odbc driver

Can any one tell how to connect Ms access 2010 (.accdb ) database with odbc driver in c# and .NET 4.0 I tried string connetionString = ("Driver={Microsoft Access...

Update ODBC DB through Excel

I am able to query and view table through excel, but I was wondering if there is a way to directly update or insert by modifying data in the excel. Similar to Microsoft Access Linked table, maybe?

C# Datetime to ODBC Datetime conversion error

We are trying to use ODBC with SQL Server 2012 for our new application because MS is phasing out OleDb and we want to try to make it easy (easier?) to port to other databases. The problem is, when...

how to overcome ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO) permanently

when am trying to open mysql in windows cmd by typing mysql. the following error is occuring. ERROR 1045 (28000): Access denied for user [email protected] (using password: NO) And then by looking...

MS Access ODBC with PostgreSQL Table Write Conflict

So I have to transfer the back end of an Access Database to Postgres recently. After linking the tables to the forms and updating the VBA coding, I tried to create a new record with the primary...

Is there a VB.NET equivalent of PrivateDBEngine from VB6?

Hi I don't have experience with VB6 or VB.NET but am trying to convert some old code to .NET. The VB6 uses PrivDBEngine. Public oDbEngine As New PrivDBEngine After some googling this looks like...

Graphical query designer for PostgreSQL

I have for years used MS Access and its query tool that is used for making queries. This tool is so good that I have never been forced to do very much SQL programming myself. The query tool has...

Access local front-end connected to Azure SQL Server back-end very slow

I've been using Access to rapid-prototype a DB. Now I'd like to do a small group online test so I split the DB and placed the back-end on Azure SQL Server, then re-linked. It's incredibly slow and...

Connecting to MSSQL in Flask using Flask-SQLAlchemy and pyodbc

I am not able to connect to MSSQL Server 2016 database using Flask-SQLALchemy and pyodbc. I have searched through Google and none of the solutions work. I am getting the following...

Cannot use Azure SQL with Azure DevOps Server 2019 - (Azure Government)

I have been struggling to get my DevOpsServer 2019-RC1 installation to see my Azure SQL Server My DevOpsServer install is on an Azure VM, as recommended I have implemented everything from the...

PhpUnit not executing via PhpStorm remote interpreter in Docker

The issue I've got is that PhpUnit does not function (properly, something does happen) when just plain clicking "Run" (Shift + F10 on Windows) in PhpStorm. First up, followed tutorials/setup...

How to fix SQLAlchemy connection problem: 'Connection info needed in SQLAlchemy format' when connecting to IBM db2 server hosted on IBM Cloud

So, I've been trying to connect to the IBM DB2 server hosted on IBM cloud for the past few days and managed to connect to it using the provided credentials and the 'ibm_db', 'ibm_db_sa', and the...

Pyspark connection to the Microsoft SQL server?

I have a huge dataset in SQL server, I want to Connect the SQL server with python, then use pyspark to run the query. I've seen the JDBC driver but I don't find the way to do it, I did it with...

Speed up odbc::dbFetch

I'm trying to analyze data stored in an SQL database (MS SQL server) in R, and on a mac. Typical queries might return a few GB of data, and the entire database is a few TB. So far, I've been using...

result_fetch([email protected], n)': nanodbc/nanodbc.cpp:2966: 07009: [Microsoft][ODBC Driver 13 for SQL Server]Invalid Descriptor Index

I have problem with MSSQL in R language, similar like in https://stackoverflow.com/questions/45001152/r-dbi-odbc-error-nanodbc-nanodbc-cpp3110-07009-microsoftodbc-driver-13-fo , but a little...

pyodbc on google colab

I am trying to connect to my SQL server on google colab by using pyodbc. However, it tells me that I cannot find the driver. Code to install packages (I replaced IP, port and password with x) ```...

How to fix endless reboot loop installing Microsoft ODBC Driver 17 - message: A previous installation required a reboot of the machine for changes

Installing Microsoft® ODBC Driver 17 on windows 10. During the install, Microsoft ODBC Driver 17 for SQL Server setup stops and shows "A previous installation required a reboot of the machine for...

Datetime field overflow when uploading csv file to SQL Server Database using BCP

I have been trying for days to fix this problem. I have a Pandas dataframe which I export to a csv file like this: df.to_csv(csv_name, index=False, header = False, encoding='utf-8-sig',...

Connection string for connecting to SQL Server on Ubuntu

Consider this scenario. SQL Server is running on ubuntu Able to connect through Azure Data Studio Able to connect through sqlcmd sqlcmd -S 192.168.99.100,31433 -U sa -P S0mePassw0rd -d friends...

How to fix Microsoft ODBC Driver 17 for SQL Server : SSL Provider ssl_choose_client_version:unsupported protocol

I have installed Sql Server 2019 Developer Edition and mssql-tools on my Ubuntu 20.04 minimal. I can connect to my localhost with no issue, but when I want to remote to another sql server: sqlcmd...

[ODBC Driver 17 for SQL Server]SSL Provider: [error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol]

os: ubuntu 20.04 server SQL server version: Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) python 3.8 import pyodbc cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL...

Cant' build Tailwind CSS

So I'm trying out Taiwlwind CSS for the first time and I'm following a tutorial. I'm sure I've followed the tutorial to the tee and we haven't even gotten anywhere and I can't seem to build, I...

Error trying to connect Power BI Desktop with MariaDB running on Docker CentOS 7

I was trying to make the connection but Power BI shows this error: "The 'Driver' property with value '{MariaDB ODBC 3.1 Driver}' doesn't correspond to an installed ODBC driver." I've been...

Pyodbc on M1 Macs

I am trying to connect to a Microsoft sql server database using pyodbc. I keep getting the error Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 17 for SQL Server'...

Mac M1 SQL Server SQLSrv OpenSSL library could not be loaded, make sure OpenSSL 1.0 or 1.1 is installed

I just bought a M1 Mac mini running Big Sur 11.6, I've installed PHP 7.3, msodbcsql17, mssql-tools, sqlsrv and pdo_sqlsrv. But when I try to connect using sqlsrv, the following error happens...

Python takes 3ms while Spring takes 80ms to execute the select query from Azure SQL Server?

I have a simple Table created in Azure SQL Database Below Python script takes only 3ms to to execute the select query from Azure SQL Server import os import sys import logging,...

Array initializer cannot be specified for a non constant dimension; use the empty initializer '{}' when retrieving data coming from database table

I'm making a program like inserting a cart and want to retrieve the data to be selected from the DataGridView using dr.item() . private sub btnpilih_click(sender as object, e as eventargs)...

Relevant tags