|
I have been given a project to create a web analytic program. Can anyone tell me where I could find appropriate materials for having a head start in the project. Websites or Books that would let start of something.
|
|
|
|
|
|
I have design a web application in ASP.NET2.0 and using SQLserver2005. when I m going to configure this application on IIS server , its working fine and coming data from data base on my system.
But whenever I am going to configure(or deploy)on IIS this application on client system.
Getting Message : can not open database "Name" requested by the login. The login failed. Login failed for user 'XP\IUser.
Client system having : VS.NET2.0 and SQLSERVER\EXPRESS .
Vinay
|
|
|
|
|
|
Checked every thing is right as well as in connection String ! but still not working
Vinay
|
|
|
|
|
Maybe you could post your connection string?
|
|
|
|
|
hiiiiii to all
please help me out to give websites name from where we can find out at least 10 page in a single websites templates
rizvan sivally
|
|
|
|
|
I would suggest a quick search in your favorite internet search engine that can help you with the results more fast.
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
The woods are lovely, dark and deep,
But I have promises to keep,
And miles to go before I sleep,
And miles to go before I sleep!
|
|
|
|
|
I need to get real time data from indian stocks market for a project requirement . Can u suggest me a link where i can fetch the real time data every 1 or 2 sec .
|
|
|
|
|
Have you tried google?
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
You may find some public source providing delayed data, but if you want it real time up to the second then I am afraid you'll have to pay and pay a lot. The biggest income for exchanges is the market data and they don't give the live prices away. I know this as it is a cornerstone of my company's business; we sell enriched market data at around £1,000 per exchange per person per month.
Panic, Chaos, Destruction.
My work here is done.
|
|
|
|
|
I've been charged with the fun task of going through all our existing web applications and seeing how they behave under IE8 (XP, not Vista), with and without compatibility mode. The latest oddity has me baffled, and I wonder if anyone can give me any hints as to where to look.
I'll spare you the code (there's a lot of it), but this component has a SELECT, size=10, with about 3000-odd options: it's a list of names. Below it is an input type=text with a JS function attached to an onKeydown that tries to move to the appropriate name in the list depending on what you type in the box: type a W, it moves to the first W in the list of names, and so on.
It works. There's a lot of code there, but it works.
The problem is that if I'm in IE8, without compatibility mode, and the account I use to log into that PC has Administrator access, it still works, but S-L-O-W-L-Y. Get rid of administrator access, and it's back to full speed. Use compatibility mode, it's back to full speed.
I can only assume that when the user has admin access, the JS is doing something in addition to the norm, somewhere. I can't imagine what - I dread to think what! Has anyone seen anything like this before? I'll go through building the code up from the basics and seeing which command has the delay if I have to, but it's going to be a big job.
By the way, the application in question is used almost exclusively by our IT support team, so asking them to do without their administrator accounts will not be a popular answer.
|
|
|
|
|
Can you not use the debugger built in to IE8 to find out which code is taking the time? It'll be easier than building the code up.
|
|
|
|
|
You can tell I'm new to IE8, can't you? I'd overlooked that completely. I'll go and find out about the debugger and how to use it, I'm sure Google will show up a tutorial or two. Thanks!
|
|
|
|
|
Hit F12 from within your IE and it should fire open the debugger for you to go and get started with the pearl-diving venture.
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
The woods are lovely, dark and deep,
But I have promises to keep,
And miles to go before I sleep,
And miles to go before I sleep!
|
|
|
|
|
"Pearl-diving" - what a lovely way of putting it! Thanks, as soon as I'm released from fire-fighting I'll go and do that.
|
|
|
|
|
Hi..
My web application is in Visual studio 2005 asp.net/c#.
I have sql server 2005 database at back end.
When run the project in visual studio my application connects with the database, but i have configured the website in local IIS, the website runs but it does not connect to the database.
I am getting following error:
Cannot open database "db1" requested by the login. The login failed.
Login failed for user 'HEM-BE419D4FB41\ASPNET'
I am using Windows authentication to connect to sql server.
my connection string is as follows
"Data Source=HEM-BE419D4FB41;Initial Catalog=db1;Integrated Security=True"
Please tell me the solution
thanks,
Hemant Thaker
By:
Hemant Thaker
|
|
|
|
|
In IIS, untick Anonymous access and check integrated windows authentication in the Directory Security tab.
|
|
|
|
|
Hi...
thanks for the response...
I have same project in two machines. one has sql server 2005 and the other has sql server express.
It works fine where i have Sql server 2005 but not in other.
what happens is.. when i browse my website from IIS it prompts me to auto generated login screen with heading "connect to XPW(machine_name)" with username and pwd...so whats going on can u tell me.
i could connect to database by doing some changes like...
identity impersonate=true,
IIS virtual directory -> security -> windows authentication ...
etc... etc...
so it works fine in that particular machine, and the other has the same settings...
the difference is only the edition of sqlserver/ express....
so why it gives me the prompt for login...
plz help me out
thanks,
hemant
By:
Hemant Thaker
|
|
|
|
|
Also make sure you have your web.config set up to use windows authentication and not forms auth.
|
|
|
|
|
Hi...
thanks for the response...
I have same project in two machines. one has sql server 2005 and the other has sql server express.
It works fine where i have Sql server 2005 but not in other.
what happens is.. when i browse my website from IIS it prompts me to auto generated login screen with heading "connect to XPW(machine_name)" with username and pwd...so whats going on can u tell me.
i could connect to database by doing some changes like...
identity impersonate=true,
IIS virtual directory -> security -> windows authentication ...
etc... etc...
so it works fine in that particular machine, and the other has the same settings...
the difference is only the edition of sqlserver/ express....
so why it gives me the prompt for login...
plz help me out
thanks,
hemant
By:
Hemant Thaker
|
|
|
|
|
Just add a new User for
HEM-BE419D4FB41\ASPNET
on the database db1.
If there is no Login created for ASPNET user in your current database instance, you need to create a login account as well.
|
|
|
|
|
Hi...
thanks for the response...
I have same project in two machines. one has sql server 2005 and the other has sql server express.
It works fine where i have Sql server 2005 but not in other.
what happens is.. when i browse my website from IIS it prompts me to auto generated login screen with heading "connect to XPW(machine_name)" with username and pwd...so whats going on can u tell me.
i could connect to database by doing some changes like...
identity impersonate=true,
IIS virtual directory -> security -> windows authentication ...
etc... etc...
so it works fine in that particular machine, and the other has the same settings...
the difference is only the edition of sqlserver/ express....
so why it gives me the prompt for login...
plz help me out
thanks,
hemant
By:
Hemant Thaker
|
|
|
|
|
Hi...
As u said, was right but was not getting my way out creating users and logins.I did search something and its like as follows
Enabling SQL Authentication
STEP1:
You need to enable SQL Authentication on the machine. This is complex in SQLExpress and you need to edit the registry. Copy the following lines of text onto a Notepad and save it with extention .REG.
-------------COPY BELOW---------------------------------
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer]
"LoginMode"=dword:00000002
-------------COPY TILL THIS---------------------------------
STEP2: Double Click on the .REG file to change the registry. This change the Authentication Mode to enable SQL Authentication.
STEP3: Restart the SQL Server Express Service or reboot the machine for registry change to take effect.
Next, you need to add a user with SQLLogin. To do this: Login to SQLExpress using Express Manager and run the script below:
-------------------------------------------
USE MASTER
sp_addLogin 'aspuser', 'aspuser@123'
GO
sp_addsrvrolemember 'aspuser', 'sysadmin'
GO
USE Cartridge
EXEC sp_adduser 'aspuser'
-------------------------------------------
In case you want to reduce the privilege for the user then you can specify something other than sysadmin, but we can think of that once this works.
Now change your connection string as follows:
connectionString = "server=.\\SQLExpress;uid=aspuser;pwd=aspuser@123;database=cartridge;";
////////////////////////////////////////
U may need to change connectionstring probably remove one '\' from server name
May be this can help someone...
thanks for ur support
Hemant
By:
Hemant Thaker
|
|
|
|
|
i want to call server side asp.net(vb) function from java script
how is that possible?
i really need it
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
