I am using Vs2008 in that i created one new project of Windows form using C# language. but the thing is i want to connect the database connection to that one, but there is no webconfig file. how to connect the database connection.
View 1 Replies
I have a database on Go Daddy and my VS2008 app can not access it via web.config connection string. Of course runs great locally in development. I copy/pasted the connection string information from Go Daddy exactly into my web.config file. Web site runs fine on the web but when I try to Login at my login page, i get :The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.
I used VS2008 to create the .sql script files and uploaded them to Go Daddy and the Go Daddy people say everything works as they and I can both Login to the database from within GoDaddy.The database i am trying to access consists of the a ASPNETDB.mdf and another Database.mdf together as one in the Go Daddy database.
here is what i used: <connectionStrings><add
name="superskin"
connectionString="Data
[code]...
I am trying to connect linq to dbf file. I am using VS2008 on windows xp with sp2. For most part I can create a connection and see the tables in the server explore, but when I try to drag and drop a table onto the .dbml i get "The selected object is an unsupported data provider". I have been trying to use FoxPro to connect to the DBF. In VS in the Data Connections I go to modify the connection and hit test and the connection says success, but no tables appear.
View 1 RepliesWhen I try to encrypt the "connectionStrings" section in the web.config file of my asp.net web application on Windows Server 2008, I'm getting the following error:
Administration utility (2.0.50727) to install and uninstall ASP.NET on the local machine. Copyright (c) Microsoft Corporation. All rights reserved. Note: This utility has limited capabilities on the Windows Vista operating system. It is recommended that you use the "Turn on or off Windows features" option of the "Programs" component of Control Panel to install or remove ASP.NET. It is also recommended that you use the IIS Manager component or the Appcmd.exe tool to configure ASP.NET applications.
The above information is followed by the list of valid options to aspnet_regiis.exe.
The command that I've used is:
aspnet_regiis.exe -pef "connectionStrings" "C:Usersuser1DocumentsMywebsite" -prov "DataProtectionConfigurationProvider"
But, the same command is working fine when used on a Windows Server 2003 machine. The problem is occurring only on Windows Server 2008 with IIS7.
I have an ms access db file and now i want to use it in my app. i have given like
Provider=MSDASQL.1;Password=pwd123;Persist Security Info=True;User ID=swgp;Data Source=SWGP;Initial Catalog=C:swgp BJswgp
but it is giving error to me.If anybody know how to give this connection string for password enabled ms access database,
need a simple video that can expalin me the simple connection between a web form and sql db i am a begineer, i am learning all the things from these website, i need a video tutoorial that will explain me that how to create a simple form and simple database and conect them and manage those datas, can you people understand what i am expecting, for example, just a user login page with user name and password , and we have to store that details with a data base, and how to see the details what we stored, thats it and how to edit those details, atleast i need the first set of connection and manupulating video.
View 4 RepliesI have web app written in .net 4.0 using url routing. It works fine in the development environment in VS 2010.But It's not working after publishing to iis7. on remote server i'm getting error HTTP Error 404.0 - Not FoundThe resource you are looking for has been removed, had its name changed, or is temporarily unavailable. I tried in virtual directory and it's not working.[URL]
View 1 RepliesI am a PHP developer trying to set up hosting for an ASP website. The site works when hosted with the original host but I need to move it.
I have uploaded the files to oneandone hosting. I have set up a datebase and chnaged the database connection details but get the following error
Inner Exception Could not find stored procedure 'uspPageHit'.
The database connection looks like this:
<add name="site" connectionString="Data Source=[hostname];Initial Catalog=[databasename];User Id=[username];Password=[password]" providerName="System.Data.SqlClient" />
and the info on the one andone host panel provides :
database name, user name, hostname, password
Have I put the correct details in the correct place?
My web server and database server are currently both in the same room. However, the web server might be changed to a different server in another building about a mile down the street. I want to make sure this doesn't have a negative impact on the connection speed between the database and web server. Is there a way to test the connection speed from both web servers to the database?
View 3 RepliesI have sql server 2008 express edition. I'm trying to use the wsat to set up the provider but I keep getting the error:
Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.
[code]....
I finished an intranet application using webconfig to store my connection string to an Access database which has linked tables to SQL Server 2005.
Everything works perfectly, but when I publish the application on a IIS server service, it seems like all connections fail... :(
I looked up on internet but found nothing on this. I think my webconfig file is correct :
[Code]....
I had another thread on this problem but I wanted to start this one so no one had to look at the code I posted in the other thread. I have a successful connection but want to display data from the SQL database on my website in my Windows form application. Here's the code I have so far. Used some of the ADONET Tutorial1 here. The table Ray Rover Activation has a number of different columns but to start out I just wanted to see if I could display data for the EmailAddress column.
Code:
[code]....
If I comment out the Sub DoStuff I don't get any errors but neither is anything displayed other than the messagebox message. If I don't comment out DoStuff then I get an error, "Incorrect syntax near the keyword 'FROM'". Maybe someone could enlighten me some on what I need to do get the data in the column EmailAddress to display.
What will change in connection string after upload database to hosting?
View 1 RepliesI am developing an application in which I can connect to the ASPNETDB.MDF if it is on my machine, however, when I want to put it on another machine and try to remote connect it, I get the error:
An error occurred while attempting to initialize a System.Data.SqlClient.SqlConnection object. The value that was provided for the connection string may be wrong, or it may contain an invalid syntax.
Parameter name: connectionString and my connection string is as follows:
<add name ="NewRemoteSqlServer" connectionString="Data Source=P1M1_2-HPSQLEXPRESS; AttachDBFilename=C:ASPNETDB.MDF; Integrated Security=SSPI; Username=P1M1_2-HP; Password=plus1minus1; " providerName="System.Data.SqlClient"/>
I developed an application using VS2010 and now when i try to deploy it on windows XP maching running IIS 5.1 i get the database version error which says:
The database '<database file path>' cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.
<database file path> . Create is aborted.
An attempt to attach an auto-named database for file <database file path> failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
I installed Microsoft Windows Sever Enterprise Edition (rus) SP1, downloaded (manually) and installed Windows Server 2003 SP2.Installed VSTS (Visual Studio Team System) 2008 (with MS SQL 2005 Express with it, MS Office 2003, MSSQL2008 Developer Preview), IE7.And my Windows Update does not detect/autoupdates any updates/service packs for VSTS2008 and MSSQLServers...like Windows XP, only updates for operating system Windows Server 2003, .NET, IE7, MS Office, etc.
Is it something wrong with my setup?Should Windows Server 2003 autoupdate detect and install VSTS2008 and MS SQL Servers updates, or should not?
I am trying to install vs 2008 on a 64 bit windows 7.
when it completes about 10% of the installation it gives me a list of error messages telling that setup has failed.I searched in microsoft communities and on the net,
Here is what I need to know about SSRS/VS2008:
View 5 RepliesI am ruuning VS 2008 on Windows XP Service Pack 3. The problem I am facing is that my windows crashes after a blue screen whenever I run a website in VS2008.Its only with websites projects in VS2008 but not with WinForms projects. WinForm applications running without any problem.This happens in this sequence that when I run the project, it starts, debugs and port is opened for my project (a popup that comes right near the system clock in taskbar) and suddenly after that a blue screen comes and Windows restarts. After restarting,
a message comes that system has been recovered from a serious, send report to Microsoft blah blah blah...Can anybody figures it out what problem there can be?
I need to extract meta-data of different files, as uploaded by the user.
For this I found out dsofile.dll from MS. Now the problem is that the version I've downloaded from
[URL] is working fine with Windows XP but giving run-time error in Windows 7 64-bit system. Finding more on the error I was getting I came to know that the dll would not work for 64 bit OS. I also downloaded 64-bit from [URL] but still am getting below run-time error:
Retrieving the COM class factory for component with CLSID {58968145-CF05-4341-995F-2EE093F6ABA3} failed due to the following error: 80040154.
I've two questions:
How can I solve this run-time error and from where will I get dll working in VS2008 Website on Windows 7 64-bit?
Is there any other way I can extract meta-data (all the attributes/properties other than exposed by System.IO.FileAttributes) of any file (could be doc, docx, xls, xlsx, jpg, pdf, txt, etc.) uploaded by the user?
My workstation does not have Internet access, but it uses a DNS server on the LAN. Every time I start any ASP.NET application from Visual Studio with either F5 or Ctrl-F5, the workstation (I don't know whether it's Visual Studio or Webdev.Webserver.exe) asks the DNS server for the IP address of "time.windows.com". The application is not started until the LAN-only DNS server returns an error, which results in a 10-second delay, during which the Internet Explorer is started, but displays a white background. Is there any way to prevent these connection attempts?
View 2 RepliesI created web form which gets data from local database (SQLEXPRESS). It gives me an error when I publish the website. I can upload regular aspx page into my site. It works fine. How can I publish data-driven web form into my website?
View 8 RepliesMy kind webhost (1and1) royally asked me to go elsewhere to do something like this.
I have 2 sites. One of them was developed by a .Net programmer. Now I am contracted to implement a PHP site and fetch data from the .Net site.
There is an ASP.Net form that a customer fills and when they hit submit, the data gets stored in SQL Server DB. How do I also store the same data in MySQL parallelly? I cannot directly use some database connectors with ASP.Net since MySQL connectivity is not supported on 1and1 Windows hosting (biz account, no less!).
What I thought of is to publish an RSS feed of entries in ASP.Net site and routinely scrape that data into MySQL on Linux host. It is an overkill, I know. Not efficient.
I have a web application in VS2005 development and I migrated this web application to the latest development in VS2008. Everything is working fine except that the modal popup panel is not showing in the form design in VS2008. I'm wondering why is it and how do I view the modal popup panel in the view design form in VS2008?
View 2 RepliesI'm having a problem with opening ASP.NET configuration in Visual Studio 2008 Express. It just won't open. Nothing happens when I click ASP.NET configuration (under Website).
Odd things:
(1) It works fine (opens) in Visual Studio 2005 Express.
(2) I tried re-installing Visual Studio 2008 Express and the ASP.NET configuration opened fine for a couples of day, but now its not working again.
