Hi I'm on windows 7 trying to set up with ODBC data source administrator a dBase DSN connection. We have this on the servers and I'm trying to replicate on my local machine to test but I can't find the Microsoft dBase driver that we use on my machine. Does anyone know how to get this on Windows 7? ...
I'm developing an application in c# .NET that is connected to a PostgresSQL database through TCP/IP with ODBC. It is possibile to connect through named pipes ? How can i do ? Do i need to modify connection string ? ...
I have an MS Access database (intolerably enough), and communicating with it through PHP (ODBC). There is a DateTime field that I have to include in my INSERT statement. This field is NOT defined as "Required" in Access, meaning that it is indeed NULL-able, and in fact some of the rows in the Access database are already NULL. The probl...
I'm working on my first Access application and I'm having trouble when I try to insert records from the Access database into an Oracle database. The first record is inserted without error, but the second record raises a "Run-Time Error '3146'" error message. Any ideas? Private Sub Command42_Click() Dim dbMyDatabase As DAO.Databa...
hi there, we're currently executing a stored procedure ( ms sql 2008 ) from axapta ( ax 2009 ). the sp is indeed quite large and the obfuscating effect is, that the sp doesn't work, if triggered via odbc. a simple "exec sp ..." executed via ssms works fine. if we remove some of the last queries executed in the sp, the sp also works fire...
Trying to load ODBC in my Rails app (I'm on Linux, FreeBSD 7.3-STABLE using rb-odbc, unixODBC, and FreeTDS to connect to MSSql) but I'm getting this error: Trace can be found here: http://gist.github.com/547759 Anyone have any glaring ideas? Thanks! ...
Our client is trying to export their data from their FileMaker 10 database into a MS SQL system via ODBC. We have the DSNs set up, and can import date and number fields, but text fields fail with: “requested conversion is not supported” Cannot get the current row value of column “[TQG6]...[Referral].ReferralAccountName” from OLE DB pro...
What I want is a Powerbuilder application that runs on Windows that runs from a CD (or some other external disk) that can read from an ASA database whose file is located on the same disk. But I want to do so without deploying the ODBC or OLEDB drivers. That is, I do not want to have to copy the driver files to the client's hard disk or...
I have to import data from a Lotus Notes database via ODBC. The source data are all varchar fields while some columns actually contain dates and numbers. I mapped those colums with NHibernate to the appropriate types which works for loading but not for comparing (using criteria, e.g. Restrictions.Eq("StoreId", 123)). Whenever I execute ...
I want to expose our internal bussiness data through odbc driver. One of the propitary product that i found is DataDirect OpenAccess. I want to use SQL to query live data from our data source. Writing my own SQLEngine will take ages but i need something like following diagram. We intend to use it on live data so exporting it to database ...
Hello, from within a C# WinForms-App I must execute a parameterized Stored Procedure on a MS SQL Express Server. The Database Connection works, the Procedure works either, but I get an Error Message: 42000: Missing Parameter '@KundenEmail' although I'm sure I added the parameter correctly. Maybe some of you could have a look - I ...
What is the best way to take a database and make it a flat file? I am have an ODBC driver and need to pull the data out into a file file. Excel, Access? OpenOffice? ...
Hi We are developing a java application that runs on a linux server, we need to integrate with an odbc connection on a windows box. Is this possible? Pablo ...
I'm doing a research for a homework, but I don't seem to find any other standard way to connect to a database, so far I've found this two: ole db odbc I've also found jdbc, but that's java only, as ado.net or pdo. I would like some help or advice links or books would be greatly appreciared. :D ...
Final answer: This was not a Delphi problem, just configuration. I use Xampp to provide the MySql server. C:\xampp\mysql\bin>mysql.exe --version mysql.exe Ver 14.14 Distrib 5.1.41, for Win32 (ia32) so, the correct connection string is 'Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=mysql;User=root; Password=;Option=3...
I'm running the following query in a PHP ODBC connection to a MSSQL sever: DECLARE @weekStart SMALLDATETIME; SET @weekStart = DATEADD(d,0, DATEDIFF(d,0,GETDATE())); -- weekStart = TODAY @ 00:00:00 -- per http://weblogs.sqlteam.com/jeffs/archive/2007/01/02/56079.aspx SET @weekStart = DATEADD(d, 1-DATEPART(dw, GETDATE(...
I'm having trouble executing a stored procedure in ODBC to a DB2 database where a stored procedure has multiple input and output params. If I specify only in input params in the call statement with ? like below, i get "SQL0440 - Routine XXXXXXX in *N not found with specified parameters.". I've changed the output params to be of type 'Ret...
Hi, I'm using NHibernate to select an entity from an Oracle database through ODBC. This works fine on a 32bit system, but on x64 the following error occurs: It seems the rowcount is not in a correct format? (ODBC part) Arithmetic operation resulted in an overflow. at System.Data.Odbc.OdbcStatementHandle.RowCount(SQLLEN& rowCount)...
I'm making a call to odbc32.dll (SQLBrowseConnect) to return a list of databases on a sql server. From running a trace I can see the query being executed is select name from master..sysdatabases where has_dbaccess(name)=1 If the credentials I pass aren't the sa user it returns just the system databases. Is there anyway I can use SQL...
I have an Excel 2007 workbook that contains an ODBC data connection (to FoxPro, if that matters). The connection is set to "refresh data when opening the file." When I go into File Explorer and open the workbook, the data populates into the spreadsheet as it should. However, when I execute a function in Access VBA that opens the workboo...