Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


How to access mysql db?

 
Logged in as: Guest
arrSession:exec spGetSession 2,2,66500
 Active Users: There are 0 members and 0 guests.
 Users viewing this topic: none
 

 

 
  
  Printable Version
All Forums >> [Scripting] >> WSH & Client Side VBScript >> How to access mysql db?
  Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!
Page: [1]
Login
Message << Older Topic   Newer Topic >>
 How to access mysql db? - 11/16/2008 11:15:18 PM   
  tinytim

 

Posts: 6
Score: 0
Joined: 11/16/2008
Status: offline
A working relative of mine has requested that I help her build a site to query one of her company's mysql databases. And then have the queried results display on a table.

Problem is I don't really have any experience with mysql and servers, excluding client which I know pretty well.

Right now I'm the closest thing they have to an IT joe. And I promised I'd help. So please. I'd really appreciate some help.
 
 
Post #: 1
 
 RE: How to access mysql db? - 11/17/2008 1:59:28 AM   
  ebgreen


Posts: 5251
Score: 31
Joined: 7/12/2005
Status: offline
Start by searching for some ADO examples. Then look at connectionstring.com to determine the connection string that you need to use. Once you establish the connection, the ADO is relatively database agnostic.

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to tinytim)
 
 
Post #: 2
 
 RE: How to access mysql db? - 11/18/2008 1:33:52 AM   
  tinytim

 

Posts: 6
Score: 0
Joined: 11/16/2008
Status: offline
Thanks ebgreen. I gave some of msdn's examples a quick browse the other day and it looks user friendly.

(in reply to ebgreen)
 
 
Post #: 3
 
 
 
  

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.
All Forums >> [Scripting] >> WSH & Client Side VBScript >> How to access mysql db? Page: [1]
Jump to:





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