Re: [U2] connect to an access database

Stu Glancy Mon, 25 Oct 2004 10:28:13 -0700

I was very interested to see your code but the attachment didn't make it. Could you paste your code into another email? Much appreciated.

Stu Glancy

Richard Taylor wrote:

Yes, you can do this, I have an operation program that reads and writes an
Access Database from a UV Basic program.  I am attaching a sample program
that shows the techniques written under Universe.  I had to change the
code to remove any proprietary information, but you should still be able
to follow the logic of reading and writing to an access database.  One
caveat, this was written to work with UV on Windows.  I believe that this
should work on Unix too as long as ODBC has been configured.  You will
also need to setup an odbc data source on the client that points to your
Access database. In this program that is call "SOSHIP" and is referenced
in the MDB.CONNECT subroutine.  Sorry I don't have an example of that, but
if you have trouble post back an I will dig in some more.

Vertis is the premier provider of targeted advertising, media, and
marketing services that drive consumers to marketers more effectively.

"The more they complicate the plumbing
 the easier it is to stop up the drain"

- Montgomery Scott NCC-1701


-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 9:33 AM
To: [EMAIL PROTECTED]
Subject: [U2] connect to an access database

Hello all,

Is anyone familiar with a way to connect an MVBasic app to an access
database
or datasource ?
I need to be able to read/ write to/from a specifiac datasource. Is there
a
way I can connect from within a UV app to another datasource via ODBC ?
Any
transport will do really.
I was thinking of writing an outside app to do the data connection to
pass
and retr for the uvapp but if theres a more direct approach from the MVApp
itself, I'm wide open to suggestions.

Thanks in advance,
Vance
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

[demime 1.01d removed an attachment of type application/octet-stream which had a name 
of ACCESS DATABASE CODE]
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] connect to an access database

Reply via email to