Occasionally we're seeing an error from ASP pages: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [MySQL][MyODBC 5.00.11][MySQL] 2006 MySQL server has gone away We're handling it the best way we can in ASP but it still crops up. I think it's more to do with the MySQL ODBC driver than the ASP code. We never see this with ...
I am using sqliteodbc and for some reason it won't get the hours, minutes, and seconds. I bind the column using this: SQLBindCol(hTimeStampNotes, 5, SQL_C_TIMESTAMP, &(noteTimeStamp.submitTime), 16, &junkLong); noteTimeStamp.submitTime is a time stamp data type: typedef struct tagTimeStampType {//TIMESTAMP_STRUCT short year; ...
Hello I have am working on a .net application that integrates with a Teradata database version 12. Currently, we are using Odbc at the DAL to interface with the database. Teradata have come out with the .Net Managed provider recently. I was wondering if there are any performance benchmarks available to compare ODBC with the .Net Manag...
I'm converting some RDO code to ODBC Provider code in .NET. The problem is parameter names were not specified in the orignal code, but param values were retrieved by parameter name after the command was executed. Is there anyway to have parameter names populated by the provider once the command is executed so calling code can access pa...
I've tried odbc_prepare() + odbc_execute() to update a record in an Access file but I always get an SQL state 07001 error message about incorrect column count (actually, the message is in Spanglish and doesn't make much sense): <?php $items = array(); $items[100] = 'Foo'; $items[200] = 'Bar'; $sql = 'UPDATE street SET name=? WHE...
I have an MS-Access 2007 front end. I will have multiple users on it. They are all going to be on the network company domain. Should I be using Windows authentication or SQL Server authentication to be connecting to SQL Server 2008 via ODBC? ...
I have problems with MySQL Connector (MyConnector) it seem there is a problem when I modify my connection via ODBC, I can create new entries, but I am unable to edit them.. I found a patch for windows 7, 32Bit. but I also need a fix for Windows 7, 64bit. ...
I was wondering what are the most popular open source obdc/database connection libraries are. I've heard of pyodbc, but I wasn't sure how widely used it was. Thanks ...
My webhost is Pair.com, which runs FreeBSD. PHP is compiled with iODBC. I have SSH2 compiled and installed and tested. I can connect to the Windows machine through the firewall and get a directory listing. What I need is the incantation to open an Access database file through the SSH connection. (Very low-traffic site, so Access sho...
I usually make applications with the front end in Access 2003 - 2007 and the back-end on SQL Server 2008. When I create an ODBC to link the tables in access I have two choices in the ODBC Data Source Administration page on my Windows XP PC: Server 2008: SQL Server Native Client 10.0 v.2007.100.2531.00 SQL Server v. 2000.85.1132.00 W...
I was going through some old code that was written in years past by another developer at my organization. Whilst trying to improve this code, I discovered that the query it uses had a very bad problem. OdbcDataAdapter financialAidDocsQuery = new OdbcDataAdapter( @"SELECT a.RRRAREQ_TREQ_CODE, ...
Tried seemingly everything here to get this to work but I keep getting "Keyword not supported" errors for just about every iteration of dsn-less connection strings I can find out there in internet land, two are shown below. Public cnSystem As New SqlClient.SqlConnection Public Sub ConnectToSQL() Dim sConnectionString As String ...
How do I create an ODBC connection using sp_addlinkedserver in SQL using a DSN-LESS connection string? I assume I am doing something wrong with syntax, here is how I set up the connection: EXEC master.dbo.sp_addlinkedserver @server = N'SERVER_NAME', @srvproduct=N'Oracle', @provider=N'MSDASQL', @provstr=N'DataSource=(DESCRIPTION=(AD...
Hi all, I'm going crazy trying to find a FOSS free (doesn't have to be open source) ODBC driver to connect to an MS SQL Server. While it doesn't strictly have to be free (which is a huge plus, for obvious reasons), the drivers I have found haven't had an easy to find price tag. Does anyone know of any preferably free, and if not free, t...
I'm trying to connect to a Sage Timberline Accounting database on my Windows 2003 Server using php 5.3. I have php correctly installed with IIS as fastcgi. I have a system DSN setup in ODBC Manager and correctly configured for the Timberline database. Here is my php script. $conn = odbc_connect("Timberline ODBC","user", "password"); ...
hi! Microsoft has a SQL server either as 32 bit or 64bit, however the 64bit contains both 32bit AND 64 bit. are there any MSI packages containing the 32 bit AND 64 bit version of the ODBC connector ? i.e. the install package decides by itself which version to install`? ...
I need to constantly merge (upsert/delete) data from an ODBC data source to a SQL Server 2008 database (number of rows vary from one row to 100000 of rows) What would you recommend as the most efficient approach (using .net 3.5 ): Use SqlBulkCopy into temp table then call stored procedure with Merge command using temp table as sour...
We are storing allot of time series data into our own proprietary "database". In the next version of our system we want to give our users a simple query mechanism to extract the raw data from the database (as a complement to the reports our system can create) by using standard tools. I have looked at the possibility to write an ODBC dri...