[ale] PHP, ODBC & MSSQL

[matty91 at bellsouth.net]

Have you looked at a web-based solution utilizing LDAP? Hierarchical
databases are great for contact databases and address books. JNDI
and the LDAP perl modules are also very easy to use.

- Ryan

On Mon, 17 Feb 2003, Jonathan Glass (IBB) wrote:

> On Mon, 2003-02-17 at 21:35, John Wells wrote:
> > IBB said:
> > > PS
> > > I've been tinkering with this off and on for like 3 years w/little
> > > success.  :(
> >
> > Damn...three years?  Any reason why you didn't just redesign the thing
> > using a different db solution?  I'm assuming there is some VB app or
> > something along those lines that updates the .mdb and that's why you
> > haven't changed.  Is this the case?
>
> Well, it wasn't this one application.  I tinkered with PHP-MSSQL-SYBASE
> connectivity at my previous employer for a few days here, a few days
> there, but something always took precedence, and I ended up just
> duplicating the data in MySQL to save a migraine.
>
> On the current project, redesigning it IS a potential solution, but it
> does take time.  I have to recreate all the secretary's tables in MySQL,
> import the data, create the ODBC links, and PRAY that all his fancy
> reports and forms work!  Unfortunately, he doesn't believe in primary
> keys (he "hates them"!) so that is making this a special challenge.  The
> biggest issue I am facing is that he continues to make changes on a
> daily basis...but, on a good note, I've already installed and configured
> the ODBC on his machine, and now it is just a matter of taking a
> Saturday and migrating his data, then creating the links.
>
> It is silly to do all this work, simply so the Intranet page can have a
> list of phone numbers and email addresses, but so goes life.
>
> Jonathan
>
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale
>
_______________________________________________
Ale mailing list
Ale at ale.org
http://www.ale.org/mailman/listinfo/ale