Open Database Connectivity (ODBC) provides a standard software interface for accessing database management systems (DBMS).
1
vote
1answer
11 views
Preparing a sql statement with odbc_prepare using wildcards
I am trying to protect myself from sql injection attacks using the odbc_prepare() function, then executing with odbc_exectue() but I am having problems doing this with wildcards.
My statement looks ...
2
votes
1answer
13 views
Excessive growth of Access 2010 database
I have a problem of excessive database growth when inserting data via ODBC into an Access 2010 database (.accdb). For example, in one case the database grows from 24MB to 140MB, but when compacted ...
0
votes
1answer
13 views
Server 2008r2 x64 and ODBC Connector
server 2008r2 x64,
mysql 5.5.24 x86,
access 2007 x86
im trying to connect mysql backend to access 2007 frontend...
after I installed mysql-connector-odbc-5.1.12-win32.msi and rebooted server. that ...
0
votes
1answer
8 views
Vertica odbc missing /opt/vertica/lib64/libverticaodbc_unixodbc.so
I am having issues with opening an odbc connection with Vertica from my machine (running centOS)
as far as i understand i have all possible packages installed for this to work but i am still missing ...
0
votes
2answers
16 views
Connecting to an MSSQL database through ODBC Error
Where to start..
I have a server with windows 2008 R2 standard 32 bits.
On that server ISS 7 is installed and a php site is added but requires databases.
Made an sql database on that server wich is ...
0
votes
0answers
18 views
Error 20009 (severity 9):Unable to connect: Adaptive Server is unavailable or does not exist OS error 111, “Connection refused”
while trying to connect to remort mssql server by command
tsql -S SQLEXPRESS -U sa
passwod :sa
it throws error as
Error 20009 (severity 9):Unable to connect: Adaptive Server is unavailable or ...
0
votes
0answers
21 views
Refresh Pivot table periodically
I have a pivot table in Excel which gets data pulled from a query with a ODBC connection from an Oracle Database which I set up on a Remote desktop where the Oracle Listener is installed.
The Excel ...
0
votes
1answer
19 views
Connecting to database with ODBC results in warnnings and notjing printed
Hi I am trying to use ODBC with php and I seem to be having some problems.This is my code:
<?php
$connect = odbc_connect("digitallibrary", "root", "");
$sql = "SELECT name FROM books";
...
0
votes
0answers
11 views
Create Db instance in cpp by odbc CConnection
Have to connect to DB by odbc named "ABC" already made in server odbc settings. and do the following in code
dbT_VOY tT_VOY(dbase2);
CString csFilter;
cout<<"the enetered voyage number ...
0
votes
0answers
26 views
Database connection implemented in cpp , Asking for db password when used in application
Following code is written in cpp, this code connects to db and brings a value set by the filters. This code is used in a application exe. Everything is working fine but when it goes to open block in ...
0
votes
3answers
43 views
I have multiple queries which i want to put in one transaction. How to go about it? [closed]
I have 3 commands 1st to update, 2nd to delete and insert. I want to implement insert command only if update and delete executed without any exception. I'm new to this. Please help me out.
Here is my ...
0
votes
1answer
39 views
ORA-12154 error when using Oracle Instant Client
I am getting this error trying to do a test connection on an ODBC DSN with the Oracle Instant client setup on Windows 7 32 bit. I have it working on another machine with Vista 32 bit.
Info:
1. Dir ...
0
votes
0answers
25 views
Error when insert through a link server from sql server
I'm trying to insert some data from a c# application to an AS400 server.I made a DSN in Control panel,Data Sources :
Data source name : Newissues
Description :iSeries Access for Windows ODBC data ...
-3
votes
1answer
26 views
Import a range of cells from an Excel file into MySQL [closed]
I have some Excel files and every end of month I will have those Excel files to calculate expenses and revenues. The issue is that the accounting department sends me Excel files that are is too much ...
1
vote
1answer
28 views
How to load SQL data into the Hortonworks Sandbox?
I have Installed Hartonworks SandBox in my pc . also tried with a CSV file and its getting in a table structerd manner its ok(Hive + hadoop), nw i want to migrate my current sql Databse into ...