<html><head></head><body bgcolor="#FFFFFF"><div>It's unlikely that odbc has anything to do with it. XOT expects to connect to MySQL directly. </div><div><br><div>David Goodwin </div><div>Pale Purple Ltd. </div><div><a href="http://www.palepurple.co.uk">http://www.palepurple.co.uk</a></div><div>0845 0046746</div><div>07792 380669</div></div><div><br>On 28 Apr 2012, at 20:42, "KnowledgeWare" <<a href="mailto:knowledgeware@kccsoft.com">knowledgeware@kccsoft.com</a>> wrote:<br><br></div><div></div><blockquote type="cite"><div><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="Generator" content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--><div class="WordSection1"><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">The ODBC connection has not fixed the problem, unless I have the wrong DSN name which I’m trying to confirm. Vince sees a PHP error, tracking that down next…however the PHP all looks OK to me. <o:p></o:p></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">RonM2<o:p></o:p></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p><div><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in"><p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:xerte-bounces@lists.nottingham.ac.uk">xerte-bounces@lists.nottingham.ac.uk</a> [mailto:xerte-bounces@lists.nottingham.ac.uk] <b>On Behalf Of </b>David Goodwin<br><b>Sent:</b> Saturday, April 28, 2012 10:02 AM<br><b>To:</b> Xerte discussion list<br><b>Cc:</b> Xerte discussion list<br><b>Subject:</b> [Xerte] Re: database.php<o:p></o:p></span></p></div></div><p class="MsoNormal"><o:p> </o:p></p><div><p class="MsoNormal">MySQL database names are probably case sensitive. <o:p></o:p></p></div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal">Just saying ...<o:p></o:p></p></div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal" style="margin-bottom:12.0pt"><br>On 28 Apr 2012, at 17:10, Pat Lockley <<a href="mailto:patrick.lockley@googlemail.com">patrick.lockley@googlemail.com</a>> wrote:<o:p></o:p></p></div><blockquote style="margin-top:5.0pt;margin-bottom:5.0pt"><div><div><p class="MsoNormal" style="margin-bottom:12.0pt">Dbanks_xot is the database name<br><br>On 28 Apr 2012, at 16:21, Dave Burnett <<a href="mailto:d_b_burnett@hotmail.com">d_b_burnett@hotmail.com</a>> wrote:<o:p></o:p></p></div><blockquote style="margin-top:5.0pt;margin-bottom:5.0pt"><div><div><p class="MsoNormal">Figure so but thought I'd check.<o:p></o:p></p><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal"><span style="font-size:10.0pt">In phpMyAdmin there is a dropdown below the designation Database</span><o:p></o:p></p></div><div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal">In the dropdown:<o:p></o:p></p></div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal">(Databases)<o:p></o:p></p></div><div><p class="MsoNormal"> dbanks [in bold]<o:p></o:p></p></div><div><p class="MsoNormal"> _commtest (57)<o:p></o:p></p></div><div><p class="MsoNormal"> _xot (11) //in brackets is the table count<o:p></o:p></p></div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal">So the name of the database is?<o:p></o:p></p></div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal">dbanks_xot ?<o:p></o:p></p></div><div><p class="MsoNormal">_xot ?<o:p></o:p></p></div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal">At any rate I get nothing.<o:p></o:p></p></div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal">I added $development = true;<o:p></o:p></p></div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal">/** <o:p></o:p></p></div><div><p class="MsoNormal"> * $xerte_toolkits_site variable<o:p></o:p></p></div><div><p class="MsoNormal"> * Variable used to hold database settings<o:p></o:p></p></div><div><p class="MsoNormal"> * @global object $xerte_toolkits_site<o:p></o:p></p></div><div><p class="MsoNormal"> */<o:p></o:p></p></div><div><p class="MsoNormal">$development = true;<o:p></o:p></p></div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal">But get no error messages.<o:p></o:p></p></div></div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p><div><p class="MsoNormal">> Date: Sat, 28 Apr 2012 15:20:41 +0100<br>> From: <a href="mailto:patrick.lockley@googlemail.com">patrick.lockley@googlemail.com</a><br>> To: <a href="mailto:xerte@lists.nottingham.ac.uk">xerte@lists.nottingham.ac.uk</a><br>> Subject: [Xerte] Re: database.php<br>> <br>> /*<br>> * Database name<br>> */<br>> $xerte_toolkits_site->database_name ="what goes here?";<br>> <br>> your database name, which could be anything<br>> <br>> /*<br>> * Database table prefix<br>> */<br>> $xerte_toolkits_site->database_table_prefix ="what goes here?";<br>> <br>> here you put a prefix in case you wish your xerte DB to sit within another one<br>> usually blank<br>> <br>> _______________________________________________<br>> Xerte mailing list<br>> <a href="mailto:Xerte@lists.nottingham.ac.uk">Xerte@lists.nottingham.ac.uk</a><br>> <a href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</a><br>> <br>> This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it. Please do not use, copy or disclose the information contained in this message or in any attachment. Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.<br>> <br>> This message has been checked for viruses but the contents of an attachment<br>> may still contain software viruses which could damage your computer system:<br>> you are advised to perform your own checks. Email communications with the<br>> University of Nottingham may be monitored as permitted by UK legislation.<br>> <o:p></o:p></p></div></div></div><p class="MsoNormal"><o:p> </o:p></p><p>This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it. Please do not use, copy or disclose the information contained in this message or in any attachment. Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham. <o:p></o:p></p><p>This message has been checked for viruses but the contents of an attachment may still contain software viruses which could damage your computer system: you are advised to perform your own checks. Email communications with the University of Nottingham may be monitored as permitted by UK legislation. <o:p></o:p></p></div></blockquote><blockquote style="margin-top:5.0pt;margin-bottom:5.0pt"><div><p class="MsoNormal" style="margin-bottom:12.0pt">_______________________________________________<br>Xerte mailing list<br><a href="mailto:Xerte@lists.nottingham.ac.uk">Xerte@lists.nottingham.ac.uk</a><br><a href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</a><br><br>This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it. Please do not use, copy or disclose the information contained in this message or in any attachment. Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.<br><br>This message has been checked for viruses but the contents of an attachment<br>may still contain software viruses which could damage your computer system:<br>you are advised to perform your own checks. Email communications with the<br>University of Nottingham may be monitored as permitted by UK legislation.<o:p></o:p></p></div></blockquote></div></blockquote><blockquote style="margin-top:5.0pt;margin-bottom:5.0pt"><div><p class="MsoNormal" style="margin-bottom:12.0pt">_______________________________________________<br>Xerte mailing list<br><a href="mailto:Xerte@lists.nottingham.ac.uk">Xerte@lists.nottingham.ac.uk</a><br><a href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</a><br><br>This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it. Please do not use, copy or disclose the information contained in this message or in any attachment. Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.<br><br>This message has been checked for viruses but the contents of an attachment<br>may still contain software viruses which could damage your computer system:<br>you are advised to perform your own checks. Email communications with the<br>University of Nottingham may be monitored as permitted by UK legislation.<o:p></o:p></p></div></blockquote></div></div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>Xerte mailing list</span><br><span><a href="mailto:Xerte@lists.nottingham.ac.uk">Xerte@lists.nottingham.ac.uk</a></span><br><span><a href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</a></span><br><span></span><br><span>This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it. Please do not use, copy or disclose the information contained in this message or in any attachment. Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.</span><br><span></span><br><span>This message has been checked for viruses but the contents of an attachment</span><br><span>may still contain software viruses which could damage your computer system:</span><br><span>you are advised to perform your own checks. Email communications with the</span><br><span>University of Nottingham may be monitored as permitted by UK legislation.</span><br><span></span><br></div></blockquote></body></html>