Sign in to follow this  
Followers 0
EKY32

~ Is it possible to connect to a remote Database?

4 posts in this topic

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



I have a local server using AppServ v2.6.0,

Posted Image

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.


[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

#3 ·  Posted (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 by Manadar

Share this post


Link to post
Share on other sites

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0