Linux ODBC in RHEL v5.2


 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications Linux ODBC in RHEL v5.2
# 1  
Old 11-23-2008
Linux ODBC in RHEL v5.2

I need some help with a project I am working on.

I am writing a database application to manage some access lists. While this is for internal use only, the IT infrastructure is US Army managed. This severely limits which software I am allowed to use. I have a RHEL v5.2 server which uses some commercial software to push our access-lists to our routers/switches. Unfortunately our access lists are huge and this commercial app is unsuitable for the management part of the project. My plan is to write the management part in Microsoft Access and share the data with the linux app via a common SQL database. My original choice was to use MySQL and have Access use link-tables. This works fine, except that each PC that runs the Access interface needs to install the MySQL ODBC driver, which is not approved by the Army. So my next thought is to keep the database internal to the Access app and have all users load it from a shared location. I would then have the server that hosts the .mdb file share it out via the ODBC functionality built into windows (I think I only need Read-Only access from the linux side). I've shared out .mdb's like this before and it's worked fine, but never to a linux box. Linux ODBC support seems like a black art (and what I do see doesnt look free). Most forum posts have the .mdb file on the linux box, but that will not be possible here since everything is controlled via Active Directory and I dont think they would allow a linux file server. If I can just find some good info on Linux ODBC setup, I think I can make this work despite all of the artificial limitations.
# 2  
Old 11-23-2008
I guess I should also point out that on the linux side I am currently using Perl with a test database I setup on the linux server (MySQL). If I can get the ODBC in Perl to work, then I believe that will solve my problem.

This is just my current "bright idea" I am open to suggestions if anyone has one. Except, don't bother with any PHP/Java/CGI interface on the RHEL box... The additional hoops to get that approved are beyond my abilities.
# 3  
Old 11-25-2008
I can't help much with the Access part, I'm Linux mascot, but here's what I've found, I hope it will be useful.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Red Hat

RHEL Linux 6.2 to 7.3 - Bootable iso

Hi All On one of my sandbox machine, I want to replace RHEL 6.2 to RHEL 7.3. I am using both developer editions. rhel-server-7.3-x86_64-dvd.iso ... This is what I have downloaded from Red Hat Enterprise Linux Download | Red Hat Developers My understanding is this file would work as a... (1 Reply)
Discussion started by: videsh77
1 Replies

2. Shell Programming and Scripting

Establish ODBC connection from Linux

Hi All, I want to establish a ODBC connection to a database from linux and query the tables of a database. Please let me know how I can achieve this. Thanks and Regards Nagaraja Akkivalli. (0 Replies)
Discussion started by: Nagaraja Akkiva
0 Replies

3. UNIX for Dummies Questions & Answers

Linux (RHEL) and ports...

Hi, One of our applications running on RHEL is not working as expected - the application supplier has advised that a port is not allowing the correct traffic. I know the port is open for incoming connections (checked with nmap and telnet) however is there a way I check the port is open for... (4 Replies)
Discussion started by: mcclunyboy
4 Replies

4. Red Hat

Linux ODBC driver issue

Hi Gurus, I have a odbc in Linux. when I run command ldd. I got following result: # ldd DWora26.so linux-vdso.so.1 => (0x00007fff26355000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fc31e70a000) librt.so.1 => /lib64/librt.so.1 (0x00007fc31e501000) ... (1 Reply)
Discussion started by: ken6503
1 Replies

5. Red Hat

odbc installation on linux.

HI All, I am trying to install odbc driver for mysql on linux red hat. when I try to install it using rpm then i get dependency error and when I try to find that dependent package then I am unable to find it on web. can you plz help me how can I install it. Thanks. # rpm -ivh... (3 Replies)
Discussion started by: mkashif
3 Replies

6. Emergency UNIX and Linux Support

RHEL/Linux Small Monitor

Hi, I'm using RHEL 4.5, and currently due to some special circumstances that required me to use this small monitor about 7" The problem is while using this monitor with windows, the monitor able to show the graphic/view.. but while using redhat it unable to detect. This monitor has no... (7 Replies)
Discussion started by: flekzout
7 Replies

7. UNIX for Advanced & Expert Users

linux rhel: on which string did this come from?

Hi Guys, RHEL 4.4 I was reviewing an app failure on one of our hosts and I encountered this entry on syslog: Feb 22 08:54:46 saturn-host rc: Starting start_server_daemon: succeeded there's timestamp, saturn-host is the servername, rc is the linux rc wrapper script, "Starting" is on... (1 Reply)
Discussion started by: marcpascual
1 Replies

8. Red Hat

Linux RHEL 4 upgradation problem

Hi All, I have some problem in upgrading Linux from kernel 2.4.21-4.EL to 2.4.21-27.EL. I downloaded the package from Rpm source : kernel-source-2.4.21-27.EL.i386 RPM I upgraded using rpm -Uvh kernel-source-2.4.21-27.EL It installed sucessfully, But when i check grub.conf file... (3 Replies)
Discussion started by: VNK
3 Replies

9. Shell Programming and Scripting

DBD::ODBC::st fetchrow_hashref failed: [unixODBC][Oracle][ODBC]Numeric value out of r

Here is part of my program code: #Collect the output of test database and count the no #of rows too while(my @array = $tstDbStatementHandle->fetchrow_array) { push @tstDbOutputArray,; $tstDbOutputRows++; } ... (3 Replies)
Discussion started by: sameerstephen
3 Replies
Login or Register to Ask a Question