ok this might seem basic, but I have made the move recently from access to mysql for our server's DB, but for some reason having a ton of trouble connecting. What sort of connection do I make? I have requested they make a system dsn with a mySQL driver, but they seem to have set it up as access instead. Anyhow, would I connect to it through ultradev, the same way I would an access DB in my connections window? I assume that if I use the DSN name, then it would connect, but what address does it run on? My domain name, or the server's mySQL URL that we access it to administer the DB?

Try to use ADO connection String - you can create one very easy, as described on www.udzone.com/go?312

Greetings,
George Petrov
UDzone.com

Maybe I misunderstood the tutorial, but doesn't an ADO connection string still have to use a DSN name? If so, it doesnt help my situation, as the drivers are still wrong in the DSN

When you don't choose a ODBC DSN, but directly the database - then an ADO Connections String is DSN-less
Just don't choose any ODBC DSN's - choose your DB directly

Greetings,
George Petrov
UDzone.com

I think I might be still in the dark on this one, but the mySQL database I have is in the bin folder, and is broken up into different files, I can't select one single database file to make the connection string. I am still forced to use the dsn, which unfortunately hasnt been fixed by the ISP.

I downloaded MySQL and to be honest i can't understand it. How the H..... can i insert my data?

Walk through this tutorial on devshed.com and some things will get more clear on how to use mysql/access to insert/update data.

www.devshed.com/Server_Side/MySQL/ODBC/