[Freeswitch-users] SQL SERVER 2008 compatibility

[Vincent Xia]

SQL SERVER 2008 compatibility

when im trying to migrate freeswitch core db from sqlite to ms sql server, i
1. create a db in sql server 2008
2. create odbc dsn "freeswitch"
3. modify the conf:<param name="core-db-dsn" value="freeswitch:sa:XXXXXX" />
4. start freeswitch console

then i got plenty of errors like
[ERR] switch_odbc.c:514 ERR: [delete from channels where
hostname='XXXXXXXX']
[STATE: 42S02 CODE 208 ERROR: [Microsoft][ODBC SQL Server Driver][SQL
Server]Invalid object 'channels'.]

i checked the db which i created in step 1 and found freeswitch tables had
been created automatically as calls, channels,
but all with a prefix 'dbo.', i.e. the table names are dbo.calls,
dbo.channels, so how can i make freeswitch operate these tables through
ODBC?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130604/cba64b15/attachment.html