Can't Access to sql database on another site.

[BarrMan]

Hi, I have a problem reading from the sql database on a site i got access to.
this is my code:
con.open "PROVIDER=SQLOLEDB;DATA SOURCE=mysql2.siteam.co.il;UID=hoops_****;PWD=*****;DATABASE=hoops_db1"
the site which reads from this database is fine but when i'm trying to read from it in my localhost i get this error:
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/hoops.co.il/includs/DBcon.asp, line 6

Can anyone help me please?

[jskaar]

Has localhost got access to this site? Perhaps is the other site (the one that works) granted access and not your local ip.

[BarrMan]

Has localhost got access to this site? Perhaps is the other site (the one that works) granted access and not your local ip.

How can i make my localhost to have access to this site's database?

[BarrMan]

.
.....

[ghell]

Yea "..." indeed..


Out of curiosity.. if its mysql why are you using the oledb provider (oledb is a microsoft provider and will likely not work with mysql.).. at the moment it is most likely trying to connect to mysql2.siteam.co.il,1433 as that is the default microsoft sql server port. if you try telnet that you see that you cant connect.

try setting up an ODBC link and doing a test connection then using a dsn connection from the page after that test has worked.

[BarrMan]

How can i do that? can we talk instantly please? my msn is emree3@gmail.com. Thanks.

[degsy]

Have you even asked your host if remote connections are allowed?

I would suspect that the only connections allowed would be from a domain on the companies servers.

[BarrMan]

degsy do you have msn? or aim? or anything else? i really need to talk instantly cuz this could take years untill i'll know what i really need to do...

and for your question... maybe i can't... but what i really wanna do is read from the sql database in my computer (localhost) and start working on the site... i can download the sql file but i really don't know how to read from it...

Thank you for your help and please if you can help me instantly. Thanks!

[degsy]

No I do not use Instant Messaging.

First, ask your host what options you have to export your database.
You are using MS SQL Server. Correct?

You can install it to your own PC
http://msdn.microsoft.com/vstudio/express/sql/download/

[BarrMan]

What do you mean by "what option to export"?

[degsy]

If you don't know then go back to basics. Get a book and start learning.

[BarrMan]

Ok, What book? what subject should i learn?

[degsy]

I learnt using w3Schools, ASPFAQ and Dreamweaver.
You can google for specifics.