~ Is it possible to connect to a remote Database?

[EKY32]

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.

[EKY32]

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 error

err.number is: 80020009

err.lastdllerror is: 0

err.scriptline is: 220

err.source is: Microsoft OLE DB Provider for ODBC Drivers

Where is the error?

Thank you.

[jvanegmond]

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

[EKY32]

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.