gina
Posts: 4
|
| Posted: 05/30/2008, 3:20 PM |
|
Hi,
I have a Windows hosting plan with GoDaddy (ASP.Net 2.0/3.0/3.5 , IIS 6.0), and I just set up a SQL Server. The host name for the server is p3swhsql-v10.shr.phx3.secureserver.net
I created a new project in CodeCharge 4.0, selected the language to be ASP 3.0, and put in the properties for the database connection.
For the InternetDB connection, server tab, I selected these parameters:
Database: SQL Server
I then selected "Use Connection String", then clicked the "Build" button
For the OLE DB Provider(s), I selected "Microsoft OLE DB Privider for SQL Server"
For the Connection tab, for the server name, I entered:
p3swhsql-v10.shr.phx3.secureserver.net
I selected "Use a specific user name and password", and entered both of these (correctly, I checked a few times). Then I entered the name of the database server, and tested the connection. That is when I got this error.
Test connection failed because of an error in initializing provider [DBNETLIB][ConnectionOpen (Connect()).] SQL Server does not exist or access is denied.
I don't know what I'm doing wrong. Does anyone have any advice on how to connect to a SQL Server? I've worked with MySql and php with CodeCharge in the past, but am having trouble with this.
Thank you,
Gina
|
 |
 |
flipandboef
Posts: 107
|
| Posted: 07/02/2008, 2:50 PM |
|
Gina have you ever figured it out? I have the same issue...
|
|
|
|
|
