ODBC

Great Reads

Hadoop For .Net & AngularJS Developers

by Bert O Neill

Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)

MFC CRecordset - How to Bypass the 255 Column Limit

by rev78

Simply bypass the 255 columns in MFC CRecordset

.NET to Hadoop Connection using Kerberos Ticket

by Amit Kumar Tiwari

.NET to Hadoop connection using Keytab file

Multiple parameter "FillBy" method in table adapter using ODBC and PostgreSQL

by Amund Gjersøe

Visual Studio Query Builder does not work with PostgreSQL when you want to use filtering parameters. This tip show how to make your own "FillBy" methods.

Latest Articles

IntelliDisk

by Ștefan-Mihai MOGA

About the IntelliDisk app that uses many components published on CodeProject

MFC CRecordset - How to Bypass the 255 Column Limit

by rev78

Simply bypass the 255 columns in MFC CRecordset

Verify Oracle Client Installation

by WernfriedD

Single .exe to verify if your Oracle Client is properly installed and working. Verify supported technologies for Oracle connection.

Issue Tracker

by Ștefan-Mihai MOGA

Did you spot any bugs today? Than this tool might save some of your time

All Articles

top

ODBC

IntelliDisk

20 Feb 2024 by Ștefan-Mihai MOGA

About the IntelliDisk app that uses many components published on CodeProject

Windows

MySQL

MFC

ODBC

Tally odbc connection with Python ?

25 Dec 2022 by Member 15875688

The above problem is due to cross-platform incompatibility, everything from python to tally needs to be 64-bit or 32-bit You need to do the following Steps 1. Install 64-bit version of Tally and Python 2. Run Tally as Administrator 3. Check in...

Python

Tally

ODBC

How to get full string in sqldatasources

24 Oct 2022 by Richard MacCutchan

SQLCHAR * driverDesc[256]; // both of these are character arrays (assuming you fixed driverDesc) SQLCHAR dsnName[256]; SQLDataSources(henv, // from the below casts I am guessing that this function returns wide characters. ...

C++

ODBC

How to get full string in sqldatasources

24 Oct 2022 by Abishek Samuel

I am getting the first character of the output where as I need full text in the output terminal. Output I get: Data Source - E Data Source - M What I have tried: #define NANODBC_USE_UNICODE 1 #ifdef _MSC_VER #define _CRT_SECURE_NO_WARNINGS...

C++

ODBC

How to get full string in sqldatasources

24 Oct 2022 by Rick York

I think the problem is the type you have declared this variable as : SQLCHAR * driverDesc[256]; That is an array of 256 pointers. The prototype says the function wants a single character pointer. Try using SQLCHAR driverDesc[256];

C++

ODBC

When run Python script from SQL server get error ?

18 Apr 2022 by Richard MacCutchan

This is the same issue as When import and export file using Python with SQL server 2019 I get error ?[^], and I already gave you a suggested solution.

Python3.6

SQL-Server

ODBC

Error when import data from excel to SQL server using Python ?

15 Apr 2022 by Maciej Los

I think you're doing it wrong. If you want to to get data from Excel/MS SQL Server and then to write it into MS SQL Server/MS Excel file, use Python. See: How to Connect to SQL Server Databases from a Python Program - SQLNetHub[^] Using Python...

Python3.6

SQL

ODBC

Error when import data from excel to SQL server using Python ?

15 Apr 2022 by ahmed_sa

I work on sql server 2017 i add script python to import data to excel but i get error (1 row affected) Msg 39004, Level 16, State 20, Line 0 A 'Python' script error occurred during execution of 'sp_execute_external_script' with HRESULT...

Python3.6

SQL

ODBC

Need information on version support

11 Feb 2022 by Member 14362033

Recently I installed php 7.3 on my linux server. Now I need to install php-odbc, php-pdo, php-xml, php-cli, php-gd, php-ldap, php-mbstring, php-myscript, php-pear-norch, Now I don't know which versions of these packages support php 7.3. How can...

PHP

PDO

ODBC

Need information on version support

11 Feb 2022 by M Imran Ansari

Look at the documentation which have necessaries files, extension and all the steps necessary for the installation of the PHP 7.3 with all extension and packages: Installing PHP 7.3 - Linux - Scriptcase Manual[^]

PHP

PDO

ODBC

Cn = new odbcconnection("DSN=tallyodbc_9000") tally connection is giving me error in DLL file but in VB.NET application same connection string runs fine

10 Sep 2021 by ATISH PAI DUKLE

i m trying to develop a dll which will pull data from tally. in vb.net windows application project it runs. But when i use same code to develop a dll which is .netframework 4 build and registered in 64bit .netframework64 folder it gives error as...

Cn = new odbcconnection("DSN=tallyodbc_9000") tally connection is giving me error in DLL file but in VB.NET application same connection string runs fine

10 Sep 2021 by Dave Kreskowiak

It's possible the Tally driver you're using is 32-bit only. Recompile your .DLL to target x86 instead of x64 or AnyCPU and give that a try.

MFC CRecordset - How to Bypass the 255 Column Limit

21 May 2021 by rev78

Simply bypass the 255 columns in MFC CRecordset

HOW to GET a RETURN from a STORED PROCEDURE, using C++, THAT HAS NO PARAMETERS, ONLY an OUTPUT

28 Oct 2020 by inlandchris1

I have finally found it reading the docs: After you do a fetch, now, get the data from SQLGetData. Works with the output param or input_output param but SP has only an output. AlarmCount has the data (long). retcode =...

HOW to GET a RETURN from a STORED PROCEDURE, using C++, THAT HAS NO PARAMETERS, ONLY an OUTPUT

28 Oct 2020 by inlandchris1

Here is the basic code taken from Microsoft docs. I had the biggest trouble connecting but found out, as you can see, the length of the DSN, username, and password has to be spot on. I will later put the size in a variable to clean it up. I...

How do I create an ODBC DSN in SUSE linux

20 Sep 2020 by pooher

I have downloaded Teradata Express 16.20_Sles11 as VM from the Teradata website. I need to create an ODBC DSN for Teradata so that I can connect it with ODBC data sources, but I don't know how to create it in Linux and also for Teradata. I have...

Linux

ODBC

How do I create an ODBC DSN in SUSE linux

20 Sep 2020 by Sandeep Mewara

I am no expert so did a quick Google. I would suggest you to start from here and then post specific queries if any once you try: ORACLE-BASE - Create an ODBC Data Source Name (DSN) on Linux[^]

Linux

ODBC

Odbc32 problem after upgrading framework in 64 bit.

28 Jul 2020 by ekograce

Hi All, I have recently updated my vb.net winform desktop application from framework 4.0 to 4.6.1. I have been using odbc32.dll for my sql server related query. It is no longer working in 4.6.1. It failed in SQLAllocHandle(SQL_HANDLE_DBC, hEnv,...

SQL

Windows

ODBC

Odbc32 problem after upgrading framework in 64 bit.

28 Jul 2020 by OriginalGriff

You cannot mix 32 and 64 bit components in the same application. You will need to either find a 64bit version of you DLL, or compile you app to 32 bits to use it.

SQL

Windows

ODBC

How to connect toad, SQL developer and SSMS using ODBC

27 Jul 2020 by pooher

Hi guys, I need to connect oracle and SQL server databases using ODBC by the following application. 1) Toad 2) SQL Developer 3) SSMS 4) CMD Is there a way to connect these applications thru ODBC. IF yes could you please help me with this. I...

How to handle excel - multiple sheet integration with ODBC driver in C#

10 Jun 2020 by Member 14859151

ohh my bad, I checked and at that time I could not find so I added one more time

SQL

MS-Excel

ODBC

How to handle excel - multiple sheet integration with ODBC driver in C#

10 Jun 2020 by Richard MacCutchan

You already posted this question at How to handle excel - multiple sheets integration with ODBC Driver connection in C# - C# Discussion Boards[^]. Please do not crosspost.

SQL

MS-Excel

ODBC

Create an application supporting multiple database like SQL server, ORACLE etc

8 May 2020 by hanu009

Hello everyone, I am trying to create an application with ODBC compliant code for DB business logic is in c# DBs to use are oracle 12c and 11g and MSSQL I am using ADO.NET, OLEDB, ODP.NET , ODBC etc. Problem is when i try to use the...

Create an application supporting multiple database like SQL server, ORACLE etc

8 May 2020 by RickZeeland

Take a look at Best-orms-for-c[^] And this CodeProject article: VITA – A Powerful and Flexible ORM and Additional Building Blocks for .NET Applications[^] If you don't want to use an ORM, take a look at: Don't Hard Code Your DataProviders[^]

Update a date-time field in Microsoft access 2003 through odbc

3 Sep 2019 by Piper18914

Hi, I am updating a record in Micro-Soft Access-2003. (Yes, 2003.....) When reading the record the dateTime is '2019-07-31T00:00:00.000'. When doing a query on the table, I can search the dateTime using a jullian date, the fractional part being the time of day and works fine in this new...

C++

ODBC

MS-Access

Update a date-time field in Microsoft access 2003 through odbc

3 Sep 2019 by CHill60

Couple of things from a fellow legacy application support type You can still use the column "date", just surround it with square brackets. I.e. update scans1 set [date] = '2019-07-31T00:00:00.000' where id = 21570 I was still getting an error until I changed it toupdate scans1 set [date] =...

C++

ODBC

MS-Access

Tally odbc connection with Python ?

17 Apr 2019 by teja varma

i tried some methods but it not working i using pyodbc for python to connect to tally odbc i tried the dsn also but didn't work please help me out! What I have tried: >>> import pyodbc >>> conn = pyodbc.connect('DSN=TallyODBC64_9000;SERVER=({local});DRIVER=Tally ODBC DRIVER64;PORT=9000')...

Python

Tally

ODBC

Tally odbc connection with Python ?

17 Apr 2019 by Richard MacCutchan

See Connecting to databases · mkleehammer/pyodbc Wiki · GitHub[^] and follow the links to check the specific format of the connection string.

Python

Tally

ODBC

INNER JOIN implementation

20 Feb 2019 by Gerry Schmitz

You create 2 connections in your program; one to each server. Query one; then query the other using the results of the first. Of course, this requires thinking beyond "join all". SQL Servers support "distributed queries". You can get to MySQL via ODBC from SQL Server. Linked servers and...

INNER JOIN implementation

20 Feb 2019 by MyOldAccount

PROBLEM: I need to perform INNER JOIN between 2 SQL queries, but that query would have to access 2 MySQL databases located on their own servers. Small example might explain better the problem I face: select * from Table1, -- Table1 is located on server 72.93.200.11 INNER JOIN Table2 ...

Error for service now source when run using open query

25 Oct 2018 by bunty swapnil

Hi, i had developed a package which integrate data from service now source to SQL database. Steps below which i used for integration. 1. Downloaded Service now ODBC driver 1.0.9 and installed. 2.Created DSN for Service now source and Used DatasourceName as Link_Server. 3.Created linked server...

SQL-Server-2016

ODBC

OA_types not found error in SSIS when connecting to service now data source

7 Oct 2018 by bunty swapnil

Hi, We have requirement to pull the Data from Service now source and import it into SQL using SSIS package. And i followed below steps to bring the data. 1.Created DSN in ODBC driver for Service Now Driver 1.0.14. 2.Then Created Linked server in Microsoft SQL Server 2016 (SP2) (KB4052908) -...

SQL

ODBC

SSIS

How do I connect a PLC Rockwell Logix Controller into a SQL Database

5 Oct 2018 by ThiyagarajanR

Hi,I need to Read some information from a Rockwell ( Allen Bradley) PLC to the SQL Server Database and perform some reporting functions.Could someone help me in Reading the Data from the PLCPLC: Control/ Compact LogixCommunication: TCP/IPOS: Windows XP SP3Visual Studio 2010...

How do I connect a PLC Rockwell Logix Controller into a SQL Database

5 Oct 2018 by stixoffire

Use OPCDA / OPCUA Server Write yourself a service to Read the data you want when you need it. There are also DataLoggers available - but depending on your need you can write your own server to read and write values..

Link access table via odbc driver

2 Mar 2018 by Member 13664630

I need to link to a file which is in Access format (it can be opened by Access), but it has another file type - .dvprj instead of .mdb or .accdb. The file name needs to stay .dvprj so it will open in its application. Access will only recognize .mdb or .accdb databases when linking to Access...

ODBC

MS-Access

Link access table via odbc driver

2 Mar 2018 by Member 13664630

This is a great solution. I will give it a try as I move forward. Thanks, Tom

ODBC

MS-Access

Link access table via odbc driver

14 Feb 2018 by Gustav Brock

First link a copy of the file, renamed as accdb (or mdb). Then run code to relink to the table(s) from the original file: Public Function Relink() Dim Database As DAO.Database Dim Table As DAO.TableDef Dim Connect As String Set Database = CurrentDb ...

ODBC

MS-Access

Non ODBC connection to sage 300 CRE from .NET winform possible?

8 Feb 2018 by nairnishitha

I am working on a Windows forms application, a migration project from Vb6 and need to connect to Sage300 CRE database. I see ADODB connection in Vb6, like "Driver=Timberline Data;DBQ=; CODEPAGE=1252; DatabaseType=1; DictionaryMode=1;MaxColSupport=255;ShortenNames=0;StandardMode=0; ...

ODBC

Non ODBC connection to sage 300 CRE from .NET winform possible?

8 Feb 2018 by Maciej Los

I'd suggest to read this: An Introduction to the Sage 300 ERP .Net API | Stephen Smith's Blog[^] After quick research i'm pretty shure that it's the only way to retrive entire information about database objects such as tables, keys, etc.

ODBC

{“ERROR [08004] [ODBC firebird driver]unavailable database”} ask

8 Feb 2018 by nairnishitha

Have an odbc conenction, to connect to a WMS database (I believe they support odbc only) and on connection open gets the exception {"ERROR [08004] [ODBC Firebird Driver]unavailable database"}. The WMS Server & Client components are installed on the machine where my code also runs. Conenction...

Firebird

ODBC

{“ERROR [08004] [ODBC firebird driver]unavailable database”} ask

8 Feb 2018 by nairnishitha

Had to prefix dbpath with 'localhost:' and password was in lower case. That helped me to connect. But since I had to get schema info, which was limited in ODBC, moved to using FireBirdClient, that is Firebird Ado.Net provider.

Firebird

ODBC

{“ERROR [08004] [ODBC firebird driver]unavailable database”} ask

2 Feb 2018 by Maciej Los

You have to install Firebird: ODBC Driver[^]

Firebird

ODBC

Issue to insert record with datetime to SQL server 2014 via ODBC C++

18 Jan 2018 by Member 11845035

I have a simple c++ code to insert a record in SQL Server 2014 via ODBC. It works fine with varchar fields, but it does not work with datetime field. Can anybody help to understand that is wrong? I've got always: "22018:1:0:[Microsoft][ODBC SQL Server Driver]Invalid character value for cast...

C++

SQL-Server-2014

ODBC

Issue to insert record with datetime to SQL server 2014 via ODBC C++

18 Jan 2018 by Jochen Arndt

Always pass time fields using binary data. That avoids any problems of converting strings to such fields. Just lookup the corresponding C type for the field type. For SQL_TYPE_TIMESTAMP it is SQL_C_TYPE_TIMESTAMP: C Data Types | Microsoft Docs[^]: C type identifier SQL_C_TYPE_TIMESTAMP[c] ODBC...

C++

SQL-Server-2014

ODBC

Issue to insert record with datetime to SQL server 2014 via ODBC C++

18 Jan 2018 by debasish mishra

Invalid character value for cast specification comes from the driver when it detects a string to date time conversion.I urge you to change the data type to a string type or you can tune the logic to ensure that you don't get strings here.

C++

SQL-Server-2014

ODBC

Crystal reports "database logon failed"error?

18 Jan 2018 by Member 10071718

I am developed Windows Form Application using C#. Its printed bill for use the crystal report. But not bill print. comes "database logon failed" error. how can solve this problem? plzz help me. Output: 'POS_System.exe' (CLR v4.0.30319: POS_System.exe): Loaded...

Crystal reports "database logon failed"error?

18 Jan 2018 by an0ther1

Ensure you have added references to Crystal Reports as follows; CrystalDecisions.CrystalReports.Engine CrystalDecisions.ReportSource CrystalDecisions.Shared CrystalDecisions.Windows.Forms Add the following using statements; using CrystalDecisions.CrystalReports.Engine; using...

The login is from an untrusted domain and cannot be used with windows authentication.

15 Jan 2018 by Walid-Gamal

Hi all after creating ODBC Connection to another server in another domain and connected success from administrator user but when I try to get data by another user it gives me the following error [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed. The login is from an untrusted domain...

ODBC

Microsoft

database

The login is from an untrusted domain and cannot be used with windows authentication.

15 Jan 2018 by OriginalGriff

Read the error message: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. That means that your connection string to SQL is trying to use Windows Authentication, and the computer trying to access SQL Server is not on the same network segment. For...

ODBC

Microsoft

database

How to: from MS access create a ODBC table link to datatable inside a DOT NET APP

21 Dec 2017 by DataMig

How To: From MS Access create a ODBC Table Link to DataTable inside a DOT NET APP So the DOT NET APP is like a poor mans SQL Server (or Data Server) The Data is in memory and does not need to be persisted or saved Pointers in the right direction would help Many Thanks In Advance m ...

How to: from MS access create a ODBC table link to datatable inside a DOT NET APP

21 Dec 2017 by Dave Kreskowiak

You have to create a provider one of the database drivers installed on the system, such as OLEDB, ODBC, or whatever. THIS IS FAR FROM A TRIVIAL TASK!! The documentation on this subject is very sparse. You can find the start of it here[^]. More on a few samples (NONE OF WHICH ARE VB.NET OR C#!)...

Asterisk func_odbc stored procedure more then 1 argument

19 Dec 2017 by GTR0123

hello guys i am using asterisk and func_odbc so i have problems on stored procedure plz help me out so the problem is like this so this is my func_odbc: [PRESENCE] dsn=concon EXEC dbo.[Check] @Bnum = '${SQL_ESC(${ARG1})}', @Anum = '${SQL_ESC(${ARG2})}' and here is my stored procedure ...

SQL

Linux

ODBC

ODBC MFC: can't use SELECT properly

13 Dec 2017 by SheepSpeech

Hi! I'm trying to use ODBC with an Access 2000 database in a C++ MFC application. I use the following code to SELECT an entry (which exists) in my Database: CNoeud myNode; myNode.Open(CRecordset::dynaset, L"SELECT * FROM Noeuds where Identifiant_Noeud=5", CRecordset::none); ...

ODBC MFC: can't use SELECT properly

13 Dec 2017 by Jochen Arndt

The keyword is C/C++ pointer arithmetic. The first parameter of the AfxMessageBox() function is an LPCTSTR string pointer. You are passing the address of a constant string and adds the value "5" (myNode.m_Identifiant_Noeud is as primary key probably some kind of int). So the message box shows...

How do use Microsoft access embedded database with ODBC?

11 Dec 2017 by SheepSpeech

I am currently migrating a C++ app using MFC from DAO to ODBC. I have an embedded Microsoft Access database. It's hard for me to understand what is required to use an embedded Access database with ODBC. I know that I need a driver, is it the same driver for an embedded and not embedded Access...

How do use Microsoft access embedded database with ODBC?

11 Dec 2017 by Leo Chapiro

Try to use CDatabase Class[^] : // This fragment is taken from the declaration for CMyDatabaseDoc // CMyDatabaseDoc is derived from CDocument. public: // Declare a CDatabase embedded in the document CDatabase m_dbCust; m_dbCust.OpenEx(_T("DSN=MFC_ODBCTest;UID=JOES"));

Verify Oracle Client Installation

1 Dec 2017 by WernfriedD

Single .exe to verify if your Oracle Client is properly installed and working. Verify supported technologies for Oracle connection.

How do I fix this persistent IM002 connection error when using pyodbc library

18 Oct 2017 by TheLostJedi

I am trying to connect to a .mdb database from Python using the pyodbc library. The connection string I am using is the following: import pyodbc conn = pyodbc.connect('DRIVER={Microsoft Access Driver(*.mdb,*.accdb)};DBQ=C:\\Sample.mdb') But I keep getting the IM002 error telling me that the...

Python2.7

ODBC

MS-Access

Print statement breaking odbc call

17 Oct 2017 by itspaddy

Hi all Using ODBC SQL_OV_ODBC3_80 with SQL Server Native Client 11 driver within a C++ app. Trouble is that several stored procedures have print statements which is breaking the ODBC calls. Is there anyway I can get round this without removing the print statements? Cheers. Found the...

T-SQL

C++

ODBC

Print statement breaking odbc call

17 Oct 2017 by Wendelius

If I recall correctly, you should investigate the SQLSTATE in order to decide if the error is a real error or a warning. Have a look at Appendix A: ODBC Error Codes | Microsoft Docs[^]

T-SQL

C++

ODBC

Implement ODBC driver using .NET

5 Oct 2017 by gilchinger

How to implement a custom ODBC driver using .NET ? Background: For accessing a little bit exotic custom made datasource I'm using some .NET moduls to convert the readonly data to a .NET datatable.The request now is, to make the datasource available as ODBC datasource.The hardcore way...

ODBC

Issue Tracker

11 Dec 2016 by Ștefan-Mihai MOGA

Did you spot any bugs today? Than this tool might save some of your time

Modalpopup extender inside another modalpopup extender

31 Aug 2016 by mridulkoul123

gridview1 inside modalpopupextender1 with a linkbutton opens another modalpopupextender2 with gridview2. now when i am clicking linkbutton of gridview1 which is inside modalpopextender1 ....modalpopupextender2 does not popup ...and not even showing any errors...its just when i inspect the...

Modalpopup extender inside another modalpopup extender

31 Aug 2016 by Andy Lanng

I'm gonna be pretty anal about this, but your code is very vulnerable. MySQL really doesn't like un-disposed connections.Please change your code as follows://Move your query to a const strin. This is just good practice private const string Query =@"SELECT a.orig_clli, ...

Modalpopup extender inside another modalpopup extender

30 Aug 2016 by Andy Lanng

Check your connection string format:MySQL Connector/ODBC 3.51 Connection Strings - ConnectionStrings.com[^]

Sybase ODBC timeout error

29 Jun 2016 by Member 9330747

Hi all,I am trying to connect Sybase database using C# from Visual studio.But I'm getting this error after around 30 seconds -ERROR [00000] [Sybase][ODBC Driver]The command has timed out.Actually it requires 1 minutes 18 seconds to execute the query in Sybase.This is my full...

.NET to Hadoop Connection using Kerberos Ticket

26 Mar 2016 by Amit Kumar Tiwari

.NET to Hadoop connection using Keytab file

How can I connect to a Microsoft access database from php WITHOUT using odbc

24 Jan 2016 by Dave Kreskowiak

Your only other option is OleDb, using either the ACE or JET engines depending on the version of the Access database you're trying to get at.

How can I connect to a Microsoft access database from php WITHOUT using odbc

24 Jan 2016 by Member 12284393

I am trying to connect to a microsoft access database that was given to me by using PHP. I would rather not use ODBC drivers to connect but I haven't been able to find a way to connect to the database otherwise.Any ideas? Only requirements are that it needs to be able to read and write...

Hot add two seperete table fealds to one select query

19 Jan 2016 by Badal Kumar

payments table not specified in your from clause.

MySQL

ODBC

Hot add two seperete table fealds to one select query

19 Jan 2016 by Eranga Gamagedara

I try to extract data using bellow query , it sow this error after execution . please help me to correct this query.Error: #1054 - Unknown column 'payments.date' in 'where clause' My query;SELECT issue.bill_id as 'Bill id', items.i_code as 'Item code', issue.qtt as 'Qtt',...

MySQL

ODBC

Hadoop For .Net & AngularJS Developers

29 Dec 2015 by Bert O Neill

Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)

Javascript

.NET-Compiler-Platform

Get the latest record per item- help

3 Dec 2015 by FrancoisViljoen

(Not syntactically correct, but shows the point)First step would be to do the following:select item_no, max(created_date) as 'created_date' from itemposts group by item_noNow you have, for every item_no, the date for which you want the itempost record.Once you have that, you...

SQL

ODBC

Get the latest record per item- help

3 Dec 2015 by Kristian_dk

Hello everyone - i have a sql riddle that is driving me crazy.I have 2 TablesItem and itempostsI want to joint them on item_no and then get the latest itempost, posting_id from the itempost table for each item.Each posting_id has a created_date.My hope will be to get a list...

SQL

ODBC

problem with OdbcDataReader .GetSchemaTable()

14 Sep 2015 by CPallini

There's the following note in the MSDN documentation[^]:To make sure that metadata columns return the correct information, you must call ExecuteReader with the behavior parameter set to KeyInfo. Otherwise, some of the columns in the schema table may return default, null, or incorrect data.

ODBC

problem with OdbcDataReader .GetSchemaTable()

14 Sep 2015 by AhmedOsamaMoh

dears now i have a huge table with more than 300 column , when i used the following code OdbcDataReader DbReader = DbCommand.ExecuteReader(); DataTable MyTable = DbReader.GetSchemaTable(); i am getting only 255 columns onlywhat should i do??

ODBC

retrieving data from database

5 Aug 2015 by syam0701

Hi all, I am fetching 1000 records at a time using SQLFetchScroll (). I got id array 1000 records but name structure i am getting garbage values. how to get both array and structure values at a time.int id[1000]; struct { SQLINTEGER len; unsigned char arr[82]; }...

VisualC++

SQL

ODBC

VB.NET - Firebird ODBC adapter fill datagrid.

16 Jul 2015 by Marcus Genovese

I am developing a Windows Forms application with firebird DB using ODBC driver to connect to the database and should fill a DataGrid with the results of a query; This is the code but I do not work in ..... what am I wrong?Private Sub Form1_Shown(ByVal sender As Object, ByVal e As...

Firebird

ODBC

DataGridView

PostgreSQL ODBC driver throws error

24 Jun 2015 by V.

I made an application in WPF that uses a postgres database. This is working fine locally.I tried to upload the binaries to another machine, installed the ODBC driver, triple checked everything I could find on the internet, but I can't get it to work:[ERROR [IM002] [Microsoft][ODBC...

PostgreSQL

ODBC

PostgreSQL ODBC driver throws error

24 Jun 2015 by V.

[SOLVED]Go figure, the driver name should have been "{PostgreSQL UNICODE}" instead of "PostgreSQL Unicode(x64)" despite the registry telling me something else. I went back to the basics and used connectionstrings.com and just tried.[/SOLVED]

PostgreSQL

ODBC

Postgersql - While Inserting Many Entries Using Odbc. Can I Write Only One Prepare And Bind Stament ?

21 Jun 2015 by Member 11782215

I have a postgres performance related doubt. if i want to do a repeatively insert many entries then prepare stament and bind stament is same but bind variables only differ . Can i able to change the bind variables alone while executing all the staments. sudo code example :stmt = insert...

How Do I Import Field Names From A Excel Sheet

10 Jun 2015 by jdeep84

try this.Workbook workbook = new Workbook(); workbook.LoadFromFile(@”..\yourfile.xlsx”); Worksheet sheet = workbook.Worksheets[0]; DataTable dt = sheet.ExportDataTable();or may be below link will help...

ODBC

How Do I Import Field Names From A Excel Sheet

9 Jun 2015 by sriram2294

iam working on a project to import external excel sheet into a sql server.i need to know how to import field names from a excel sheet so that i can import data in corresponding fields in the sql server.

ODBC

How to insert data to MSSQL Server with odbc connection in PHP

2 Apr 2015 by Peter Leow

You are messing up the quotes and injecting query string directly into sql statement. That is open for SQL Injection[^].$para1 = mysqli_real_escape_string($connection, $_POST['yatisno']);$para2 = mysqli_real_escape_string($connection, $_SESSION['login_user']);$q = "INSERT INTO...

SQL-Server-2008R2

PHP

ODBC

How to insert data to MSSQL Server with odbc connection in PHP

2 Apr 2015 by Tahsin Çetin

I am trying to insert my data to mssql server with odbc using PHP but it doesnt insert any rows.Here My PHP Codes:$q="INSERT INTO dosyadegerlendirme ( YatisNo, Degerlendirici, ...

SQL-Server-2008R2

PHP

ODBC

Access 97 Frontend - SQL Server 2005 Backend Linked Table Error

2 Apr 2015 by JammoD87

Hi,I have a legacy Access 97 Frontend application which utilises a SQL Server 2005 backend over a SQL Server ODBC Driver (Connection), we use the Linked Table feature on this setup.I create, amend and link in tables on a daily basis and I am aware of the conversions that occur between...

SQL

ODBC

MS-Access

How to work with jdateChooser

6 Jan 2015 by Member 11348104

How to get dates from 2 different jDateChooser and use them in query likeselect *from records where date between jDateChooser and jDateChooserHelp will be very much appreciated and thanks in advance.EDIT:I have tried doing this still gives me error type mismatchDate...

Java

ODBC

Unable to get the result of query

2 Jan 2015 by Maciej Los

When you work with MS Access database, proper query is:SELECT * FROM records where bill_issued_on BETWEEN #2015-01-01# AND #2015-12-28#See this: Examples of using dates as criteria in Access queries[^]BTW: i do not recommend to use SELECT *, because of query performance. Rather than...

Java

ODBC

Unable to get the result of query

2 Jan 2015 by Sergey Alexandrovich Kryukov

First of all, you are applying BETWEEN to strings, but apparently you need to apply it to dates. Please see, for example: http://www.techonthenet.com/sql/between.php[^].Worse, the way you compose your query is wrong from the very beginning. Your query is composed by concatenation with...

Java

ODBC

Unable to get the result of query

2 Jan 2015 by Member 11348104

Hello everyone i am stuck at this for quite some time i am new to java help would be very appreciated Basically i am getting result of all customers between specified dates bill_issued_on datatype=date\time in accessString sDate=(...

Java

ODBC

How to Fetch the Daybook entries of tally for a particular date using xml(Soap) Request

15 Dec 2014 by Sujit Kumar Sahu

>I am unable to Fetch the Daybook entries from Tally for a particular date can you help me in fetching(Exporting) the DayBook Entries for a particular date or fetch the entries by the voucher key or voucher id . i am trying to fetch the daybook entries for a particular date but in response...

Quick Introduction to YB.ORM - Object Relational Mapper for C++

30 Oct 2014 by Vaclav Naydenov

How C++ library YB.ORM can help manipulate the data stored in RDBMS using domain classes. Basic concepts of ORM are explained by examples.

ODBC Api, retrieve result SQLExecDirect

29 Oct 2014 by Vaclav Naydenov

ODBC is a kind of API that is more easily understood by example.#include #include #include int main() { SQLHENV henv; SQLHDBC hdbc; SQLHSTMT hstmt; SQLRETURN rc; /* allocate handles and connect */ SQLAllocHandle(SQL_HANDLE_ENV,...

C++

ODBC

ODBC Api, retrieve result SQLExecDirect

20 Oct 2014 by Member 11086796

Hi, i'm new in C++ and using the ODBC Api from Microsoft.My question is how i retrieve the result of: SQLExecDirect(hstmt, "Select Count(*) From Table", SQL_NTS);It is a little confuse to me the use of the ODBC Api.Thanks

C++

ODBC

Link to SQL Table in Access 2003

12 Sep 2014 by jimc1968

I have an SQL 2008 database containing a table with close to 1 million records. I'm trying to connect with an Access 2003 database via ODBC. I create the ODBC connection successfully, and I use that connection to link my tables. When I get to the end of the wizard, I can see the list of tables....

SQL-Server-2008R2

ODBC

MS-Access

How to Query Against ODBC database

12 Sep 2014 by ZurdoDev

The only way you can have your application support multiple types of datasources is if you write the different versions of the tsql based on your target. Microsoft Access will be different than Sql which is different than MySql which is different than Oracle. They all have some different...

SQL

ODBC

database

How to Query Against ODBC database

12 Sep 2014 by Mohamed Rafiq K

Hi,I want create a table using sql query in my c# application.it is getting only odbc connection string.obviously i can get the database provider by the odbc connection string.i cant execute the create table query in some database.it is throwing error.because all the database field...

SQL

ODBC

database

Issue in WMB message broker insert to a Sybase Database Table

20 Aug 2014 by WENzER

Currently am facing an issue while inserting data in to Sybase database 15.7 with WMB code flow. Am currently using WMB7 Broker and I have written code in our message flow which is trying to insert the data in the table directly rather than using store procedure. The data types used in database...

driver

ODBC

database

Crystal Report Generate Client Machine using MySQL ODBC Connection

10 Jul 2014 by abdulsafran

I have created C# application using visual studio 2008, I have added some reports from Crystal Reports. For the Crystal Report I have used ODBC connection which created ODBC MySQL. All the reports are generating pertectly in my machine.But, once I clicked the report generate button function...