odbc

Oracle - ODBC connection using MS Access error (ORA-12154)

I am trying to use MS access to connect to a Oracle database. I keep on getting the following error message: ORA-12154: TSN- could not resolve the connect identifier secified The Oracle Drivers OracleClient10g can verify that the database server exists. I have a section in my tsnnames.ora file that looks like this: UBASEP10G = (DESC...

OLEDB v/s ODBC

What is the difference between OLEDB and ODBC? When do I use which and how do I know what I am looking at is a OLEDB driver v/s an ODBC driver? ...

SQL Server Backup Database over ODBC

I'm trying to write a program that is able to import and export a specific database, plus users and logins, from a Microsoft SQL Server database. I have an abstraction layer between my code and ODBC that much of our other software uses. The abstraction layer normally runs with autocommit off and handles transactions on its own, but since...

Ruby scripting on Windows

I'm making a simple script using ruby on a Windows 2003 Server. My questions are: How can I connect to a database through ODBC? I will be connecting to both Sybase on Solaris and MSSQL Server. How can I send emails through an Exchange Server 2003? Update What's the best simple IDE for Ruby scripting? I currently use SciTE (whic...

Hourly ODBC pull to SQL 2005

I'm trying to pull data from an ODBC app to SQL2005(dev ed) DB on an hourly basis. When I run SSIS the option to import all tables and views is grayed out and forces your to write a query. How would I go about setting up a SSIS integration service to update ALL 250 some tables on an hourly basis. ...

Persuade Access 2007 to use a .UDL file/oledb connection?

Is there any way of coaxing Access 2007 into using a .UDL file? Specifically, one of our older products uses an Interbase 6.0 database. My client would like to link to his database, for read/write, using Access 2007 (in the short term). While this isn't my preferred way of doing things at all, given it's all single-user and the other ...

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

Hi , while connecting .net to sybase server... got this error message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified it was working sometime back. system DSN with same detatils work and data connection through vs.net also work. i am using vs.net 2005 Any suggestions? ...

.NET ODBC DataProvider never connects via Transoft ODBC driver

I've got a windows service that I've written in .Net. In our current implementation we are interfacing with a Transoft ODBC. I've got logging implemented, and basically when we open the ODBC connection it just never connects. Never errors out or anything. We've been able to connect to the database via Access, so we know the connectiv...

ThreadAbortException calling OdbcDataReader.ExecuteReader()

I'm running an SQL query against a mainframe DB2 database using the OdbcDataReader class and ExecuteReader() method. This code is in production and has been running fine for months. The query normally takes 1-2 minutes to execute. This past Friday, the query encountered a ThreadAbortException. Below is the formatted stack trace. The A...

AS/400 ODBC Drivers

We have been using the Client Access ODBC drivers when accessing AS/400 data from our .net applications and SQL DTS/SSIS packages. Are there third party drivers that provide better performance or functionality? ...

How do I set a ODBC .DSN file to allow it to access any database in Postgresql ?

Hello I'm writing an MFC App to automatically configure Postgresql with ODBC for use by another app. The idea being that the user runs the app and it automatically creates the database and the tables within it. My problem is that when I set up the File DSN it seems to require the name of the database it will access. This appears in the ...

Paradox Tables in C#

Hi, I'm trying to read a Paradox 5 table into a dataset or simular data structure with the view to putting it into an SQL server 2005 table. I've trawled google and SO but with not much luck. I've tried ODBC: public void ParadoxGet() { string ConnectionString = @"Driver={Microsoft Paradox Driver (*.db )};DriverID=538;Fil=Paradox 5....

Can I make Asynchronous ODBC Calls? Any reference materials?

Does ODBC support asynchronous calls? If it does, then can you tell me about any reference materials? My preferred language is C++. ...

MySQL: how to get the list of tables using ODBC

I am connecting to a MySQL DB trough a terminal who only have a program with an ODBC connection to a MySQL DB. I can put querys in the program, but not access MySQL directly. I there a way to query the DB to obtain the list of tables? ...

MySQL: how to get the list of fields in a table using ODBC

I am connecting to a MySQL DB trough a terminal who only have a program with an ODBC connection to a MySQL DB. I can put querys in the program, but not access MySQL directly. I there a way to query the DB to obtain the list of fields in a table other than select * from table ?? (don't know why but the select returns a error) ...

Database trigger that communicates with an external program

I've got a SQLServer Database and an application (.NET) that configures data on that database. On the other hand, I've got an application (VC++) that reads that data from the database and must be 'informed' a soon as possible of any change in the data saved on the database. I would like to receive a signal from the database engine when ...

Link an ODBC table in Access 2007

I have an Access 2002 application which links an Oracle table via ODBC with this code: Set HRSWsp = CreateWorkspace("CONNODBC", "", "", dbUseODBC) Set HRSConn = HRSWsp.OpenConnection("HRSCONN", dbDriverPrompt, , "ODBC;") DoCmd.TransferDatabase acLink, "Database ODBC", HRSConn.Connect, acTable, "SCHEMA.TABLE", "TABLE", False, True Unfo...

Is there a difference in the underlying protocol for ODBC, OLEDB & ADO.NET

When communicating to a SQL Server database using one of the typical systems, ODBC, OLEDB or ADO.NET, is the underlying basic protocol the same? Are all the differences between these systems basically just client side issues? Is this all just different flavors of TDS (Tabular Data Stream) transfer? [MS-TDS]: Tabular Data Stream Protoc...

How can I save a DataTable to a .DBF?

I've been working on a program to read a dbf file, mess around with the data, and save it back to dbf. The problem that I am having is specifically to do with the writing portion. private const string constring = "Driver={Microsoft dBASE Driver (*.dbf)};" + "SourceType=DBF;" ...

Delphi ADO connection to DBF files hangs when debugging

I'm connecting to DBF files using Delphi 2009 ADO components and this connection string: Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mypath; If c:\mypath doesn't exist, and I run the application inside the debugger, my app hangs. No exception is raised. If I run the application without debugging, an exception is prope...