Questions tagged [sql]
Tag for all questions about getting a connection to, setting up, or accessing a SQL database using Mathematica, particularly (but not restricted to) using Mathematica's DatabaseLink package.
108 questions
4
votes
0
answers
287
views
How to connect Tabular to SQL Server?
I have a Microsoft SQL Server database running and I am able to connect to it using:
...
- 10.4k
0
votes
0
answers
250
views
How to specify NULL when inserting data into SQL Server using SQLExecute
I have an Microsoft SQL Server connection using:
...
- 10.4k
3
votes
1
answer
405
views
How can I use older JDBC driver(s) to connect with old mySQL databases?
I got a new Mac at work, fresh install of Mathematica v13.3 (old 2015 Mac is dying and has v11.3).
Problem: In v13.3 I cannot connect to older mySQL databases, using v13's JDBC driver (...
- 31
4
votes
0
answers
130
views
Entity Framework for Relational Databases is compiling `If` and `Which` statement incorrectly
Suppose I have an SQLite Database with a table name myTable. Then running the following query:
...
- 10.4k
3
votes
1
answer
706
views
Java error NoSuchFieldException: usr_paths with OpenSQLConnection after installing 13.2
I performed a fresh install of Mathematica 13.2. The first code that I tried worked just fine under 13.0. It opens an SQL server connection using single sign-on (SSO) for my credentials. However, in ...
- 66.4k
1
vote
1
answer
635
views
JDBC::error when connecting to MySQL database
I'm trying to connect to a MySQL database. I've seen quite a few different methods (some of which are conflicting and seem to be outdated) of connecting but haven't managed to get any to work so far.
...
- 379
1
vote
0
answers
190
views
How to specify table names in DatabaseLink for access database that have spaces in the names?
I am able to establish the connection with the access database as follows:
...
- 10.4k
6
votes
0
answers
184
views
Who broke the JDBC?
For the last 10 years or so, I have been accessing the tables of a PostgreSQL database successfully. Suddenly, having upgraded to Version 13.0, I get error messages in the simplest of queries, such as ...
user79916
3
votes
1
answer
115
views
Are Experimental Functions like DatabaseReference not available on Mathematica for Raspberry Pi?
I tried calling DatabaseReference and RelationalDatabase on version 12.3.1.0 for the Raspberry Pi, and found that the functions were not defined. I see in the documentation that they are Experimental ...
- 451
1
vote
1
answer
133
views
Querying ( e.g. ) Google Trends Data with Mathematica front-end
Mathematica has some excellent data query and analysis methods, but can also perform as a front-end to an SQL database.
Having worked as an SQL DBA in the past I would like to investigate further what ...
- 9,737
0
votes
0
answers
123
views
Failure connecting local MySQL server
I have locally installed and run the latest version of Oracle MySQL Community Server 8.0 on port 3306. I successfully established connections to it from locally installed Oracle MySQL Workbench 8.0 ...
- 62.5k
2
votes
1
answer
231
views
OpenSQLConnection fails - due to some Java problem?
After upgrading to 12.3, I can no longer connect to an MS SQL Server using OpenSQLConnection. Apparently due to some problem with Java(?). I tried to reinstall JRE 8, but no change.
DatabaseExplorer[] ...
- 557
0
votes
0
answers
174
views
Wolfram Mathematica 11 and MS SQLServer 2019
I'm trying to connect with Wolfram Mathematica 11 to Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)(Build 19042: ).
I'm unable to do it, and I don't find the documentation for that task.
I tried ...
4
votes
2
answers
320
views
Problems with OpenSQLConnection on Mathematica 12.2 (Linux)
I used Mathematica to access the data of a MariaDB MySQL database. Within the version 12.0 it worked well on linux using the following code:
...
- 897
9
votes
1
answer
340
views
Generating Google BigQuery API Access Token in Wolfram Language
I'm working on a Wolfram Language Package to connect into Google Bigquery (that I'll make public available). In order to finish It, I need to solve a last step, that is how to get an authentication ...
- 26.5k