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

learn more… | top users | synonyms

3
votes
0answers
90 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
218 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
113 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 ...
0
votes
0answers
28 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
45 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
83 views

Cannot access the Database using the JDCB - ODBC

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