Skip to main content

Questions tagged [databaselink]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
47 views

How to specify NULL when inserting data into SQL Server using SQLExecute

I have an Microsoft SQL Server connection using: ...
user13892's user avatar
  • 9,443
0 votes
1 answer
57 views

Connection of MariaDB 11.2 to work with Mathematica 13.3.1

I would like to get the proper driver settings in place to permit the mariaDB database to connect to Mathematica via a JDBC driver running on a Windows11 64-bit machine. I've got mariaDB version 11.2 ...
Stuart Poss's user avatar
  • 1,883
2 votes
1 answer
162 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 (...
Mark_in_DK's user avatar
3 votes
0 answers
64 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: ...
user13892's user avatar
  • 9,443
1 vote
1 answer
295 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. ...
wmv's user avatar
  • 379
3 votes
0 answers
75 views

Where is the ODBC driver in DatabaseLink for Microsoft Access?

I have an access database file which 925MB. When trying to establish connection with it using: ...
user13892's user avatar
  • 9,443
1 vote
0 answers
151 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: ...
user13892's user avatar
  • 9,443
1 vote
1 answer
76 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 ...
nilo de roock's user avatar
2 votes
1 answer
144 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[] ...
HJensen's user avatar
  • 537
4 votes
1 answer
160 views

Can't connect to MS SQL using Active Directory Integrated Services via DatabaseLink

We have a data lake in here that uses MS SQL Server 12.02 and connects using the active directory integrated services authentication. The standard driver would not work ...
Zviovich's user avatar
  • 9,308
3 votes
1 answer
95 views

Retrieve the Date/Time difference in a MongoCollection

Each of my MongoDB documents contain two date-string timestamps: namely a LogOndt and LogOffdt timestamp. For example: ...
Romke Bontekoe's user avatar
1 vote
2 answers
158 views

How to access an English-Chinese dictionary database file correctly?

Now I have an English-Chinese dictionary database file (This database source file comes from this website and this file can be downloaded by clicking "点此下载". After downloading, you can ...
A little mouse on the pampas's user avatar
3 votes
0 answers
132 views

error database connection MMA 12.2

I work with MMA 12.0. When I want to make a connection with met Oracle Database, I do: ...
Michiel van Mens's user avatar
0 votes
0 answers
101 views

Mathematica fails to load welcome screen: "Authentication Required"

Problem When I open Mathematica 12.1.0 on windows 10, I get an "Authentication Required" window during the splash screen. The auth window has no input or buttons, and the text in the window ...
Kevin W's user avatar
  • 31
7 votes
1 answer
216 views

How to map MS SQL Server onto the Entity Framework?

I created a reference using the following: ...
user13892's user avatar
  • 9,443
22 votes
1 answer
819 views

What are the benefits of Entity Classes for Databases?

To me, using the older database functionality is much simpler: ...
M.R.'s user avatar
  • 31.5k
8 votes
1 answer
272 views

How to do a database query on substrings?

With the package DatabaseLink I can open a connection to my MYSQL database. Then I can use SQL commands like ...
Fred Simons's user avatar
  • 10.2k
1 vote
2 answers
74 views

Insert a DateObject into MySQL database?

I want to use Mathematica to do some SQL tasks like insert. However, I have difficulty in inserting date into SQL. Here is an example. ...
407PZ's user avatar
  • 1,461
12 votes
2 answers
1k views

How to extract Bitmap image from SQL records?

I'm trying to extract image from records of the MSSQL demo database NorthWind with this codes, ...
Jerry's user avatar
  • 2,459
5 votes
1 answer
151 views

Local Storage of Periodically Collected Data (without using DataDrop)

I would like to take periodic measurements (e.g. noise levels and temperature in my office from a Raspberry Pi, etc.), say, every minute and have a long-reaching record of this similar to Stephen's ...
Ghersic's user avatar
  • 1,157
5 votes
1 answer
151 views

Retrieve column data from MongoCollection

I am connecting to a mongo database from Mathematica. I can get a MongoCollection object, but can not get a column of data from it. ...
user1470393's user avatar
1 vote
0 answers
78 views

Probable Bug in SQLColumn condition < upper limit for SQLSelect

I have a perfectly good SQLSelect query that doesn't work if and only if it contains an extra < condition on a column already used. Details follow... This SQLselect shows that the expected data ...
Julian Moore's user avatar
  • 2,560
0 votes
0 answers
41 views

SQLConnection causes kernel hangs

This question is additional question to Maintaining SQLConnections In Mathematica 10.4.1.0 (64bit). ...
Dragutin's user avatar
  • 920
3 votes
1 answer
331 views

Maintaining SQLConnections

I'm using SQLConnection to database in repetitive ScheduledTask. To prevent creation of new connections, and to maintain binding ...
Dragutin's user avatar
  • 920
0 votes
0 answers
110 views

SQL export data

I have data imported from excel file into mathematica but mathematica automatically converts large number into scientific form and when transferring this data to sql string field i get the following .....
user13892's user avatar
  • 9,443
0 votes
0 answers
51 views

How to set primary key in SQLCreateTable to be auto_increment

I'm trying to create a table using SQLCreateTable. What I need is auto incremented primary key. My table will be growing in time and I don't want to check previous value of primary key every time I ...
Izabela Kowalska's user avatar
4 votes
1 answer
95 views

Context of SQLBinary in Package

I have the following code for a simple key value store for binary data: ...
Albert Retey's user avatar
  • 23.6k
4 votes
0 answers
102 views

Mathematica not releasing RAM

The following code is supposed to sequentially read data from a large CSV file and put it row by row into an SQL server. Although I thought RAM consumption should be constant the system keeps asking ...
user13892's user avatar
  • 9,443
3 votes
1 answer
81 views

How to select a SQLConnection from SQLConnections[] by its "Name" property?

When creating a SQLConnection you can give it a name with the "Name" option. The connections are also added to the output of the ...
Edmund's user avatar
  • 42.3k
8 votes
1 answer
172 views

Why has this SQLInsert behaviour changed?

Using Mathematica 11.1 to insert into a MySQL table with this schema... ...
Chris Degnen's user avatar
3 votes
2 answers
638 views

I have a bigdata CSV file as a single table of five columns and almost 10 million rows

I need to examine the bigdata file with a database/DBMS and have used MS Office 365/Access successfully so to do, import and query. I have also tried, many times, to open a MMA 10.4 database link ...
Lew R's user avatar
  • 31
2 votes
1 answer
202 views

Connection to SQL server - Failed

I have a test database created by the colleagues from IT department and I can also access / see it using MS SQL Server Management Studio 2016. However, I cannot establish a connection to it from ...
Conrad's user avatar
  • 723
19 votes
1 answer
503 views

DatabaseLink and Libreoffice odb

Preface In scientific projects, I often deal with large Excel files from partners as this is unfortunately still the way to store data. Always, one of my first steps after importing the data is to ...
halirutan's user avatar
  • 113k
2 votes
0 answers
106 views

SQL Group By using SQLSelect

I would like to use the SQLSelect[] function in Mathematica 11 to get aggregated data from a large database. Is using SQLExecute ...
finetuned's user avatar
1 vote
0 answers
45 views

Integer data type mapping problem with SQLInsert in DatabaseLink package

I am working with a following SQL table named "ticket". Now let's see the data types for the columns. ...
PlatoManiac's user avatar
  • 14.8k
4 votes
0 answers
586 views

How to OpenSQLConnection with JDBC for "Microsoft Excel"?

I have a very large Microsoft Excel file that will not Import even after setting a 5GB heap size for Java as follows. ...
Edmund's user avatar
  • 42.3k
3 votes
0 answers
55 views

Error in DatabaseLink when trying to select from multiple tables

I've noticed a rather inconvenient (assumed) bug when selecting data joined across multiple SQL tables. Example: ...
kale's user avatar
  • 10.9k
11 votes
3 answers
2k views

JDBC-to-ODBC bridge gone. How to connect to SQL Server now in case of Windows Authentication?

Connecting to our corporate SQL servers using JDBC never worked for me, perhaps related to the Windows Authentication method that is necessary in our network. However, I found out that configuring the ...
Sjoerd C. de Vries's user avatar
0 votes
0 answers
88 views

How to pass a table type parameter to SQLExecute?

In MS SQL Server 2016 I have a table type parameter: CREATE TYPE dbo.Ids AS TABLE (Id INTEGER NOT NULL); and a stored procedure: ...
Edmund's user avatar
  • 42.3k
8 votes
2 answers
848 views

How to speed up interpreting numbers from strings?

In processing a large text file I have batches from ReadList of 100,000 Records of the form. ...
Edmund's user avatar
  • 42.3k
1 vote
0 answers
92 views

Using MemberQ or Contains* in a query fails

Using MemberQ or Contains* in a query fails: ...
M.R.'s user avatar
  • 31.5k
4 votes
1 answer
315 views

How do I insert Unicode into a MySQL database?

I'm having trouble transferring Unicode strings from one MySQL database to another using DatabaseLink` functions. Here is my failed attempt to read a string from ...
Ben's user avatar
  • 141
2 votes
0 answers
258 views

Random sample from sql database uniformly over time [closed]

I'd like to sample rows from a table uniformly over time, here is the naive way to do this: SELECT * FROM table ORDER BY RAND() LIMIT 10000 Unfortunately, ...
M.R.'s user avatar
  • 31.5k
3 votes
1 answer
271 views

Cloud Form Function Database

I am trying to build a web inventory application using a SQLite database hosted in the cloud home directory. I have a database in the home directory and I can query that database while in the code ...
Ray Troy's user avatar
4 votes
0 answers
77 views

Mathematica 10.3 on Windows 10 Home Premium Connection to SQL Server 2016 [duplicate]

Having installed sql server 2016 evaluation copy. I have setup a sample database using sql server management studio. Typed the following in mathematica ...
user13892's user avatar
  • 9,443
1 vote
0 answers
140 views

Using Mathematica to connect to Cloudera Impala

I am trying to connect to Cloudera Impala via Mathematica, but so far I have not been able to do so. Has anyone ever done it? I have been able to connect to it via R using the JDBC or ODBC interface ...
bernddude's user avatar
  • 161
4 votes
1 answer
223 views

Connection to SQL server databases from Mathematica

I am an SQL developer and very new to Mathematica. As per my requirement I need to make a connection from Mathematica to my sql server database, after which my client will do some analysis with the ...
Siva's user avatar
  • 41
5 votes
1 answer
291 views

SQLInsert'ing Null into a table (not SQLite)

Is it possible to insert Null values using DatabaseLink, without formatting the query string manually? Hans found (below) that this works for SQLite, so it appears ...
mfvonh's user avatar
  • 8,460
1 vote
1 answer
380 views

Package functions not loaded after successful `Get` (`<<`) [closed]

I have the following package: ...
Edmund's user avatar
  • 42.3k
1 vote
0 answers
241 views

Awkward DatabaseLink JDBC Error [closed]

I've created a GUI application (a database editor) that uses DatabaseLink and it is currently working fine on my PC (M10.02, Windows 7) and on a clients's PC (CDF Player Pro 10.02, Windiws 8). While ...
Ariel Sepulveda's user avatar