Skip to Content.
Sympa Menu

freetds - [freetds] Unable to connect to data source, SQL state S1000 in SQLConnect

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Baris Simsek <bsimsek AT empatiq.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Unable to connect to data source, SQL state S1000 in SQLConnect
  • Date: Mon, 20 Jun 2005 14:02:53 +0300

thanks, i've installed it. i wrote a php code to test it, and i did following configuration (i found them in this ml archive)

lib paths are correct. i am not sure about port and tds version in freetds.conf. Am i in correct way? is there any other way?

thanks,

regards,

conn.php
<?php
$conn = odbc_connect('saster', 'admin', 'opass') or die("connect error!");
?>
Full error message of this code: *Warning*: odbc_connect(): SQL error: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source, SQL state S1000 in SQLConnect in */usr/local/www/data-dist/odbc/conn.php* on line *3*
connect error!

odbc.ini
[ODBC Data Sources]
saster = VXM DB

[saster]
Driver = TDS
Servername = VXM

odbcinst.ini
[FreeTDS]
Description = FreeTDS unixODBC Driver
Driver = /usr/lib/libtdsodbc.so
UsageCount = 1

[TDS]
Description = FreeTDS
Driver = /usr/lib/libtdsodbc.so

freetds.conf
[VXM]
host=192.168.2.41
port=1433
tds version=8.0
client charset = utf-8


ZIGLIO, Frediano, VF-IT wrote:

Hello,

i've installed freetds package on FreeBSD by portage system. There is no problem, i could do it. But i cannot find libdbodbc library. I decided to install it from original source. Do you have any idea about following problem:

# ./configure --prefix=/usr --enable-sybase-compat --with-unixodbc
# make

In file included from odbc.c:55:
../../include/tdsodbc.h:26: sql.h: No such file or directory
../../include/tdsodbc.h:27: sqlext.h: No such file or directory
../../include/tdsodbc.h:28: odbcinst.h: No such file or directory
In file included from odbc.c:60:
odbc_util.h:28: sql.h: No such file or directory
odbc_util.h:29: sqlext.h: No such file or directory
In file included from odbc.c:63:
prepare_query.h:28: sql.h: No such file or directory
prepare_query.h:29: sqlext.h: No such file or directory
*** Error code 1



You have to install unixODBC with development files (like includes) to
compile with unixODBC support.

freddy77
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds








Archive powered by MHonArc 2.6.24.

Top of Page