This is the code I'm using to update an SQL database: Public Sub main() Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Set cnn = New ADODB.Connection Set rst = New ADODB.Recordset cnn.Open "ConnectionName" rst.ActiveConnection = cnn rst.CursorLocation = adUseServer rst.Source = "Update Table ....
I'm using Python to read and write SAS datasets, using pyodbc and the SAS ODBC drivers. I can load the data perfectly well, but when I save the data, using something like: cursor.execute('insert into dataset.test VALUES (?)', u'testing') ... I get a pyodbc.Error: ('HY004', '[HY004] [Microsoft][ODBC Driver Manager] SQL data type out o...
I'm trying to update a database field to the current time, but can't pass "now()". I get the following error: 'now' is not a recognized built-in function name. The method I'm using to query the database is as follows: Public Sub main() Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Set cnn = New ADODB.Connectio...
Followed the instructions on the Rails wiki and have had success connecting to SQL Server 2000 with TSQL -- both with DSN-less and DNS connections. I'm running Mac OS X 10.6.3. Wiki instructions here. Installed ruby-odbc, dbi (0.4.0), dbd-odbc (2.4.5), activerecord-sqlserver-adapter (2.3.5). In my database.yml (Rails 2.3.6): develop...
Sybase ODBC driver have an issue with the decimal data type. For example, when an application is trying to save in the database a decimal value occurs this error: ERROR [22018] [DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]Implicit conversion from datatype 'VARCHAR' to 'DECIMAL' is not allowed. Use the CONVERT function to...
To create an ODBC connection in VBA, two things are required: Create a ODBC data source Add references in Excel What I'd like to know is if OLEDB has fewer requirements and is easier to implement. ...
We recently upgraded a major application to Visual Studio 2010. Unfortunately, we are still using several database servers that are still running SQL Server 2000 (8.0.2055 to be precise). According to this article (http://blogs.msdn.com/b/habibh/archive/2009/07/27/visual-studio-2010-rip-list-partial.aspx), "Since mainstream support for...
I have a windows program which generates PGP forms which will be filled in later. Those PHP forms will populate a database. It looks very much like MySql, but I can't be certain, so let's call it ODBC. And, yes, it does have to be a windows program. There will also be PHP forms which query the database - examine which tables and field...
Hi, I am working on XP m\c and right now I don't have sybase install. But My server has the sybase 12.5 (that much I only know). I am using web service to talk to that server. How can I call the data from that server, For this I am using a webservice which has some web methods that are using specific connection string. Right now I am...
Folks: Has anyone had success connecting to a Progress-4GL database with Delphi? I've been unable to establish any connection with the ODBC driver provided by the vendor (Progress OpenEdge 10.1C Driver). I've entered (what I believe are) the right parameters, but keep on getting an error whenever I test the connection: "[Data...
I am new to database programming, so I'd like help getting on the right track. I have read that there are Microsoft-defined and third-party data providers for data access. MSDN has information on data providers for SQL Server, OLE DB, ODBC, Oracle, as well as the EntityClient provider (Entity Framework). Which data provider is today's ...
Hello, I run a c# process and in the middle of the night this happens: ERROR [HY000][DataDirect][ODBC Sybase Wire Protocol driver] Timeout exceeded I know for sure that the database is allways active! But this keeps happening! Do you how can I fix this error? Thanks in advance! EDIT: is there a way to put the timeout four times big...
I have a function defined inside an Oracle package: CREATE OR REPLACE PACKAGE BODY TESTUSER.TESTPKG as FUNCTION testfunc(n IN NUMBER) RETURN NUMBER as begin return n + 1; end testfunc; end testpkg; / How can I call it from C# using Odbc? I tried the following: using System; using System.Data; using System.Data.Odbc; class ...
Disclaimer: I am a n00b. It seems like ODBC does not support a BOOLEAN type? Is this true? If so, what's the standard kludgearound? Edit: I am using ADO with Delphi on Windows to write the data, but PHP 5 to read it back. ...
Y.A.N.Q. (yet another n00b question). I have managed to design my db, defining tables & columns. I have even got code to access the db, yay! Now, one bit that I haven't yet gotten to in the "MySql weekend crash course". Let's say that I want to store something like "notes" which is a TStringList sort of thing. A list of strings which...
Is there anyway to install myodbc 2.50.39-nt on a 64bit windows 7 computer? (it says 'the version of this file is not compatable with the version of windows that you are running') I have a few old VB6 programs that use it (almost all of it has been moved to a private intranet) If it isn't possible, it looks like the newer version of myo...
Hi All, I have a VB6 application that has been performing very well. Recently, we upgraded our server to a Windows 2003 server. Migration of the databases and shares went well and we experienced no problems. Except one. And it has happened at multiple sites. I use the MySQL ODBC 5.1 connector to point to my MySQL database. On identical...
I'm attempting to connect to a database via ODBC, and I am finding no help through Google/the internet. Our ERP uses OMNIS as a framework, which provides an ODBC driver for querying OMNIS' proprietary database outside of the program. I've created the driver and DSN, but I cannot begin manipulating data or sending queries with PHP. The ...
We are getting the following ODBC timeout errors when executing sql code against a SQL Server database. "Connectivity error: [Microsoft][ODBC SQL Server Driver]Timeout expired" "S1T00" The confusing thing here is that our stack dump says that the SQL code it is executing when the timeout occurrs - is very simple: SELECT @@TRANCOUNT AS...
This is probably a long shot, but I thought I would ask anyway.. I have an application I wrote back in the 90's in Omnis 7.3.5 that is still running (kind of like the Energizer Bunny..just keeps on going!) Its had no maintenance for years... The application accesses a Sybase database which is hosted on an elderly Unix box that needs to...