database connectivity

[Sam_Sharp]

---

@Yamaeda wrote:

Since it's the Execute query that generates the error i assume the question is somehow ill formed. Date, e.g. might be reserved and not allowed as column name. Try the query directly in the database before placing it in code.

/Y

---

Ah! Yes - I seem to remember that 'date' is a function in SQL - try escaping the time and date column names (e.g. with a tick ` or an apostrophe ' - I forget which)

[Matt14122017]

Hi Yamaeda,

I have run the query directly in the database and the query returns the right data.

regards

Matt

[Yamaeda]

---

@Sam_Sharp wrote:

---

---

Ah! Yes - I seem to remember that 'date' is a function in SQL - try escaping the time and date column names (e.g. with a tick ` or an apostrophe ' - I forget which)

---

If accessing Access or MSSQL it's often good to use [] around column names ( [date] ).

/Y

[Sam_Sharp]

---

@Matt14122017 wrote:

Hi Yamaeda,

I have run the query directly in the database and the query returns the right data.

regards

Matt

---

Then you need to tell us what the full error message is!!

[Matt14122017]

Hello Sam,

Here is the full message error.

regards

Matt

[Sam_Sharp]

Look at the query string in the error... you have your query in the box which ends with "ORDER BY time;" but then you concatenate "Pavilion (Retail)" at the end of it - which isn't a valid query.

[GUYFelix66]

How did you get your Amazon timestream to Connect to LabView Successfully? , Please help 

[Steffen01]

how about capital letters in the column names? Then you have to use " "  as in "Capital" otherwise Capital turns into capital, column does not exist

I made my software so it shows the actual string that goes into SQL, then I can copy paste that into SQL admin and run

[Yamaeda]

---

@Steffen01 wrote:

I made my software so it shows the actual string that goes into SQL, then I can copy paste that into SQL admin and run

---

That's a good way to test things manually before trusting the program. 🙂

[NIquist]

Note that the query issue is from an old 2018 thread that GUYFelix has resurrected.  He is only asking about connecting to Amazon.

@GUYFelix:  Adding to an old thread is confusing to the people that respond.  You are better off starting a new thread to ask your question.  😉