database connectivity without toolkit

[programmindragon]

Is it possible to connect to an SQL database without the database connectivity toolkit?  I've learned that I can create Excel reports without the report generation toolkit so I thought it might be possible?

[Wiebe@CARYA · Accepted solution]

"programmindragon" <x@no.email> wrote in message
news:1222726210026-784473@exchange.ni.com...
> Is it possible to connect to an SQL database without the database
connectivity toolkit?&nbsp; I've learned that I can create Excel reports
without the report generation toolkit so I thought it might be possible?

Sure, you could also use a free SQL toolkit: LabSQL. Both the DCT and LabSQL
are based on ADO ActiveX component, so you can also make something yourself.

Regards,

Wiebe.

[jcarmody]

I've used LabSQL and am pleased.  It doesn't have the bells & whistles of the toolkit, but it works well (if you're familiar with SQL).  You can see that LabSQL doesn't use a UDL file, but relies on a DSN.  That's not as convienient, I think.

 

jm 

PS - I didn't come up with that clever table name

[programmindragon]

Thank you both for your help.  I will give it a try.

[Neil.Pate]

You do not have to use DSN, you can wire in a connection string constant.

[jcarmody]

Perhaps that's even more convenient than a UDL.  I like it, thanks.

[programmindragon]

Thanks for that tip.  I'd rather use a connection string instead of a DSN.

[kavishiva]

kindly let me know where i can download labsql. The original link from travis is not working

[AeroSoul]

If original developer for this doesn't offer a link to a 22 year old tool, i doubt it would work anymore.

[kavishiva]

Fine is there any alternative to labsql ..like some other 3rd party tool