Questions tagged [jdbc]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
2answers
34 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. ...
0
votes
1answer
122 views

QODBC (Quickbooks), ODBC Mathematica connection string [duplicate]

I am trying to connect to QuickBooks using QODBC driver. I am able to successfully connect when I use RazorSQL but can not figure out the correct statements in Mathematica (11.2) nor can Icconnect ...
3
votes
1answer
3k views

JDBC with “autoReconnect=True”

I sometimes leave long computations running overnight and return in the morning to find that my database connection has timed out. I typically have to kill the kernel and launch a new database ...
3
votes
1answer
3k views

How to access AWS Redshift

Hello i am trying to access AWS redshift server. I have the driver installed JDBC[ "com.amazon.redshift.jdbc41.Driver",... ] However it seems that i can't ...
0
votes
2answers
58 views

SQLInsert SQLExpr not working in V11

This worked fine in Mathematica 7. Any ideas how to fix it for version 11? ...
4
votes
0answers
284 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. ...
11
votes
3answers
1k 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 ...