Winwedge - DDE - MySQL

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Winwedge - DDE - MySQL

Post by Burrito »

I am goign to be creating phone log system that will dump phone records to a database which I will use with php to do some fun stuff with the data.

Winwedge is an application that can either parse the phone logs and dump them to a text file, or dump them directly to a database...using DDE. I'm not familar with DDE but from what I gather on the winwedge site, it is basically a database driver. On their site they say you can use DDE to dump to an access database or a MSSQL database. I'd like to dump it all to a MySQL database if that's possible.

my question then is two-fold: One is DDE a database driver? And two, if so, can it talk to MySQL.

I've already tossed around the idea of parsing the txt files that winwedge can create and dumping the data to a MySQL DB from there, but that was met with great resistance by the IT dood here...he wants it all to be "realtime"...I tried to explain that I could parse it "realtime" to no avail.

please let me know,

thx for your time,

Burr
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

php can talk with ms-access and ms-sql too..

or get the mysql - odbc driver (somewhere on the mysql site)
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post by Burrito »

yeah got myodbc installed....now trying to figure out how to get msaccess to talk to mysql.

I'm trying to create a "data access page" but I can't seem to find my odbc driver that I set up to my mysql db. It's only showing me the ole db stuff.

I realize that this has gone WAAAAAAAAAAAAAY beyond the scope of this forum as I'm no where near anythign php related right nwo....but if you have some suggestions as to what I should do to connect ms access to mysql, I'd greatly appreciate it.
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

you should not connect ms-access to mysql directly :)

my suggestion was: make the application talk with odbc (and feed it a dsn like mysql://user:pass@host/db)


or write your php script so that they use ms-access or mssql as dbms instead of mysql. (through http://adodb.sf.net this isn't really hard)
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post by Burrito »

Tim, thx for the suggestions:

I finally figured out how to make access talk with mysql and here's what I did:

I created a new database, then hit file --> get external data --> link tables and I was able to select my odbc from there and add my table from mysql.

I can now update, select, etc right off my mysql db from within access so problem solved.

This shouldn't be a security issue because this stuff will all be in house and I'm not too concerned with lag issues because it will only be creating new records at the most every 2 seconds.

I will run all of my php stuff connecting to the mysql db using the standard data connection.

I appreciate all the help.

Burr
Post Reply