Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.soft-sys.math.mathematica > #6010 > unrolled thread
| Started by | "McHale, Paul" <Paul.McHale@excelitas.com> |
|---|---|
| First post | 2011-10-29 11:26 +0000 |
| Last post | 2011-10-29 11:26 +0000 |
| Articles | 1 — 1 participant |
Back to article view | Back to comp.soft-sys.math.mathematica
This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by
below is the oldest one visible, not the original post.
Re: Mathematica Beginner/Student and Mysql "McHale, Paul" <Paul.McHale@excelitas.com> - 2011-10-29 11:26 +0000
| From | "McHale, Paul" <Paul.McHale@excelitas.com> |
|---|---|
| Date | 2011-10-29 11:26 +0000 |
| Subject | Re: Mathematica Beginner/Student and Mysql |
| Message-ID | <j8gnsl$5hr$1@smc.vnet.net> |
Here is what I do... (* I check to see if it is open before I try *) Needs["DatabaseLink`"] myConn=If[SameQ[Head[myConn],SQLConnection],myConn, OpenSQLConnection["Mrp", "Username"->"mrpadmin", "Password"->"1734admin"]] (* define the sql string *) str1="SELECT SerialNumber, DateTime, OptionName, IndexNumber, Text, Scenario FROM MyView WHERE (Text='Passed') AND (IndexNumber=22) AND (Scenario LIKE'Acceptance%') ORDER BY IndexNumber"; (* execute the sql string *) mTestList=SQLExecute[myConn,str1]; Some notes: 1. If you use GUID, you must create a view which replaces them with some other type. Mathematica freaks out on GUIDs. 2. You must go into Start Menu -> All Programs -> Administrative Tools -> Data Sources ODBC Make sure you add a connection to your database. I seem to remember a catch22. You must be able to select the database in menu when you type only: Needs["DatabaseLink`"] OpenSQLConnection[] If it is not there, the driver is not configured properly. Use the System DNS tab in windows to configure it (in above path). If you try to view a relational database with their previous viewer you would get an erroneous error due to GUID. I think this avoidable. You must call the named database directly. You must call a view that resolves GUID. Paul McHale | Electrical Engineer, Energetics Systems | Excelitas Technologies Corp. Phone: +1 937.865.3004 | Fax: +1 937.865.5170 | Mobile: +1 937.371.2828 1100 Vanguard Blvd, Miamisburg, Ohio 45342-0312 USA Paul.McHale@Excelitas.com www.excelitas.com Please consider the environment before printing this e-mail. This email message and any attachments are confidential and proprietary to Excelitas Technologies Corp. If you are not the intended recipient of this message, please inform the sender by replying to this email or sending a message to the sender and destroy the message and any attachments. Thank you -----Original Message----- From: ejules [mailto:weberejules@gmail.com] Sent: Friday, October 28, 2011 5:36 AM Subject: Matematica Beginner/Student and Mysql Hello Everybody.. I hope this is the right place to post... I'm student and currently trying to connect a mysql database running locally on 127.0.0.1:3306 localhost, including the database Testdatabase with table Testtable. I try now to connect with Mathematica: Needs["DatabaseLink`"]; SqlConnection[ JDBC["MySQL(Connector/J)", "localhost:3306/testdatabase"], "Name" -> "TestDB", "Username" -> "root", "Password" -> ""] conn1 = OpensqlConnection["TestDB"] SQLTableNames[conn1] Unfortunately my Ouptut is only a echo of what i wrote but not the result i'm looking for afterwards i would like to send standard sql queries to retrieve data... Anyone could help me? Step by step? I never used Mathematica before, but as my datasets are pretty large and manipulating data in tables is very convienient, i would really appreciate any help.. Thank you! ejules
Back to top | Article view | comp.soft-sys.math.mathematica
csiph-web