Select Statement error with ODBC connection

Database
Highlighted
Enthusiast

Select Statement error with ODBC connection

Hi,

 

I'm doing a bit of revision in Teradata so I downloaded the Version 16.20.0.2 from the internet.

 

I already had the Northwind sample database that MS Access uses so I connected this ACCess DB as a new ODBC connection.

 

I went to run a simple query but I'm getting an error that's not very helpful as I'm pretty sure the syntax is right.

 

Can anyone suggest where I've got it wrong?

 

ThanksTera_Error.PNG

 

 

 

 

 

 

 

 

 


Accepted Solutions
Teradata Employee

Re: Select Statement error with ODBC connection

You are trying to run Teradata sql on an access database.

1 ACCEPTED SOLUTION
3 REPLIES
Teradata Employee

Re: Select Statement error with ODBC connection

You are trying to run Teradata sql on an access database.

Enthusiast

Re: Select Statement error with ODBC connection

Really?

 

Is ther e a Teradata sample database that I could use  instead?

 

If so, how do I connect that?

 

Thanks

Enthusiast

Re: Select Statement error with ODBC connection

Thanks, I'm downloading the Express version.

 

Appreciate your help!