I know this is probably a very elementary question, but I am trying to create a table in my new sql server Database and the only thing I can assume is that you must create tables through web pages. I am trying to just connect to the database and I can't seem to do that. This is the error I am getting ADODB.Connection error '800a0e7a' Provider cannot be found. It may not be properly installed. /dbsetup.asp, line 15 And this is my code. Set objConn = Server.CreateObject("ADODB.Connection") set rstCreateTable=server.CreateObject("ADODB.Recordset") objConn.Open "Data Source=tcp:s03.Winhost.com;Provider=ADODB;Initial Catalog=****;User ID=****;Password=****;Integrated Security=False;" 'set cmd = server.createobject("ADODB.Command") rstCreateTable.Open "select * from customerinfo", objConn I copied the connection string from the control pannel and entered the "Provider=ADODB" information because I read on another site that this is required. What am I doing wrong here? Thanks Jen
Actually you can connect to our SQL 2008 server using SQL Server management Studio. Try looking at this kb article. http://support.Winhost.com/KB/a689/how-to-connect-to-sql-server-2008-using-sql-server.aspx
I am so sorry, but how do you get SQL Server management Studio? Is this software that I can download and use? Thanks!!!!! Jen
Yes you can download this free from Microsoft. Try looking at this link.. http://www.microsoft.com/express/database/
