I created a Delphi application which utilizes an ODBC data source to access text files in csv format. The driver is the "Microsoft Access Text Driver". But when I deploy my application on a Windows 7 computer it does not work because this driver is not available (there are only two available in odbcad32: sql native client and sql serve...
I recently installed SQL Server 2008 Express on my Windows 7 Ultimate x64 home machine. I also have IIS 7.5 with PHP 5.3, and I was trying to connect to SQL via ADODB, but kept getting this error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application After doing a small...
When you run a query like so: $query = "SELECT * FROM table"; $result = odbc_exec($dbh, $query); while ($row = odbc_fetch_array($result)) { print_r($row); } Does the resource stored in $result point to data that exists on the server running php? Or is pointing to data in the database? Put another way, as the while loop does it's...
Situation: I have a program written in VB6 The source code of the program is not available It connects to a database using ODBC connection string. The vendor setup a connection name to the database when the program was first installed 6 years ago My machine crashed, all the settings are gone! The program vendor is out of business. Even...
I'm trying to connect to Sybase database from the web server using UnixODBC. Sybase is installed on windows server while the web server is on Unix Server. In order to connect to Sybase I'm using UnixODBC which requires the file libdbodbc.so for Sybase I'm trying to locate this file but I'm unable to find it anywhere. Anyone can tell ...
Does anyone know of a way to make Excel 2003 push changes to a MySQL database? Currently, we're using Excel 2003 for keeping track of a big bunch of interconnected equipment (actually, an entire electric power distribution system with all the hoo-ha's that hang off it.) Quite frankly, using a spreadsheet for this sucks and I'm sick of i...
In Excel I can go to Data -> Import External Data -> Import Data... and then select the data source to use and then after I provide login information it gives me a list of tables. I would like to know how to get that list programmatically using C#. ...
Can Anybody tell me how to connect ASP to MySQL database.. I have already install MySQL in my localhost, Add a connection through Data Source (ODBC) in ctrl panel and test connection succeed. Now I want to show the query on my default.aspx page so that I can do the insert / update / delete my table data in MySQL. Can anyone help me? ...
I set timeout to 0 but the connection close prematuraly, what is wrong with this statement ? Using odbcconn As New OdbcConnection(DataShared.gstrCNN) odbcconn.ConnectionTimeout = 0 odbcconn.Open() Dim OdbcCmd As New OdbcCommand( _ "{ ? = CALL [proc_Cp_GenEstadoCta](" & _ PCOD_EMPR...
I have an existing PHP script that needs to work with data from an Access db, and the machine it's on is migrating from Win2K to Windows 7. I looked around, and Microsoft seems to say that this is still available somewhere, but I can't find any solid information about how to actually get it. ...
The report is runnig fine in Visual Studio 2005 but fails when I deploy it on IIS. It prompts, the report you requested requires further information. I think it needs to get installed some service pack either of SQL server client, or of Crystal Reports. Please suggest. ...
I have a large VB program that connects to Oracle database. strCn = "Driver={Microsoft ODBC for Oracle};" & _ "SERVER=PSPROD;" Set Cn = New ADODB.Connection Cn.ConnectionString = strCn Cn.CursorLocation = adUseNone Cn.Open There are many users of my program so I have a table that contains each user's login name and their ac...
Hi, I need to develop some kind of application and use DB in it. Let's say i want to develop it over Windows currently, however, in a couple months i may have to migrate it to Linux. I started reading a little bit about it, but couldn't get to point i needed. Is there or isn't a generic/protable/standart api for using DB ? I read th...
I have application that requires SQL Server 2000 as database storage. I do not really want to use SQL Server 2000, but I can user MySQL Server instead. Application uses ODBC to connect to SQL Server Database. I would like to know if it is possible to make fake SQL Server which will send and receive data to/from MySQL Server applicatio...
A month ago, I was showing a buddy how use .NET to query MySQL. It worked just fine, but he didn't understand why we needed a "driver" for MySQL in conjunction with ODBC. He though ODBC would be enough. When he asked me why, I did my best, but my answer came up short. What is the correct explanation for this question? ...
What is the path of least resistance in getting an SBCL application running on Windows to connect to a SQL Server instance, using integrated authentication? I have found posts on connecting from CL-SQL to SQL Server using ODBC connections but as far as I can tell, there is no way to this without first manually setting up a DSN. Is ther...
I couldn't find out why it shows error. I have created table named books in Oracle priorly. create table books(num number); Then I wrote code in Java: Class.forName("oracle.jdbc.driver.OracleDriver"); con=DriverManager.getConnection( "jdbc:oracle:thin:@CF:1521:orcl", "scott", "tiger"); Statement s=con.createStatement(); s...
Using Visual Basic for Applications, how can I find out which version of the MySQL ODBC driver is installed in Windows on a user's machine? I have a Microsoft Access application that uses the MySQL ODBC driver to make a connection. The connection string looks like this: ODBC;DATABASE=mydatabase;DRIVER={MySQL ODBC 3.51 Driver}; OPT...
Hi all, I'm working on an eCommerce website for a small merchant. This merchant uses Opera (which is based on Visual FoxPro) to manage his in-store inventory, and would like the online store inventory to reflect the in-store inventory. I'm guessing that my first step is to set up a way to regularly transfer the information from the VF...
Old subject, combined with new tools: What would be the best/appropriate way to query data for a web application from an AspenTech IP21 (InfoPlus.21) data historian? In the past, I've used some pretty awful queries via the Aspen SqlPlus ODBC driver, but that doesn't seem like the right approach, as it doesn't seem to install on Win 7 at...