Sql Server Remote Connection Error

[sudheesh kumar s]

When I am trying to connect to a DB in the remote system from my VB6 Application I am getting the error " Runtime Error -2147467259(80004005)[Microsoft ODBC SQL Server Driver] [DatabaseName] SQL Server does not exist or access denied. " Pls Help its very urgent

[_Damian S_]

Well, the error pretty much says it all.

sudheesh kumar s wrote:

SQL Server does not exist or access denied.

Check that the SQL Server exists... do you have the name right? Check that if you have the name right, do you have permission to access it from your location?

I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! If you like cars, check out the Booger Mobile blog | If you feel generous - make a donation to Camp Quality!!

[sudheesh kumar s]

What all I have to check for access permissions. I am using an Online DB and my application is a Windows application in VB6. I have checked the remote connection property of my SQL Server and it is ok. Then i also checked the DB name and connection string (given by the hosting site) and found no errors. Can u pls help me to find out a solution. Thanks for your quick reply