Re: [U2] [UV] ODBC + UPS
...and Ross on BCI --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Thursday, December 10, 2009 5:01 PM To: U2 Users List Subject: Re: [U2] [UV] ODBC + UPS Once again... John Hester... has knocked me out of my socks. Because John's answer works, we can read and write directly via the UPS-ODBC connection to UniVerse. Thanks a billion John. Thanks also to Brian and Neil on BCI Connectivity. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Wednesday, December 09, 2009 10:09 PM To: U2 Users List Subject: Re: [U2] [UV] ODBC + UPS You need to change the the "READ" parameter in the HS_FILE_ACCESS record for the UV file to "READ_WRITE", then run HS.UPDATE.FILEINFO in that file's account. At that point a SQL insert to the file from the windows side should be allowed. See the UV ODBC guide for more detailed info. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Tuesday, December 01, 2009 1:09 PM To: U2 Users List Subject: [U2] [UV] ODBC + UPS I can read via ODBC from UniVerse to a Windows PC. Is it possible to write ODBC? I am trying to do an export from United Parcel Service WorldShip. When I try to setup a simple export map link in WorldShip, WorldShip comes back with an error. Help would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] ODBC + UPS
Once again... John Hester... has knocked me out of my socks. Because John's answer works, we can read and write directly via the UPS-ODBC connection to UniVerse. Thanks a billion John. Thanks also to Brian and Neil on BCI Connectivity. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Wednesday, December 09, 2009 10:09 PM To: U2 Users List Subject: Re: [U2] [UV] ODBC + UPS You need to change the the "READ" parameter in the HS_FILE_ACCESS record for the UV file to "READ_WRITE", then run HS.UPDATE.FILEINFO in that file's account. At that point a SQL insert to the file from the windows side should be allowed. See the UV ODBC guide for more detailed info. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Tuesday, December 01, 2009 1:09 PM To: U2 Users List Subject: [U2] [UV] ODBC + UPS I can read via ODBC from UniVerse to a Windows PC. Is it possible to write ODBC? I am trying to do an export from United Parcel Service WorldShip. When I try to setup a simple export map link in WorldShip, WorldShip comes back with an error. Help would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] ODBC + UPS
You need to change the the "READ" parameter in the HS_FILE_ACCESS record for the UV file to "READ_WRITE", then run HS.UPDATE.FILEINFO in that file's account. At that point a SQL insert to the file from the windows side should be allowed. See the UV ODBC guide for more detailed info. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Tuesday, December 01, 2009 1:09 PM To: U2 Users List Subject: [U2] [UV] ODBC + UPS I can read via ODBC from UniVerse to a Windows PC. Is it possible to write ODBC? I am trying to do an export from United Parcel Service WorldShip. When I try to setup a simple export map link in WorldShip, WorldShip comes back with an error. Help would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] ODBC + UPS
Thanks Neil... BCI is just what I was looking for. Thanks also to Garry. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Neil Richards Sent: Monday, December 07, 2009 4:18 PM To: U2 Users List Subject: Re: [U2] [UV] ODBC + UPS Take a look at the BCI reference manual The UniVerse BASIC SQL Client Interface is an application programming interface (API) that makes UniVerse a client in a client/server environment. The server data source can be either: A local or remote UniVerse database A relational DBMS such as INFORMIX, SYBASE, or DB2 You use the SQL Client Interface to connect to one or more data sources. ODBC Data Sources To connect to an ODBC data source, an ODBC driver manager and suitable ODBC drivers for the data sources you want to connect to must be installed on the client system. Once connected to any data source, the SQL Client Interface lets you read data from and write data to the data source. Your application program can access the capabilities of the server DBMS Hope this helps Neil From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill [bi...@hkmetalcraft.com] Sent: Tuesday, December 01, 2009 1:08 PM To: U2 Users List Subject: [U2] [UV] ODBC + UPS I can read via ODBC from UniVerse to a Windows PC. Is it possible to write ODBC? I am trying to do an export from United Parcel Service WorldShip. When I try to setup a simple export map link in WorldShip, WorldShip comes back with an error. Help would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org<mailto:U2-Users@listserver.u2ug.org> http://listserver.u2ug.org/mailman/listinfo/u2-users Total Control Panel Login<https://asp-6.reflexion.net/login?domain=switp.com> To: n...@switp.com<https://asp-6.reflexion.net/address-properties?aID=467558 98> From: u2-users-boun...@listserver.u2ug.org<https://asp-6.reflexion.net/address -properties?aID=60327323> Message Score: 50 High (60): Pass My Spam Blocking Level: Medium Medium (75): Pass Low (90): Pass Block<https://asp-6.reflexion.net/FooterAction?ver=1&bl-sender-address=1 &rID=46755898&aID=60327323> this sender / Block<https://asp-6.reflexion.net/FooterAction?ver=1&ent=1&bl-sender-add ress=1&rID=46755898&aID=60327323> this sender enterprise-wide Block<https://asp-6.reflexion.net/FooterAction?ver=1&bl-sender-domain=1&; rID=46755898&aID=60327323> listserver.u2ug.org / Block<https://asp-6.reflexion.net/FooterAction?ver=1&ent=1&bl-sender-dom ain=1&rID=46755898&aID=60327323> listserver.u2ug.org enterprise-wide This message was delivered because the content filter score did not exceed your filter level. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] ODBC + UPS
The UPS ODBC issues an SQL Insert command. We do an end-of-order write in "append mode" to a file on a Unix Samba Drive and every 15 minutes a UV phantom job reads the file and updates our order file with the shipment/package data. Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Tuesday, December 01, 2009 1:09 PM To: U2 Users List Subject: [U2] [UV] ODBC + UPS I can read via ODBC from UniVerse to a Windows PC. Is it possible to write ODBC? I am trying to do an export from United Parcel Service WorldShip. When I try to setup a simple export map link in WorldShip, WorldShip comes back with an error. Help would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] ODBC + UPS
Take a look at the BCI reference manual The UniVerse BASIC SQL Client Interface is an application programming interface (API) that makes UniVerse a client in a client/server environment. The server data source can be either: A local or remote UniVerse database A relational DBMS such as INFORMIX, SYBASE, or DB2 You use the SQL Client Interface to connect to one or more data sources. ODBC Data Sources To connect to an ODBC data source, an ODBC driver manager and suitable ODBC drivers for the data sources you want to connect to must be installed on the client system. Once connected to any data source, the SQL Client Interface lets you read data from and write data to the data source. Your application program can access the capabilities of the server DBMS Hope this helps Neil From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill [bi...@hkmetalcraft.com] Sent: Tuesday, December 01, 2009 1:08 PM To: U2 Users List Subject: [U2] [UV] ODBC + UPS I can read via ODBC from UniVerse to a Windows PC. Is it possible to write ODBC? I am trying to do an export from United Parcel Service WorldShip. When I try to setup a simple export map link in WorldShip, WorldShip comes back with an error. Help would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org<mailto:U2-Users@listserver.u2ug.org> http://listserver.u2ug.org/mailman/listinfo/u2-users Total Control Panel Login<https://asp-6.reflexion.net/login?domain=switp.com> To: n...@switp.com<https://asp-6.reflexion.net/address-properties?aID=46755898> From: u2-users-boun...@listserver.u2ug.org<https://asp-6.reflexion.net/address-properties?aID=60327323> Message Score: 50 High (60): Pass My Spam Blocking Level: Medium Medium (75): Pass Low (90): Pass Block<https://asp-6.reflexion.net/FooterAction?ver=1&bl-sender-address=1&rID=46755898&aID=60327323> this sender / Block<https://asp-6.reflexion.net/FooterAction?ver=1&ent=1&bl-sender-address=1&rID=46755898&aID=60327323> this sender enterprise-wide Block<https://asp-6.reflexion.net/FooterAction?ver=1&bl-sender-domain=1&rID=46755898&aID=60327323> listserver.u2ug.org / Block<https://asp-6.reflexion.net/FooterAction?ver=1&ent=1&bl-sender-domain=1&rID=46755898&aID=60327323> listserver.u2ug.org enterprise-wide This message was delivered because the content filter score did not exceed your filter level. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [UV] ODBC + UPS
I can read via ODBC from UniVerse to a Windows PC. Is it possible to write ODBC? I am trying to do an export from United Parcel Service WorldShip. When I try to setup a simple export map link in WorldShip, WorldShip comes back with an error. Help would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users