The sql tag has no wiki summary.
2
votes
2answers
170 views
Working with a database
I just started to work with a database through Mathematica. I have a large data set. I use an .mx file to store my data. Now I have to store the data in a database, ...
2
votes
0answers
47 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
2answers
107 views
Network database access - How do I connect to a remote database?
I am able to connect to a specific MS Access Database when it is on the same Windows computer as Mathematica via the command
...
3
votes
1answer
72 views
Running postgresql query with backslash
I've been able to connect to a Vertica database, and also been able to run a SELECT query. But I'm not being able to run a query with a backslash in it. (Vertica has commands like postgresql.) The ...
2
votes
0answers
64 views
Add new JDBC Driver to connect MM to SQL database
I cannot open a SQLConnection to a SQL vectorwise database and I assume the JDBC driver is the problem. A JAR file was provided to me - the only info additionally provided to me was the java class: ...
2
votes
1answer
70 views
Mathematica 9.0 problem: ParallelTable with SQLExecute
I have run into the following problem: when I try to run the following code in Mathematica 9 I get SQL connection error on all kernels.
The code is:
...
7
votes
1answer
88 views
SQL JDBC Zerodatetime
I am trying to query SQL data with MATHEMATICA - however, the MySQL database contains zerodates and that leads to the following error message:
e.g. (1) *SQLSelect[conn, "orders", {"time_created"}, ...
1
vote
0answers
72 views
What is SQLQueries?
Does anyone know what SQLQueries does and what arguments should be supplied?
I hoped that it returns names of views in a database, but it apparently does not.
2
votes
0answers
131 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 ...
5
votes
3answers
182 views
Executing Mathematica script from inside SQL Server
Does anyone have experience in calling Mathematica from inside SQL Server to do calculations? For example, how can I make a Procedure that uses Mathematica? Or a job that runs some Mathematica script?
...
10
votes
1answer
215 views
Microsoft SQL DatabaseLink connection using Windows Authentication
For those who use Mathematica with databases in companies, a common way to securely connect to those is using Windows Authentication (detailed here).
Mathematica doesn't seem to support this ...
4
votes
1answer
207 views
How to match two sets of data over 1 or more identifier, of unequal length?
Brief Question about how to best match lists with Criteria from Identifiers (thus for me: translate SQL to Mathematica ;) ).
If I have two sets:
...
7
votes
1answer
200 views
Stealth daylight saving shift in SQL data
I'm querying a SQL database with DatabaseLink and resulting SQLDateTime objects are shifted by an hour during daylight saving ...
