Advertisement
Guest User

MariaDB CONNECT engine test

a guest
Jan 26th, 2015
212
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 1.59 KB | None | 0 0
  1. [gmontee@localhost ~]$ cat /etc/odbc.ini
  2.  
  3. [connect_test]
  4. Driver          = /usr/lib64/libtdsodbc.so.0
  5. Description     = MSSQL Server
  6. Trace           = No
  7. Server          = 192.168.1.12
  8. Database        = connect_test
  9. Port            = 1433
  10. TDS_Version     = 7.1
  11.  
  12. [gmontee@localhost ~]$ isql connect_test sa password
  13. +---------------------------------------+
  14. | Connected!                            |
  15. |                                       |
  16. | sql-statement                         |
  17. | help [tablename]                      |
  18. | quit                                  |
  19. |                                       |
  20. +---------------------------------------+
  21. SQL> select * from dbo.Table_1;
  22. +------------+-----------+---------------------+
  23. | a          | b         | c                   |
  24. +------------+-----------+---------------------+
  25. +------------+-----------+---------------------+
  26. SQLRowCount returns 0
  27. SQL> quit
  28. [gmontee@localhost ~]$ mysql -u root tmp
  29. Reading table information for completion of table and column names
  30. You can turn off this feature to get a quicker startup with -A
  31.  
  32. Welcome to the MariaDB monitor.  Commands end with ; or \g.
  33. Your MariaDB connection id is 7
  34. Server version: 10.0.15-MariaDB MariaDB Server
  35.  
  36. Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.
  37.  
  38. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  39.  
  40. MariaDB [tmp]> CREATE TABLE Table_1 engine=connect table_type=ODBC tabname='dbo.Table_1' connection='DSN=connect_test;UID=sa;PWD=password';
  41. ERROR 1105 (HY000): [unixODBC][FreeTDS][SQL Server]Unable to connect to data source
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement