Skip to Content.
Sympa Menu

freetds - Re: [freetds] Output from SQL Server database

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Output from SQL Server database
  • Date: Tue, 28 Oct 2014 09:30:52 +0000

Hi,
for the dump in this case the better way is to enable ODBC trace, refer
to DM documentation.

I understand that data came from user input but how does they reach the
database? For instance web <-> PHP <-> PHP library <-> ODBC <-> Oracle <->
SQL connector <-> FreeTDS settings YYY <-> MSSQL version XXX or Windows GUI
<-> MS OLE driver <-> MSSQL. How is FreeTDS configured? How is the
connector configured? Which kind of characters are you trying to insert?

Frediano

Frediano

2014-10-27 18:44 GMT+00:00 Turk, Scott A <SATurk AT missouristate.edu>:

> FreeTDS version is 7.2. The data type of the column in question is
> nvarchar on the SQL server side - would the rest of the table description
> help? We are accessing the data via an Oracle link in SQL Developer. The
> data is produced by user input.
>
> How can I produce a dump file?
>
> Thanks!
>
> SCOTT TURK
> DATABASE ANALYST, DBA
> COMPUTER SERVICES - MIS
> MISSOURI STATE UNIVERSITY
> SATURK AT MISSOURISTATE.EDU
> (417) 836-6195
>
>
> -----Original Message-----
> From: FreeTDS [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of
> Frediano Ziglio
> Sent: Monday, October 27, 2014 12:13 PM
> To: FreeTDS Development Group
> Subject: Re: [freetds] Output from SQL Server database
>
> 2014-10-27 16:48 GMT+00:00 Turk, Scott A <SATurk AT missouristate.edu>:
>
> > Hi, we're having a problem with the output we're getting across an
> > Oracle link to a SQL Server database. The column output appears to
> > have inserted nulls in between each character. The data type of the
> column is nvarchar.
> > Our application is SQL Developer.
> >
> > Any ideas on what may be going wrong? We also use FreeTDS to link to
> > other SQL Server databases and have not seen this happen previously.
> >
> > Thanks!
> >
> > Scott Turk
> > Database Analyst, DBA
> > Computer Services - MIS
> > Missouri State University
> > SATurk AT missouristate.edu<mailto:SATurk AT missouristate.edu>
> > (417) 836-6195
> >
> >
> Hi,
> any more details like FreeTDS version, possible dump, how did you upload
> data, tables definition.
>
> Frediano
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> 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