odbc with ms sql server

mierdatuti · 08-26-2009, 02:55 PM

Hi,

I try to connect using odbc to a microsoft sql server but when I try to connect it says me:

Code:

isql -v prueba usser password
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[08S01][unixODBC][FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist
[ISQL]ERROR: Could not SQLConnect
david@david-desktop:/etc$

I have this configuration files:

Code:

/etc/odbc.ini
[prueba]

Description        = Coeenxion para microsoft sql server
Driver          = ms-sql                                
Servername      = ms-sql                                
#Servername      = defekas62                            
UID =           emuser                                  
Port    =               1433   


/etc/freetds/freetds.conf  
....
....
[ms-sql]                    
     # Version 8.0 para SQL Server 2000
     # Version 7.0 para SQL Server 7   
     # Version 6.0 para SQL Server 6   
     host = defekas62                  
     port = 1433                       
     tds version = 7.0



/etc/odbcinst.ini
[ms-sql]
Description             =  Conexiona microsoft sql server
Driver          = /usr/lib/odbc/libtdsodbc.so
Setup           = /usr/lib/odbc/libtdsS.so
UsageCount      = 1
FileUsage       = 1

Could you help me?
Many thanks and sorry for my english!

kbp · 08-27-2009, 09:28 AM

Hi,

Lets just start with the basic tests, can you ping 'defekas62' by name from the david-desktop pc ?
If that succeeds, can you telnet to port 1433 on 'defekas62' from david-desktop ?

thanks,

kbp

mierdatuti · 08-27-2009, 02:50 PM

Quote:

Originally Posted by kbp

Hi,

Lets just start with the basic tests, can you ping 'defekas62' by name from the david-desktop pc ?
If that succeeds, can you telnet to port 1433 on 'defekas62' from david-desktop ?

thanks,

kbp

Many thanks, finally it works! But it's something strange when I try to make a select two times, the second time it gives me an error:

Code:

isql prueba user passwd
+---------------------------------------+                    
| Connected!                            |                    
|                                       |                    
| sql-statement                         |                    
| help [tablename]                      |                    
| quit                                  |                    
|                                       |                    
+---------------------------------------+                    
SQL> select * from JOBACTIONS    
+---------------------------------+------------+------------+
| USERNAME                        | ISGROUP    | ACTIONTYPE |
+---------------------------------+------------+------------+
| AdminGroup                      | 1          | 0          |
| AdminGroup                      | 1          | 1          |
| AdminGroup                      | 1          | 2          |
| AdminGroup                      | 1          | 3          |
............
............

Everithing ok but the second and the third one:

Code:

SQL> select * from JOBACTIONS
+------------+
|            |
+------------+
+------------+
SQLRowCount returns 0
SQL> select * from JOBACTIONS
[ISQL]ERROR: Could not SQLExecute
SQL> select * from JOBACTIONS

Any help?
Many thanks and sorry for my english

cse.navneet · 06-25-2011, 07:26 AM

I am also facing the same problem, please suggest me how you have resolved this problem.

Thanks in advance.