Given a pre-configured ODBC System DSN, I'd like to write a function that gracefully tests that connection using VBA. Private Function TestConnection(ByVal dsnName As String) As Boolean ' What goes here?? ' End Function Edit: To clarify, the System DSNs are pointing to external SQL Server 2005 databases, with Windows NT authenti...
I'm using UnixODBC with PHP 5.2.4 on Ubuntu 8.04 LTS and trying to pull all the results from a table sitting on an iSeries and replicate them to a local MySQL table. Code-wise it is working with no errors but I'm ending up with more rows that what is contained on the iSeries. I should end up with 25,613 rows but PHP reports that 25,6...
Is it possible to connect to SQLite in C++ and using ODBC API without register the database in ODBC? I have code that uses ODBC talking to databases and don't want to rewrite for using SQLite and don’t want to register new ODBC connections. ...
I'm trying to connect to an Oracle Database with Access 2003. I want to use an ODBC connection and I want to set it up so that the user doesn't need to enter a password. One of the problems I am having though is my sql query uses INTERFACE.Products and Access sees the period and thinks I'm trying to opening a file. IE Interface.MDB, w...
I'm using ASP.NET 2.0 to connect to a Sybase Sql Anywhere 5 server. And I get this error sporadically. It just happens sometimes. The error message is: ERROR [HY000] [Sybase][ODBC Driver]General error: attempted two active database requests Exception Details: System.Data.Odbc.OdbcException: ERROR [HY000] [Sybase][ODBC Driver]General e...
I have read-access to a MySQL database and am trying to connect to it via the MySql ODBC 5.1 driver. I'm getting an authorization failure (401) from the server. The administrator set up my access as follows: mysql> grant select, create temporary tables on theDatabase.* to 'adrian' identified by 'password'; I am successful in connecting...
I tried to trace ODBC function calls from my program working on Linux. This program dynamically links ODBC manager and then connect to database and fetch some data. I can trace ODBC calls with unixODBC by adding to odbcinst.ini: [ODBC] Trace=yes TraceFile=/tmp/sql.log This method is documented by IBM: Collecting data for an ODBC Prob...
I have a report made with Crystal Reports 2008 that I need to deploy a production system which means that I need to be able to change the database connection at runtime. The database is PostgreSQL 8.3.0 and the connection I use for creating the initial report is an ODBC connection. I have found various ways to change the database conne...
to connect multiple tables in oracle with ODBC do we need to create different DSN for different tables ...
I have a table (readings) already connected by ODBC in Access that opens very quickly when I click on it. However, when I try to run this in VBA I it locks up and never displays anything: Dim strSql As String strSql = "SELECT readings.ids " & _ "INTO ids_temp " & _ "FROM readings " & _ "WHERE readings.ids > 12...
What apps or tools do you use for data entry into your database? I'm trying to improve our existing (cumbersome) system that uses a php web based system for entering data one ... item ... at ... a ... time. My current solution to this is to use a spreadsheet. It works well with text and numbers that are human readable, but not with fore...
Is there any way that I can connect to a server DB (Oracle, MS SQL, Sybase, ...) from a Windows Mobile application (written in C# using VS 2008). Is there support for say ODBC or another technologie? I'm connecting to a LAN via WLAN or via UMTS. There is no possibility for me to install an additional server component. ...
I have a varbinary(MAX) field in a SQL Server 2005 database. I'm trying to figure out how to insert binary data (ie. an image) into that field using PHP. I'm using ODBC for the connection to the SQL Server database. I have seen a number of examples that explain this for use with a MySql database but I have not been able to get it to work...
Can a Sql 2005 database that uses the xml type be accessed with ODBC? ...
I've seen lots of questions regarding moving data from Access to SQL Server, but I'd like to go the other route. Here's why: I've been working on a sizable project with a SQL Server 2008 back-end and Access 2007 front-end. I'd like to be able to do some work on the front-end from home over the weekend, but I don't have access (VPN or ...
I found out about the freeTDS which can be used here, but there are doubts about its stability in the production environment. Is there any other way to interactive with MSSQL Server from Solaris besides using ODBC driver? ...
Are there any free Sybase ASE 12.5x ODBC Drivers available, or does anyone have any experience with any paid ones? I'm looking for a fast and simple solution, but don't necessarily want to pay big bucks. Thanks in advance. ...
I am using an Odbc driver with Paradox. I have a table with a date in it. I am trying to query by the date in that column. I can't seem to get the where clause to work. I can get the record searching by ints, but I don't know how to use the date time. OdbcCommand comm= new OdbcCommand("SELECT * FROM [Journal] WHERE" + ...
I'm not trying to create an ODBC connection to be used in my application. I am working with another scripting language (I have no choice) that uses a local ODBC connection defined in odbcad32 (the Microsoft ODBC Source Administrator). I want to programmatically change the server in in odbcad32, and then call the script to do what it doe...
Hi, I have some .dat and .idx files and one .sup file in a directory , and i would like to know if there is any tool or .net programming tecnique to find out what type of database is? I dont know if this could help, but if i open one .dat file as text file, i get this: 0~0904021846460509040218464605>ÀÀX2Ü And the common part of all t...