Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [gmontee@localhost ~]$ cat /etc/odbc.ini
- [connect_test]
- Driver = /usr/lib64/libtdsodbc.so.0
- Description = MSSQL Server
- Trace = No
- Server = 192.168.1.12
- Database = connect_test
- Port = 1433
- TDS_Version = 7.1
- [gmontee@localhost ~]$ isql connect_test sa password
- +---------------------------------------+
- | Connected! |
- | |
- | sql-statement |
- | help [tablename] |
- | quit |
- | |
- +---------------------------------------+
- SQL> select * from dbo.Table_1;
- +------------+-----------+---------------------+
- | a | b | c |
- +------------+-----------+---------------------+
- +------------+-----------+---------------------+
- SQLRowCount returns 0
- SQL> quit
- [gmontee@localhost ~]$ mysql -u root tmp
- Reading table information for completion of table and column names
- You can turn off this feature to get a quicker startup with -A
- Welcome to the MariaDB monitor. Commands end with ; or \g.
- Your MariaDB connection id is 7
- Server version: 10.0.15-MariaDB MariaDB Server
- Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- MariaDB [tmp]> CREATE TABLE Table_1 engine=connect table_type=ODBC tabname='dbo.Table_1' connection='DSN=connect_test;UID=sa;PWD=password';
- ERROR 1105 (HY000): [unixODBC][FreeTDS][SQL Server]Unable to connect to data source
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement