danseagrave
Posts: 4
|
Posted: 06/29/2007, 2:47 AM |
|
Hello,
This is my first time using codecharge for a asp.net project (i've used codecharge for ASP3 before and dotnet for desktop apps)
I've got an interesting error here. I've got two machines
1. dev + web server (IIS, ASPNET 2)
2. database server (MSSQL)
codecharge 3 running on the dev machine and connects (using an SQL user, not windows auth.) to the db server.
In the IDE the connection is fine
when the site is published ASP gives a error:
Quote :[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
It is being thrown in the GetResultSet() method forthe gids DataProvider
Quote :
Line 265:'After execute Select @2-B6207104
Line 266: If Not IsNothing(E) Then Throw E
Line 267: End Try
I've checked the web.config file and the connection string has got the correct userid and password.
Any ideas why the connection works in the IDE but not on the published site?
|
|
|
|