From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

SQL dbase

Hi!

I have a problem using the SQL toolkit with the dbase driver.
I can only give the column a name of 10 characters.
Does anyone know how to change this?

Is there another free database that is better to use?

Thanks

Per
0 Kudos
Message 1 of 4
(2,645 Views)
Last I heard, dBase wasn't a free product. If you're talking about the example
.dbv files that come with the SQL toolkit, then I'm not surprised that there
are some limitations since theexamples are pretty old. Remember that you
get what you pay for. We used to use Access because it was cheap. Once we
got more than a half dozen computers trying to write to the database at the
same time though, I had to spend most of my time just maintaining the database.
We moved to SQL Server, have over 50 computers writing, and I spend almost
no time on maintenance.

"møller" wrote:
>Hi!>>I have a problem using the SQL toolkit with the dbase driver.>I can
only give the column a name of 10 characters.>Does anyone know how to change
this?>>Is there another fre
e database that is better to use?>>Thanks>>Per>>
0 Kudos
Message 2 of 4
(2,645 Views)
This should not be a LabVIEW limitation, I have used column names longer
than 10 chars with SQL toolkit. May depend on what database you are
using and its ODBC driver.

If your wanting free then use Java, all is free, SQL is available free
as well.

Jim

"møller" wrote:

> Hi!
>
> I have a problem using the SQL toolkit with the dbase driver.
> I can only give the column a name of 10 characters.
> Does anyone know how to change this?
>
> Is there another free database that is better to use?
>
> Thanks
>
> Per
0 Kudos
Message 3 of 4
(2,645 Views)
There are several free SQL databases. We keep a list at
http://ourworld.compuserve.com/homepages/OCELOTSQL/sites.htm
Peter Gulutzan
Ocelot Computer Services Inc.


Sent via Deja.com
http://www.deja.com/
0 Kudos
Message 4 of 4
(2,645 Views)