odbc

Connect PHP to an AS/400

I've got an upcoming project wherein I will need to connect our website (PHP5/Apache 1.3/OpenBSD 4.1) to our back-end system running on a iSeries with OS400 V5R3 so that I can access some tables stored there. I've done some checking around but am running into some roadblocks. From what I've seen the DB2 extensions and DB2 software from ...

Using Parameters in MS Reporting Services (SQL 2008) against an ODBC data source

I writing a report in Visual Studio that takes a user input parameter and runs against an ODBC datasource. I would like to write the query manually and have reporting services replace part of the where clause with the parameter value before sending it to the database. What seems to be happening is that the @parmName I am assuming will be...

Using MS Access & ODBC to connect to a remote PostgreSQL

I currently have an MS Access application that connects to a PostgreSQL database via ODBC. This successfully runs on a LAN with 20 users (each running their own version of Access). Now I am thinking through some disaster recovery scenarios, and it seems that a quick and easy method of protecting the data is to use log shipping to create ...

Using MySQL on Visual Studio 2008

I am using the ODBC connector to access a MySQL db from visual studio 2008 and i am facing performance problems when dealing with crystal reports and to solve this i need a native connector to visual studio. if someone has had a similar problem and knows a solution or tools ( freeware preferable ) , i would be really grateful. ...

How can I lock down my MS-SQL DB from my users and yet still access it through ODBC?

I've got an ms-access application that's accessing and ms-sql db through an ODBC connection. I'm trying to force my users to update the data only through the application portion, but I don't care if they read the data directly or through their own custom ms-access db (they use it for creating ad hoc reports). What I'm looking for is a w...

How do I get ms-access to connect to ms-sql as a different user?

How do I get ms-access to connect (through ODBC) to an ms-sql database as a different user than their Active Directory ID? I don't want to specify an account in the ODBC connection, I want to do it on the ms-access side to hide it from my users. Doing it in the ODBC connection would put me right back in to the original situation I'm tr...

C# ODBC Dialog

Any information on how to display the ODBC connections dialog and get the chosen ODBC back? ...

Using Rails 2.x with MS SQL Server 2005

Does anybody here have positive experience of working with MS SQL Server 2005 from Rails 2.x? Our developers use Mac OS X, and our production runs on Linux. For legacy reasons we should use MS SQL Server 2005. We're using ruby-odbc and are running into various problems, too depressing to list here. I get an impression that we're doin...

How do you deal with NULL values in columns of type boolean in MS Access?

I was wondering if there is a better way to cope with MS-Access' inability to handle NULL for boolean-values other than change the column-data-type to integer. ...

Control which columns become primary keys with Microsoft Access ODBC link to Oracle

When you create a Microsoft Access 2003 link to an Oracle table using Oracle's ODBC driver, you are sometimes asked to state which columns are the primary key(s). I would like to know how to change that initial assignment, or even how to get Access/ODBC to forget the assignment. In my limited testing I wonder if the assignment isn't cac...

What is a Privileged instruction?

I have added some code which compiles cleanly and have just received this Windows error: --------------------------- (MonTel Administrator) 2.12.7: MtAdmin.exe - Application Error --------------------------- The exception Privileged instruction. (0xc0000096) occurred in the application at location 0x00486752. I am about to go on a ...

Best way to debug an ODBC driver on Windows

What is the best way to debug a custom ODBC driver on Windows? A former member of our team wrote the driver so we have the source available. How do you attach a debugger to the driver? Or is it easier to just add "trace prints" to the driver to see what is going on? ...

How to programmatically configure an ODBC Datasource using C#

Is there any way to create a ODBC DSN with C#? Maybe a P/invoke? ...

Reverse Engineering for Database Diagramming in Visio with SQL Server 2008

I need to reverse engineer a Microsoft SQL Server 2008 in order to create a Microsoft Visio 2007 Database Model Diagram. So I choose Reverse Engineer from the Database menu to connect to the DB. I configured the Microsoft SQL Server Visio driver so that is uses SQL Server Native Client 10.0 as the ODBC driver. Afterwards I created a Use...

Reading a COBOL DAT file

I have been given a set of COBOL DAT, IDX and KEY files and I need to read the data in them and export it into Access, XLS, CSV, etc. I do not know the version, vendor of the COBOL code as I only have the windows executable that created the files. I have tried Easysoft and Parkway ODBC drivers but I have not been successful in reading t...

what is the difference between OLE DB and ODBC data sources?

I was reading a MS Excel help article about pivotcache and wonder what they mean by OLE DB and ODBC sources ...You should use the CommandText property instead of the SQL property, which now exists primarily for compatibility with earlier versions of Microsoft Excel. If you use both properties, the CommandText property’s v...

ODBC Connection Pool

I'm having trouble with ODBC connection pool I've read the article Frequently Asked Questions About ODBC Connection Pooling and setup everything to make use of ODBC connection pool. The problem is, after I release the connection it is not returned to the pool. Instead it is hard closed. I check it using Performance monitor utility in W...

.NET ODBC Connection Pooling

I open a connection like this: Using conn as New OdbcConnection(connectionString) conn.Open() //do stuff End Using If connection pooling is enabled, the connection is not physically closed but released to the pool and will get reused. If it is disabled, it will be physically closed. Is there any way of knowing programmaticall...

What are the access restrictions on accessing a DSN

We are running part of our app as a windows service and it needs to b able to access DSNs in order to import through ODBC. However there seem to be a lot of restrictions found through trial and error on what DSNs it can access. For example it seems that it cannot 1. access a system DSN unless the account that is running the service ha...

Microsoft.ApplicationBlocks.Data.ODBCHelper ?

I've found mention of a data application block existing for ODBC, but can't seem to find it anywhere. If i didn't have a copy of the Access DB application block I wouldn't believe it ever existed either. Anyone know where to download either the DLL or the code-base from? --UPDATE: It is NOT included in either the v1, v2, or Enterpris...