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

learn more… | top users | synonyms

11
votes
0answers
193 views

Benefit of using Dataset to collect SQLSelect output

Considering a DatabaseExample included with Mathematica: ...
4
votes
0answers
58 views

Is it possible to specify GMT as default in OpenSQLConnection or JDBC?

I'm connecting to a PostgreSQL database, with tables containing TIMESTAMPs with timezone, using ...
3
votes
0answers
473 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
299 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
163 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
27 views

OpenSQLConnection SSPI Library Not Loaded

I am attempting to open a connection to SQL Server with Windows Authentication (SSPI) using OpenSQLConnection and JDBC. ...
1
vote
0answers
31 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 ...
1
vote
0answers
42 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
26 views

How to identify primary keys in an existing database table

I would like to identify the primary keys in a DB table using DatabaseLink commands trying to exclude SQLExecute. It seems like SQLTableInformation or SQLColumnInformation may not show that ...
0
votes
0answers
37 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
57 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
148 views

Cannot access the Database using the JDCB - ODBC

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