This is documentation for Mathematica 6, which was
based on an earlier version of the Wolfram Language.
View current documentation (Version 11.1)

WriteDataSource

WriteDataSource[name]
writes a new HSQL data source name.
WriteDataSource[name, database]
writes a new data source to database.
  • To use WriteDataSource, you first need to load DatabaseLink using Needs["DatabaseLink`"].
  • The following options can be given:
"Description"""textual description of the data source
"URL"AutomaticURL to use in the JDBC setting
"Username"Automaticusername for the connection
"Password"Automaticpassword for the connection
"Properties"{}properties to set for this connection
"Location"Userwhere to install the data source
"RelativePath"Automaticwhether file-based databases have a relative path
"UseConnectionPool"Automaticwhether a connection pool should be used
"ReadOnly"Automaticwhether the connection should be read-only
Needs["DatabaseLink`"]
Create a new data source named testSource that will use the HSQL database:
In[2]:=
Click for copyable input
Out[2]=
 
Needs["DatabaseLink`"]
Create a new data source that includes the Username and Password and is available to all users:
In[2]:=
Click for copyable input
Out[2]=