freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
[freetds] Unable to connect to data source, SQL state S1000 in SQLConnect
- 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
-
[freetds] tdsodbc.h:26: sql.h: No such file or directory,
Baris Simsek, 06/20/2005
- <Possible follow-up(s)>
-
RE: [freetds] tdsodbc.h:26: sql.h: No such file or directory,
ZIGLIO, Frediano, VF-IT, 06/20/2005
-
[freetds] Unable to connect to data source, SQL state S1000 in SQLConnect,
Baris Simsek, 06/20/2005
- Re: [freetds] Unable to connect to data source, SQL state S1000 in SQLConnect, James K. Lowden, 06/20/2005
-
[freetds] Unable to connect to data source, SQL state S1000 in SQLConnect,
Baris Simsek, 06/20/2005
Archive powered by MHonArc 2.6.24.