Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL Hosting connection question

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-27 : 23:29:22
Chris writes "I use a DSN-less connection string to connect to a SQL database from within my Visual FoxPro application. Using the connection, i can post data from my Fox tables into SQL - no problem. The SQL database resides on the same PC as my VFP app.

Now, i need to find a SQL / NT / ASP hosting company where i can setup my SQL database and do the same so that the data can be viewed from their website via ASP pages. My users will not be hosting their own site. A host company will be used. The connection string in VFP is very similar to whats used in ASP:

lcConnStr = "DRIVER=SQL Server;SERVER=MyServ;DATABASE=MyDb;uid=MyUser;pwd=MyPw"
lnConnection = SQLSTRINGCONNECT(lcConnStr)

And now the question...

I had been emailing hosting companies, and they tell me that i cannot use a DSN-less connection string from an "external application". What gives? Whats the alternative?"
   

- Advertisement -