RE: [U2] The best way to access SQLServer from UV [not-secure]
snip What is the best way to get information to and from a SQLServer database using Universe Basic? /snip What do you plan on doing? Are you pushing small records to SQLServer, retrieving small records or pushing/getting large tables? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] The best way to access SQLServer from UV
The best way - I cannot answer that... Sorry. I think somebody will suggest ODBC... So I should let him/her explain it. :) I assume when you said Latest version, you mean SQL Server 2005. http://technet.microsoft.com/en-us/library/ms191274.aspx Microsoft SQL Server 2005 provides native XML Web Services through the SQL Server 2005 Database Engine by using the following open standards: HTTP, SOAP, WSDL, blah, blah, blah... So maybe you can use Universe's callHTTP. Good Luck! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Wednesday, June 27, 2007 9:10 AM To: u2-users@listserver.u2ug.org Subject: [U2] The best way to access SQLServer from UV I know this question has come up before but there have been many new developments in Universe including a whole new release so I'm going to ask it anyway. Also I know that it sometimes it's a matter of what you have been taught. What is the best way to get information to and from a SQLServer database using Universe Basic? I would prefer to hear about built in features and not outside sources. Not that I don't appreciate that you guys have some wonderful products but we have a fully qualified staff of programmers here and other than the operating systems we have pretty much developed everything we have in-house. We are running Red Hat Enterprise Linux AS release 3 with uniVerse 10.1.12 Reality flavor. The SQLServer will be on a Windows 2003 Server and most likely the latest version of SQLServer. We are not opposed to upgrading the Linux or uniVerse if that would give us more to work with. Jerry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] The best way to access SQLServer from UV [not-secure]
Basically it has to do with PCI. We are putting all of our card data on a secure encrypted SQLServer so we can access the data from all of our applications. The records will most likely be in one table and we will want to read the data, record by record, or write it, record by record, using UV. Or, get/put, whatever the term being used. It has to be real time and as fast as possible, up to 5,000 cards a minute, as we do now. -Original Message- From: Hennessey, Mark F. [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 9:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] The best way to access SQLServer from UV [not-secure] snip What is the best way to get information to and from a SQLServer database using Universe Basic? /snip What do you plan on doing? Are you pushing small records to SQLServer, retrieving small records or pushing/getting large tables? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] The best way to access SQLServer from UV
Yes, I'm told it will be SQL Server 2005 on Windows 2003. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 9:55 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] The best way to access SQLServer from UV The best way - I cannot answer that... Sorry. I think somebody will suggest ODBC... So I should let him/her explain it. :) I assume when you said Latest version, you mean SQL Server 2005. http://technet.microsoft.com/en-us/library/ms191274.aspx Microsoft SQL Server 2005 provides native XML Web Services through the SQL Server 2005 Database Engine by using the following open standards: HTTP, SOAP, WSDL, blah, blah, blah... So maybe you can use Universe's callHTTP. Good Luck! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Wednesday, June 27, 2007 9:10 AM To: u2-users@listserver.u2ug.org Subject: [U2] The best way to access SQLServer from UV I know this question has come up before but there have been many new developments in Universe including a whole new release so I'm going to ask it anyway. Also I know that it sometimes it's a matter of what you have been taught. What is the best way to get information to and from a SQLServer database using Universe Basic? I would prefer to hear about built in features and not outside sources. Not that I don't appreciate that you guys have some wonderful products but we have a fully qualified staff of programmers here and other than the operating systems we have pretty much developed everything we have in-house. We are running Red Hat Enterprise Linux AS release 3 with uniVerse 10.1.12 Reality flavor. The SQLServer will be on a Windows 2003 Server and most likely the latest version of SQLServer. We are not opposed to upgrading the Linux or uniVerse if that would give us more to work with. Jerry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] The best way to access SQLServer from UV
Universe BCI works very well. http://212.241.202.162/kb/kbview.wsp?id=9 Ross -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Wednesday, June 27, 2007 6:10 AM To: u2-users@listserver.u2ug.org Subject: [U2] The best way to access SQLServer from UV I know this question has come up before but there have been many new developments in Universe including a whole new release so I'm going to ask it anyway. Also I know that it sometimes it's a matter of what you have been taught. What is the best way to get information to and from a SQLServer database using Universe Basic? I would prefer to hear about built in features and not outside sources. Not that I don't appreciate that you guys have some wonderful products but we have a fully qualified staff of programmers here and other than the operating systems we have pretty much developed everything we have in-house. We are running Red Hat Enterprise Linux AS release 3 with uniVerse 10.1.12 Reality flavor. The SQLServer will be on a Windows 2003 Server and most likely the latest version of SQLServer. We are not opposed to upgrading the Linux or uniVerse if that would give us more to work with. Jerry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] The best way to access SQLServer from UV [not-secure]
Jerry Sorry I send my previous reply before seeing this post. I was thinking of the bulk update side. Brian Basically it has to do with PCI. We are putting all of our card data on a secure encrypted SQLServer so we can access the data from all of our applications. The records will most likely be in one table and we will want to read the data, record by record, or write it, record by record, using UV. Or, get/put, whatever the term being used. It has to be real time and as fast as possible, up to 5,000 cards a minute, as we do now. -Original Message- From: Hennessey, Mark F. [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 9:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] The best way to access SQLServer from UV [not-secure] snip What is the best way to get information to and from a SQLServer database using Universe Basic? /snip What do you plan on doing? Are you pushing small records to SQLServer, retrieving small records or pushing/getting large tables? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] The best way to access SQLServer from UV
Jerry, I don't know if it's the best way, but we use UV's bci. At tcl enter HELP BCI and you'll see all the functions. It works great for us. We can write UV programs with the sql embedded or write UV programs calling sql server stored procedures returning a result set. We're satisfied with it. Plus there are a number of list members who are familiar with the technology who can offer much assistance. Rudy Date: Wed, 27 Jun 2007 08:09:44 -0500 From: Jerry Banker [EMAIL PROTECTED] Subject: [U2] The best way to access SQLServer from UV I know this question has come up before but there have been many new developments in Universe including a whole new release so I'm going to ask it anyway. Also I know that it sometimes it's a matter of what you have been taught. What is the best way to get information to and from a SQLServer database using Universe Basic? I would prefer to hear about built in features and not outside sources. Not that I don't appreciate that you guys have some wonderful products but we have a fully qualified staff of programmers here and other than the operating systems we have pretty much developed everything we have in-house. We are running Red Hat Enterprise Linux AS release 3 with uniVerse 10.1.12 Reality flavor. The SQLServer will be on a Windows 2003 Server and most likely the latest version of SQLServer. We are not opposed to upgrading the Linux or uniVerse if that would give us more to work with. Jerry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] The best way to access SQLServer from UV
Jerry If by 'built-in' you include the middleware that comes with UV: 1. Create a .Net client. 2. Use the UniXML class to produce a dataset from a RetrieVe or SQL XML statement. 3. Iterate through the dataset and use a dbCommand to push that into SQL via a stored procedure. Simple and effective. Brian I know this question has come up before but there have been many new developments in Universe including a whole new release so I'm going to ask it anyway. Also I know that it sometimes it's a matter of what you have been taught. What is the best way to get information to and from a SQLServer database using Universe Basic? I would prefer to hear about built in features and not outside sources. Not that I don't appreciate that you guys have some wonderful products but we have a fully qualified staff of programmers here and other than the operating systems we have pretty much developed everything we have in-house. We are running Red Hat Enterprise Linux AS release 3 with uniVerse 10.1.12 Reality flavor. The SQLServer will be on a Windows 2003 Server and most likely the latest version of SQLServer. We are not opposed to upgrading the Linux or uniVerse if that would give us more to work with. Jerry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] The best way to access SQLServer from UV [not-secure]
Any reason you're not putting it on a secure encrypted UV server? (I believe the latest version of UV does native encryption ... :-) If it's not a 1-1 record-row match, then SQL-Server will be unlikely to match UV for speed. Cheers, Wol -Original Message- From: Jerry Banker [mailto:[EMAIL PROTECTED] Sent: 27 June 2007 16:20 To: u2-users@listserver.u2ug.org Subject: RE: [U2] The best way to access SQLServer from UV [not-secure] Basically it has to do with PCI. We are putting all of our card data on a secure encrypted SQLServer so we can access the data from all of our applications. The records will most likely be in one table and we will want to read the data, record by record, or write it, record by record, using UV. Or, get/put, whatever the term being used. It has to be real time and as fast as possible, up to 5,000 cards a minute, as we do now. -Original Message- From: Hennessey, Mark F. [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 9:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] The best way to access SQLServer from UV [not-secure] snip What is the best way to get information to and from a SQLServer database using Universe Basic? /snip What do you plan on doing? Are you pushing small records to SQLServer, retrieving small records or pushing/getting large tables? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] The best way to access SQLServer from UV [not-secure]
Strange, I never received a reply from you. -Original Message- From: Brian Leach [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 11:00 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] The best way to access SQLServer from UV [not-secure] Jerry Sorry I send my previous reply before seeing this post. I was thinking of the bulk update side. Brian Basically it has to do with PCI. We are putting all of our card data on a secure encrypted SQLServer so we can access the data from all of our applications. The records will most likely be in one table and we will want to read the data, record by record, or write it, record by record, using UV. Or, get/put, whatever the term being used. It has to be real time and as fast as possible, up to 5,000 cards a minute, as we do now. -Original Message- From: Hennessey, Mark F. [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 9:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] The best way to access SQLServer from UV [not-secure] snip What is the best way to get information to and from a SQLServer database using Universe Basic? /snip What do you plan on doing? Are you pushing small records to SQLServer, retrieving small records or pushing/getting large tables? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] The best way to access SQLServer from UV [not-secure]
Our universe system is accessed too directly from the web for us to qualify for PCI compliance. We also have other places that contain card data, like contract images, and we access the data from more than just UV. So we have to put all of this data on a more secure system in only one place. Lock it down and encrypt all of it. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 11:00 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] The best way to access SQLServer from UV [not-secure] Any reason you're not putting it on a secure encrypted UV server? (I believe the latest version of UV does native encryption ... :-) If it's not a 1-1 record-row match, then SQL-Server will be unlikely to match UV for speed. Cheers, Wol -Original Message- From: Jerry Banker [mailto:[EMAIL PROTECTED] Sent: 27 June 2007 16:20 To: u2-users@listserver.u2ug.org Subject: RE: [U2] The best way to access SQLServer from UV [not-secure] Basically it has to do with PCI. We are putting all of our card data on a secure encrypted SQLServer so we can access the data from all of our applications. The records will most likely be in one table and we will want to read the data, record by record, or write it, record by record, using UV. Or, get/put, whatever the term being used. It has to be real time and as fast as possible, up to 5,000 cards a minute, as we do now. -Original Message- From: Hennessey, Mark F. [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 9:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] The best way to access SQLServer from UV [not-secure] snip What is the best way to get information to and from a SQLServer database using Universe Basic? /snip What do you plan on doing? Are you pushing small records to SQLServer, retrieving small records or pushing/getting large tables? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] The best way to access SQLServer from UV
We're also using UV TOXML + MS SQLXML to transfer data. Stuart What is the best way to get information to and from a SQLServer database using Universe Basic? ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/