Menu
News
All News
Dungeons & Dragons
Level Up: Advanced 5th Edition
Pathfinder
Starfinder
Warhammer
2d20 System
Year Zero Engine
Industry News
Reviews
Dragon Reflections
White Dwarf Reflections
Columns
Weekly Digests
Weekly News Digest
Freebies, Sales & Bundles
RPG Print News
RPG Crowdfunding News
Game Content
ENterplanetary DimENsions
Mythological Figures
Opinion
Worlds of Design
Peregrine's Nest
RPG Evolution
Other Columns
From the Freelancing Frontline
Monster ENcyclopedia
WotC/TSR Alumni Look Back
4 Hours w/RSD (Ryan Dancey)
The Road to 3E (Jonathan Tweet)
Greenwood's Realms (Ed Greenwood)
Drawmij's TSR (Jim Ward)
Community
Forums & Topics
Forum List
Latest Posts
Forum list
*Dungeons & Dragons
Level Up: Advanced 5th Edition
D&D Older Editions, OSR, & D&D Variants
*TTRPGs General
*Pathfinder & Starfinder
EN Publishing
*Geek Talk & Media
Search forums
Chat/Discord
Resources
Wiki
Pages
Latest activity
Media
New media
New comments
Search media
Downloads
Latest reviews
Search resources
EN Publishing
Store
EN5ider
Adventures in ZEITGEIST
Awfully Cheerful Engine
What's OLD is NEW
Judge Dredd & The Worlds Of 2000AD
War of the Burning Sky
Level Up: Advanced 5E
Events & Releases
Upcoming Events
Private Events
Featured Events
Socials!
EN Publishing
Twitter
BlueSky
Facebook
Instagram
EN World
BlueSky
YouTube
Facebook
Twitter
Twitch
Podcast
Features
Top 5 RPGs Compiled Charts 2004-Present
Adventure Game Industry Market Research Summary (RPGs) V1.0
Ryan Dancey: Acquiring TSR
Q&A With Gary Gygax
D&D Rules FAQs
TSR, WotC, & Paizo: A Comparative History
D&D Pronunciation Guide
Million Dollar TTRPG Kickstarters
Tabletop RPG Podcast Hall of Fame
Eric Noah's Unofficial D&D 3rd Edition News
D&D in the Mainstream
D&D & RPG History
About Morrus
Log in
Register
What's new
Search
Search
Search titles only
By:
Forums & Topics
Forum List
Latest Posts
Forum list
*Dungeons & Dragons
Level Up: Advanced 5th Edition
D&D Older Editions, OSR, & D&D Variants
*TTRPGs General
*Pathfinder & Starfinder
EN Publishing
*Geek Talk & Media
Search forums
Chat/Discord
Menu
Log in
Register
Install the app
Install
Upgrade your account to a Community Supporter account and remove most of the site ads.
Rocket your D&D 5E and Level Up: Advanced 5E games into space! Alpha Star Magazine Is Launching... Right Now!
Community
General Tabletop Discussion
*Geek Talk & Media
Andargor's SRD 3.5 XML and MySQL database
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Bad Paper" data-source="post: 2679187" data-attributes="member: 24674"><p><strong>Access</strong></p><p></p><p>that's easy.</p><p></p><p>1) Download and install MySQL</p><p>2) Download Andargor's database</p><p>3) In MySQL's command line client, tell it to Create Database DnD35;</p><p>4) In MySQL's command line client, tell it to \. <path to Andargor's huge SQL textfile here>;</p><p>5) Download and install MySQL Connector/ODBC</p><p>6) Configure the ODBC connector to point to MySQL's DnD35 database</p><p>7) In Access, create your 3.5 database</p><p>8) In Access, Get External Data - > Link Tables</p><p>9) In the dialog box, choose the drop-down menu of file type: ODBC Databases ()</p><p></p><p>from there, you can figure it out. You can instead choose to Import Tables in step 8, but then you wind up with duplicate data occupying like 60MB on your drive.</p><p></p><p>Also note the semicolon in steps 3 and 4. If you press enter before the semicolon, the client keeps prompting you until you give it that ;</p><p></p><p>I'm still a little fresh to the world of SQL, and I just wrote those steps from memory, so I may only be about 95% right, but it's close enough for jazz.</p><p></p><p>Oh! I almost forgot. When configuring the ODBC connector, note the defaults. They are not the same defaults that MySQL uses. When you install MySQL it assumes your account is root@localhost and you give it a password. The ODBC connector will call you ODBC@localhost and default to no password. Make sure that the ODBC agrees with the MySQL.</p><p></p><p>Also, for you Access users, did you know that when you switch back-and-forth between query design view and data view, that that button is actually a drop-down box that can also give you SQL view? This is how I started teaching myself SQL. <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f60e.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":cool:" title="Cool :cool:" data-smilie="6"data-shortname=":cool:" /></p></blockquote><p></p>
[QUOTE="Bad Paper, post: 2679187, member: 24674"] [b]Access[/b] that's easy. 1) Download and install MySQL 2) Download Andargor's database 3) In MySQL's command line client, tell it to Create Database DnD35; 4) In MySQL's command line client, tell it to \. <path to Andargor's huge SQL textfile here>; 5) Download and install MySQL Connector/ODBC 6) Configure the ODBC connector to point to MySQL's DnD35 database 7) In Access, create your 3.5 database 8) In Access, Get External Data - > Link Tables 9) In the dialog box, choose the drop-down menu of file type: ODBC Databases () from there, you can figure it out. You can instead choose to Import Tables in step 8, but then you wind up with duplicate data occupying like 60MB on your drive. Also note the semicolon in steps 3 and 4. If you press enter before the semicolon, the client keeps prompting you until you give it that ; I'm still a little fresh to the world of SQL, and I just wrote those steps from memory, so I may only be about 95% right, but it's close enough for jazz. Oh! I almost forgot. When configuring the ODBC connector, note the defaults. They are not the same defaults that MySQL uses. When you install MySQL it assumes your account is root@localhost and you give it a password. The ODBC connector will call you ODBC@localhost and default to no password. Make sure that the ODBC agrees with the MySQL. Also, for you Access users, did you know that when you switch back-and-forth between query design view and data view, that that button is actually a drop-down box that can also give you SQL view? This is how I started teaching myself SQL. :cool: [/QUOTE]
Insert quotes…
Verification
Post reply
Community
General Tabletop Discussion
*Geek Talk & Media
Andargor's SRD 3.5 XML and MySQL database
Top
