Thread: issue using dts and odbc driver with unicode
Hi I was using dts in Microsoft SQL server to do several automated data dumps.
After changing over to Unicode and the latest odbc driver I am getting errors.
Any one have any feedback, is this related to the other threads about Microsoft query etc?
I can try and write an application to dump the data but it would be much easier if I could continue to use the tools I am used to.
Joel Fradkin
Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel. 941-753-7111 ext 305
jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
© 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
This email message is for the use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and delete and destroy all copies of the original message, including attachments.
On Windows Unicode works with PostgreSQL and ODBC only on Windows-XP platforms correct. On all other platforms sting columns are read without encoding. String columns are written encoded.
Josef Springer
Josegv Springer
Joel Fradkin wrote:
Josef Springer
Josegv Springer
Joel Fradkin wrote:
Hi I was using dts in Microsoft SQL server to do several automated data dumps.
After changing over to Unicode and the latest odbc driver I am getting errors.
Any one have any feedback, is this related to the other threads about Microsoft query etc?
I can try and write an application to dump the data but it would be much easier if I could continue to use the tools I am used to.
Joel Fradkin
Wazagua, Inc.
2520 Trailmate Dr
Sarasota , F lorid a 34243
Tel. 941-753-7111 ext 305
jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
© 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
This email message is for the use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and delete and destroy all copies of the original message, including attachments.
A little more info would help.... What error msg for example? /D -----Original Message----- From: "Joel Fradkin"<jfradkin@wazagua.com> Sent: 08/08/05 15:39:23 To: "pgsql-odbc@postgresql.org"<pgsql-odbc@postgresql.org> Subject: [ODBC] issue using dts and odbc driver with unicode Hi I was using dts in Microsoft SQL server to do several automated data dumps. After changing over to Unicode and the latest odbc driver I am getting errors. Any one have any feedback, is this related to the other threads about Microsoft query etc? I can try and write an application to dump the data but it would be much easier if I could continue to use the tools I am used to. Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 jfradkin@wazagua.com www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc This email message is for the use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and delete and destroy all copies of the original message, including attachments. -----Unmodified Original Message----- Hi I was using dts in Microsoft SQL server to do several automated data dumps. After changing over to Unicode and the latest odbc driver I am getting errors. Any one have any feedback, is this related to the other threads about Microsoft query etc? I can try and write an application to dump the data but it would be much easier if I could continue to use the tools I am used to. Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 jfradkin@wazagua.com www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc This email message is for the use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and delete and destroy all copies of the original message, including attachments.
Dave, Thanks for the response. It worked ok for two of the four file dumps in the dts it was dumping so maybe it is a specific field type. The specific error was unable to bind (makes me think the columns some how get reported differently from when you define the dts and when the query runs, but cant say for sure; I did try and recreate the process in case it involved a change in the tables / sql, but same error). The dts is something like select * from viewcaseexport where clientnum = 'WAZ' The viewcaseexport is SELECT c.caseid, c.clientnum, c.casenum, c.sourcemodule, c.sourcedocnum, c.casevalue, c.admitted, c.recovered, c.restitutionowed, 1 AS numberofcase, c.casetype, c.status, c.opendate, c.closedate, c."action", c.closebyuser, c.casesource, c.method, c.method2, c.reportingagentfirstinitial, c.reportingagentlastname, c.monthsemployedatcase, c.createdby, c.subjecttype, c.offensetype, c.patrontype, c.jobtitle, c.outofficetime, c.inofficetime, c.doh, c.dot, c.staffexecid, c.worktypeid, c.workaddress, c.firstname, c.lastname, c.ssn, c.dob, c.identificationtypeid, c.identificationtype, c.address, c.city, c.state, c.zip, c.phone, c.gender::text AS gender, c.ethnicityid, c.ethnicity, c.militarybranch, c.militarystatus, c.secagentnum, c.locationnum, c.store, c.locationaddress, c.locationcity, c.locationstate, c.locationzip, c.locationphone, c.districtnum, c.district, c.regionnum, c.region, c.divisionnum, c.division, c.apprehdate, c."year", c.quarter, c."month", c.weekday, c.week, c."time", c.signedstatement, c.ageatcase, c.cdacasetype, c.cdamerchandisedisp1, c.cdamerchandisedisp2, c.cdaincaseof, c.cdaresponsiblesalut, c.cdarespfirst, c.cdaresplast, c.cdaretailvalue, c.cdacash, c.cdadamagedmdse, c.cdaotherdamages, c.cdafirstpayementdate, c.cdaregularpaymentamount, c.cdaoriginalamount, c.cdatotalbalance, c.cdaincidentid, c.cdaobservedbyid, c.cdaconcealedid, c.cdamdsedispid, c.cdasubjectdispid, c.cdaexited, c.cdaallowpay, c.cdacdsigned, c.cdaidchecked, c.casereport FROM tblcasehistory c WHERE c.isdeleted = false; Case history schema is: CREATE TABLE tblcasehistory ( caseid int4, clientnum varchar, casenum varchar, sourcemodule char, sourcedocnum varchar, sourcedocid int4, sourcemoduledesc text, casevalue numeric, admitted numeric, recovered numeric, restitutionowed numeric, numberofcase int4, casetype varchar, status varchar, opendate timestamp, closedate timestamp, "action" varchar, closebyuser varchar, casesource varchar, method varchar, method2 varchar, reportingagentfirstinitial varchar, reportingagentlastname varchar, monthsemployedatcase int4, chrmonthsemployedatcase varchar, createdby varchar, subjecttype varchar, offensetype varchar, patrontype varchar, jobtitle varchar, worktype varchar, outofficetime varchar, inofficetime varchar, doh timestamp, dot timestamp, staffexecid varchar, worktypeid varchar, workaddress varchar, firstname varchar, lastname varchar, subjectname text, ssn varchar, dob timestamp, identificationtypeid int4, identificationtype varchar, address varchar, city varchar, state varchar, zip varchar, phone varchar, testscore int4, gender varchar, ethnicityid int4, ethnicity varchar, militarybranch varchar, militarystatus varchar, secagentnum varchar, secagentname varchar, locationid int4, regionid int4, districtid int4, divisionid int4, locationnum varchar, store varchar, locationaddress varchar, locationcity varchar, locationstate varchar, locationzip varchar, locationphone varchar, districtnum varchar, district varchar, regionnum varchar, region varchar, divisionnum varchar, division varchar, apprehdate timestamp, "year" text, quarter text, "month" text, weekday text, week text, "time" text, signedstatement int4, ageatcase int4, cdacasetype varchar, cdamerchandisedisp1 varchar, cdamerchandisedisp2 varchar, cdaincaseof varchar, cdaresponsiblesalut varchar, cdarespfirst varchar, cdaresplast varchar, cdaretailvalue numeric, cdacash numeric, cdadamagedmdse numeric, cdaotherdamages numeric, cdafirstpayementdate timestamp, cdaregularpaymentamount numeric, cdaoriginalamount numeric, cdatotalbalance numeric, cdaincidentid int4, cdaobservedbyid int4, cdaconcealedid int4, cdamdsedispid int4, cdasubjectdispid int4, cdaexited varchar, cdaallowpay varchar, cdacdsigned varchar, cdaidchecked varchar, casereport text, cdatransfer bool, civilcase text, merchandisetotal numeric, casereferencenum varchar, lpregionnum varchar, lpmanager varchar, restitutiontype varchar, isdeleted bool ) Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 jfradkin@wazagua.com www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc This email message is for the use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and delete and destroy all copies of the original message, including attachments. -----Original Message----- From: Dave Page [mailto:dpage@vale-housing.co.uk] Sent: Tuesday, August 09, 2005 5:22 AM To: jfradkin@wazagua.com; pgsql-odbc@postgresql.org Subject: RE: [ODBC] issue using dts and odbc driver with unicode A little more info would help.... What error msg for example? /D -----Original Message----- From: "Joel Fradkin"<jfradkin@wazagua.com> Sent: 08/08/05 15:39:23 To: "pgsql-odbc@postgresql.org"<pgsql-odbc@postgresql.org> Subject: [ODBC] issue using dts and odbc driver with unicode Hi I was using dts in Microsoft SQL server to do several automated data dumps. After changing over to Unicode and the latest odbc driver I am getting errors. Any one have any feedback, is this related to the other threads about Microsoft query etc? I can try and write an application to dump the data but it would be much easier if I could continue to use the tools I am used to. Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 jfradkin@wazagua.com www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc This email message is for the use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and delete and destroy all copies of the original message, including attachments. -----Unmodified Original Message----- Hi I was using dts in Microsoft SQL server to do several automated data dumps. After changing over to Unicode and the latest odbc driver I am getting errors. Any one have any feedback, is this related to the other threads about Microsoft query etc? I can try and write an application to dump the data but it would be much easier if I could continue to use the tools I am used to. Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 jfradkin@wazagua.com www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc This email message is for the use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and delete and destroy all copies of the original message, including attachments.