<img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/wallbash.gif" style="vertical-align:middle" emoid=":wallbash:" border="0" alt="wallbash.gif" /> <br /><br />I would like to make an odbc connection to the database so that I might use a disconnected recordset that I can update the db from. Anyhoo.... anyone using odbc_connect to their mysql db and if so could you throw me a bone?<br /><br /><br />Thanks much<br />-Tom<!--content-->
I'm not certain about odbc connections specifically, but <br /><br />TCH_David talks about remote connections to the database in this thread:<br /><a href="http://www.totalchoicehosting.com/forums/index.php?showtopic=18362&hl=yoursql" target="_blank">http://www.totalchoicehosting.com/forums/i...8362&hl=yoursql</a><br /><br />And this thread also talks about remote connection (emphasis on Excel):<br /><a href="http://www.totalchoicehosting.com/forums/index.php?showtopic=17162" target="_blank">http://www.totalchoicehosting.com/forums/i...showtopic=17162</a><br /><br />And this thread adapted the Excel information to a more general process:<br /><a href="http://www.totalchoicehosting.com/forums/index.php?showtopic=18314&hl=yoursql" target="_blank">http://www.totalchoicehosting.com/forums/i...8314&hl=yoursql</a><br /><br /><br />If odbc is another way of doing a remote connection (which is what it sounds like you're trying to do), those threads might get you started.<!--content-->
I'm not certain about odbc connections specifically, but <br /><br />TCH_David talks about remote connections to the database in this thread:<br /><a href="http://www.totalchoicehosting.com/forums/index.php?showtopic=18362&hl=yoursql" target="_blank">http://www.totalchoicehosting.com/forums/i...8362&hl=yoursql</a><br /><br />And this thread also talks about remote connection (emphasis on Excel):<br /><a href="http://www.totalchoicehosting.com/forums/index.php?showtopic=17162" target="_blank">http://www.totalchoicehosting.com/forums/i...showtopic=17162</a><br /><br />And this thread adapted the Excel information to a more general process:<br /><a href="http://www.totalchoicehosting.com/forums/index.php?showtopic=18314&hl=yoursql" target="_blank">http://www.totalchoicehosting.com/forums/i...8314&hl=yoursql</a><br /><br /><br />If odbc is another way of doing a remote connection (which is what it sounds like you're trying to do), those threads might get you started.<!--content-->