Configuration :: Incorrect Log On Parameter On Static Ip Server?
Aug 7, 2010
i am developing a crystal report in my asp.net site with MS SQL7.0 backend the problem is that when i m using it in lan from my pc it is working but when i deploy it on server having statc ip creystal report is not opening following error occured.
Logon failed. Details: ADO Error Code: 0x Source: Microsoft OLE DB Provider for SQL Server Description: Invalid authorization specification SQL State: 28000 Error in File C:WINDOWSTEMP ptQuotation {25579341-6096-4C84-91C5-6571EBC8991F}.rpt: Unable to connect: incorrect log on parameters.
I'm using this code... What I want to do is to insert values from a table to another, but I want the user to decide from which server, database and table....
My custome ControllerFactory controllerName is passed an Action name and not the only Controller in my application. Where or how can I correct this so my Controller name, SearchMembers, is passed in and not the Action name of that method, Search.
I have a crystal report using store procedure with DSN Name: 192.168.0.3. when I keep the connection to this server it's OK
But when i change the logon info and disconnect to the server to connect to My PC it appear the error : "Unable to connect: Incorrect log on parameter"
I am working with a sql server database with about 50 stored procedures. The database and stored procedureswere not created by me. The stored procedures all begin with a number in their name.
Example: 17P_Comsetter
The problem I am having is that if I try and execute the stored procedure at the command line in Query Analyzer,the query analyzer appears not to like that the stored procedure begins with a number. For example:
If I try an run the stored procedure as follows:
EXEC 17P_Comsetter
Then I get the following error message:
Msg 102, ..... Incorrect Syntax near '17'
I am using SQL server 2005. Does anyone know why I am getting this error message?
I have ajax control toolkit in bin folder ,i have win 7 inmy system but still i m getting this error ..
Could not load file or assembly 'AjaxControlToolkit' or one of its dependencies. The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG))
I am using VWDExpress 2010 to create my application, now i have a hosting account on Godaddy, now my requirement is to upload the DB's in my project on the server at godaddy. A useful link for the same is provided here
[URL]
Now my problem is after I do all of the above ie create the test.sql file and try to upload it on the server, the query analyzer at godaddy gives me an error saying "INCORRECT SYNTAX NEAR GO" ,"INCORRECT SYNTAX NEAR IF EXISTS" ,INCORRECT SYNTAX NEAR )" ,etc
Now I am using sqlserver 2008 while the server on godaddy is sqlserver 2005.
I just want the url /style/style.css to point to another static file on the webserver..
I'm getting this error:
There is no build provider registered for the extension '.css'. You can register one in the <compilation><buildProviders> section in machine.config or web.config. Make sure is has a BuildProviderAppliesToAttribute attribute which includes the value 'Web' or 'All'.
my asp.net app uses dynamic stylesheets. so each of my pages uses a pre_init method to load the relevant stylesheet. the stylesheet is the same for ALL users of the app.for each page load, i don't want to query the database to determine which stylesheet to use. therefore, I simply load the stylesheet from a STATIC variable that I store when the app starts.
works fine locally. however, on the production server the STATIC variable is reset to Null after about 5 minutes. why is that?? is there a better way for me to handle this? Should I change something in IIS? Should I change the methodolgoy I am using to retreive the stylesheet?
I am building a web application that will not only require a standard user/pass authentication, but users will need to reside at certain locations to authenticate. My initial thought is to have those locations set up with static ips, that I can look for in the request for authentication. I am mostly a programmer and not an expert in http and iis. I am hoping to get some good advice as to what the pros and cons to this approach will be. Also, VPN to the web server is not an option. This web application will be exposed to the web.
Does precompilation have any effect on XML files? i.e. can I obscure/protect xml files using precompilation? I assume that it has no effect as they aren't code.
If I use XML files as Embedded Resources, they appear in the DLL in a text editor as normal text. If the dll is edited and saved using a text editor, will it still work if it is unsigned?
I have a UDF called Split which accepts a comma separated list and returns a table variable splitting the values in a row. So for ex if I call the function
Select * From dbo.Split('100,287,312', ',')
The output of this query will be
ID-----Value 1------100 2------287 3------312
Now I am trying to use cross apply to return each row for each csv but I am getting an error Line 3: Incorrect syntax near 'apply'.
Here is my query
select c.course_id, c.course_title, b.* from course c cross apply dbo.[Split](c.foreign_lang_equiv_course_id, ',') As b
Now, I want to select all unique locationid's from a single username, its important that the results can be PAGED and SORTED, I now have:
SELECT * FROM (select ROW_NUMBER() OVER (ORDER BY createdate) as RowNum, distinct(locationid), l.* FROM location_views lv INNER JOIN locations l on l.id=lv.locationid where lv.username='myname@hotmail.com' ) as info WHERE RowNum > 0 AND RowNum <= 100
But this throws the error: "Incorrect syntax near the keyword 'distinct'."
On one server, everything works. I am attempting to call a C++ assembly from C#/ASP.NET application.
When I deploy the web application in another server, it fails with the error message:
"The application has failed to start because its side-by-side configuration is incorrect" I have copied the dll into the correct folder which has permissions for the user and the application pool identity. The path has been added in the PATH variable. The DLL is fine and is not dependent on any other DLL.
The layout of my web app is C:inetpubwwwroot<sln folder><web app folder>. So the image folder in my web app would be the previous path images.
When I try to save to my images folder from a FileUpload control and use Server.MapPath, it drops my <sln folder>, so the path is incorrect. How do I fix this? I figured Server.MapPath just moved up the folder until it hit a drive, no?
We had a simple Gridview that displayed a column list as Linkbuttons but we now need to display three columns as one, so I wrote a simple stored procedure to do it. However, the output in the Gridview shows duplicates and is not in order even though I specifySELECT DISTINCT in the result select as shown below.
ALTER PROCEDURE [dbo].[GetGeneralAction] Add the parameters for the stored procedure here AS BEGIN SET NOCOUNT ON; CREATE TABLE #TempTbl (GeneralAction varchar(300) ) INSERT INTO #TempTbl (GeneralAction) SELECT [General Action] FROM [dbo].[Formulary2011] INSERT INTO #TempTbl (GeneralAction) SELECT [General Action2] FROM [dbo].[Formulary2011] [code]...
