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?