From my application written with Delphi 2009, I am reading from and writing to an IBM DB2 database using ADO, the ODBC Provider for ADO, and ODBC: Application -> ADO (Win32) -> ODBC-Provider for ADO -> ODBC -> (net) -> DB2 (Windows) Now, my application need to store unicode data. So I set my database codepage to UTF-8. Delphi handles s...
Environment: Rails 2.3.2 DBI 0.4.1 DBD/ODBC 0.2.4 Scenario: I have a Rails app that imports most of it's data from external SQL DBs into the Rails SQL DB via regular batch jobs. Those batch jobs start by loading the Rails environment, then proceed to make direct database connections via RubyDBI. Once I connect, I run select statements t...
How do I connect to Mas90's file using their ODBC that they setup - SOTAMAS90? how do I do this in vb.net ? ...
Hello, We're using DB2 9.1 on Linux and SQL Server 2005, and the IBM db2 odbc driver. We have a linked server set up to DB2. From SQL Server, I can do the following: -- I can create the new table fine exec ('create table dev.TestSylviaB (field1 int) in TS_DEV_USER_XXXX') at LinkDB2 -- I can use 4 part naming to select from it, as lo...
I have a WebTrends ODBC source on server1 and a SQL Server 2005 on server2. I want to connect to this ODBC from SQL Server on server2. So far, I managed to connect to this ODBC from SQL Server which is on same server, using following definition for linked server: EXEC sp_addlinkedserver @server = N'WT_ODBC', @provider=N'MSDASQL', @da...
I am using Perl's DBD::ODBC to connect to an Oracle database. However, an issue arises when I try to execute a select query using a date in the where clause. It seems this issue occurs because of the database's date format being DD-MON-RR (see DBD::ODBC::FAQ). Since I cannot change the database's settings, can anyone suggest a workaro...
Hello, When connecting to a Sybase ASE database via ODBC using the code below, I'll occasionally get a '[IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed' error. Can this be caused by my code? I read here that I should be using the 'With' statement instead, but I don't understand how that would affect this. T...
I have a Perl script on a Linux (Ubuntu 8.10) machine and I need to write data to a SQL Server Database. I've been trying to use the DBD::ODBC module but I can't get it to connect. Where can I get a free/open source driver to use to use for the ODBC connection or is there another way to do this from Perl on Linux? ...
Hi, I need to have a way to iterate through a database table without actually storing it in memory anywhere. I want to essentially read through the rows like an input iterator. I've tried using cursors with a select statement (select * from table_name), but this retrieves the entire table and feeds it back to be one row at a time. So ...
what are the various other programs using which i can connect to odbc database besides ms-access. i'm talking about programs in which i can run sql queries. i dont want to use ms-access because the size of the access file has become 1.5 gb . why my database is 1.5 gb ? i am using access to connect to odbc - mysql database . which is q...
I need to find the next record in a database with (say) a given Surname. So if the user is looking at A Smith, the query would return either the Next A Smith, or B Smith the solution is probably similar to that discussed here : http://stackoverflow.com/questions/638065/selecting-subsequent-records-arbitrarily-with-limit but using an ODB...
I need to deploy some software through SMS/SCCM and the software requires that an ODBC connection be created in Windows. The connection information I was given requires a user name and password. I have a batch script to import the connection information into the registry, however I don't know how to go about putting the user name and pas...
Here is the code: CDatabase m_db; m_db.OpenEx(_T( "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=mydb;UID=root;PASSWORD=123123;OPTION=3;"), FALSE ); CRecordset recSet(&m_db); recSet.Open(AFX_DB_USE_DEFAULT_TYPE, _T("SELECT * From articles"), CRecordset::executeDirect); int nRecords = recSet.GetRecordCount(); // Equals to 1! ...
microsoft visual studio opens my table using dataset designer but i cannot open my table using the same connectionstring. my database is DBase IV. and this is the connectionstring Driver={Microsoft dBASE Driver (*.dbf)};collatingsequence=ASCII;dbq=d:\Data\88;deleted=0;driverid=277;fil=dBase IV;maxbuffersize=2048;maxscanrows=8;p...
Hi, I am trying to connect to Oracle Server through ODBC driver for Oracle but when testing the connection I am facing the error TNS:Listener does not currently know of service requested in connect descriptor. Can any1 please tell me what I am supposed to do to resolve this error? ...
Is it possible to have an ODBC connection and an ADO connection share the same underlying SQL Server connection, so that both are using the same SPID? Currently I am using SQLDriverConnect and ADODB::_ConnectionPtr->Open. I can make these connections in either order, so perhaps it's possible to open one making use of the other? (Langua...
We just moved our SQL 2000 databases to a new SQL 2008 box. After the move, we bound the IP address of the SQL 2000 box to the new SQL 2008 box. This works, except in a VB6 application running on a Windows 2000 SP4 box where we are getting the error: "Query cannot be updated because the FROM clause is not a single simple table name" ...
I have a folder containing a few paradox 5 files. _folder = @"c:\temp\resource"; I then use the connection string ConnectionString: Driver={Microsoft Paradox Driver (*.db )};DriverID=538;Fil=Paradox 5.X;DefaultDir=c:\temp\resource;Dbq=c:\temp\resource;CollatingSequence=ASCII; Access the files. [Test] public void Paradoxgrou...
I am getting the following ODBC exception when I moved my development platform from Windows XP X86 to Windows 7 X64: ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application What I'm sure it means is that the server it is connecting to is 32 bit, and the comp...
I'm trying to use .net to connect to an AVAYA CMS Informix database. I'm using Microsoft Visual Studio 2005 and connecting via a DNS I've created. I can see the tables no problem, but when I try to show the data on an .aspx page, I get the following error: "Parser Error Message: Unrecognized configuration section 'connectionStrings'" and...