navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

MySql Database and FP The final Answer

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> MySql Database and FP The final Answer
Page: [1]
 
REPOMAN

 

Posts: 84
Joined: 1/31/2002
From: WESTMONT IL USA
Status: offline

 
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!

_____________________________

Robert
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
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

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)


(in reply to REPOMAN)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
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"

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)


(in reply to Spooky)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> MySql Database and FP The final Answer
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts