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
Winwedge - DDE - MySQL
Moderator: General Moderators
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.
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.
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)
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)
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
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