Questions tagged [databaselink]
DatabaseLink is a toolkit for working with SQL databases built into Mathematica.
102
questions
1
vote
1
answer
66
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 (...
- 11
3
votes
0
answers
62
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:
...
- 9,113
1
vote
1
answer
192
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.
...
- 359
3
votes
0
answers
70
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:
...
- 9,113
1
vote
0
answers
128
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:
...
- 9,113
0
votes
1
answer
66
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,637
2
votes
1
answer
139
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[] ...
- 517
4
votes
1
answer
154
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
...
- 9,288
3
votes
1
answer
92
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:
...
- 1,883
1
vote
2
answers
136
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 ...
3
votes
0
answers
129
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:
...
- 2,615
0
votes
0
answers
88
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 ...
- 31
7
votes
1
answer
211
views
How to map MS SQL Server onto the Entity Framework?
I created a reference using the following:
...
- 9,113
22
votes
1
answer
807
views
What are the benefits of Entity Classes for Databases?
To me, using the older database functionality is much simpler:
...
- 31.2k
8
votes
1
answer
268
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
...
- 10.1k
1
vote
2
answers
73
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.
...
- 1,441
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,
...
- 2,409
5
votes
1
answer
149
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 ...
- 1,137
5
votes
1
answer
149
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.
...
- 279
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 ...
- 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).
...
- 910
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 ...
- 910
0
votes
0
answers
109
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 .....
- 9,113
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 ...
4
votes
1
answer
94
views
Context of SQLBinary in Package
I have the following code for a simple key value store for binary data:
...
- 23.5k
4
votes
0
answers
100
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 ...
- 9,113
3
votes
1
answer
75
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 ...
- 41.7k
8
votes
1
answer
170
views
Why has this SQLInsert behaviour changed?
Using Mathematica 11.1 to insert into a MySQL table with this schema...
...
- 30.7k
3
votes
2
answers
635
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 ...
- 31
2
votes
1
answer
196
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 ...
- 713
19
votes
1
answer
496
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 ...
- 112k
2
votes
0
answers
105
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 ...
- 21
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.
...
- 14.6k
4
votes
0
answers
574
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.
...
- 41.7k
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:
...
- 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 ...
- 65.6k
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:
...
- 41.7k
8
votes
2
answers
830
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.
...
- 41.7k
1
vote
0
answers
91
views
4
votes
1
answer
311
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 ...
- 141
2
votes
0
answers
240
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, ...
- 31.2k
3
votes
1
answer
270
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 ...
- 33
4
votes
0
answers
76
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
...
- 9,113
1
vote
0
answers
138
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 ...
- 161
4
votes
1
answer
217
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 ...
- 41
5
votes
1
answer
281
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 ...
- 8,442
1
vote
1
answer
375
views
Package functions not loaded after successful `Get` (`<<`) [closed]
I have the following package:
...
- 41.7k
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 ...
- 1,657
1
vote
1
answer
96
views
How to specify the number of precision digits for columns using DatabaseLink functions and options
Some databases (e.g. MySQL) does not store decimal places for seconds unless the number of digits needed is directly specified (e.g. DATETIME(4) for 4 digits) when creating the table in the database. ...
- 1,657
0
votes
0
answers
134
views
Mathematica SQL command that counts records in table
Is there a DatabaseLink command other than SQLExecute that can be used to count the total records in a database table?
- 1,657