DatabaseLink is a toolkit for working with SQL databases built into Mathematica.

learn more… | top users | synonyms

9
votes
0answers
157 views

Benefit of using Dataset to collect SQLSelect output

Considering a DatabaseExample included with Mathematica: ...
3
votes
0answers
111 views

Using cursors with result sets to reduce memory usage

I have a database table with 900,000 rows and 80 columns per row which I'd like to work with in mathematica. My computations are isolated to each row, so I'd like to stream only a single row (or small ...
3
votes
0answers
412 views

Problem inserting data into a mysql table with column names having a space

I have a mysql table whose column name has space. I tried inserting the data into this column. I got an error I tried a sample code, which tests accessing the columns with a space and that returns ...
3
votes
0answers
273 views

Microsoft SQL DatabaseLink connection using Windows Authentication from Mac

We know that Mathematic doesn't natively support Windows Authentication connect. But as we can see in this post, the problem can be easily solved when your Mathematica is in Windows version (I have ...
2
votes
0answers
26 views

Need a recommendation for managing a database link

I want to make a package which needs to have a external database link. But it is hard for me to have an idea about how to manage the database link. I want the link to be connected as long as I use the ...
2
votes
0answers
143 views

Can Mathematica use a MySQL ODBC connector?

I have a MySQL database that I connect to using Mathematica and would like to distribute my Mathematica code to others. We already have ODBC DSNs setup on peoples machines using the MySQL ODBC ...
1
vote
0answers
37 views

SQLDateTime from a time column is missing the milliseconds component

Can anyone confirm this? I am using M9.0.1 on win7 64bit connecting to a SQL Server db. When I fetch a datetime column the SQLDateTime objects contain 6 entries, 5 integers and a fractional second ...
0
votes
0answers
31 views

Mathematica not showing MySQL databases

I have MySQL installed and I want to access the databases from Mathematica. From the command line this is what I have Now I want to edit this db directly form Mathematica. If I do ...
0
votes
0answers
49 views

Creating ODBC connection on mac

Iam not able to create a ODBC connection on mac through mathematica even though i have created a connection successfully through ODBC Administrator. The error message iam getting was: JDBC::error: ...
0
votes
0answers
68 views

analysing data with MLF using (Oracle) Database connection

I'm testing the MLF package in Mathematica for datamining purpose. I start the databaseconnectivity with the following code: ...
0
votes
0answers
118 views

Cannot access the Database using the JDCB - ODBC

Runnig this code after building the ODBC connection for my access application named WPC : ...