REM Project: SQLTest
REM Created: 11/9/2008 7:14:11 PM
REM
REM ***** Main Source File *****
REM
MySQL_Init
conn$ = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=http://www.mywebsite.com;DATABASE=civ3fi3_files;UID=civ3fi3_files;PASSWORD=thepassword;OPTION=3;"
meh = MySQL_SetConnection(conn$)
Results = MySQL_RunStatement("SELECT * FROM v11_member_profiles")
for i = 0 to Results
print MySQL_GetRowDataByColName(i, "MEMBER_NAME")
next i
print "Done"
wait key
I have the MySQL ODBC installed on my computer and it shows up, exactly as typed, in the Control Panel->Admin Tools.
The websites that everyone linked with the DLL were mostly down, so I used www.archive.org to hunt for it and somewhere on there is where I saw the Dec 2007 version, but it could have been someone just reposting the older version.
Edit: Before anyone asks, I have set up the sql server to allow remote connections, so it shouldn't be a localhost type problem