« GRITZ Home | Email msg. | Reply to msg. | Post new | Board info. Previous | Home | Next

Re: Recommended: SQL for Data Analytics - Learn SQL in 4 Hours (free). Plus thanks to Zim! 

By: Zimbler0 in GRITZ | Recommend this post (1)
Tue, 20 May 25 7:08 AM | 7 view(s)
Boardmark this board | Grits Breakfast of Champeens!
Msg. 08571 of 08578
(This msg. is a reply to 08567 by Fiz)

Jump:
Jump to board:
Jump to msg. #

Fiz > The server was successfully moved to Linux on Friday.


Very very Interesting.
Is the data kept in Microsoft Sequel Server?

My first thought was Sequel Server won't run under Linux . . . but apparently it does.

http://community.ptc.com/t5/Windchill/ms-sequel-server-on-Linux/td-p/876065

Microsoft Access does NOT run under Linux . . . Although this next site claims it can.

http://thelinuxcode.com/install-microsoft-office-linux/
(I do have doubts.)

I have limited database experience so . . . But my first thought here would be to skip Access and go right into the Sequel server and writing SQL queries directly. (If the eventual goal is to be writing C code to access the data in the SQL Server.)

There also seems to be more than a few SQL tutorials available on line.

Hmmmmm
>>>
C / C++ ODBC example application accesses a SQL database

http://learn.microsoft.com/en-us/sql/connect/odbc/cpp-code-example-app-connect-access-sql-db?view=sql-server-ver16
>>>

Looks like 'Geek' to me.

Zim.




Avatar

Mad Poet Strikes Again.




» You can also:
- - - - -
The above is a reply to the following message:
Re: Recommended: SQL for Data Analytics - Learn SQL in 4 Hours (free). Plus thanks to Zim!
By: Fiz
in GRITZ
Tue, 20 May 25 3:28 AM
Msg. 08567 of 08578

Zim: Does 'ODBC' ring any bells?

I knew the acronym but not the actual meaning: "Open Database Connectivity is a standard application programming interface for accessing database management systems." Thanks for asking, as it got me to look it up and learn that it is an OPEN standard.

The original plan was for me to use Access to start off with and, later, learn more about written SQL and, eventually, programming ... probably in C#. Since I got behind, I decided to jump ahead into the SQL with the hope it will make the whole thing more motivating to me. We will see how that goes.

The bigger plan is more grandiose: get off of Windows Server and Windows as a client, and go to Linux as a server...and eventually re-write the client software to run all on Linux. The server was successfully moved to Linux on Friday. The next steps are up to me. I haven't programmed in more than 30 years, and have almost no experience with SQL, so I am a little ADHD/anxious now. ;->


« GRITZ Home | Email msg. | Reply to msg. | Post new | Board info. Previous | Home | Next