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.

learn more… | top users | synonyms

1
vote
1answer
90 views

Importing SQL view vs table

I am trying to import a SQL view not a table in Mathematica. The command: SQLSelect[conn, "DataByYear"] This will correctly bring in the table. However using the ...
11
votes
0answers
251 views

Benefit of using Dataset to collect SQLSelect output

Considering a DatabaseExample included with Mathematica: ...
4
votes
0answers
102 views

Create SQL Database on a manually specified directory

I am inserting lots of data into the preinstalled SQL Database in MM: con= OpenSQLConnection["demo"] > SQLCreateTable[con, SQLTable["anyname"], SQLcolums] > ... I am running out of disk space on my ...
3
votes
0answers
386 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 ...
2
votes
0answers
99 views

MySQL insert statement over remote server is extremely slow. How can I speed it up?

I need to insert values to a remote MySQL server. However it is extremely slow compared to a local MySQL server. This is my timing for the local MySQL server ...
2
votes
0answers
228 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 ...
1
vote
0answers
43 views

running the mathematica script in SQL Server

Hi i am trying to learn mathematica. I am following instruction in one of the questions asked before and did the following: In SQL Server a stored procedure is created as follows: ...
1
vote
0answers
47 views

Using MemberQ or Contains* in a query fails

Using MemberQ or Contains* in a query fails: ...
1
vote
0answers
39 views

Login failed with Windows account into sql server using mathemcatica

I am trying to make a connection from WOLFRAM- MATHEMATICA to an SQL server database. When I tried with my windows authentication, I am getting an error saying login failed for user, but when I tried ...