For some reason this didn't end up in my reply to the email so I'm posting it again:
Yes, I did set the default database in the ODBC setup to AdventureWorks2012.
I finally got it working somewhat with the following script thanks to your suggestions. The only thing I wonder is if there is a faster way than to create each select statement individually. I'm not able to multi-select the database tables (seems like that would be a good enhancement), and SQL SELECT * FROM AdventureWorks2012.Person.* doesn't work either.
Since neither of those approaches worked I needed to select each Person table individually; I'd have to do the same for the Production.*, Purchasing.*, and Sales.* tables as well which could be somewhat time consuming.
Is there another way? Personally, I'd like to see a multi-select list for the Database Tables.
Thanks so much for your help!
If you would, and anyone in this community is invited as well, to connect with me on LinkedIn, you can do so at:
http://www.linkedin.com/in/frankjgalan
fgalan27@gmail.com (for purposes of LinkedIn connection only)
Code that Finally Worked! tyvm:
ODBC CONNECT TO AdventureWorks2012 (XUserId is AMFdaZFMXE, XPassword is ZNBDHZMGHKYYGDBGXJVB);
SQL SELECT *
FROM AdventureWorks2012.Person.Address;
SQL SELECT *
FROM AdventureWorks2012.Person.AddressType;
SQL SELECT *
FROM AdventureWorks2012.Person.BusinessEntity;
SQL SELECT *
FROM AdventureWorks2012.Person.BusinessEntityContact;
SQL SELECT *
FROM AdventureWorks2012.Person.ContactType;
SQL SELECT *
FROM AdventureWorks2012.Person.CountryRegion;
SQL SELECT *
FROM AdventureWorks2012.Person.EmailAddress;
SQL SELECT *
FROM AdventureWorks2012.Person.Password;
SQL SELECT *
FROM AdventureWorks2012.Person.Person;
SQL SELECT *
FROM AdventureWorks2012.Person.PersonPhone;
SQL SELECT *
FROM AdventureWorks2012.Person.PhoneNumberType;
SQL SELECT *
FROM AdventureWorks2012.Person.StateProvince;
