Re: Problems with isql
Igor <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Igor, (is like talking to a mirror) Yes.. I'm sure! And this server is allowed to connect without problems... tsql is working fine: [root@bsd ~]# tsql -H 192.168.1.21 -p 1401 -U $DBUSER -P $DBPASS locale is "C" locale charset is "US-ASCII" 1> SELECT count(*) FROM tbLekkus_Produto 2> go 5864 (1 row affected) Thanks Igor On Fri, May 9, 2008 at 3:05 PM, Igor Korot <[email protected]> wrote: > Igor, > > -----Original Message----- >>From: Igor <[email protected]> >>Sent: May 9, 2008 10:27 AM >>To: Igor Korot <[email protected]>, FreeTDS Development Group <[email protected]> >>Subject: Re: [freetds] Problems with isql >> >>Hi Igor :) >> >>This server is my firewall... but this isn't the problem.. >> >>I've installed bind to get /bin/host to work fine.. and now FreeTDS is >>trying to connect to correct server: >> >>[root@bsd ~]# osql -S LekkusLOJA -U $DBUSER -P $DBPASS >>looking for odbc.ini and odbcinst.ini in /usr/local/etc >> reading "/root/.odbc.ini" >>[LekkusLOJA] not found in "/root/.odbc.ini" >> reading "/usr/local/etc/odbc.ini" >>[LekkusLOJA] found in "/usr/local/etc/odbc.ini" >>found this section: >> [LekkusLOJA] >> Description = Lekkus LOJA >> Driver = FreeTDS >> Trace = No >> Server = bzbraziline >> Port = 1401 > ^^^^^ > > Are you sure that the server is listening on this port? > >> TDS_version = 8.0 >> Database = Lekkus >> >>looking for driver for DSN [LekkusLOJA] >>driver "FreeTDS" found for [LekkusLOJA] in odbc.ini >>found driver named "FreeTDS" >>FreeTDS is not a readable file >>looking for entry named [FreeTDS] in /usr/local/etc/odbcinst.ini >>driver "/usr/local/lib/libtdsodbc.so" found for [FreeTDS] in odbcinst.ini >>/usr/local/lib/libtdsodbc.so is a readable file >>"Server" found, not using freetds.conf >>FreeTDS servername is "bzbraziline" >>bzbraziline has address 192.168.1.21 >> >> DSN: LekkusLOJA >> Server's hostname: bzbraziline >> Address: 192.168.1.21 >> Driver: /usr/local/lib/libtdsodbc.so >> >>Attempting connection as lekkus... >>[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source >>[ISQL]ERROR: Could not SQLConnect >>[root@bsd ~]# >>[root@bsd ~]# telnet 192.168.1.21 1401 >>Trying 192.168.1.21... >>Connected to 192.168.1.21. >>Escape character is '^]'. >> >>The connection are allowed... DNS is working fine.. but still having >>problems to connect :-( >> >>Thanks > > Also, what about firewall on the client side? > > Thank you. > >> >>Igor >> >>On Fri, May 9, 2008 at 2:06 PM, Igor Korot <[email protected]> wrote: >>> Igor, >>> Do you run any kind of firewall? Either on client or server? >>> Can you telnet to the machine? >>> >>> Thank you. >>> >>> -----Original Message----- >>>>From: Igor <[email protected]> >>>>Sent: May 9, 2008 9:51 AM >>>>To: FreeTDS Development Group <[email protected]> >>>>Subject: Re: [freetds] Problems with isql >>>> >>>>Hi James, thanks for reply :) >>>> >>>>I guess now is easy to found error... >>>> >>>>I've installed 0.82 but I got the same error... looking with osql (a >>>>great tool, thanks) I can found the error but I don't know how to >>>>solve this... >>>> >>>>I guess the osql make a system call to /bin/host but on freebsd the >>>>returns is different from linux, take a look on error: >>>> >>>>[root@bsd ~]# osql -S LekkusLOJA -U $DBUSER -P $DBPASS >>>>looking for odbc.ini and odbcinst.ini in /usr/local/etc >>>> reading "/root/.odbc.ini" >>>>[LekkusLOJA] not found in "/root/.odbc.ini" >>>> reading "/usr/local/etc/odbc.ini" >>>>[LekkusLOJA] found in "/usr/local/etc/odbc.ini" >>>>found this section: >>>> [LekkusLOJA] >>>> Description = Lekkus LOJA >>>> Driver = FreeTDS >>>> Trace = No >>>> Server = 192.168.1.21 >>>> Port = 1401 >>>> TDS_version = 8.0 >>>> Database = Lekkus >>>> >>>>looking for driver for DSN [LekkusLOJA] >>>>driver "FreeTDS" found for [LekkusLOJA] in odbc.ini >>>>found driver named "FreeTDS" >>>>FreeTDS is not a readable file >>>>looking for entry named [FreeTDS] in /usr/local/etc/odbcinst.ini >>>>driver "/usr/local/lib/libtdsodbc.so" found for [FreeTDS] in odbcinst.ini >>>>/usr/local/lib/libtdsodbc.so is a readable file >>>>"Server" found, not using freetds.conf >>>>FreeTDS servername is "192.168.1.21" >>>>192.168.1.21 has address Name: erp.braziline.com.br Address: >>>>192.168.1.21 Aliases: erp >>>> >>>> DSN: LekkusLOJA >>>> Server's hostname: 192.168.1.21 >>>> Address: Name: >>>> erp.braziline.com.br: Address: >>>> 192.168.1.21: Aliases: >>>> erp: >>>> Driver: /usr/local/lib/libtdsodbc.so >>>> >>>>Attempting connection as lekkus... >>>>[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source >>>>[ISQL]ERROR: Could not SQLConnect >>>> >>>>Can you have any sugestion ? >>>> >>>>Thanks >>>> >>>>Igor >>>> >>>>On Fri, May 9, 2008 at 10:56 AM, James K. Lowden <[email protected]> wrote: >>>>> Igor wrote: >>>>>> >>>>>> I've installed: >>>>>> - unixODBC-2.2.12 >>>>>> - freetds-0.65.dev.20061107 >>>>>> (I've installed this versions because I get this working fine) >>>>>> >>>>>> The error: >>>>>> >>>>>> [root@bsd /usr/local/etc]# isql -v LekkusLOJA $DBUSER $DBPASS >>>>>> [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source >>>>>> [ISQL]ERROR: Could not SQLConnect >>>>> >>>>> Suggestions: >>>>> >>>>> 1. Use 0.82. It's what's for breakfast. >>>>> 2. Try src/apps/osql to troubleshoot your ODBC setup. >>>>> 3. TDSDUMP and TDSDUMPCONFIG will show how isql is trying to connect. >>>>> >>>>> HTH. >>>>> >>>>> --jkl >>>>> >>>>> _______________________________________________ >>>>> FreeTDS mailing list >>>>> [email protected] >>>>> http://lists.ibiblio.org/mailman/listinfo/freetds >>>>> >>>>_______________________________________________ >>>>FreeTDS mailing list >>>>[email protected] >>>>http://lists.ibiblio.org/mailman/listinfo/freetds >>> >>> _______________________________________________ >>> FreeTDS mailing list >>> [email protected] >>> http://lists.ibiblio.org/mailman/listinfo/freetds >>> > > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds >