<div dir="ltr"><div>SQL SERVER 2008 compatibility<br></div><div><br></div><div>when im trying to migrate freeswitch core db from sqlite to ms sql server, i</div><div>1. create a db in sql server 2008</div><div>2. create odbc dsn "freeswitch"</div>
<div>3. modify the conf:<param name="core-db-dsn" value="freeswitch:sa:XXXXXX" /></div><div>4. start freeswitch console</div><div><br></div><div>then i got plenty of errors like</div><div>[ERR] switch_odbc.c:514 ERR: [delete from channels where hostname='XXXXXXXX']</div>
<div>[STATE: 42S02 CODE 208 ERROR: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object 'channels'.]</div><div><br></div><div>i checked the db which i created in step 1 and found freeswitch tables had been created automatically as calls, channels,</div>
<div>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?</div></div>