| :: error trying to run reports :: (6) | Post a New Message | Post a Reply |
 error trying to run reports | Post a Reply |
since: May 1, 2005
from: somewhere
I've looked through the setup pages and advice on the forum. The database is working with an asp based program but I have checked the name passwords etc but cannot get past this error.
Errors Occured!
Error #:-2147467259
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
I'm using
<%
'TODO: Change the constants below to reflect your database settings
Const SERVER_NAME = "(local)"
Const DATABASE_NAME = "mydbasename"
Const USER_NAME = "sa"
Const PASSWORD = "mypassword"
'declare your variables
Dim objWiz, strConnectionString
'initialize your variables
strConnectionString = "Provider=MSDASQL;Driver={SQL Server};"& _
"Server= "& SERVER_NAME & ";Database= "& DATABASE_NAME & ";"& _
"User ID= "& USER_NAME & ";Password= "& PASSWORD & ";"
Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")
'Make sure you initialize before adding any HTML text
objWiz.Init(strConnectionString)
'put this where you want your reports
objWiz.DisplayReports
Set objWiz = Nothing
%>
thoughts?? Sorry but I'm kinda new to this as you've gathered.
 Re: error trying to run reports | Post a Reply |
from: Washington, DC
Check this article from Microsoft
http://support.microsoft.com/default.aspx?scid=kb;en-us;328306
-------------------------
Ghost
| Re: error trying to run reports | Post a Reply |
from: Laurel, MD
-------------------------
Master of the Game
| Re: error trying to run reports | Post a Reply |
since: May 1, 2005
from: somewhere
thanks for the response - the more i dig into this site the more I'm convinced that this program is the solution for me.
I am still having an issue connecting however. The application I am using accesses the database fine so clearly its me. However the support for the product is intermittant hence trying asp report wizard. So.... back on the newbie bit is there a way I can check the server name? Possibly change it? The database name is fine as is the login and password and the server name is the only bit of uncertainty.
| Re: error trying to run reports | Post a Reply |
since: May 1, 2005
from: somewhere
| Re: error trying to run reports | Post a Reply |
from: Washington, DC
You can check it by right-clicking on My Computer icon then select Network Identification (in Win2k or Computer Name in XP).
The server name will be the first part of the full computer name
-------------------------
Ghost