Call Us Today! 877.742.2583




Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleClick here to expand Table of Contents
Panel
borderColorlightgray
bgColor#f7f7f7
borderWidth1
borderStyledotted

Table of Contents
maxLevel3
outlinetrue
indent1em
stylenone
excludeAbout
printablefalse

...

DSN with username and password

...

 

Code Block
<param name="core-db-dsn" value="database:username:password"/>

</pre>or<pre>

Code Block
<param name="core-db-dsn" value="odbc://database:username:password"/>

...

...

DSN with username

...

Note the colon at the end.<pre>

Code Block
<param name="core-db-dsn" value="database:username:"/>

...

or<pre>

Code Block
<param name="core-db-dsn" value="odbc://database:username"/>

...

...

DSN only

...


Note the two colons at the end.<pre>

Code Block
<param name="core-db-dsn" value="database::"/>

</pre>or<pre>

Code Block
<param name="core-db-dsn" value="odbc://database"/>

...

Info

The following formats NO LONGER WORK (since v1.2.4)

...

Code Block
<param name="core-db-dsn" value="database"/>

...


<param name="core-db-dsn" value="database:password"/>

...

...

DSN-less

...

 

DSN-less connections are also possible. Such connections don't require setting up in odbc.ini.

...

MyODBC example (OPTION=67108864 enables batched statements):<pre>

Code Block
<param name="core-db-dsn" value="odbc://DRIVER=mysql;SERVER=a.b.c.d;UID=username;PWD=secretpassword;DATABASE=freeswitch;OPTION=67108864">

...