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/
Re: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified}
gerry-u2ug wrote: 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. Price shouldn't be a problem with mysql: *MySQL Connector/ODBC* (also known as MyODBC) allows you to connect to a MySQL database server using the ODBC database API on all Microsoft Windows and most Unix platforms, including through such applications and programming environments such as Microsoft Access, Microsoft Excel, and Borland Delphi. Features *Standards compliant* The production-ready version of Connector/ODBC is compliant with the ODBC 2.50 specification, Level 0 (with some Level 1 and 2 features). The stable version, is compliant with the ODBC 3.51 specification, Level 1 (complete Core API and Level 2 features). *Cross-platform* Connector/ODBC is available for Microsoft Windows, as well as many Unix systems (including Linux, Sun Solaris, HP-UX, IBM AIX, and Mac OS X). Downloads, Licensing, and Support Two versions of MySQL Connector/ODBC are available for download: * MySQL Connector/ODBC 3.51 http://dev.mysql.com/downloads/connector/odbc/3.51.html is the production-ready version of the driver, and is available under the GPL. * MySQL Connector/ODBC 2.50 http://dev.mysql.com/downloads/connector/odbc/2.50.html is the old production-ready version of the driver, and is available under the LGPL. MySQL Connectors are available under the MySQL AB dual licensing model. Under this model, users may choose to use MySQL products under the free software/opensource GNU General Public License http://www.mysql.com/company/legal/licensing/opensource-license.html (commonly known as the GPL) or under acommercial license http://www.mysql.com/company/legal/licensing/commercial-license.html. from www.mysql.com/products/connector/odbc -- mats --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified}
MySql is easy - i understand it is perhaps not as easy if you are talking MS sql and your U2 is on unix - as said above third party drivers are required or an odbc bridge ! On 10/14/05, Mats Carlid [EMAIL PROTECTED] wrote: gerry-u2ug wrote: 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. Price shouldn't be a problem with mysql: *MySQL Connector/ODBC* (also known as MyODBC) allows you to connect to a MySQL database server using the ODBC database API on all Microsoft Windows and most Unix platforms, including through such applications and programming environments such as Microsoft Access, Microsoft Excel, and Borland Delphi. Features *Standards compliant* The production-ready version of Connector/ODBC is compliant with the ODBC 2.50 specification, Level 0 (with some Level 1 and 2 features). The stable version, is compliant with the ODBC 3.51 specification, Level 1 (complete Core API and Level 2 features). *Cross-platform* Connector/ODBC is available for Microsoft Windows, as well as many Unix systems (including Linux, Sun Solaris, HP-UX, IBM AIX, and Mac OS X). Downloads, Licensing, and Support Two versions of MySQL Connector/ODBC are available for download: * MySQL Connector/ODBC 3.51 http://dev.mysql.com/downloads/connector/odbc/3.51.html is the production-ready version of the driver, and is available under the GPL. * MySQL Connector/ODBC 2.50 http://dev.mysql.com/downloads/connector/odbc/2.50.html is the old production-ready version of the driver, and is available under the LGPL. MySQL Connectors are available under the MySQL AB dual licensing model. Under this model, users may choose to use MySQL products under the free software/opensource GNU General Public License http://www.mysql.com/company/legal/licensing/opensource-license.html (commonly known as the GPL) or under acommercial license http://www.mysql.com/company/legal/licensing/commercial-license.html. from www.mysql.com/products/connector/odbc -- mats --- 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] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified}
Bob,
I'd like to see those routines,
Thanks,
Noah
-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/
RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified}
Wendy,
Not sure I cut your original message out of the messages correctly, but here
goes.
As someone else mentioned for unix you need to 'acquire' 3rd party software
in order to access non-unix databases from unix, i.e., MS SQL, Oracle, Sybase,
etc.
We're running AIX and have found Easysoft ODBC-ODBC Bridge software to be
great! (granted we're only pulling information from MS SQL into UniData, but
that's ALL we need it for.)
Check out their website at www.easysoft.com, their inexpensive especially
compared to certain other 3rd parties.
It's easy to install and setup. Contact me off list if you have any questions.
Hope this is helpful,
Arthur
Arthur Metherall
Courier Corporation
-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] connection from UniBasic to a SQL database [was What are you
using to develop your web pages...] {Unclassified}
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/
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/
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/
