Other hosts connecting to sql

Hi!

Is it possible to connect other sites on other hosts to a discount asp SQL Server?

I have several clients that have sites scatered arround and i'm looking for a place to store all relavante data.

Thanks for the help!

Helder

 

Yea, there's no limitation on where the connection are coming from, so you shouldn't have any problems.

 

I thougt so... but the connection string isn't working.

I'm getting the error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Connection String:
"Data Source=tcp:esql2k801.discountasp.net;Initial Catalog=SQL2008_667775_heldrodb;User ID=SQL2008_667775_heldrodb_user;Password=******;"


What is missing?

 

The error you have is saying your application is not finding the data source or driver to connect. Is this error happening at another host or your account here?

If it's hosted here, have you tried the DSN-less connection? http://support.discountasp.net/KB/a...ng-dsn-less-connection.aspx?KBSearchID=119685

 

That's the point. I have several hosts that are not here...

 

Well the issue doesn't seem to be on DASPs side, but rather the other web host not having the right drivers to connect.

I'd probably have to recommend you check with the other hosts, as they might have different options for connecting to SQL servers.