Help Backup: net

Showing posts with label net. Show all posts

Wednesday, March 21, 2012

Hi Everybody, Sql Server 2005 SE installation problem

I faced the following problem while installing Sql Server 2005 SE

"Error 193 Installing .NET Framework 2.0" while installing Sql Server 2005

Please help me to proceed further

i have the same error. did you work around it?|||I am also having this problem. Has anyone else encountered this particular error?|||

Are there any log files created under:

%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG?

If so, you can start by looking at Summary.txt. It should give you some indication of which component failed. Then you should be able to delve into the specific log file of the failed component. If you'd like, zip up the LOG directory and send it to me and I'll have a look (jeff.papiez@.microsoft.com)

|||You can also try installing .NET Frameworks 2.0 directly by calling \Redist\2.0\dotnetfx.exe. This will give you the full UI installation of .NET Frameworks 2.0 which may have some better error messages.|||

Im having the same problem.

What to do ?

Thanks

|||

This might sound stupid but i copied the "SQL Server x86" folder from the DVD onto my local hard drive and ran the "\SQL Server x86\Servers\setup.exe" from the hard drive copy to install the server components. Lo and behold everything worked fine.

- faizelk

sql

Hi Everybody, Sql Server 2005 SE installation problem

I faced the following problem while installing Sql Server 2005 SE

"Error 193 Installing .NET Framework 2.0" while installing Sql Server 2005

Please help me to proceed further

i have the same error. did you work around it?|||I am also having this problem. Has anyone else encountered this particular error?|||

Are there any log files created under:

%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG?

Im having the same problem.

What to do ?

Thanks

|||

- faizelk

Hi Everybody, Sql Server 2005 SE installation problem

I faced the following problem while installing Sql Server 2005 SE

"Error 193 Installing .NET Framework 2.0" while installing Sql Server 2005

Please help me to proceed further

i have the same error. did you work around it?|||I am also having this problem. Has anyone else encountered this particular error?|||

Are there any log files created under:

%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG?

Im having the same problem.

What to do ?

Thanks

|||

- faizelk

Monday, March 19, 2012

hi all

http://groups.msn.com/-netusergroup
http://groups.msn.com/-netusergroup
Hi all its my .net user group all r welcome to join
this groups.And develop your skillsjinishivs wrote:

Quote:

Originally Posted by

http://groups.msn.com/-netusergroup
http://groups.msn.com/-netusergroup
>
>
Hi all its my .net user group all r welcome to join
this groups.And develop your skills

Poor grammar. Off-topic here. Redundant with the
microsoft.public.dotnet.* hierarchy of groups. Lame.|||On 10 Giu, 13:41, jinishivs <jinish...@.gmail.comwrote:

Quote:

Originally Posted by

Hi all its my .net user group all r welcome to join
this groups.And develop your skills

I don't want to sound rude, but I will join you group to develop my
skills in Sql Server after you develop yours in English.

Friday, March 9, 2012

help-for copying database

hi,
i m new 4 sql server.
i create one app. in asp.net.

i create one database in sql server.
now,
i want to make setup for my app.
so,
i want copy database and put on c:/.../wwwroot/app folder.

how can i do this?

one more things,
i create database using enterprise manager.
i want to see my database file.
where it is stored?

somebody help me.

it's urgent.
thanks in advance.Not a wise move but if you insist, right-click on the database from Ent Mgr and then click on the Data Files tab, you will find the path to your datbase file there. Next, click on the Transaction Log tab on you will find the path to your transaction log there; these are the two files that make an SQL database.

Wednesday, March 7, 2012

HELP: SqlCeConnection path error in .NET compact framework (Pocket PC Emulator)

Hi all,

I am trying to access my SQL Server database through SqlCeConnection:

cecon = new SqlCeConnection("Data Source=D:\\D_Drive\\csharppract\\nddbpda\\nddbpda\\nddbpdadatabase.sdf");
cecon.Open();

I am getting the following error:

System.Data.SqlServerCe.SqlCeException was unhandled
Message="The path is not valid. Check the directory for the database. [ Path = D:\\D_Drive\\csharppract\\nddbpda\\nddbpda\\nddbpdadatabase.sdf ]"
HResult=-2147467259
NativeError=25009
Source="SQL Server 2005 Mobile Edition ADO.NET Data Provider"
StackTrace:
at System.Data.SqlServerCe.SqlCeConnection.ProcessResults()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at nddbpda.frmCeMain.frmCeMain_Load()
at System.Windows.Forms.Form.OnLoad()
at System.Windows.Forms.Form._SetVisibleNotify()
at System.Windows.Forms.Control.set_Visible()
at System.Windows.Forms.Application.Run()
at nddbpda.Program.Main()

When I tried to get the path from which the database file is being accepted, I got a different path:

string path;
path = System.IO.Path.GetDirectoryName(
System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
MessageBox.Show(path);

This code gives me this path:

\Program Files\nddbpda

Then I changed the path in my connection string to this:

cecon = new SqlCeConnection("Data Source=\\Program Files\\nddbpda\\nddbpdadatabase.sdf");
cecon.Open();

When I ran my application it worked (virtually), but the database is not getting updated (for obvious reasons).

What should I do now to correct this?

Thanks in advance.

Saswata.

Did you ever find an answer to your problem? I am experiencing the very same thing.

If I reference a local sdf it works fine, but if I reference the sdf located on the CE device, I get the same error as you.
|||

Windows CE devices (including emulator – simulated device) don't support drive letters (see that "D:\" in the path above? That makes it invalid on CE), don't support relative paths (that is, all paths must be full and absolute) and can't see your desktop hard drive (not by drive letter anyway). Common way to get absolute path is to append database name to the path to the application itself as done above.

Naturally, database on desktop won’t be updated because device has no idea it even exists. It changes database on device file system and it’s up to you to copy changed database from device file system to desktop file system as needed.

Now to using database on device from desktop application: that won’t work because there’s no way to reference database on device in desktop application; device is not mapped as desktop file system. Active Sync explorer extension simply fakes it. Visual Studio does that via special remote provider which is not public. If you want to access database on device then copy it to local file system (e.g. using RAPI), access it, and then copy it back to device. See this.

|||

If u got any soln on above please share this wiht me

My ID is abhijeettidke@.gmail.com

Monday, February 27, 2012

HELP: SqlCeConnection path error in .NET compact framework (Pocket PC Emulator)

Hi all,

I am trying to access my SQL Server database through SqlCeConnection:

cecon = new SqlCeConnection("Data Source=D:\\D_Drive\\csharppract\\nddbpda\\nddbpda\\nddbpdadatabase.sdf");

cecon.Open();

I am getting the following error:

When I tried to get the path from which the database file is being accepted, I got a different path:

string path;

path = System.IO.Path.GetDirectoryName(

System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);

MessageBox.Show(path);

This code gives me this path:

\Program Files\nddbpda

Then I changed the path in my connection string to this:

cecon = new SqlCeConnection("Data Source=\\Program Files\\nddbpda\\nddbpdadatabase.sdf");

cecon.Open();

When I ran my application it worked (virtually), but the database is not getting updated (for obvious reasons).

What should I do now to correct this?

Thanks in advance.

Saswata.

Moving to SQL Server Compact Edition forum where it has got better chances of being answered.

-Thanks,

Mohit

|||You can only access files located on the emulator, not your local drives. You have to copy or create the sdf file in the emulator in the desired location. There is no C: drive or D: drive in the emulator, just a "\" root

HELP: SqlCeConnection path error in .NET compact framework (Pocket PC Emulator)

Hi all,

I am trying to access my SQL Server database through SqlCeConnection:

cecon = new SqlCeConnection("Data Source=D:\\D_Drive\\csharppract\\nddbpda\\nddbpda\\nddbpdadatabase.sdf");
cecon.Open();

I am getting the following error:

When I tried to get the path from which the database file is being accepted, I got a different path:

string path;
path = System.IO.Path.GetDirectoryName(
System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
MessageBox.Show(path);

This code gives me this path:

\Program Files\nddbpda

Then I changed the path in my connection string to this:

cecon = new SqlCeConnection("Data Source=\\Program Files\\nddbpda\\nddbpdadatabase.sdf");
cecon.Open();

When I ran my application it worked (virtually), but the database is not getting updated (for obvious reasons).

What should I do now to correct this?

Thanks in advance.

Saswata.

Did you ever find an answer to your problem? I am experiencing the very same thing.

If I reference a local sdf it works fine, but if I reference the sdf located on the CE device, I get the same error as you.
|||

|||

If u got any soln on above please share this wiht me

My ID is abhijeettidke@.gmail.com

Help: SQL 2000 connection error(.NET 2.0, VS 2005)

Moderated by XIII, please use a normal font size for better readability:

for some reason, my web application can not connect to my SQL 2000

my application is based on .net 2.0 (IIS 5.1) using vs 2005workstation does not install any sql serversql 2000 locates at the remote server.the sql server can be connected via vs environment (data connnection), therefore, i think the connection string, server name and instance name is correcti have tried all the solution i can find online, but it is not workingLocalSQLServer connection string has been removed in GobalSettingalso remove all default connection string in web.config (<clear />)aspnet_regsql can register the sql 2000 db successfulvs 2005 can access and display the data in sql 2000 quite wellhas been reboot lots of times.still bug out

any body have any idea? thanks, it already costs me the whole day

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Can you telnet to the remote server (test TCP/IP)? And how about "net use\\servername\IPC$" the remote server (test Named pipe)? You can take a look at this post:

http://forums.asp.net/thread/1266057.aspx

|||

Thank Jay,

I can telnet to the remote server. Actually, I think the connection to the remote server is correct (in VS 2005 environment the data can be display quite well), the only problem is .NET 2.0 always think the remote server is SQL 2005. I have removed the localSQLServer connection string in web.config file (<clear />) but still not working.

|||

Then how about force to use TCP/IP to connect? You can do this by usingtcp:myinstance,portas Data Source, where port is the tcp port used the SQL instance service. Actually there should be no difference when connect to SQL2005 or SQL2000, you can take a look at this article which shows how to place membership on SQL2000:

http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

Sunday, February 19, 2012

HELP: ASP.NET won''t connect to SQLexpress after deploying to IIS, try a lot of things...

Hello,

I have finish building my ASP.NET site using VS 2005 and it compile just fine. Than I try hosting it to the web via IIS v5.1 and I am getting permission error from SQL express.

I have posted a detail question in experts-exchange.com and since you need a user account to even view the thread, I have taken the liberty to save the thread as .html file and host it to my ISP site. You can see the detail problem I am having here: http://users.accesscomm.ca/mm/EEdetail.html

I am going to list out some stuff I have done:

1. I have two database that need access, the ASPNETDB.mdf for user login and another database (PhotoDataBase.mdf) to store information relating to the photo I uploaded to my ASP.NET site.

2. I have already follow this How to site: http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx and setup:
- TCP/IP enable, as shown here:
- I have started SQL Browser service
- The firewall part I am not so sure about. I am currently using Zonealarm....

3. I have installed SQL Server Management Studio Express(SSMSE) and attach the two database to it.

4. I have set SSMSE server properties to accept both SQL and window authentication.

5. I have made sure that both database "read only" setting to false

6. I have setup SQL login with User ID = SQLLOGIN

Here is the original connection in web.config:
<add name="ConnectionString"
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|Da

taDirectory|\PhotoDataBase.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />

and here is the new connection I just type in web.config that replace the original one:
<add name="ConnectionString"
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\PhotoDataBase.mdf; Server=MINGDESKTOP; Integrated Security=False; uid=SQLLOGIN; Password=XXXXXX;"
providerName="System.Data.SqlClient" />

and the error i get are the follow:

Server Error in '/' Application.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
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: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

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.

7. I did haven't done much to ASPNETDB.mdf yet and the error i get right now are the following:

___
Server Error in '/' Application.
Cannot open user default database. Login failed.
Login failed for user 'MINGDESKTOP\ASPNET'.
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: Cannot open user default database. Login failed.
Login failed for user 'MINGDESKTOP\ASPNET'.
__

Please help! I am really running out of ideas.... and I need to have this setup in a few days....

Thanks!

These two links will take you in the right direction but you still have the ASPNETDB as a User Instance database which is not supported in other editions of SQL Server so you need to correct that also. In Asp.net deployment takes careful planning or any part of the application can stop the deployment. Hope this helps.

http://geekswithblogs.net/ranganh/archive/2005/04/25/37613.aspx

http://weblogs.asp.net/scottgu/archive/2006/04/22/Always-set-the-_2200_applicationName_2200_-property-when-configuring-ASP.NET-2.0-Membership-and-other-Providers.aspx

|||

Caddre wrote:

These two links will take you in the right direction but you still have the ASPNETDB as a User Instance database which is not supported in other editions of SQL Server so you need to correct that also. In Asp.net deployment takes careful planning or any part of the application can stop the deployment. Hope this helps.

http://geekswithblogs.net/ranganh/archive/2005/04/25/37613.aspx

http://weblogs.asp.net/scottgu/archive/2006/04/22/Always-set-the-_2200_applicationName_2200_-property-when-configuring-ASP.NET-2.0-Membership-and-other-Providers.aspx

Thanks! This is the answer I needed!

|||

I am glad I could help.

Help...pls check whats wrong....not able to do insert with sqldatasource

Hi frdz,

I m the new user of ASP.NET WEB APPLICATIONS WITH C# LANGUAGE.
I m using SQL SERVER 2005 and SQLDATASOURCE to get or retrieve the data from the database.
I have created the stored procedure for insert and update.
The stored procedure is executing fine when i m running it from sqlserver2005.

My problem is with the web-application page.
I m not able to insert or update data thru that...
Pls check the code and tell me what's missing out ........

SQLDATASOURCE

<asp:SqlDataSource ID="srcemp" runat="server" ConnectionString="<%$ ConnectionStrings:empmaster %>"
InsertCommand="empStoredProcedure" InsertCommandType="StoredProcedure"
UpdateCommand="empStoredProcedure" UpdateCommandType="StoredProcedure"
DeleteCommand="DELETE FROM empmaster
WHERE empid = @.empid" DeleteCommandType="Text"
SelectCommand="select * from empmaster " SelectCommandType="Text">
<InsertParameters>
<asp:Parameter Name="empname" Type="String" />
<asp:Parameter Name="address" Type="String" />
<asp:Parameter Name="city" />
<asp:Parameter Name="pincode" />
<asp:Parameter Name="state" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="empname" Type="String" />
<asp:Parameter Name="address" Type="String" />
<asp:Parameter Name="city" />
<asp:Parameter Name="pincode" />
<asp:Parameter Name="state" />
</UpdateParameters>
</asp:SqlDataSource
GRIDVIEW

<asp:GridView ID="empGridView" runat="server" AutoGenerateColumns="False"
DataKeyNames="empid" DataSourceID="srcemp"
Width="56px" >
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:LinkButton ID="btnDelete" runat="server" CommandName="Delete" OnClientClick="return confirm('Are you sure you want to delete this row ?');">Delete</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>

<asp:boundfield datafield="empname"
headertext="emp Name"/>
<asp:boundfield datafield="address"
headertext="Address"/>
<asp:boundfield datafield="city"
headertext="City"/>
<asp:boundfield datafield="state"
headertext="State"/>

<asp:CheckBoxField
DataField="deleted"
HeaderText="In Existance" />

</Columns>

</asp:GridView
C# code

protected void cmdsubmit_Click(object sender, EventArgs e)
{
srcemp.InsertParameters["empname"].DefaultValue = tbcompanyname.Text;
srcemp.InsertParameters["address"].DefaultValue = tbaddress.Text;
srcemp.InsertParameters["city"].DefaultValue = tbcity.Text;
srcemp.InsertParameters["pincode"].DefaultValue = tbpincode.Text;
srcemp.InsertParameters["state"].DefaultValue = cmbstate.SelectedItem.ToString();

srcemp.Insert();
}

Note :

I m not getting a single error msg for the above code in web-page or stored procedure but it does not insert,update or delete the record from the database...
Thanxs in adv...

pls reply at earliest if possible...What's missing ??

can anyone check out..what's wrong ??

Hi,

From your code, it seems that your parameters come from TextBox and DropDownList. So you should try this way:

<asp:ControlParameter Name="empname" ControlId="tbcompanyname" PropertyName="Text"/>
<asp:ControlParameter Name="address" ControlId="tbaddress" PropertyName="Text"/>
<asp:ControlParameter Name="city" ControlId="tbcity" PropertyName="Text"/>
<asp:ControlParameter Name="pincode" ControlId="tbpincode" PropertyName="Text"/>
<asp:ControlParameter Name="state" ControlId="cmbstate" PropertyName="SelectedItem"/>

</InsertParameters>
<UpdateParameters>
<asp:ControlParameter Name="empname" ControlId="tbcompanyname" PropertyName="Text"/>
<asp:ControlParameter Name="address" ControlId="tbaddress" PropertyName="Text"/>
<asp:ControlParameter Name="city" ControlId="tbcity" PropertyName="Text"/>
<asp:ControlParameter Name="pincode" ControlId="tbpincode" PropertyName="Text"/>
<asp:ControlParameter Name="state" ControlId="cmbstate" PropertyName="SelectedItem"/>

</UpdateParameters>
</asp:SqlDataSource>

In your C# code:

protected void cmdsubmit_Click(object sender, EventArgs e)
{
srcemp.Insert();
}

Hope this helps. Thanks.

Wednesday, March 21, 2012

Hi Everybody, Sql Server 2005 SE installation problem

Hi Everybody, Sql Server 2005 SE installation problem

Hi Everybody, Sql Server 2005 SE installation problem

Monday, March 19, 2012

hi all

Friday, March 9, 2012

help-for copying database

Wednesday, March 7, 2012

HELP: SqlCeConnection path error in .NET compact framework (Pocket PC Emulator)

Monday, February 27, 2012

HELP: SqlCeConnection path error in .NET compact framework (Pocket PC Emulator)

HELP: SqlCeConnection path error in .NET compact framework (Pocket PC Emulator)

Help: SQL 2000 connection error(.NET 2.0, VS 2005)

Sunday, February 19, 2012

HELP: ASP.NET won''t connect to SQLexpress after deploying to IIS, try a lot of things...

Help...pls check whats wrong....not able to do insert with sqldatasource

Help Backup

Blog Archive

About Me