JVRudnick
04-17-2003, 07:52 PM
Hello all...
Been fighting my way into learning how to change over from an Access db to mySQL, and it works fine here on my own dev box.
Thing is, I've uploaded same to my webhost (NT and IIS is what we're on - we're an MS shop) and the host is CLUELESS when it comes to providing ASP support as they're really an apache outfit...sigh...
I also sent the whole folder to them too, with the dbase inside (named cars) and it's two tables. My app -- of course -- will not run...oh, I finally figured out the "paths" to use in ASP to allow my pages to query the mySQL dbase..no thanks to the host!
So, help please, I inquired...sure they said, here use this great tool to manage your db named phpmyAdmin. Have tried to run a pure query on that, and it continues to say sorry, no such table in that dbase???
Huh? I know it's there, just like it's on my own dev box..which leads me to believe that the host merely copied the dbase title, Id and Pw and left it at that...figuring that I can make the tables again (this is the right way to "hand" your host an mySQL dbase right???)
I now see that the phpmyAdmin offers the ability to make tables...UGH....as one of them has 230 fields.
Anyone offer some help here? Can phpmyAdmin import a file from my dbase folder here on my own dev box to do that quickly?
Or, as I'm using an ASP solution, is there any "other" way to admin mySQL from same rather than use the phpmyAdmin puppy?
Anyone here?
Jim
Been fighting my way into learning how to change over from an Access db to mySQL, and it works fine here on my own dev box.
Thing is, I've uploaded same to my webhost (NT and IIS is what we're on - we're an MS shop) and the host is CLUELESS when it comes to providing ASP support as they're really an apache outfit...sigh...
I also sent the whole folder to them too, with the dbase inside (named cars) and it's two tables. My app -- of course -- will not run...oh, I finally figured out the "paths" to use in ASP to allow my pages to query the mySQL dbase..no thanks to the host!
So, help please, I inquired...sure they said, here use this great tool to manage your db named phpmyAdmin. Have tried to run a pure query on that, and it continues to say sorry, no such table in that dbase???
Huh? I know it's there, just like it's on my own dev box..which leads me to believe that the host merely copied the dbase title, Id and Pw and left it at that...figuring that I can make the tables again (this is the right way to "hand" your host an mySQL dbase right???)
I now see that the phpmyAdmin offers the ability to make tables...UGH....as one of them has 230 fields.
Anyone offer some help here? Can phpmyAdmin import a file from my dbase folder here on my own dev box to do that quickly?
Or, as I'm using an ASP solution, is there any "other" way to admin mySQL from same rather than use the phpmyAdmin puppy?
Anyone here?
Jim