VS 2008 Pro, XP
Jun 4, 2008
Hi All
Im trying out connecting to a SQL Server database.
Ive got a Web Application and have Dragged and Dropped a SQLDataSource on the page.
Ive Selected the "Configure Data Source" option on the component.
Ive then selected the "New Connection" button on the "Configure Data Soure - SQLDataSource1" pop-up window.
Choose Data Source Ive then selected the "Microsoft SQL Server" then pressed continue.
On the "Add Connection" Window Ive then:-
Selected the Server Name from the drop down list
Selected the "Use Windows Authentication"
Selected "Select or enter a database name" and put a path in like "C:DataMyDatabase.mdf"
then pressed the "Test Connection" and get "Test Connection Succeeded" (this is the same whether a DB path exists or not ???)
then pressed ok and the following message appears:-
"Unable to find the requested .Net Framework Data Provider. It may not be Installed"
Any ideas why ?
tia
Andrew
View 1 Replies
ADVERTISEMENT
Mar 31, 2008
There are a few features in the new SQL Server - Reporting Services that I really need in production. I have tested everything and it works great. I am running the CTP version since Microsoft is saying they aren't releasing the release version until 3rd quarter 2008.
Since Microsoft won't sell SQL 2008 until 3rd quarter, can I run the CTP in production until the release and then purchase SQL 2008?
Jim
View 1 Replies
View Related
Dec 23, 2007
when I try to make a sqldatasource with visual studio 2008 and SQLServer 2008 . I found that there are a message that the visual studio 2008 can support only SQLServer 2005 and SQLServer 2000how to make my visual studio 2008 support SQLServer 2008
View 1 Replies
View Related
Feb 25, 2008
Hello!
Recently, I set up server with Windows Web Server 2008 RC1, SQL 2008 Express beta, .NET 3.5, IIS 7.
I'm running ASP.NET web application with SQL database. Everything works fine until the first application state on the server expires. After that, any postback that starts a new application state on the server and connects to the database, results in the following error:
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
Is this a bug that will be fixed in release of Windows / SQL or am I doing something wrong?
Many thanks for help,
Jan
View 1 Replies
View Related
Mar 7, 2008
Hi all,
New to this so please be patient and please help.
I have developed an SQL 2005 Express command line option install for our company which has been working seamlessly for the last 18 months.
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
I downloaded the €œMicrosoft SQL Server 2008 Express CTP, February 2008€? from http://www.microsoft.com/downloads/details.aspx?FamilyId=749BD760-F404-4D45-9AC0-D7F1B3ED1053&displaylang=en
I simply replaced the 2005 file €œSQLEXPR.EXE€? with the 2008 file €œ€?, recompiled the installation and tested only for it to fail. I than read the 2008 books online and noted the change in command line options.
http://www.microsoft.com/downloads/details.aspx?familyid=19DB0B42-A5B2-456F-9C5C-F295CDD58D7A&displaylang=en
http://msdn2.microsoft.com/en-us/library/ms144259(SQL.100).aspx
I then changed the command line to suit the Microsoft 2008 books online, recompiled the installation and tested only for it to fail once more.
Interestingly I tested the install from the default GUI and at the point of adding the €œsa€? login credentials it fails to allow the installation to proceed. Strangely by selecting the windows authentication credentials, €œnext€? than €œback€? it now allows me to add the €œsa€? login credentials and continues to install correctly as required.
I hope I have explained this clearly enough.
1. Is this a bug in the €œMicrosoft SQL Server 2008 CTP, February 2008€? installation?
2. If so is this causing the command line install options to fail?
3. How do I obtain a version of €œMicrosoft SQL Server 2008 Express€? that will work installing from the command line?
Thanks in advance.
View 1 Replies
View Related
Apr 23, 2008
Hello - does anyone have experience w/SQL Server 2005 in a virtual environment? I'm considering this for a production environment but not sure if performance will suffer. Our databases will have a lot of writing but not too much reading. A SSRS solution is currently the only app. connecting to the SQL db. Max users to server at any given time will be very low (~10 users max). But the databases are pulling in data from other, outside multiple data sources on a daily basis.
Any pointers to documentation or any advice?
Thanks,
A Brown
View 1 Replies
View Related
Apr 15, 2008
Hello,Is SQL Express 2008 already available for download? Where can I get it?Is it shipping already with VS 2008?Thanks,Miguel
View 5 Replies
View Related
Apr 9, 2008
Hi this is srinivasa rao ,installation problem server configuraions sqlserver 2008 express edition username and password do not match the error
View 1 Replies
View Related
Jun 18, 2007
Hi,
does anyone have some information about the further developments of bi in the next release SQL 2008? Does anyone have a kind of timetable for the release?
Thanks in advance,
hs
View 7 Replies
View Related
Mar 11, 2008
Howdy,
With SQL 2008 do out in the near future, I need to know the specs on SQL CE 2008.
I have been digging around on the net but it looks like mum is the word thus far... so I am going to ask you straight out.
Please give us all a taste of the spec for SQL CE 2008 including the following:
Will Linq be supported?
What Proc limit will be supported?
What DB size limit will be supported?
How many concurrent connections will be supported?
Will .net types be supported?
Will the new filestream type be supported?
One last question on SQL CE 2005. As I am sure you are aware - Server Manager (2005) will not pick up a sdf created with 3.5. Since we (the developers out there) have to wait for SQL CE 2008 for an unanounced amount of time, will you give a hot fix so we can look at a 3.5 sdf in Server Manager (2005)?
Thanks, Johnathan
View 4 Replies
View Related
Apr 7, 2008
Hi,
Can some one give some links for reporting and notification better explanation in sql 2008
View 5 Replies
View Related
Jan 17, 2008
Anyone know when about SQL 2008 will be released, trying to plan upgrades.
View 2 Replies
View Related
Feb 26, 2008
Hello, I am currently running Visual Studio 2005, and I also have SQL Server 2005 Express Edition Advance series where I have FULLTEXTSEARCH working. I have just bought a new computer and I will like to install Visual Studio 2008 on it, what do I need to do in order for me to migrate my database to my new computer? Do I need to install a different SQL Server? Thanks Louis
View 2 Replies
View Related
Apr 7, 2008
is there a version of SQL express 2008 ??
View 1 Replies
View Related
Apr 22, 2008
I want to use VWD 2008 and MS SQL 2005 with SP2 for my app.
I can't make a connection to a database !!!
I created a new mdf database using SQL Server Management Studio.
When I try to connect to the new database from VWD 2008 I get the following error :
An error has ocurred while establising 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 SQL Network Interfaces,Error 26 - Error Locate Server/Instance Specified)
I read over the internet many articles about but still the same result.
From this link I followed every step :
http://www.sql-server-performance.com/faq/establishing_remote_connection_seetings_not_allow_remote_connection_p1.aspx
My SQL Server and SQL Server Browser are exempted by the firewall on the server machine. My SQL server and VWD are installed on localhost and allow remote connections are checked on database properties - connections and SQL Server Surface Area Configuration - local and remote connections.
What can I do?
Thank You !
View 11 Replies
View Related
Jun 10, 2008
Hello all,
I just wanted to share my happiness with the Microsoft's release of the new version of SQL Server 2008, MS SQL Server 2008 RC0.
You can download and install the evaluation versions from Microsoft Downloads.
http://download.microsoft.com/download/2/0/c/20cf6e18-0448-4e7b-8d8c-60a3c4802671/Download_Instructions_ENU.htm
I liked the new logo very much!
Eralper
MS SQL Server Articles
View 1 Replies
View Related
Jun 4, 2007
The best mail today was, witout doubt, the one from Grant Dickinson at Microsoft telling that SQL Server 2008 June CTP is available from the SQL Server (http://www.microsoft.com/sql/prodinfo/futureversion/default.mspx) pages at Microsoft. :)
It's time to play. :cool:
View 9 Replies
View Related
Sep 18, 2007
Hi all I have a question, has anyone tried the new ACT Premium 2008 apparently it runs off of SQL Server and can support 31-50 Users.
Has anyone tried it??
We are trying to get rid of Access and have a database that has a customizeable front end and will run off SQL Server 2005
View 7 Replies
View Related
Apr 23, 2008
Hello,
I just installed SQL Server 2008, i'm not certain if I am missing a step or theory...
just ran a simple command:
USE master
GO
For some reason, the process simply keeps on running.
Correct or incorrect statement, the results shouldnt appear any longer than a few seconds...
Does anyone know why this is taking a lot longer than it should?
View 3 Replies
View Related
May 22, 2008
I have a Actual_dt column that is a type of date. I am trying to get all the values from the table that have the date less than 2008/01/01.
Please help.
Thanks
View 6 Replies
View Related
Oct 2, 2007
I would like to buy SQL server 2008 book. I need it badly. would you please tell me where I can find it? thanks. and I look forward to hearing from you as soon as possible.
thanh
View 5 Replies
View Related
Aug 28, 2007
I just downloaded the SQL Server 2008 CTP. Anyone here check it outyet? Thoughts?
View 1 Replies
View Related
Nov 21, 2007
The RTM bits provide an upgrade capability.
My first stab at this with a 450mb .sdf was illuminating.
The process grinds away, writes out the new .sdf and then, just as it completes and raises it's 'successfully completed' banner, it deletes the new .sdf!
Tried both with and without encryption. Made no difference. No, it's not in the recycle bin either, or anywhere else on the drive.
How cool of an upgrade feature is that?
Using VS2008 Pro installed on XP
SSCE team: Time to bring out a separate upgrade tool?
View 1 Replies
View Related
Jul 15, 2007
Dear Sirs.
I have Client Server Application
on Client Side i have .NET 1.1 WinForm Application
on Server Side i have SQL Server 2000
I'm using "OLE DB PROVIDER FOR SQL SERVER" for the Data Access
1)
I'd like to upgrade Server Side to SQL Server 2005 (I will copy same database with users to sql2005)
Should i update Clients to .NET 2.0 too ?
Do i need install Native Client Lib on Client ?
2)
when SQL Server 2008 is Relesed
Can i connect to it from .NET 1.1 Application ?
Thank you in Advance.
View 6 Replies
View Related
Jan 1, 2008
I installed VWD 2008 on my Vista Business. I had a lot of trouble installing SQL Express 2005 & SQL EXpress 2008 CTP and SQL Express 2008. Finally managed to install SQL Express 2008 on my Vista Business. If anybody has problem installing SQL Express on Vista let me know. I found resources on MSDNER and this forum to resolve this.
But now I have a new problem that is. I can not add the SQL connection from DataExplorer of VWD 2008. It say it can connect only up to SQL 2005. Now I try to install SQL 2005 it goes up to the stage where it says looking for IIS server and disappears.
Does anybody know how to install SQL Express 2005 on Vista Business (while SQL Express 2008 is installed, I don't want to loose it) or get VWD to talk to SQL Express 2008?
Your help is much appreciated.
View 1 Replies
View Related
Dec 3, 2007
Hi
i am new to sql2008 and coming from vb6,sql2000 background. We tried Orcas. we dont want to move our project to dotnet for atleast one year. we want to makie it tune with windows vista also. so kindly tell us which version of adodb can be used with vb6 and sql2008. i am pasting our old code from vb6 here.
Code Block
dim cn as new adodb.connection
cn.open "Provider=SQLOLEDB.1;password=NETECH0507;Persist Security Info=False;User ID=sa;Initial Catalog=" & dbname & ";Data Source=" & gStrSQLServerName
Let me know what are the changes required while connecting with vb6 and sql 2008 express edition
Rgds
Pramod
View 6 Replies
View Related
May 19, 2008
Anyone here aware of Sql Server 2008 RTM availability date.
View 1 Replies
View Related
Jun 12, 2007
I see the Developer edition of SQL Server 2008 is available. When will the Express version be available?
View 3 Replies
View Related
Nov 17, 2007
Hi-
VS 2008 supports targeting different versions of the .NET Framework. Will this apply to SSCE as well? I have some older apps that I want to keep in .NET 2 and SSCE 3.1. But I would also like to develop new stuff in 3.5. Will the targeting mechanism in VS 2008 support using SSCE 3.1 with .NET 2.0 and SSCE 3.5 with .NET 3.5?
Thanks.
-Gary
View 3 Replies
View Related
May 12, 2008
--Environment: SQL Server 2000
I am doing following query for who is reaching of Age 65/75 in May 2008 but Member_DOB's or Spouse_DOB's showing different month. Month should show '05' because I want to see results who is reaching of age 65/75 in May 2008 only.
Please help in this regard.
--Query:
Select m.empid, m.dob "Member_DOB",
round(datediff(dd,m.dob,'05/30/2008')/365.25,1) Member_Age,
d.dob "Spouse_DOB",
round(datediff(dd,d.dob,'05/30/2008')/365.25,1) Spouse_Age
from member m
left outer join (SELECT * FROM depend where depcode = 'S' and activestatus = 1)d
on m.empid = d.empid
where (datepart(yy,m.dob) in (1933,1943) or
datepart(yy,d.dob) in (1933,1943))
and round(datediff(dd,m.dob,'05/30/2008')/365.25,1) in (65,75)
or round(datediff(dd,d.dob,'05/30/2008')/365.25,1) in (65,75)
--Results:
Empid Member_DOB Member_Age Spouse_DOB Spouse_Age
000000033 1931-12-07 00:00:00.000 76.500000 1933-06-16 00:00:00.000 75.000000
000000085 1933-05-23 00:00:00.000 75.000000 1938-03-10 00:00:00.000 70.200000
000000695 1933-06-10 00:00:00.000 75.000000 1934-07-08 00:00:00.000 73.900000
000000792 1931-01-15 00:00:00.000 77.400000 1933-06-05 00:00:00.000 75.000000
000002406 1933-05-27 00:00:00.000 75.000000 NULL NULL
000004149 1933-05-20 00:00:00.000 75.000000 NULL NULL
Desired results:
Member_DOB and Spouse_DOB's should show '05' i.e. 1931-05-07, 1931-05-15
View 2 Replies
View Related
Feb 29, 2008
I currently create reports in VS 2005. If I upgrade to VS 2008, what will happen to the BDIS development tools?
Thanks
Dean
View 3 Replies
View Related
Jan 2, 2008
I pray I am in the right forum.
I went to MSDN Products Keys and Downloads and found that they offer Sql Server 2008 as a free download for MSDN Pro subscribers. At least this is my inpression as to what is going on. I think it comes on 4 or 5 DVDs.
I am using Sql Server Express Edition with Advanced Features. I want to be honest and say that I most likely do not use these "advanced features" because of the nature of my work. I do not have this customer/product canonical setup. I store numerical data as well as stocks info. It is all for myself. I understand that the "advanced features" include reporting services but so far I have never used them.
This is my dilemma. I want to stay abreast with the progress and use the most current software. If I download the full SqlServer it will kill my machine with the enormous surface area. I do not need even systems databases, let alone Nowthwind. I create my onw DBs.
Do they have an equivalent of Sql Server Express for 2008?
What would you advice me to do?
Thanks.
View 1 Replies
View Related