Re: [Freeswitch-users] Core.db MSSQL

I went back to ODBC Administrator.

Added a new ODBC Driver 11 for SQL Server 32 bit

Named it sqldb

Changed the default database to a blank database called freeswitch no password needed.

Tested good.

Now I changed the config to the below.

Restarted freeswitch.

Looked in my sqldb and no tables found in the freeswitch db.

Do I have to load anything in the modules?

From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Ken Rice
Sent: Friday, March 29, 2013 10:34 AM
To: FreeSWITCH Users Help
Subject: Re: [Freeswitch-users] Core.db MSSQL

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

Shouldn’t that be odbc://DSN_NAME::

On 3/29/13 8:15 AM, "Andre" <andretodd@verizon.net> wrote:

I’m trying to figure out how to get the Core.db into a Microsoft SQL Server.

In Switch.config.xml have

<param name="auto-create-schemas" value="true"/>
<param name="auto-clear-sql" value="true"/>
<param name="core-dbtype" value="MSSQL"/>
<param name="core-db-dsn" value="dsn:sqldb::" />

I have a DNS setup called sqldb using ODBC DRIVER 11 FOR SQL SERVER.

I don’t see anything happening and I don’t see a database structure being built.
What did I do wrong?
Thanks
Andre
_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

--
Ken
http://www.FreeSWITCH.org
http://www.ClueCon.com
http://www.OSTAG.org
irc.freenode.net #freeswitch