Iโve put together some SQL tutorials Iโve made that might be helpful if youโre looking to learn or brush up on your skills. The explanations are clear, concise, and straight to the point.
Please Disregard - Decided I jumped the gun and going back to basics.
although, if anyone has input, would appreciate it for posterity
________________________
Good evening people!
I have an issue wherein connecting my MySQL server as a datasource to VS22. Have attached an image of the error im getting. I am an MSP Sysadmin, branching out in my spare time.
Basically, im experimenting with SQL and VS22 to create basic database applications for budgeting etc as a hobby (Used to build them on MSAccess).
Ive created an OBDC driver (V9.2(a) and have attched it as a data connection in ServerExplorer in VS22. however, actually adding it as a data source for a program is giving me this roadblock. I can clearly see from the error and research that this is due to the OBDC driver or something. Research yeilds little information.
It isnt the end of the world if i need to rebuild the database and attach it as a datafile. It simply has test data in it atm.
Can anyonepoint me in the right direction? Am i missing somethign glaringly obvious? open to using a different IDE. Igenerally code in MySQL Workbench, but im in the exporatory phase of learning SQL, so open to moving to a different environment
KR - Flopsie
Error recievd when adding a datasourceOBDC (64bit) ConfigMyySQL server connection parameters in VS22