Related
Jaskmar Is it possible to make an ODBC connection without installing a system level driver? Can I just point to the DLL containing the driver? I'm using it in 32bit C++, currently testing it on Windows, connecting to a Firebird database. I have tried the follo
previous One of our statisticians is stuck trying to read data from mongoDB using SAS. In my experience connecting mongo to other languages always requires the use of native drivers, but in this case I have found that it is only possible to use ODBC. I'm tryin
previous One of our statisticians is stuck trying to read data from mongoDB using SAS. In my experience, connecting mongo to other languages always requires using native drivers, but in this case I found that only using ODBC is possible. I'm trying to find a b
motto I have code taken from Qt Wiki: QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
db.setDatabaseName("DRIVER={Microsoft Excel Driver (*.xls)};DBQ=" + QString("sht.xlsx"));
if(db.open())
{
QSqlQuery query("select * from [" + QString("Sheet1") + "$
motto I have code taken from Qt Wiki: QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
db.setDatabaseName("DRIVER={Microsoft Excel Driver (*.xls)};DBQ=" + QString("sht.xlsx"));
if(db.open())
{
QSqlQuery query("select * from [" + QString("Sheet1") + "$
motto I have code taken from Qt Wiki: QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
db.setDatabaseName("DRIVER={Microsoft Excel Driver (*.xls)};DBQ=" + QString("sht.xlsx"));
if(db.open())
{
QSqlQuery query("select * from [" + QString("Sheet1") + "$
Dan Rex I work for a company in New Zealand. Currently, we use a remote server (Plexus) to store large amounts of data (>2 billion rows for some tables). We've started using SharePoint routing, and I've created many databases and applications in SharePoint tha
Dan Rex I work for a company in New Zealand. Currently, we use a remote server (Plexus) to store large amounts of data (>2 billion rows for some tables). We've started using SharePoint routing, and I've created many databases and applications in SharePoint tha
Kostya Cherno I have a simple code that selects data using MySQl and PHP. here is: <?php
require_once 'login.php' ;
$db_server = mysql_connect($db_hostname, $db_username, $db_password);
if (!$db_server) die ("Unable to connect to MySQL: " . mysql_error());
m
motto I have code taken from Qt Wiki: QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
db.setDatabaseName("DRIVER={Microsoft Excel Driver (*.xls)};DBQ=" + QString("sht.xlsx"));
if(db.open())
{
QSqlQuery query("select * from [" + QString("Sheet1") + "$
motto I have code taken from Qt Wiki: QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
db.setDatabaseName("DRIVER={Microsoft Excel Driver (*.xls)};DBQ=" + QString("sht.xlsx"));
if(db.open())
{
QSqlQuery query("select * from [" + QString("Sheet1") + "$
Dan Rex I work for a company in New Zealand. Currently, we use a remote server (Plexus) to store large amounts of data (>2 billion rows for some tables). We've started using SharePoint routing, and I've created many databases and applications in SharePoint tha
Dan Rex I work for a company in New Zealand. Currently, we use a remote server (Plexus) to store large amounts of data (>2 billion rows for some tables). We've started using SharePoint routing, and I've created many databases and applications in SharePoint tha
Wilzerbert I am using the following command to connect to an xlsx file via ODBC : "DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);HDR=YES;IMEX=1;READONLY=TRUE;DBQ=C:\Temp\test.xlsx"
It works fine, but when there is no header in the file, I alwa
mood I try to use the new container based infrastructure on Travis. But I have a problem with installing the ODBC driver. Now, I'm going to use sudoit. sudo: required
addons:
apt:
packages:
- unixodbc
- unixodbc-dev
- libmyodbc
before
mood I try to use the new container based infrastructure on Travis. But I have a problem with installing the ODBC driver. Now, I'm going to use sudoit. sudo: required
addons:
apt:
packages:
- unixodbc
- unixodbc-dev
- libmyodbc
before
Wilzerbert I am using the following command to connect to an xlsx file via ODBC : "DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);HDR=YES;IMEX=1;READONLY=TRUE;DBQ=C:\Temp\test.xlsx"
It works fine, but when there is no header in the file, I alwa
Wilzerbert I am using the following command to connect to an xlsx file via ODBC : "DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);HDR=YES;IMEX=1;READONLY=TRUE;DBQ=C:\Temp\test.xlsx"
It works fine, but when there is no header in the file, I alwa
Wilzerbert I am using the following command to connect to an xlsx file via ODBC : "DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);HDR=YES;IMEX=1;READONLY=TRUE;DBQ=C:\Temp\test.xlsx"
It works fine, but when there is no header in the file, I alwa
mood I try to use the new container based infrastructure on Travis. But I have a problem with installing the ODBC driver. Now, I'm going to use sudoit. sudo: required
addons:
apt:
packages:
- unixodbc
- unixodbc-dev
- libmyodbc
before
Wilzerbert I am using the following command to connect to an xlsx file via ODBC : "DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);HDR=YES;IMEX=1;READONLY=TRUE;DBQ=C:\Temp\test.xlsx"
It works fine, but when there is no header in the file, I alwa
Wilzerbert I am using the following command to connect to an xlsx file via ODBC : "DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);HDR=YES;IMEX=1;READONLY=TRUE;DBQ=C:\Temp\test.xlsx"
It works fine, but when there is no header in the file, I alwa
Wilzerbert I am using the following command to connect to an xlsx file via ODBC : "DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);HDR=YES;IMEX=1;READONLY=TRUE;DBQ=C:\Temp\test.xlsx"
It works fine, but when there is no header in the file, I alwa
Floris I am trying to connect to a PostgreSQL database using the R ODBC driver in RStudio. R cannot detect the driver for some reason: $ Rscript -e 'odbc::odbcListDrivers()'
[1] name attribute value
<0 rows> (or 0-length row.names)
Even though they a
Andre I deployed a PHP Cloud Foundry application using a PHP buildpack. This buildpack has an ODBC Cli extension so I can use DB2 functions and connect to DB2 on the cloud. But I can't connect to the Z/OS DB2 database through Secure Gateway because I get a lic
Floris I am trying to connect to a PostgreSQL database using the R ODBC driver in RStudio. R cannot detect the driver for some reason: $ Rscript -e 'odbc::odbcListDrivers()'
[1] name attribute value
<0 rows> (or 0-length row.names)
Even though they a
Snow I want to check if Cloudera's Hive ODBC driver is installed on my machine. Its registry key is HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC. How should I check? Snow Registry keys can be verified using the reg query tool . This parameter must be use
Floris I am trying to connect to a PostgreSQL database using the R ODBC driver in RStudio. R cannot detect the driver for some reason: $ Rscript -e 'odbc::odbcListDrivers()'
[1] name attribute value
<0 rows> (or 0-length row.names)
Even though they a
Rex Bloom I'm using RAD Studio XE8, C++Builder, FireDac on Windows 8.1. I am connecting to SQL Server 2012 on a virtual machine on the network. I'm using ODBC when I connect the FireDac. This is the driver signature reported by FireDac. [FireDAC][Phys][ODBC][M