MySql Database and FP The final Answer (Full Version)

All Forums >> [Web Development] >> ASP and Database

Message

---

REPOMAN -> MySql Database and FP The final Answer (12/14/2004 12:31:17) FP 2003 XP Pro Linux Server MySql ======== Hello All I have been reading the posts on the forms and cant seem to get the info needed.. Is it possible to connect DRW in FP2003 to the MySql Database? If so How? Must it be done with ASP pages? Is there a walkthur? Please help me out, The other posts get so close to the answer....Then No reply... Thanks for any help!

---

Spooky -> RE: MySql Database and FP The final Answer (12/14/2004 14:35:37) Sure is ;-) Ive only tried it with a myODBC connector as a DSN, and only for display purposes so far. Make sure you have a DSN set up, and add it as a database connection. Tools > site settings > database > add > System Data Source Now, if the connection is correct, then when you insert a database using the normal methods, you can query a MySQL database

---

Spooky -> RE: MySql Database and FP The final Answer (12/14/2004 14:39:38) btw - if its on a different server, then you may need to set up a DSNless connection using the host supplied details This may require you manually set up a DSNless conenction in the global.asa file, as it seems the only network databases are SQL and Oracle via the database connection setup. A connection would look like : Application("Database1_Connectionstring") = "DRIVER={MySQL ODBC 3.51 Driver};Server=IPADDRESS;Port=3306;Option=16384;Stmt=;Database=XXXXXXXX;Uid=XXXXXX;Pwd=XXXXXX"

---

Page: [1]

Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

6.445313E-02