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

.NET to Hadoop Connection using Kerberos Ticket

26 Mar 2016 by Amit Kumar Tiwari

.NET to Hadoop connection using Keytab file

XML

.NET4.5

.NET

[ODBC Microsoft Access Driver] Query input must contain at least one table or query

4 Feb 2012 by vrushali katkade

i have used the odbc to excute the query.i have attached the access(.mdb) database to the dsn then used the following query insert into SCRIPT (ID1, NM ) select '10' as DTID1 , 'DD' as DTNM Union All select '20' as DTID1 , 'DRR' as DTNM Union All select '30' as DTID1 , 'DDD'...

ODBC

[ODBC Microsoft Access Driver] Query input must contain at least one table or query

4 Feb 2012 by Christian Graus

This looks messy, why can't you just have insert into xxx values(x,y) ?

ODBC

abort or kill "exec master..xp_cmdshell bcp select" when cancel button click in c# windows application

17 Jul 2012 by D-Kishore

Dear Friends,I had one issue in C# windows application.Here i am working with C# windows applications.My question like, i have one form with two buttons submit & cancel In button click i am staring one thread.The thread contains one stored procedure having the below code...

SQL

ODBC

abort or kill "exec master..xp_cmdshell bcp select" when cancel button click in c# windows application

2 Jul 2012 by sinhasourabh

It is more a suggestion, Try to fetch the processid for your process using System.Daignostic; and terminate that process on your cancle button click event.

SQL

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

Access Data Source that is a 64 bit odbc driver

13 Apr 2012 by tharre

Hello all, I've written a program that has worked well on 32 bit machines but, I have found that on W7 the application puts the driver in the wow5624 directory for the ODBC. I can access and find the data source but when I try to do a connect I get an error message something like, cannot find...

Access Data Source that is a 64 bit odbc driver

13 Apr 2012 by Kuldeep B

Hi Tharre...1)Download AccessDatabaseEngine_x64.exe fromhttp://www.microsoft.com/download/en/details.aspx?id=13255[^]2)Uninstall MS Office from your Machine.3)Install AccessDatabaseEngine_x64.exe.4)Install MS OfficeThen try your application.May this help you.Enjoy...

Access Data Source that is a 64 bit odbc driver

13 Apr 2012 by tharre

Hi Kuldeep,Guess I wasn't clear enough. The application that created an ODBC placed it's ODBC into the SysWOW64 directory. I have written code that can retreive the Data Source from the 64-bit registry but when I use the name it cannot find the source because the vb program seems to be...

Accessing 64-bit SQL Anywhere DB DSN source

16 Apr 2012 by tharre

Hello all,Well, I've run into a road block and could use some ideas. I built a program that looks at a SQL Anywhere database 9.0. It has worked fine under XP or windows 7 as long as the DB is in the 32bit ODBC directory. As the application that creates the database, not mine, puts it...

ODBC

64-bit

Accessing 64-bit SQL Anywhere DB DSN source

17 Apr 2012 by Maciej Los

Try to run: C:\Windows\SysWOW64\odbcad32.exe to register new DSN source. And use this DSN name building connection string ;)

ODBC

64-bit

Add, Edit & Delete DSN using MySQL ODBC & VB.NET

13 May 2013 by JMAM

Hi I would like to know the best code for Add, Edit & Delete DSN using MySQL ODBC & VB.NET.So far this is my code, the problem is that i need to run the system as admin.Imports Microsoft.Win32Public Class frmmysqlDSN Inherits System.Windows.Forms.Form#Region " Windows...

MySQL

ODBC

Add, Edit & Delete DSN using MySQL ODBC & VB.NET

13 May 2013 by Dave Kreskowiak

You're not explaining the problem and how you expect this stuff to work at all.You need admin priv's because you're writing to HKEY_LOCAL_MACHINE. Normal users cannot do that and there is no way around it.

MySQL

ODBC

Add, Edit & Delete DSN using MySQL ODBC & VB.NET

8 May 2014 by santidat

Dear Sir :Thanks for your code.It is true you need permissions to write in the LOCAL_MACHINE , but you can save the DSN in the CURRENT_USER (Registry.CurrentUser)Ichecked the drive using the local machine registry key and create the dns in the CurrentUserIt works fine for me.I...

MySQL

ODBC

ADO.Net ODBCConnection is not returning InfoMessage event!!

17 May 2012 by debdeep Bhattacharyya

I am using ODBCConnection and trying to get back InfoMessage .. the sql anywhere driver is odbc11.dll. I am not getting the InfoMessage even raised!! Can someone please help! The server is Sybase IQusing System.Data.Odbc;using System;namespace ConsoleApplication2{ class Program...

ADO.NET

ODBC

ADO.Net ODBCConnection is not returning InfoMessage event!!

17 May 2012 by Wendelius

Few things you could try:- define the message as TYPE WARNING- Use ExecuteNonQuery instead of ExecuteReader

ADO.NET

ODBC

ADO.Net ODBCConnection is not returning InfoMessage event!!

17 May 2012 by debdeep Bhattacharyya

I am using AsaConnection instead of OdbcConnection. It is provided by Sybase SQL Anywhere inside ianywhere.data.asaclient.dll .. Now I get back the InfoMessage!!

ADO.NET

ODBC

AS400 Multi-Member Integrated File

24 Nov 2010 by Bman232003

I'm trying to extract data from a multi-member file on an AS400. The member resides in /qsys.lib/aplus7fts.lib/rcw@@.file(rcwxx.mbr) within the Integrated File System.Best case scenerio, I would like to retrieve this data via SQL. I have read articles on doing a create alias mylib/myfile for...

SQL

ODBC

AS400 Multi-Member Integrated File

14 Aug 2011 by S Douglas

I am not sure about mulit-member objects on the AS400, but I do connect to an AS400 from SQL to extract data. Not sure if this will help but worth a try1) Create linked server, using provider IBM DB2 for i5/OS...2) Under providers, locate the IBMDA400, allow inprocess, set to true3) In...

SQL

ODBC

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

c# ODBC connection to a remote (Non SQL) server to retrieve .csv file

7 Dec 2013 by PClarkeirl

Hello,I have a c# application which uses ODBC connections to various databases successfully (eg. DB2 database on iseries) I now need to access a .CSV file on a remote printer server which, is not a SQL server, but I am having problems finding a driver for this. I am able to successfully remote...

ODBC

C++: ODBC MSSQL Server SQLBindParameter() time binding problems

14 Feb 2013 by Alexey Loire

Heya everyone.I'm stuck while working on my programm.The problem is the following:Preambulae:My app is connecting to the SQL SERVER 2008r2 via ODBC driver and then executes INSERT statement. There're lots of params in it, but i'm stuck with inserting time data. DB has field which needs...

C++

SQL-Server

ODBC

C++: ODBC MSSQL Server SQLBindParameter() time binding problems

14 Feb 2013 by Alexey Loire

I've found out what caused the problem. Found it in expierence way.The THING that was wrong is:retCode = SQLBindParameter(sqlstatementhandle, 5, SQL_PARAM_INPUT, SQL_C_TYPE_TIME, SQL_TYPE_TIMESTAMP, SQL_TIME_LEN, 0, &Duration, 0, &cbTime);SQL_TIME_LEN - is made by microsoft. by...

C++

SQL-Server

ODBC

C/C++ ODBC Handle Wrappers

2 Aug 2012 by v3nOm_

In order to further explore ODBC and increase my programming experience i was going to put together my own ODBC wrapper classes. Below are the wrapper classes i have made so far and i'm curious on any problems anyone happens to see with it :) thanks for the help and cheerstemplate

C/C++ ODBC Handle Wrappers

5 Aug 2012 by armagedescu

As suggestions. If you return bool then you have to return false/true instead of FALSE/TRUE, because you are not using BOOL. Second, don't name the class Handle. Instead of CConnectionHandle use CConnection name, or even better CDatabase. Instead ir CStatementHandle use CStatement or CQuery, and...

C/C++ ODBC Handle Wrappers

3 Aug 2012 by v3nOm_

I do appreciate your feedback and understand I am missing a lot :) I think it's better to get advice early then to late and have a lot of rewriting :) thanks for the advice and your time

C/C++ ODBC Handle Wrappers

3 Aug 2012 by JackDingler

My advice is to test the code yourself first, to see if it solves the problem you are addressing.I've had little need in the last decade, to do much with the ODBC layer. Using Wizard generated code such as MFC generated classes based on CRecordset, save a lot of time, and perform well enough...

Calling Oracle StoredProc using Win32:ODBC

18 Jan 2013 by Member 9767982

I'm using Perl 5, version 14.The Win32::ODBC is VERSION = '0.034'; and Oracle as database. Im able to reteive information from the database using queries like "emp_id, emp_name from emp" by the following codeuse Win32::ODBC;$db= new...

Calling Oracle StoredProc using Win32:ODBC

18 Jan 2013 by Hasham Ahmad

try this??my $ST=$DB->prepare("call apps.package_name.proc(?, ?, ?)");my ($ST_result, $arg1, $arg2);...$ST->bind_param(1, $arg1);$ST->bind_param(2, $arg2);$ST->bind_param_inout(3, \$ST_result, 0, { ora_type=>ORA_RSET } );$ST->execute();while (my $hr =...

Can we display image from Database SQL SERVER or Odbc and front end as HTML ?

7 Jan 2014 by Amirsalgar1

Hello friends ,Can we display image from Database SQL SERVER or Odbc and front end as HTML ?Thanks in Adv :)

HTML

SQL-Server

ODBC

Can we display image from Database SQL SERVER or Odbc and front end as HTML ?

8 Jan 2014 by thatraja

With HTML you can't do much things. Go with server side like ASP.NET or php. And check these jQuery plugins, do customization & merge it. And Google for more samplesTop 10+ jQuery Database Plugins[^]7 jQuery Fullscreen Slideshow Plugins[^]

HTML

SQL-Server

ODBC

Can we display image from Database SQL SERVER or Odbc and front end as HTML ?

8 Jan 2014 by Christian Graus

I assume by HTML, you just mean, any web platform. Typically, you create a HTTP handler on a URL, which then takes an id, which identifies the image in the DB, reads it out, and returns it to the browser.You sure do not need to buy a library to do this ( like Dynamsoft ), but you will...

HTML

SQL-Server

ODBC

Cannot connect to MYSQL server using ODBC Connection

22 Apr 2011 by Varshini2009

Hi All,I had connected to the MYSQL database using WCF services with connection string:OdbcConnection sqlcon = new OdbcConnection("DRIVER={MySQL ODBC 3.51 Driver};SERVER=xxx.xxx.xxx.xx;database=xxxxxx;UID=xxxxxx;Pwd=xxxxx;Connect Timeout=500; pooling=true; Max Pool Size=200");I had...

MySQL

WCF

ODBC

Cannot connect to MYSQL server using ODBC Connection

22 Apr 2011 by Kim Togo

Perhaps a firewall is in place and block connection to MySQL tcp port 3306 ?Is the MySQL and your program running on the same computer?Can't connect to [local] MySQL server[^]Another thing, take a look at the managed MySQL database connector and skip ODBC.Download Connector/Net[^]

MySQL

WCF

ODBC

Cannot connect to MYSQL server using ODBC Connection

22 Apr 2011 by Prasanta_Prince

1. Make sure you have installed the .Net Framework on your server 2. Download the ODBC .Net data provider and install it on your development machine or your server. You can download it here:...

MySQL

WCF

ODBC

Cannot connect to MYSQL server using ODBC Connection

23 Apr 2011 by Pratik Bhesaniya

Refer below it will help you,Link1[^]Link2[^]

MySQL

WCF

ODBC

Changing culture on the Postgresql ODBC driver

16 Jan 2012 by Amund Gjersøe

I've used the ODBC driver when generating DataSets in Visual Studio 2010 multiple times, but this time it all went wrong. The table in the DB has a set of columns defined as numeric(7,2). I try to insert data through the autogenerated Insert method like this:int x =...

PostgreSQL

ODBC

Changing culture on the Postgresql ODBC driver

16 Jan 2012 by Amund Gjersøe

Lol, things work in mysterious ways!It turns out that to get the Postgres ODBC driver to work properly I had to read from the table before inserting data into it. In all other applications I did read from the DB as well as write. In my current application I only write, and that was the...

PostgreSQL

ODBC

CLongBinary & RFX_LongBinary !? How to

19 Jul 2011 by Mr. Tomay

I have created an SDI project with ODBC support using the class wizard.In my database file (MS Access ".mdb"), there are some fields with type "OLE Object".To bind the db columns with the app record-set data members, the class wizard has choosed to bind db "OLE Objects" with record-set...

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.

Codes in accessing a mysql database using ado and mysql odbc driver in vb6

22 Mar 2011 by grander22

please help me. can someone teach me on what are the codes and where to put them if i where to use mysql as my database, adodb as my codes and vb6 for the interface? or can someone give me a sample project?

MySQL

ADO

ODBC

Codes in accessing a mysql database using ado and mysql odbc driver in vb6

22 Mar 2011 by Kschuler

Try google.[^]

MySQL

ADO

ODBC

Command.ExecuteNonQuery Not Take Effect

4 Jan 2013 by Mr. Mahesh Patel

Hi experts,I am Using Microsoft Visual Studio 2005 and MSSQL Server 2005.In my Website i am using ODBC Connection using "System DSN".In my code of get Data, it is working successfully.But, in my code of Insert Data to Database, I am Execution Non Query which is not taking effect...

Command.ExecuteNonQuery Not Take Effect

4 Jan 2013 by Jan Steyn

You must use the full ODBC call syntax. It also doesn't use named parameters, so you would use a question mark in each param's placecmd.CommandText = "exec Save_Employee ?, ?, ?";if you had 3 parameters.For further...

Command.ExecuteNonQuery Not Take Effect

4 Jan 2013 by Rahul Rajat Singh

How are you passing the parameters that needs to be updated to the stored procedure. I think you are missing a lot of SqlParameters and you also don't need to call the cmd.Parameters.Clear();If your stored procedure is not expecting any parameter from the outside world then perhaps we need...

Connecting Mfc application to remote Sql server

11 Nov 2012 by Sharath2790

I've been working in a MFC application Which requires a database connectivity... I've Worked with C# and database, VB and database where i used Connection string IP Address, User Id,Password to access database. But I've been trying to find similar way to establish connection between My MFC...

Connecting Mfc application to remote Sql server

12 Nov 2012 by Sharath2790

As It Was Dialog based application!! I Completed it by using CDatabase Class....

Connecting to multiple hosts using connection string

27 Apr 2012 by ebpzr

I need to connet to database server with different hosts. I will change the host frequently by iteretaing through some data. How can i make the connection string dynamic so that i can change the host name whenever I need.Also the username and password in the connection string is same...

ODBC

Connecting to multiple hosts using connection string

27 Apr 2012 by Dave Kreskowiak

The connection string is just a string. It's very simple string manipulation to change the server name in a connection string. I would suggest just putting a known tag in the connection string in place of an actual server name. When you want to change the server name, it's a very simple call...

ODBC

Connection to SQL server 2012 from UNIX server using C programming language

8 Jun 2014 by Member 10872273

Hi ,I need sample C code to connect to SQL server 2012 from Unix server using ODBC driver from www.easysoft.com.I have the trial version of this ODBC driver for SQL server installed in my unix box.Could someone Please help me with the working code.Thanks & Regards,Deepti

SQL-Server-2012

ODBC

Connection to SQL server 2012 from UNIX server using C programming language

2 Jul 2014 by KarstenK

Muli G is right there is a fine sample on that website. Looks like the full connection sample is really good.Dont ferget enhanced error handling - you will need it.

SQL-Server-2012

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[^]

Creating System DSN in VB.Net

4 May 2011 by candice_Blav

I have a code that looks like this that will create a system dsn that has a username and password. It works but when i looked in my created dsn, the login id and password have default values. Hope you'll help me guys.. thanks :)Private Shared Sub CreateSystemDSN() 'create dsn...

ODBC

Creating System DSN in VB.Net

3 May 2011 by Bryian Tan

hi,maybe this will helpHow To Programmatically Create a DSN for SQL Server with VB[^]

ODBC

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...

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...

DataAdapter.Update giving an extra column

11 May 2011 by Sokka_sta

Hello all. I'm using the ODBC Microsoft Text Driver to load a csv file into the dataset to be displayed in the datagridview, the DGV has no columns in at present. I can load the file successfully but I encounter 2 problems:a) The 2 columns load fine but a third 'noname' column is also...

ODBC

DataAdapter.Update giving an extra column

11 May 2011 by Wayne Gaylard

When it comes to SQL queries you should never use SELECT * FROM test.csv, rather name the columns you want to extract by name. Thus if you do thisvoid RefreshData() { OdbcConnection conn = new OdbcConnection(@"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=C:\;"); ...

ODBC

DataAdapter.Update giving an extra column

11 May 2011 by Ashishmau

here is your modifed update statementda.Update(ds.Tables[0].DefaultView.ToTable(true, new string[] { "empName", "salary" }));try with this....

ODBC

DB2 ODBC connection problem

14 May 2012 by Support123

Hi,We have an ODBC (System DSN) pointing to a IBM/DB2. When we run the "Connect" from the ODBC Data Source Administration screen it connects without a problem. When we create a .udl file and select the ODBC conncetion and specify the username and password, the connection fails with the...

ODBC

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

27 Mar 2013 by Member 9330747

I am getting this error while trying to connect Sybase databse from Visual Studio 2010 in C# code.My App.Config file is like this :

ODBC

database

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

27 Mar 2013 by Maciej Los

There are possible 2 reasons (as good as i know):1)It looks like you do not specify a driver for connection string.//string connStr = "Driver={Sybase System 11};SRVR=" + dsn + ";DB=" + database + ";UID=" + userId + ";PWD=" + password; string connStr = "DSN=" + dsn + ";Uid="...

ODBC

database

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

Error Occured: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

23 Sep 2011 by Asutosha

Hi,I have dot net application which update several table in my database for a single functionality Example (pass file).One button "pass file" is there when I click it do many DML and sql query.For first few click it will work successfully, but after some times it show below...

Error Occured: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

23 Sep 2011 by bbirajdar

Make sure that you are releasing the connection objects in your data access layer. If you are running multiple statements in the stored procedure, then seperate them with 'GO'Also try specifying the timeout in the conenction string. Keep the timeout to 10 or 20 minutes.

Error Occured: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

5 Feb 2014 by zhang zhirong

Try this in your web.config,Alternatively, try to Select Top 50 or less records in your SQL Statement

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

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

Final Year Project Idea

15 Jul 2011 by Chief894

Hello guys, I am a software engineering student in APIIT Malaysia and in less than two months I am expected to submit the final year project proposal. But I do not have any idea of what to do as my final year project. I am interested much in front-end graphical user interface design,...

Final Year Project Idea

15 Jul 2011 by OriginalGriff

Talk to your tutors: they will have a better idea of how complex a project you are expected to produce. They may not give you any concrete suggestions, but they may be able to help you focus your mind on your strengths, and what is acceptable as a final year project.

Final Year Project Idea

16 Jul 2011 by uspatel

You can develop any management information System.UI,JDBC and Reporting is the most important part of any MIS.

Final Year Project Idea

16 Jul 2011 by thatraja

Here you go, look at those answers(Some answers contains links to external sites).Project topic for mca[^]

Final Year Project Idea

16 Jul 2011 by RaviRanjanKr

Go there-[Project List based on Java][^] for getting 41 topics which will might help you.

generic odbc to xml webservice

8 Nov 2010 by Werner.Gunter

hi there,could anyone PLEASE point me in a direction where i might find a generic, ready to use (configuring source & target details) web service which would query an odbc data source and produce an xml dataset?i need it for dynamically updating an xcelsius dashboard, and am really not...

Get all table names to array (Using sql and c++)

19 Aug 2012 by wedagedara

Hi,Please help me to complete the code. I want to get all table names to an array.Will this code work? If not, please suggest a method...SqlString = "select * from sys.tables"; recset.Open(CRecordset::forwardOnly,SqlString,CRecordset::readOnly); while( !recset.IsEOF()...

Get all table names to array (Using sql and c++)

19 Aug 2012 by Espen Harlinn

Why ask? Create a small test program, and you'll have your answer ... if you run into any problems at that point, feel free to ask here on the forum.You can use one of these CRecordset[^] as a starting point.Best regardsEspen Harlinn

Get DataSource Name and Data

12 Nov 2013 by Luiey Ichigo

Hi!I manage to get the DSN from registry. But the column for data unable to retrieve. Can someone help me? Below are my code to find the value of ODBC. Private Sub GetDSNDetails() Dim dsnNames As New List(Of String) Dim reg As Microsoft.Win32.RegistryKey =...

VS2010

Visual-Studio

ODBC

Get DataSource Name and Data

12 Nov 2013 by Vijai Anand.G

Hi,Try this one, Dim dsnNames As New List(Of String) Dim reg As Microsoft.Win32.RegistryKey = Registry.LocalMachine.OpenSubKey("Software") If reg IsNot Nothing Then reg = reg.OpenSubKey("ODBC") If reg IsNot Nothing Then ...

VS2010

Visual-Studio

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

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

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

Handling Single Quote Issue in ODBC

22 Jun 2011 by Mohandas_Kulasekaran

Hi Guys,I am trying to query a CSV file using where statement. Following is the code:-Line 1: string sDataValue = "Icom 20' Extension Cable f/COMMANDMIC";Line 2: DataTable dtCSV = new DataTable();Line 3: string strConnString = @"Driver={Microsoft Text Driver (*.txt;...

Handling Single Quote Issue in ODBC

22 Jun 2011 by 2irfanshaikh

Check the link given below:A Fast CSV Reader[^]

Handling Single Quote Issue in ODBC

22 Jun 2011 by Prerak Patel

Easiest way,Line 7: strSQL = "SELECT * FROM data.csv WHERE column1 = '" + sDataValue.Replace("'", "''") + "'";Proper way, Use parameterised query.Line 7: strSQL = "SELECT * FROM data.csv WHERE column1 = ?";Line 8: OdbcCommand cmdSelect = new OdbcCommand(strSQL, CsvConn); ...

Hosting WCF in IIS odbc driver not found error

16 Aug 2013 by Member 8780842

I have created a wcf service I run it indivudually and use that service reference it is working . Then I hosted the service the database is not working .this is my connection string of sql odbc database string s = "dsn=agent1;Trusted_Connection=True"; web.config file of WCF...

Hosting WCF in IIS odbc driver not found error

16 Aug 2013 by Sampath Lokuge

The error is created because the code is specifying a DSN that does not exist.That is "agent1".So you have to create it on your IIS server's Data Sources (ODBC).To see your existing DSN"s go to Control Panel - Data Sources (ODBC).If it does not then create one.For more info check...

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

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

how do connect MsAccess Database in php?

15 Feb 2014 by Member 10599958

I try to connect 'dbname' database using php.my current code is below.$conn = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq='C:\xampp\htdocs\test\dbname.accdb'", '', '');if (!$conn) { exit("Connection Failed: " . $conn); }?>when i trying to connect at that...

PHP

ODBC

how do connect MsAccess Database in php?

15 Feb 2014 by Krunal Rohit

http://www.sitepoint.com/using...

PHP

ODBC

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...

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 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

17 Apr 2014 by Sergey Alexandrovich Kryukov

Please see my comment to the question: your needs are formulated too vaguely; there is nothing much to discuss here.Perhaps, first thing to learn is: stop mixing all things together. You need some separate layers or maybe also some different tiers (don't mix them...

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

18 Apr 2014 by Archie Jacobs

Start with AdvancedHMI. It will let you get the data from the PLC very easily. Then you can write some VB code to store it in a database.

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..

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