DatabaseLink is a toolkit for working with SQL databases built into Mathematica.
-1
votes
1answer
76 views
How to insert big list of Data in DB?
I have a list of values with length is 60000.Earlier I used this list in my App by using ...
0
votes
0answers
53 views
How can I connect to a SQLServer database without login details? [closed]
I create a New Database in MS SQLServer 2012, specifically I didn't mention any Login details. I created tables in that DB.
Now I want to connect with Mathematica. For that purpose I wrote the ...
4
votes
1answer
25 views
Correct behavior of lock file in hsqldb connection
I'm running in to some problems with generating a persistent HSQLDB and during some troubleshooting I came upon the following behavior.
...
2
votes
2answers
161 views
How can I import images from a Microsoft SQLServer database?
I have a table with binary data (images) in Microsoft SQlServer. I want to import that data and convert it into Image format. I wrote the following code, but it's ...
2
votes
2answers
173 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
48 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
111 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
...
1
vote
1answer
135 views
How can I connect database(MSSQL Server) with Mathematica?
Newly I started working with database(MSSQL Server 2012).
by google help, I created Table name as EmployeesList and also ...
4
votes
1answer
107 views
How can I write image to MySQL database?
I have a database, such as:
In Mathematica, the final code is:
img1=Export["/home/user/Desktop/1.jpg",resultimg1];
I tried ...
3
votes
1answer
111 views
Handling error in database connection (TimeConstrained)
I have a lot of scripts that use a database connection, and I have realized that my code should be protected against errors in my connection. For example, when my database is out for some technical ...
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.
7
votes
2answers
139 views
DatabaseLink`: MySQL query with client/server compression
I'm trying to reduce transfer time when accessing rows of a mysql table over a network, where each row has a lot of data. Is there a way to enable client-server compression when accessing a mysql ...
1
vote
0answers
146 views
Data wrangling messy data
This is an offshoot from my previous question about dealing with large datasets in Mathematica. I think it might provide more value to more people as a separate question.
I'd like to know how people ...
2
votes
0answers
132 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
1answer
77 views
Can I store a DataDistribution in a database?
I have a DataDistribution
data = KernelMixtureDistribution[RandomVariate[NormalDistribution[], 10^5]]
that takes a long time ...
8
votes
2answers
235 views
10
votes
1answer
219 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 ...
7
votes
1answer
205 views
Complex queries to MS SQL Server
I'm using DatabaseLink to query MS SQL Server with SQLExecute which works totaly fine, for ex.:
...
4
votes
2answers
313 views
Trying to extract information from an MDB file. Import is too slow
I am running a Linux box and as usual the documentation for this type of box is not great.
I am trying to open up and extract and possibly include later on information from a "mdb" file. The file ...
0
votes
1answer
125 views
What format to use to store expressions in database?
I am storing lists of expressions into a MySQL database. Each list is of form
{_String, {_String, _Real}, _Real}
What data format should each column of the ...
10
votes
1answer
204 views
Is there a way to print out SQL queries made using DatabaseLink?
I have a Mathematica batch script which makes some MySQL queries using DatabaseLink to store parameters of the run in a database. Recently, I had a run where these queries failed, and there was no ...
6
votes
1answer
563 views
How can I connect to a database using the 32 Bit ODBC on a Windows 7 (64 Bit) machine?
I am having difficulties using a DSN that was defined in the 32 Bit version of the ODBC-manager? (there are two separate managers for 32/64 Bit on a 64 Bit machine)
Using the DatabaseLink package ...
4
votes
2answers
110 views
What is the quickest way to convert a lot of SQLDateTime[] objects to DateLists
I often run database queries that return sets of {date, datum} objects. A hypothetical query looks like
...
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 ...
4
votes
4answers
381 views
MySQL Connection Problem
I have a problem with the configuration of the J-Connector plug-in with a MySQL database. Most of the time all works well, but sometimes the connection remains blocked for 2 hours and then it gives ...
9
votes
3answers
382 views
How can I speed up SQL queries in Mathematica?
I have an application that queries a MySQL database many times for data. At the moment, Mathematica and MySQL are running on the same box and yet it takes over 1.6 seconds for the query to run and ...
