GotCommunityNet

Re: CSKDB.cmd can't access database

Afgooey — Fri, 04 Mar 2005 01:44:54 GMT

ok got it to work by doing it sll with SQL connection no windows authenticatino, and doing it as an upgrade. It is awesome, totally worth this pain. But... although I can get to it through explorer, the project won't build, it is missing

C:\Program Files\ASP.NET Starter Kits\ASP.NET Community Starter Kit (CSVS)\CommunityStarterKit\Engine\Framework\ContentPages\Controls\HtmlTextBox.cs(14): The type or namespace name 'HtmlTextBoxControls' does not exist in the class or namespace 'ASPNET.StarterKit.Communities' (are you missing an assembly reference?)

however the file is does exist and the namespace is ASPNET.StarterKit.Communities
above the namespace line says
[assembly:TagPrefix("HtmlTextBoxControls", "FTB")]

is this the assembly file I may be missing

this errer is for many different things, can't see them though they are there

thanks

Re: CSKDB.cmd can't access database

Afgooey — Thu, 03 Mar 2005 23:39:34 GMT

ok for some reason if I put in (local) instrad of localhost the script runs, but if I go to the site, I am getting an error saying, have no idea why this work, am just trying anything, and that worked for rainbow installer to see the database (but then it got stuck and can't find it again)

Could not find stored procedure 'Community_Custom_RedirectGetRedirectsForCommunity'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'Community_Custom_RedirectGetRedirectsForCommunity'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException: Could not find stored procedure 'Community_Custom_RedirectGetRedirectsForCommunity'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
System.Data.SqlClient.SqlCommand.ExecuteReader() +41
ASPNET.StarterKit.Communities.CustomRedirectUtility.GetCustomRedirectsFromDB() +191
ASPNET.StarterKit.Communities.CustomRedirectUtility.GetCustomRedirects() +104
ASPNET.StarterKit.Communities.CustomRedirectUtility.CalculateRedirects(String requestPath) +93
ASPNET.StarterKit.Communities.CommunitiesModule.Application_BeginRequest(Object source, EventArgs e) +257
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87

Re: CSKDB.cmd can't access database

Afgooey — Thu, 03 Mar 2005 21:39:51 GMT

by the way the error I get from the other starter kits when trying to find my database is

System.Exception: Unable to lookup local instances of SQL Server or MSDE
at InstallerActions.SQLSetup.GetInstances()
at InstallerActions.SelectDB.SelectDB_Load(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Re: CSKDB.cmd can't access database

Afgooey — Thu, 03 Mar 2005 21:36:12 GMT

this may be related to my problem. The installers for the Portal, the Reports and the Commerce start up kits can't find SQL Server either. There is something special in the installers for the Commerce Kit and the Issue Tracker Kit that can see my SQL Server.

I know nothing about SQL server, have used access and oracle before a little

Re: CSKDB.cmd can't access database

Afgooey — Thu, 03 Mar 2005 21:27:11 GMT

thanks, SQL server is running. I put in localhost for the IP address, I can ping myself, but not sure how to ping the server. I type

CSKDB.CMD localhost, CommunityStarterKit, sa, password

for the last 2 arguments I typed in sa, then the password I gave to SQL when setting up the SAPWD password. Not sure about this.

The nice install that cersion 1.0 has can find the SQL server no problem, so there's got to ba a way

How do I find out if SQL Server has a different port number?

Does a Database called CommunityStarterKit have to be created first?

Do I have to change the text in web.config to point to my machine and database first?

Why is SQL access better?

Re: CSKDB.cmd can't access database

Redd — Thu, 03 Mar 2005 16:32:45 GMT

The error claims that the SQL server doesn't exist. Most likely possibilities:

Make sure the SQL server is actually running.

You are using the wrong name or ip address for the SQL server. Open a command prompt and try to ping the server using the exact same name as you are using for the CSKDB.cmd parameter.

You may have a name resolution problem. Try using the IP address instead of the name, or add the name to your hosts file. If the SQL server is on a different machine make sure you can resolve the name. If DNS is being used for name resolution make sure the DNS server has an entry for the SQL server.

If the SQL server is using a different port # be sure to specify the port number with the name or IP address. MyServer:4001 for example.

The trtusted command file is only for use with trusted connections (windows security). I highly recommend you use SQL authentication and the standard command file if possible.

CSKDB.cmd can't access database

Afgooey — Thu, 03 Mar 2005 12:56:08 GMT

Hi, I can install and compile/run 1.0, but not the upgrade.

When I run the CSKDB.cmd I get an error
[DBNETLIB]SQL Server does not exist or access denied
[DBNETLIB]ConnectionOpen (Connect())

I have tried doing it with 1.1 following the standalone instructions, by copying files into the 1.0 installation and upgrading, and with using the newer file called CSKDBtrusted.CMD and everyway gives me the same error message. Any suggestions?