SQL query help with DB Toolkit

[BadAzzS10]

All,

Could use your help. Labview 2009.

I am connecting to my SQL Server database (SQL 2005) using the DB Connectivity Toolkit. I'm trying to return the actual users name from the SQL server based on their employee number. The APP node returns the users employee number.  I seem to error out when I get to the Execute VI and I'm not sure why.

Any help will be greatly appreciated.

[Ray.R]

silly prelimionary question:  Did you configure access to the database for the development PC?

[BadAzzS10]

I have.

[Yamaeda]

The conversion from variant looks fishy, might it be there it genererates an error?

If you only want 1 name, i'd simply do an index array on the database answer, then the same Varitant to string.

/Y

[BadAzzS10]

You'd be correct on it generates the error on the Database Variant to Data VI.

I've made the changes and it now runs, but I return shapes instead of words now.

The column I'm looking for is the third column in my SQL table.

Sorry about the questions. Still learning.

[BadAzzS10]

This might help...

[Ray.R]

After fetching the database you build an array.  Is it not already a 2D array?

Then you cast it to variant.  Was it not already variant?

Then you convert the "thing"/variant-thing to string.

You may have too many steps..