Group Abstract Group Abstract

Message Boards Message Boards

0
|
4.8K Views
|
4 Replies
|
0 Total Likes
View groups...
Share
Share this post:

How do I connect to and access a SQL Database in Mathematica

POSTED BY: Henrick Jeanty
4 Replies
Sort By:
Rohit Namjoshi
Rohit Namjoshi
Posted 2 years ago

Can you share the C# code that successfully connects to the DB?
POSTED BY: Rohit Namjoshi
POSTED BY: Henrick Jeanty
Rohit Namjoshi
Rohit Namjoshi
Posted 2 years ago

Try

conn = OpenSQLConnection[
  JDBC["Microsoft SQL Server(microsoft)", "(LcalDB)\\MSSQLLocalDB"],
  "Catalog" -> "StockDataDB", "instance" -> "LOCALDB#B5C431B2"]

Are you sure this is correct

Server: (LcalDB)\MSSQLLocalDB

Is it LocalDB and not LcalDB?
POSTED BY: Rohit Namjoshi
POSTED BY: Henrick Jeanty
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Tag limit exceeded
Note: Only the first five people you tag will receive an email notification; the other tagged names will appear as links to their profiles.
Reply Preview
Attachments
Remove
or Discard