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:18:24 -0400

I just checked and my char set is:LANG="en_US.UTF-8"
SUPPORTED="en_US.UTF-8:en_US:en"

So seems like UTF-8 should have worked unless I messed up the entry in conf.

On 4/11/06, blackwater dev <blackwaterdev AT gmail.com> wrote:
>
> 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