Odbc Questions

I was reading a ms excel help article about pivotcache and wonder what they mean by ole db and odbc sources ...you

I've got an ms-access application that's accessing and ms-sql db through an odbc connection. i'm trying to force my users to update the data

Using asp.net as programming language on iis server. the database is access and i connect to the database using odbc. when i fill some

I have a data frame that fetches data from sql and sends out an email based on the condition of a column. but these columns are not present in

I have a laravel installation running on a debian 9.9 server and php 7.4. i need to connect to a sql server database on a remote windows

I am trying to run a sql command using pyodbc in python. in which sql command contains multiple select commands and if statements. but i

I want to insert data in the sql server from a raspberry pi with python. i tried with pypyodbc but it s not working properly. can you guide me

I am unable to create a sql server stored procedure using python's pyodbc. the command executes correctly and i get no error message however the

I want to connect python to ms-access but can't install new software (programs/drivers) and don't have admin rights as i'm working on a company

I'm trying to update an sql table by way of a inner join between a pandas dataframe which is calculatated locally on my server and a sql table in

I'm trying to figure out the best way to resolve inserting a conditional sql snippet within a laravel 5.8 application function. i'm

Iam trying to connect to teradata from python using teradata module but it results in timedout. the exception is: (434,

I'm executing a query to a db2 ibm database in laravel. call storedproc.get('leaders', '{"params": ""}', 'lead_management', 'fr');

I've installed sql-alchemy access so that i'm able to use pandas and pyodbc to query my access db's. the issue is, it's incredibly slow

I'm searching an sql table for customers who's name starts with my input and i have problem writing the "starting with" logic, it works fine when

I'm trying to run sql query with like operator through python to find any values that have "test" in any position. the problem seems to be with

I am trying to create a store procedure in master in mssql through python code. the following is my code: import pyodbc conn =

I have a sql odbc statement in python but it always returns an error. on the sql server the statement works fine. can anyone help me here?

I am pulling records from a sql server from python: region = 'hk' . . where r.rfq_create_date_time >=

Import the package import pandas as pd import pyodbc building the connection conn =

I have two tables; itemtable and producttable. producttable's itemid column links to

I have installed the driver on my mac and tried to run the rust, unfortunately i keep getting the following message: error: ('01000',

Set up mwe: i have a table in sql server as such create table dbo.mytable( order_id int

I use pyodbc to connect mysql, and successful put some chinese data to mysql but i can't print it out for correct character

I'm ingesting data from salesforce to azure sql database using python with pyodbc. i make a first connexion with salesforce as shown

I have made a python script that connects to mssql database and inserts something there. problem is in this line:

I was wondering if there is a better way to cope with ms-access' inability to handle null for boolean-values other than change the

I'm trying to access an oracle database using odbc in php. (apache 2, php 5, odbc driver and oracle database 11.2 are installed on ubuntu server

I am trying to connect r to database (i just want to point out that i do not have any experience with databases, thats why i was hoping you could

I have the following code: import pyodbc conn = pyodbc.connect('dsn=querybuilder') cursor = conn.cursor() stringa = "select

Here is ms access database, it contains

We are using the jdbc-odbc bridge to connect to an ms sql database. when perform inserts or updates, strings are put into the database padded to

I created a table in sql server as follows: create table testpk ( id int not null identity (1, 1) primary key, numval

I'm trying to connect to a mysql 5 database using the mysql odbc 5.1 driver. in the control panel's odbc settings i created and tested the odbc

Is there any way to connect to an ms sql server database with python on linux using windows domain credentials? i can connect perfectly

I've got an upcoming project wherein i will need to connect our website (php5/apache 1.3/openbsd 4.1) to our back-end system running

I have been stuck up in this scenario. my application is in c++ which connects to mysql database 5.5.34 through mysql odbc connector v5.2

I am trying to get the the day ,month ,year from sql server using cdbvariant but i cant able to do that my code is below what i want is

I can easily access azure sql database through sql server 2014 but when i am trying to connect my php(laravel) web application to azure sql