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...
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? ...
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...
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...
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. ...
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 ...
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? ...
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...
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...
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? ...
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 ...
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....
Does ODBC support asynchronous calls? If it does, then can you tell me about any reference materials? My preferred language is C++. ...
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? ...
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) ...
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 ...
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...
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...
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;" ...
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...