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?
You can try setting the default schema on the user: ALTER USER FreeSwitch WITH DEFAULT_SCHEMA = dbo; -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/SQL-SERVER-2008-compatibility-... Sent from the freeswitch-users mailing list archive at Nabble.com.
participants (2)
-
Dan Barua
-
Vincent Xia