EKY32 20 Posted August 19, 2012 Is it available to connect to a database on a remote online server and get data from it?I saw this but I'm not sure it's really what I want, is it?Thank you. [font="'trebuchet ms', helvetica, sans-serif;"]Please mark the answer of your question if you found it.[/font] Share this post Link to post Share on other sites
EKY32 20 Posted August 20, 2012 I have a local server using AppServ v2.6.0,I tried all the ways to connect starting with _sql_Connect(-1,"localhost","","root","toor"), the username and password are correct and i just have a connection error:err.description is: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.err.windescription: Unspecified errorerr.number is: 80020009err.lastdllerror is: 0err.scriptline is: 220err.source is: Microsoft OLE DB Provider for ODBC DriversWhere is the error?Thank you. [font="'trebuchet ms', helvetica, sans-serif;"]Please mark the answer of your question if you found it.[/font] Share this post Link to post Share on other sites
jvanegmond 306 Posted August 20, 2012 (edited) You're using the library for the Microsoft SQL server. Your SQL server is of the MySQL variant. These are not compatible.Try or Edited August 20, 2012 by Manadar github.com/jvanegmond Share this post Link to post Share on other sites
EKY32 20 Posted August 20, 2012 Ah thank you Mr.Manadar, can i connect to remote database and query it? like my forum's database? is this possible somehow?Thank you. [font="'trebuchet ms', helvetica, sans-serif;"]Please mark the answer of your question if you found it.[/font] Share this post Link to post Share on other sites