EhostingBiz.com Screwed me

[DevGrp]

Ok, after slaving over this blogging engine that I have been creating for the past week, it has now come to my attention that MS SQL Server DB wont accept a Sql data provider. You have to use OleDb data provider which sucks since its a SQL Server DB.

You would think that they would support the data provider that is optimized for SQL Server. So after I uploaded my project, it started puking. Now I have to go and redo the whole project since I just messed it up when I tried to do a mass find and replace.

[J Staniforth]

Wont it??? What is preventing this?

[DevGrp]

Originally posted by J Staniforth
Wont it??? What is preventing this?

I dont know what they did to prevent this, but on their site, when I went to create the DB, it had these two connection strings to use
OLE DB connection string (DSNless Connection):
"Provider=SQLOLEDB;Data Source=SQL-Server-IP;User Id=DB_user_id;Password=Db_pwd;
Initial Catalog=Your_DB_Name;"

ODBC connection string (Requires a ODBC to be created first):
"DSN=ODBC_Name;User Id=DB_user_id;Password=Db_pwd;Initial Catalog=Your_DB_Name;"

There is none for the SQL data provider. I am going to call them later to find out what happened.

[Cander]

What happens when you try to use the SQLClient class?

[hellswraith]

I use www.ehostingbiz.com and I am pretty sure I am using the sql provider. I am using all the Sql data classes such as the SqlDataReader, and SqlConnection...etc..

I am also making use of the MS Data Access Block to access my stored procs and such.

Give me a while, and I will show you what I have through and email or pm.

[DevGrp]

Well, I dont what I'm doing wrong, but it just wont work when I use the SQLClient. I have a SQL Server DB at home, and everything work perfectly. All I did was just change the connection properties in the web.config file to match that of the my webhost and uploaded the project. When I browse to the project, the error I get is "usersql cant login. Now, I can connect to the DB with my user id and password and execute queries from Enterprise manager. So I dont know what the problem is.

I even dragged the table from the DB in server explorer and put the password in the connection string and it still did'nt work.

I had to change SQLClient to OleDB for it to work. All I did was just change everything from SQLClient to OleDB, and now everything works fine. The only other thing that I change was
the way that SQLClient(@) and OleDB(?) handles parameters.

Now everything is working, you can check it out here http://blog.pwc.com.

[DevGrp]

Originally posted by hellswraith
I use www.ehostingbiz.com and I am pretty sure I am using the sql provider. I am using all the Sql data classes such as the SqlDataReader, and SqlConnection...etc..

I am also making use of the MS Data Access Block to access my stored procs and such.

Give me a while, and I will show you what I have through and email or pm.

Hey hellswraith I would really appreciate that. Thanks

[hellswraith]

This is what I use for the connection string (of course you are going to have to put in your user id, password, initial catalog, and the correct data source ip):

connectionString = "data source=76.321.321.321;initial catalog=VXForums;persist security info=False;user id=********;Password=********;packet size=4096";

I had problems getting it all to work, but finally found the info in the www.webhost4life.com help area. (They are the same company I believe).

[DevGrp]

Originally posted by hellswraith
This is what I use for the connection string (of course you are going to have to put in your user id, password, initial catalog, and the correct data source ip):

connectionString = "data source=66.102.133.20;initial catalog=VXForums;persist security info=False;user id=********;Password=********;packet size=4096";

I had problems getting it all to work, but finally found the info in the www.webhost4life.com help area. (They are the same company I believe).

Ok, thanks I'll try that when I get home.

[J Staniforth]

Do they let yu host multiple domains from one account?