Questions tagged [odbc-sql-server-driver]

33 questions
1
vote
2 answers

Unknown token received from SQL Server

I got this error when trying to run a query in SQL server query analyzer. What is the reason?
user29982
  • 443
  • 4
  • 9
  • 14
1
vote
1 answer

Include SqlServerDriver on maven project

I have this problem: I have to connect to a sql server db using sqlServerDriver in my maven project. The problem is: i can't find any repository that provide me the artifact: com.microsoft.sqlserver
0
votes
0 answers

ODBC Driver 18 for SQL Server]Datetime field overflow. Fractional second precision exceeds the scale specified in the parameter binding. SqlState22008

I'm trying to insert TimeStamp Value into AzureSQL Server's DB table using ODBC driver 18 and I have set ODBC version as 3.0(SQL_OV_ODBC3). However I am getting below error [Microsoft][ODBC Driver 18 for SQL Server]Datetime field overflow.…
0
votes
1 answer

SQLSTATE HY024 with error message [Microsoft][ODBC Driver Manager] Invalid argument value

I am trying to connect to Azure SQL via a C++ program. However it is getting failed and I found the error with SQLGetDiagRec and SQLGetDiagField. The SQLSTATE is HY024 with error message [Microsoft][ODBC Driver Manager] Invalid argument value Below…
0
votes
0 answers

ODBC ANSI_WARNINGS warning message is breaking stored procedures

I think ANSI warnings are somehow breaking my stored procedure calling, and I'm trying to figure out how to fix it. DB Server: MS SQL Server 2008 Client: Ubuntu Bionic unixODBC Microsoft ODBC Driver 17 for SQL Server for Linux nanodbc I have a…
0
votes
0 answers

SQLSTATE[08S01]: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:140E0197:SSL routines:SSL_shutdown:shutdown while in init]

It's a new experience for me, using Laravel with SQL Server. My issue is, some of it shows this error message SQLSTATE[08S01]: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:140E0197:SSL routines:SSL_shutdown:shutdown while in init]…
Udom
  • 329
  • 2
  • 4
  • 18
0
votes
0 answers

Problem SQLServerDriver server name contains comma

I am trying to connect a SQL server and for this I am using the driver provided by microsoft com.microsoft.sqlserver.jdbc.SQLServerDriver Now they changed the connection by adding a comma to it and I can no longer create the connection, does anyone…
0
votes
1 answer

Running Bash Script to Download SQL Server ODBC Driver in Databricks Fails

I have bash script that looks something like this, curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list sudo apt-get…
Minura Punchihewa
  • 1,498
  • 1
  • 12
  • 35
0
votes
0 answers

Question related to SQL Server Driver support for pyodbc's fast_executemany option

I am trying to improve insert performance to a SQL Server Database table using Python. (First step taken is instead of row by row insert, prepare a bulk statement.) After going through driver support documentation (…
MDixit
  • 3
  • 2
0
votes
1 answer

MSSQL login authentication problems with ODBC connection and R stats package

I am trying to connect an ODBC source to the R statistical package but having log in problems. I have set up the ODBC name eplR with an SQL server driver linking to the (local) server using windows NT authentication with the network login ID…
pssguy
  • 3,455
  • 7
  • 38
  • 68
0
votes
1 answer

Dynamic sql query from MS SQL to MySQL

I have 2 dbs one on MS SQL and another on Mysql. I have written some sql scriots which fetch data from Mysql and insert into MS SQL. To do this I have set up device driver connection and linked server on MS SQL and these scripts are executed on MS…
pramodtech
  • 6,300
  • 18
  • 72
  • 111
0
votes
1 answer

How to install sql server driver while creating a python api

I want to create a python api so that i can communicate with my database hosted on sql server. I am trying to create it with help og google cloud platform.But when i am doing it the pyodbc package is not getting installed as it has a sql drive…
0
votes
0 answers

IBM MobileFirst 7.1 ,com.microsoft.jdbc.sqlserver.SQLServerDriver not found

Have installed mobile first 7.1 ,Have pushed the adapters successfully.But while making adapter call,getting error com.microsoft.jdbc.sqlserver.SQLServerDriver not found In Work light or Project Work space. After search have tried many option , have…
0
votes
1 answer

Lost connection to MySQL server in Windows XP while adding Data Source - ODBC

When I am trying to connect to the localhost, there is no problem. But when I am connecting to my server, I am getting this error. [08S01][MySQL][ODBC 5.1 Driver] Lost connection to MySQL server at ‘reading initial communication packet’, system…
user279244
  • 961
  • 5
  • 18
  • 32
0
votes
0 answers

OBDC and ExecuteReader issues

I'm trying to do a little powerShell script, which establishes a OBDC connection using SQL Server Native Client 11.0 as Driver and retrieve some data which, in my case, is just getting the list to the database tables. ##### Start the database…
Salah Elgo
  • 85
  • 1
  • 2
  • 10