Advertisement
Guest User

Untitled

a guest
Feb 11th, 2016
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.23 KB | None | 0 0
  1. [asterisk-connector]
  2. Description = MS SQL connection to 'asterisk' database
  3. Driver = /usr/lib64/libtdsodbc.so
  4. Setup = /usr/lib64/libtdsS.so
  5. Servername = SQL2
  6. Port = 1433
  7. Username = MyUsername
  8. Password = MyPassword
  9. TDS_Version = 7.0
  10.  
  11. [odbc-test]
  12. Description = TDS connection
  13. Driver = /usr/lib64/libtdsodbc.so
  14. Setup = /usr/lib64/libtdsS.so
  15. UsageCount = 1
  16. FileUsage = 1
  17.  
  18. [asterisk-connector]
  19. enabled => yes
  20. dsn => asterisk-connector
  21. username => MyUsername
  22. password => MyPassword
  23. pooling => no
  24. limit =>
  25. pre-connect => yes
  26.  
  27. [root@TestVM etc]# isql -v asterisk-connector MyUsername MyPassword
  28. +---------------------------------------+
  29. | Connected! |
  30. | |
  31. | sql-statement |
  32. | help [tablename] |
  33. | quit |
  34. | |
  35. +---------------------------------------+
  36. SQL>
  37.  
  38. [root@TestVM etc]# isql -v asterisk-connector
  39. [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
  40. [01000][unixODBC][FreeTDS][SQL Server]Adaptive Server connection failed
  41. [ISQL]ERROR: Could not SQLConnect
  42.  
  43. isql -v asterisk-connector
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement