Hi Bob, I hope I did not miss your reply. We have the problem to make SQL 2000 communicate with Universe 10 or 11 with IBM Universe ODBC driver. Based on its document, this driver seems do not support the SQL server.
Could you share your experience on the way of using OpenLink ODBC driver for SQL server? Thanks, Kathy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Gonzalez Sent: Friday, October 14, 2005 12:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] connection from UniBasic to a SQL database Hello Bob. I would like to see a sample of how you do that. You don't have to give away your source, but giving us an ideal of how it works. thanks. > > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney >Sent: Thursday, October 13, 2005 11:13 PM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] connection from UniBasic to a SQL database [was What >are you using to develop your web pages...] {Unclassified} > >Wendy: > >We talk to ms sql all the time thru OpenLink ODBC drivers using the BCI > >It works fine and the only problems we had was with the ODBC driver > >Have routines that do it if you'd like to look > >Bob > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] Behalf Of gerry-u2ug >Sent: 14 October 2005 01:48 >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] connection from UniBasic to a SQL database [was What >are you using to develop your web pages...] {Unclassified} > > >things are not this simle on unix - 3rd party odbc drivers need to be >purchased , installed & configured. >I have never worked with a client who has gone this route, it never >seems to be worth the bother & expense. > > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] Behalf Of HENDERSON MIKE, >MR >Sent: Thursday, October 13, 2005 06:11 PM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] connection from UniBasic to a SQL database [was What >are you using to develop your web pages...] {Unclassified} > > >Wendy > > > -----Original Message----- > > From: [EMAIL PROTECTED] On Behalf Of Wendy Smoak > > Sent: Friday, 14 October 2005 09:10 > > To: u2-users@listserver.u2ug.org > > Subject: Re: [U2] [AD] What are you using to develop your web pages? > > JavaScript? PHP? .Net? > > > > From: "Symeon Breen" <[EMAIL PROTECTED]> > > > > > it is easy to read/write mysql from your Unibasic. > > > > Really? So far we have not been successful getting a connection from > > UniBasic to a SQL database. What are you using? (My guess is that > > you're on Windows.) > >I've written stuff to read from a SQL database into UniBasic using the >BCI. >There's no conceptual difference between reading & writing, it's just a >matter of using a SQL INSERT or MODIFY instead of a SELECT in the string >passed to SQL. I do have some doubts about how to set up transactions >to allow simultaneous SQL & UV updates, but that's functionality we >don't need yet. > >The BCI documentation is sparse and the example code execrable, but it >does work and performance is not too bad, either. > >UV 10.0.15 to MS SQL Server 2000, all on Windows, using the MS SQL >Server driver. > >Mike > > > > > We're on HP-UX. At the moment I'm reading from Sybase with their JDBC > > > driver then using UniObjects for Java to write records into UniData. > > It's working fine, but it would be > > *really* nice to connect directly to Sybase from a UniBasic program. > > > > -- > > Wendy Smoak > > ------- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > > >The information contained in this Internet Email message is intended for >the addressee only and may contain privileged information, but not >necessarily the official views or opinions of the New Zealand Defence >Force. >If you are not the intended recipient you must not use, disclose, copy >or distribute this message or the information in it. > >If you have received this message in error, please Email or telephone >the sender immediately. >------- >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/ > >______________________________________________________________________ >This email has been scanned by the MessageLabs Email Security System. >For more information please visit http://www.messagelabs.com/email >______________________________________________________________________ > >______________________________________________________________________ >This email has been scanned by the MessageLabs Email Security System. >For more information please visit http://www.messagelabs.com/email >______________________________________________________________________ >------- >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/
