Windows error 0x80131937, -2146232009

ERROR [HY000] General error: Invalid file dsn ''

I am trying to use this code snippet And I get the following error message: System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] General error: Invalid file dsn '' at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions) at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection o wningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, [...] read more

Adding Odbc reference to my application

I am using Visual Studio 2013 to connect to MySql database using ODBC. I am unable to find reference for System.Data.Odbc in my project. I keep on getting this exception System.Data.Odbc.OdbcException (0x80131937): ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, [...] read more

Error when using odbc on some platforms (32 bit vs 64 bit)

We are using Installshield to install one of our application. One of the steps requires to enter a connection strings for an Oracle instance. In Installshield, we use ODBC to open the oracle connection and run some scripts on the database. We have a problem with package when we install [...] read more

What is the ConnectionString to create a OdbcConnection for an access mdb file

I want to connect from c# to an Access MDB file by using Odbc. When I try to execute OdbcConnection con = new OdbcConnection( "Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\\temp\\test.mdb;"); I get the following exception: exc {System.Data.Odbc.OdbcException (0x80131937): ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver [...] read more

Reading Huge volume of data from Sqlite to SQL Server fails at pre-execute

I have a huge (26GB) sqlite database that I want to import to SQL Server with SSIS. I have everything setup correctly. Some of the data flows are working correctly and importing the data. Data flows are simple. They just consist of source and destination. But when it comes to [...] read more

Error connecting Excel throw odbc in C#

Im getting this error when connecting Excel in ODBC: System.Data.Odbc.OdbcException occurred HResult=0x80131937 Message=ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Source= StackTrace: <Cannot evaluate the exception stack trace> This is my code: string ConnectionString = "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};Dbq=" + [...] read more

Issue accessing MS Access from IronPython

I'm trying to run scripts in MS Access using IronPython in Spotfire. Thus far, I can't even get connected to MS Access. Here is my code for connecting: import clr import System clr.AddReference("System.Data") from System.Data import DataSet from System.Data.Odbc import OdbcConnection, OdbcDataAdapter connectString = ( "Driver={Microsoft Access Driver (*.mdb, *.accdb)};" [...] read more

Insert decimal value into Currency Access field

Short background: I am replacing an outdated, Visual Based based program with a C#-based one. With the program comes an Access (JET) based database which is already in use. For now, I want to connect to the current database for practical reasons. However in the foreseeable future I'd like to [...] read more

Creating OdbcConnection to relativity client

I went through the process of creating the server and client ODBC objects in my computer to a Cobol database and I named the client PARSECCLI. I tested the connection and it works. I can get datasets through Microsoft Query (I can't get Sql Server Management Studio to connect to [...] read more

Simba ODBC connection to delta table & read data from delta format tables using .Net C#

I am trying to read data from delta format tables using c# via simba odbc driver. delta format table sample : https://docs.delta.io/latest/quick-start.html#-create-a-table&language-python Have downloaded and configured simba odbc as instructed in https://www.simba.com/products/Spark/doc/ODBC_InstallGuide/mac/content/odbc/configuring/drivermanager.htm I am able to successfully connect to the spark thrift server after this configuration. However, I am unable [...] read more

Why Am I Getting Error Using TransactionScope?

Everybody! I am having trouble with TransactionScope. I want my web method to be transactional. If any exception occurs, I want all database changes rolled back. Otherwise, commit. Please see error message below. > System.ApplicationException: Error in someClass :: Method public returnType > methodName(parameterType parameter) : > > System.ApplicationException: Error [...] read more

Migrate from MySQL (MariaDB) to SQL (Azure)

I'm having trouble with this process, and would love some pointers! Current source database is a MariaDB one (similar to MySQL). I have ODBC drivers connecting successfully. I've installed Microsoft SQL Server Management (SSMS) 17, and connected to my Azure SQL Database. I've found solutions that its possible to create [...] read more

Database returns null after successful connection with Devart in C#

I am trying to connect C# to an InterBase Database. I have downloaded and install Devart ODBC Driver for Windows and installed it. I configured the System DSN in control panel and got a Success message when I tested the connection. I generated a connection string during the process of [...] read more

Change field datatype from Int32 to Int64 in SSRS

I have a report I'm developing with SSRS using an ODBC datasource. The query I'm running has three integer values it's returning. It correctly defined one as Int64 but it made two other values Int32 even though they were out of range for that. Now when I run the report [...] read more

C# to connect to a Progress Database

I'm trying to develop a program that will connect to a Progress Database (9.1E) using C# (Visual Studio 2010 Ultimate), but I first need to get a connection string to the Progress Database from the C# program. I have tried the following, but I'm unsuccessful in establishing a connection to [...] read more

Error with datareader when value from timestamp column is null

As a follow up to this question, when I use that code and one of the results has a NULL value for a DateTime column, I get the following error: > ERROR [22007] [Cache ODBC][State : 22007][Native Code 22007] > [E:!work\projects\dotnet_feed\dotnetFeed] Invalid datetime format Here is the full code, adapted [...] read more

Can I make an IDataReader ignore column length definitions?

I'm working with a ProgressDB table that defines columns as strings of max length x, but in no way, shape, or form actually enforces this limitation; I have discovered several cases where the column data is significantly larger than the column length as defined. (It was an unpleasant shock to [...] read more

System.Data.Odbc.OdbcException (0x80131937): ERROR [HYT00] [Microsoft][SQL Server]Query timeout expired

SQL Server version: MSSQL 2012 64-bit MS OS version: Windows Server 2012 Standard R2 64-bit IIS version: 8.5 Database Recovery Mode: Full The architecture described below: Client ---------> Server (IIS) ------------> MSSQL DB https ODBC 1) Our application (written in c#) running at Server uses ODBC driver( ODBC interface) to [...] read more

Parameter sent to SQL Server stored procedure not recognized

I am in Visual Studio 2010 using C# and connection to a SQL Server 2008 database. I am calling a stored procedure and passing it a parameter. I am getting the error message below. I have checked the parameter being passed and the name and value are correct and the [...] read more

Batch file executes SSIS package successfully when done manually, but fails when it's executed with Windows Task Scheduler

I have a batch file that executes a SSIS package, this SSIS package gets data from an Access data base in a server(z: unit). Then passes the data to a SQL Server. When I execute the batch file manually (double click) or on the command line it works fine. But [...] read more

How do I resolve error, "(IM002) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"?

How do I resolve error, "(IM002) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" ? So far I have tried: 1. Adding the right conenction string 2. Make sure the referencing DSN that has been created What are some more things I should look into? [...] read more

Can't connect to an Access 2013 file in Visual Basic 2012 using code

It's just a simple Access 2013 file. I'm using this connection string: Dim odbccn As New Data.Odbc.OdbcConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=access.accdb;Persist Security Info=False;") Connecting to the same file using the data source explorer seems to work, and it even provides that same connection string. But doing it with code brings up this. System.Data.Odbc.OdbcException [...] read more

MARS not working with sql native client

I have a C# application that export data to sql server using odbc connection. I got this error: System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [Microsoft][SQL Native Client] Connection is busy with results for another command. I have tried MARS_Connection=yes in the connection string but it is not working.There is no problem with [...] read more

Use SQLITE ODBC with .NET on MAC OS

Hi I'm trying to do a very simple program in .NET (3.1 Core or 5) something like this: using System; using System.Data.Odbc; namespace testsqlite { class Program { static void Main(string[] args) { var conn = new OdbcConnection(); conn.ConnectionString = "Driver=SQLITE3;Database=Orders.db;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;"; conn.Open(); var stmt = conn.CreateCommand(); stmt.CommandText = "Select * [...] read more

Error IM003 when connecting to Oracle ODBC data source in ASP.NET Core app on .NET Core 3.1 in IIS

I have an ASP.NET Core application running on .NET Core 3.1 in IIS 10 on Windows Server 2019. When trying to connect to an Oracle ODBC data source, I'm getting this error: > System.Data.Odbc.OdbcException (0x80131937): ERROR [IM003] Specified driver > could not be loaded due to system error 1114: A [...] read more

Statement Timeout: On Web Sessions ONLY

I have a website and on that website, certain reports are run using SQL via the PSQL ODBC Source. Any report where the SQL takes longer than 30 seconds to run seems to time out! I have tried amending the statement_timeout settings within PostgreSQL and this hasn't helped. I have [...] read more

How to Connect Apache Hive with ODBC and MIT Karberos using vb.net

Please help me. I was create ssis package on visual studio 2012 to get data from Hive Apache, to connect the database i am using ODBC with Cloudera ODBC Driver for Apache Hive, Mechanism with MIT Karberos. When i was execute package from visual studio / project there's no error, [...] read more

Postgres Query Timing out after 30 Seconds

There is a Query that keeps timing out exactly after 30 seconds. I have seen a few posts on Stackoverflow which are similar to the issue i'm facing, the only thing that makes my issue different is that, i'm not using a DSN-LESS Connection, I'm using ODBC ADMINISTRATOR. The following [...] read more

MS SQL ODBC 17 Driver connects first tme but then give SSL Provider error:140A90F1:lib(20):func(169):reason(241)

I am facing this issue with dotNET core app, that connects and disconnects with SQL server using DSN defined in odbc.ini. Currently I am using the latest MS SQL ODBC driver i.e. msodbcsql17-17.4.2.1-1 and UnixODBC driver unixODBC 2.3.7. I have tried downgrading the MSSQL ODBC driver to 11 and 13 [...] read more

SSIS Event Handler - How do I get the entire error message?

I've set up a data flow task with a source component (ODBC to Salesforce) that writes rowcounts and any raised error messages to a table. I've created an OnError event handler that writes the message from System::ErrorDescription to a variable, and then that variable is written to the table. My [...] read more

Why is a SQL command in my code replaced by "TODO: FUNC" at runtime?

I'm setting up a .NET program to manipulate some data in our Redshift database. Most of my commands go through without a problem, but when I try to execute an INSERT statement involving a CONVERT function in the select, it replaces the entirety of the CONVERT function with the text [...] read more

System.Data.Odbc.OdbcException (0x80131937) After publishing I cannot use Odbc functionality to read, delete, and write into an access mdb file

Can't connect OdbcConnection Microsoft Access Driver - After publish System.Data.Odbc.OdbcException (0x80131937) After publishing the application I lose OdbcConnection/Command functionality. The code below is where the application errors out when published. In development all of this works. //Connect to access .mdbcd var conn = new OdbcConnection(@"Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=D:\wwwroot\mo22\storesales.mdb"); conn.Open(); [...] read more

Apache Ignite v2.7: Cannot change column data type - Error or Intended Behavior?

I'm getting an error when running a set of SQL statements through an ODBC connection that change the data type for a column. Error: [HY000] Wrong value has been set [typeName=SQL_PUBLIC_X_0aae5780_0c94_4706_b144_f2ca2336a96e, fieldName=VALUE, fieldType=String, assignedValueType=int] Is it intended behavior or expected error? Will this behavior change in future releases to support [...] read more

SQL Server with TLS 1.2 from .NET Core with ODBC

I know this has come up a million times, but apparently not with .NET Core using System.Data.Odbc. With TLS 1.0 turned of in the registry, I get an error: > {System.Data.Odbc.OdbcException (0x80131937): ERROR [08001] [Microsoft][ODBC > SQL Server Driver][DBNETLIB]SSL Security error > > ERROR [01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen > [...] read more

Count field is incorrect

I am using FastReport .NET [https://i.stack.imgur.com/YEsTH.png] I have a SQL query in Postgres: select * from product where idproduct =: param But when I run an error it displays: > System.Data.Odbc.OdbcException (0x80131937): ERROR [07002] [Devart] [ODBC] > COUNT field incorrect read more

Where is Simba DB SQL Reference?

I have never used Simba DB before... however my boss needs me to do integration between Simba DB and our system. I just want to see the syntax of Simba SQL. However I can get no result on internet. I just want to know two syntax. One. Type conversion statement [...] read more

SQL Job failed because driver is not valid

I have a SSIS package that I want to schedule in a job in SQL Server 2008, the package runs perfectly by it's own, but when executed in a job it fails, I get the following error message: > Executed as user: XXXXXXX \ SYSTEM. Execute Package Utility for Microsoft [...] read more

Auto truncate fields with ODBCDataAdapter on INSERT and UPDATE

I am updating a database using System.Data.Odbc.OdbcDataAdapter. I also don't know what table or fields I'm updating until runtime. The code I have works and is roughly equivalent to the following: { mConn = new OdbcConnection(connectionStr); mConn.Open(); mDataSet = new DataSet(); mDataAdapter = new OdbcDataAdapter(selectStatement, mConn); mCmdBldr = new OdbcCommandBuilder(mDataAdapter); [...] read more

Unable to import Data into MySQL from Visual Studio with C#

I am trying to import a csv file that is filled with data, into a table in MySQL. The permissions for the user connection have access to all commands such as insert. The code works fine with no errors, and I print a confirmation after each insert. But still, no [...] read more

Issues connecting to Progress database via ODBC in published Web Application

I am having issue trying to get my Web Application published and running correctly on our IIS server. When I test from within Visual Studio 2015 with the same ODBC driver setups, everything works fine. It is only once I try to publish the Web Application and access it off [...] read more

Run SSIS Package error in SQL Agent

I run my SSIS package in SSDT and Success, but when I run the package using SQL Agent and get error. The error message is below copy_r_bp:Error: System.Data.Odbc.OdbcException (0x80131937): ERROR [HY001] Out of memory while reading tuples. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] [...] read more

Package that runs perfect on SSIS, but fails on SQL - server job activity

I wonder if you can help me, I am having a problem which I can't figure out for the last few days... I get these errors when I run a package, that runs perfect on SSIS, on SQL - server job activity: > Error: There were errors during task validation [...] read more

Inserting large amounts of data into hive (around 64MB)

Ok, so I have a hive table on a remote hadoop node set up on a linux machine. I'm having an issue when attempting to insert a large json string, large as in possibly 64MB or more given that map reduce won't work well unless I approach that limit. I've [...] read more

Importing Caché dB into SQL Server 2008 R2 using SSMS

I've been tasked with extracting the data from a Caché dB (Specifically SunGard AddVantage)and relocating it to a new SQL Server. I was provided with a ODBC in order to connect to the server. When I attempt to Import via the "SQL Server Import and Export Wizard", I get the [...] read more

job execution in SSIS fails

I have one job(report generation) which runs once in day for whole month but its running properly till 24th date of month after that it is giving below error.Pls provide solution asap. Highlighted the error below For your reference > ERROR: Executed as user: MMKNDJAVADB\Administrator. Microsoft (R) SQL Server > [...] read more

C# connect Progress Database Error

I want to connect progress database in local with c#. my c# code is: string connectionString = "DSN=OpenEdge Wire Protocol;Host = localhost; DB = E:\\programs\\DBs\\TrDB\\trnakdb; UID = connuser; PWD = 123456; PORT = 11112"; DataTable dt = new DataTable(); int rows; using (OdbcConnection connection = new OdbcConnection(connectionString)) using (OdbcCommand command [...] read more

Time outs using ODBC but not Openquery to a linked server

I am connecting to an external database via a linked server. I am using a multithreaded console program in C# to break up this SELECT statement. SELECT * FROM ( SELECT C.Part_Key, C.Part_Operation_Key, C.Net_Weight, C.Plexus_Customer_No, C.Serial_No, ROW_NUMBER() OVER (ORDER BY C.Serial_No) AS row FROM Part_v_Container AS C ) a WHERE [...] read more

error of exporting a sql data table from IBM netezza database to a txt file on win 7

I would like to export a data table from IBM netezza SQL daatbase in Aginity workbench to a txt file on win 7. I called The sql query from C# in visual studio 2013: CREATE EXTERNAL TABLE 'C:\\path\\my_name.txt' USING ( Y2BASE 2000 ENCODING 'internal' REMOTESOURCE 'ODBC' ESCAPECHAR '\' ) AS [...] read more

ODBCConnection Issue when Opening the connection

I'm having some issues with a windows service that I have running. I've created a new test service that creates an ODBCConnection with a connection string that I have verified many times to be correct. Whenever I call the Open() method, I get the following error: Error: System.Data.Odbc.OdbcException (0x80131937): ERROR [...] read more

Why does the following code gives error when it is published and browsed from IIS?

private DataTable LoadCSV() { DataSet ds = new DataSet(); try { string strConnString = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + this.DirectoryPathCSV.Trim() + ";Extensions=asc,csv,tab,txt;Persist Security Info=False"; string sql_select; OdbcConnection conn = new OdbcConnection(strConnString.Trim()); conn.Open(); sql_select = "select * from [" + this.FilePathCSV.Trim() + "]"; OdbcDataAdapter obj_oledb_da = new OdbcDataAdapter(sql_select, conn); obj_oledb_da.Fill(ds, [...] read more

ODBC connection in Windows Service fails on second connection attempt

I wrote a .Net Windows service to copy data from a 4D database (v12) to a SQL Server database every 4 hours. It is running on Windows 7 32-bit and running as Local System. I am using version 12.02 of the 4D ODBC driver. When the service 1st runs everything [...] read more

How to use PL/SQL with pure C#?

I elaborated this little piece of code to get started with my baby steps. The connection is good. Simple OdbcDataReader selects are working fine. But I can't test any PL/SQL functions. How does it work ? Do I need to install something extra or do I do something wrong ? [...] read more

ExecuteScalar multiple transactions

I am trying to execute ExecuteScalar() with 2 instruction with ODBC connection to mysql in a query. My query is : string query = @"SET @MY_ID := (SELECT IFNULL(MAX(id) + 1, 1) FROM sc);" + Environment.NewLine + "INSERT INTO sc (id, name) values (@MY_ID, 'TESTE');" I am getting: {System.Data.Odbc.OdbcException (0x80131937): [...] read more

C# - Error with insert into AS400 using ODBC

Someone can help me??? I trying to make a app using C# and ODBC iSeries to insert some XMLs informations into AS400. So, I have a error that I can't undertand and resolve. *System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0104 - Token ; was not valid. Valid tokens: [...] read more

ODBCException thrown when checking if column IsDBNull

I am writing a program that reads data from one database to be inserted/updated in another. The source database will be DB2 when deployed, but at the moment I am developing using a SQL Server 2008 R2 copy. I am using ODBC driver 11 for SQL Server to read the [...] read more

Connecting derby with .net c# through ibm db2 driver

I'm trying to connect derby database with C# application through IBM DB2. At first I've installed IBM Data Server Driver Package, which, according to the documentation given in the following url as http://www.ibm.com/developerworks/data/library/techarticle/dm-0410ng/index.html. Then I installed IBM Data Server Client, which has this dll in "bin" directory, which I added [...] read more

ADO.net source giving error DTS_E_INDUCEDTRANSFORMFAILUREONERROR in SSIS

Here's the full error message: > [ADO NET Source [1]] Error: SSIS Error Code > DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "ADO NET Source" (1)" > failed because error code 0x80131937 occurred, and the error row disposition > on "output column "Z_ID" (16)" specifies failure on error. An error occurred > on the [...] read more

ODBC driven ASP.NET application running on iis doesn't work on speceific system

I'm having a strange problem with IIS, asp.net and ODBC. My application is driven by SQL server via ODBC driver (I know it's bad practice, but my entire DAL is already written and will not be changed). The problem is that when I run an SP with my web interface, [...] read more

Timberline ODBC Error with TEMP Environment variable

I have stumper that's been causing intermittent error at a client which has been increasing in frequency. I have an application that processes data, and reads from an accounting package called Timberline, running on Windows Server 2008. The Timberline system uses a Pervasive database, and my app communicated with it [...] read more

DB connection~ working on local not on server

I have a query that is working fine on my local but when placed on the server it comes back with this error, Server Error in 'Page' Application. ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Description: An unhandled exception occurred during the [...] read more