I've tried the below script but I am getting an error: dim cn, rs set cn = CreateObject("ADODB.Connection") set rs = CreateObject("ADODB.Recordset") cn.connectionstring = "Provider=MysqlProv; Data Source=Adonis; User Id=mysqluser; Password = mysqlpass;" cn.open rs.open "select * from Countries", cn, 3 rs.MoveFirst while not rs.eof ...
I am trying to allow a user to select a table a 2 columns from that table for use in a query. They define the provider and the connection string to choose the database. This is done using the DBProviderFactory and the DBConnectionStringBuilder. The problem seems to be when using the ODBC provider, other providers (OLEDB, Sql) seem ok....
I would like to run an SQL query on an iSeries (...or "System i" or "AS/400"...) machine as part of a Nagios check, but haven't found a suitable way of interfacing the database yet. IBM suggests using the ODBC driver of System i Access for Linux with unixODBC, but since both systems are new to me, I'd like to know if there are other wa...
I need to talk to a remote SQL Server 2000 database. I use MAMP locally and I would like to continue using it. However, I'm lost as to what I need to do to add support for talking to this database from PHP. It looks like either the ODBC or SQL Server functions in PHP will work, but those modules aren't installed by default. Can someo...
I'm having trouble connecting to a SQL Server 2005 install from this very simple Ruby app: #!/usr/bin/env ruby require 'rubygems' require 'sequel' Sequel.odbc('dev04')['select top 1 * from users'].all The dev04 DSN points to my odbc.ini file entry: [dev04] Driver = FreeTDS Description = ODBC connection via FreeTDS Trace =...
I am currently using a Microsoft ODBC driver to connect a .NET application to a Paradox Database. Periodically I get errors like ERROR [HY000] [Microsoft][ODBC Paradox Driver] Reserved error (-3034); there is no message for this error. I would like to find a list of error codes that can translate -3034 into something that means somet...
Hello there, i'm trying to build a setup package for a legacy vb6 software. the software itself connects to a sql server via sqlncli (native client). i've packaged all the dependencies and deploy them to a new machine running winxp and office2003. now, from the target machine i can connect to the database (ms sqlserver 2005) that is ru...
I have a MS Access database (Access 2002, for the record). It has a column whose name contains a question mark, say, for example table "Users" with columns "uid" and "isAdmin?". I need to connect to this database via ODBC, and query for this column, along the following lines: select [uid], [isAdmin?] from Users order by [isAdmin?]; ...
I have a adaptive server anywhere network server(version 7.0),it's name is "TestServer". Now, Client want to connect this server using OdbcConnetion in DOTNET,How to set the connection string ? ...
I am looking for drivers that can be used to connect to sybase database from QTP. ...
How to access a remote database with Visual Basic 6? It's been a while since I've done any code in Visual Basic 6, I remember ODBC connections however I'm not sure how I would go about it. All that I need is to have a database on a host computer and then some clients would connect to it, probably without need to guarantee simultaneous ...
Hi, I'm looking for a way to open an Access MDB file inside a Java App (using JDBC). A quick Google Search suggests that I need the JDBC-ODBC Bridge for this... Does this mean that I need to configure every system I want to run my app on to provide a ODBC DSN for the MDB I want to open? And one more question (since I've never used OD...
Traditionally, my client software forces a configuration of the ODBC source by going into 'Administrative Tools' and manually creating a new ODBC connection. Is there anyway to configure a new ODBC connection during an install? On a related note, is there a way to capture an existing ODBC connection for use in this theoretical process?...
Hi there, I want to implement a "smartODBCLogin". I know how to get a list of all engineNames and drivers from all ODBC data sources out of the registry. Now I want to know, which of these sources are available (active). (To open a new odbcConnection wouldn't work/help, would take to much time.) Does anybody know how to implement this...
Using CDaoDatabase defined in afxdao.h, how can I open up Excel 2007 (xlsx) files? I can open up Excel 2003 (xls) files using the connection string Excel 8.0;HDR=NO;IMEX=1, anybody know how I can do this? Thanks! ...
These are MY symptoms: (XP Pro, 32bit) -Programs that access .mdb databases (aside from Access 2007 itself) can not get any data. -Using the Data Sources in Visual Studio 2008 to connect to an MDB shows tables, but you can not query. you receive "Unknown Error" from the Microsoft JET Database Engine -ArcCatalog can not read a personal g...
I've spent the last couple days trying to get ODBC installed and I am about to lose my mind, I'm way out of my element here. Please can some one help me before I fall to pieces. Here's what I'm trying: 1) Download 1.7.2 source code package found here (I'm using 1.7.2): http://www.mamp.info/en/downloads/index.html 2) CD into the php dir...
I have a VB6 app that access's a database thru a ODBC Connection. It will run fine for a few hours then I get the following Error. Any Ideas? [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite(WrapperWrite()) ...
I am just beginning to learn how to write software that accesses an SQL server. It seems that each server implementation (Postgres, MySQL, etc.) offers API libraries for various languages (my code is in C and C++, though solutions for Java and Python would also interest me). I'm a little wary of depending on these libraries, however, b...
I have problem with connecting to a Firebird database. It works perfectly, when I use isql tool, or program I have written using Borland dbExpress drivers. When I try to test ODBC connection it fails. I am using official Firebird ODBC drivers, version 2.0. Strange facts: On other machines in the same network ODBC connection test fails...