Skip to Content.
Sympa Menu

freetds - Re: [freetds] Please Help...Log files Included-Connection kickedoff ofMSSQL db

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "blackwater dev" <blackwaterdev AT gmail.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Please Help...Log files Included-Connection kickedoff ofMSSQL db
  • Date: Tue, 11 Apr 2006 14:00:23 -0400

Ok, I set the config dump and saw where it was getting the config. I then
set up a section in the config:

[mystuff]
host = xxx.xx.xxx.xx
port = 1433
tds version = 8.0

and in the php mssql_connect function pass in
("mystuff",$username,$password);

The problem is, if I use version 8.0, I get this for just about every column
if not every column:

Warning: mssql_query(): WARNING! Some character(s) could not be converted
into client's character set. Unconverted bytes were changed to question
marks ('?'). (severity 16) in
/usr/local/apache2/htdocs/nh/includes/lib/ms_db.class.php on line 182
PHP Warning: mssql_query(): WARNING! Some character(s) could not be
converted into client's character set. Unconverted bytes were changed to
question marks ('?'). (severity 16) in
/usr/local/apache2/htdocs/nh/includes/lib/ms_db.class.php on line 182

I tried to set client charset=UTF-8 but that didn't work. How do I know
what to use for the char set?

Thanks!


On 4/11/06, blackwater dev <blackwaterdev AT gmail.com> wrote:
>
> James,
>
> I am actually running this not through apache but from the command line
> via php import.php.
>
> I have a conf file in my home and the roots home and also put on in
> /usr/local/etc. Ok, dumb question, my head has just been in a fog but by
> setting TDSDUMPCONFIG that will force where the conf file is looked up? The
> var isn't set as I can't echo it.
>
> Thanks again!
>
>
> On 4/11/06, Lowden, James K <james.k.lowden AT alliancebernstein.com> wrote:
> >
> > From: blackwater dev
> >
> > > I did have the conf file in my home directory but it wasn't being
> > picked up
> >
> > That is simply not possible. I'm absolutely sure your unmodified code
> > looks in the user's home directory for a file called '.freetds.conf'.
> >
> > If you're running this under PHP i.e. on a webserver, it is likely the
> > webserver runs under a different account than yours, and thus has a
> > different home directory.
> >
> > Please use TDSDUMPCONFIG to confirm, and at least get yourself to the
> > point where you're using TDS version 7.0 . There's no point trying to
> > debug the executable if it's not using your configuration file and not
> > using the right protocol version. Remember that TDSDUMPCONFIG, as an
> > environment variable, must be set before launching the executable that
> > uses FreeTDS. I suggest you add it to the .profile file in the home
> > directory of the webserver account.
> >
> > HTH.
> >
> > --jkl
> >
> >
> >
> > -----------------------------------------
> > The information contained in this transmission may be privileged and
> > confidential and is intended only for the use of the person(s) named
> > above. If you are not the intended recipient, or an employee or agent
> > responsible
> > for delivering this message to the intended recipient, any review,
> > dissemination,
> > distribution or duplication of this communication is strictly
> > prohibited. If you are
> > not the intended recipient, please contact the sender immediately by
> > reply e-mail
> > and destroy all copies of the original message. Please note that we do
> > not accept
> > account orders and/or instructions by e-mail, and therefore will not be
> > responsible
> > for carrying out such orders and/or instructions. If you, as the
> > intended recipient
> > of this message, the purpose of which is to inform and update our
> > clients, prospects
> > and consultants of developments relating to our services and products,
> > would not
> > like to receive further e-mail correspondence from the sender, please
> > "reply" to the
> > sender indicating your wishes. In the U.S.: 1345 Avenue of the
> > Americas, New York,
> > NY 10105.
> > _______________________________________________
> > 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