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

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

RE: [U2] The best way to access SQLServer from UV [not-secure]

] 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

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

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

RE: [U2] The best way to access SQLServer from UV [not-secure]

. [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

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

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

RE: [U2] The best way to access SQLServer from UV [not-secure]

:[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

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

RE: [U2] The best way to access SQLServer from UV [not-secure]

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

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