I have a SQL Server 2000 database. I am trying to ssetup a sqldatasource in Visual Web Developer 2008 Express. I get an error saying "Microsoft.SqlServer.Management.Sdk.Sfc cannot be loaded". Everything I can find says this is related to 2005 or 2008. Any ideas what I can look for?
View 2 Replieshow to install microsoft sqlserver 2005 or 2008 on window 7 with x64 bit.It works perfectly on vista but on getting a new system which comes with window 7 and x64bit i was unable to load the software onit except my visual studio 2008.
View 1 RepliesI have an error when visiting my page
The Microsoft Jet database engine cannot open the file 'E:""""""""datab.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
Iam using the DBconnection object through out my applicationI use the same as a singleton objectWhen more operations are performed on the single objectit throws an error ERROR [HY001] [Microsoft][ODBC Microsoft Access Driver] Cannot open any more tables.But it occurs only some timesHow to solve this?Can any property can be set to avoid this type of error.Or can i overload and write any method to avoid thisTo Identify the same i wrote some Poc and tried alsoLike opening the connection object and looping through 1000 times and creating a command object for the connection and running a query.Some times iam getting the exception and some times its running
View 7 RepliesI am trying to use sql spatial in visual studio 2010 with asp.net 4.Where did microsoft.sqlserver.types go?Does this mean you can't use SqlGeometry or SqlGeography in asp.net 4?
View 2 RepliesI have written an ASP.NET page that accesses a SqlServer 2008 database and utilises the new spatial types. In order to use these types in my .NET code, I had to install the SQL Server System CLR Types addin to get the Microsoft.SqlServer.Types.dll file.I added the file to my GAC and referenced it from my ASP.NET project. I compiled all the projects in my solution in "Any CPU" mode and it runs fine on my development machine. However, when I deploy it to my hosting provider, I get the following exception when I access the page that uses the SqlGeography type:
System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
at Microsoft.SqlServer.Types.GLNativeMethods.GeodeticIsValid(GeoMarshalData g, Boolean& result)
at Microsoft.SqlServer.Types.GLNativeMethods.GeodeticIsValid(GeoData g)
at Microsoft.SqlServer.Types.SqlGeography.IsValidExpensive()
at Microsoft.SqlServer.Types.SqlGeography.ConstructGeographyFromUserInput(GeoData g, Int32 srid)
at Microsoft.SqlServer.Types.SqlGeography.GeographyFromBinary(OpenGisType type, SqlBytes binary, Int32 srid)
at Microsoft.SqlServer.Types.SqlGeography.STGeomFromWKB(SqlBytes wkbGeometry, Int32 srid)
....A quick google on the error code seems to suggest that the problem is something to do with loading a 32bit dll into a 64bit runtime. I've checked with my hosting provider and they are running Windows Server 2008 x64 and they told me that my website is running in a 64 bit ASP.NET runtime.I can't seem to find a 64 bit version of the Types dll and compiling my program in "x86", "x64" or "Any CPU" modes seems to make no difference. Is there any way that I can get around this problem without having to pay to host my website on it's own machine?
Hi,
I am trying to developing a project which is getting mssql version, creating tables,views and insert default datas to database.
I have to develeope it working in MSSQL 2005-2008.
Now my project uses using Microsoft.SqlServer.Management.Smo; using Microsoft.SqlServer.Management.Common;
name spaces from MSSQL dlls.it works fine in serves which has MSSQL2008.Bu d-today i tried it in a server which has MSSQL2005 nad it failed.
Error;
Could not load file or assembly 'Microsoft.SqlServer.SqlClrProvider, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
So.Where can i find this namespace and and i need to add this namespace dll to my project.
Else i need another way to do these process working in 2005 nad 2008.
When i execute the openrowset with OLEDB4.0 in sqlserver2008(64bit),then the following error comes "Microsoft.Jet.OLEDB.4.0" has not been registered"and the query is
Select * from OPENROWSET('Microsoft.Jet.OLEDB.4.0',
''Excel 8.0;Database='c: est est.xls ';HRD=NO;',
'SELECT * FROM [sheet1$]') SELECT FirstColumnName FROM tablename
i am using sql express 08 & sql management studio exp 08. I tried to clone a database from another but an error occured. My steps:
[newDatabase] >> right click >> tasks >> restore >> databaseOn general section: from database = [databaseSource] >> backup sets: all checked
On options section: overwrite existing database: checked, recovery state: restore with recoveryClick [ OK ] button The error:
Restore failed for 'MyServerSQLEXPRESS'. (Microsoft.SqlServer.SmoExtended)
Additional information:
System.Data.SqlClient.SqlError: The file 'x:.........databaseSource.mdf' cannot be overwritten. It is being used by database 'databaseSource'. (Microsoft.SqlServer.Smo)
And why sql management studio tried to overwrite the dataSource (not newDatabase)? how to clone a database? I also tried backup databaseSource to file and then restore newDatabase from the file but resulting the same error.
we have local net in our company.(we dont have win server.)
now i want to know how i can connect to the sqlServer in pc1 from pc2?
i have been trying to connect to SQLserver from ASP.net web developer in an n-tier architecture.But it shows this error in conncetion
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
I really need to create ID like this. But I don't know how use this Procedure .If you don't mind can you explain to me step by step how to use to procedure for create auto ID in database. (Should I call to this Procedure from somewhere else, like webpage button or something)
View 4 Replies i am new to this cubes concept in sqlserver . i need to connect to cubes and and query and get an result and display that result in grid view
how to connect to an cube, articles on it, code any thing
I have a problem with saving hebrew into sqlserver.I've done it before in another computer but did not have problem.Now the hebrew is saved as '???'.About the field collation, it is latin1_general_cp1_ci_as in another DB I have in another computeranf also in the current field in the current DB.I guess it not the collation.Ialso tried to change the text field to varchar, but it still saves '???'.
View 9 RepliesI try to import Excel files to sqlserver problem is that the number and the titles of columns are dynamic.How can i do that by code?
View 5 RepliesI am using Sqlserver2008.
I want to konw how to get TransactionID(customized auto generated number) with 9dgits(2 alphabets, 7 numerics).
[Code].....
I have a select query where iam fetching the data from minimum of 7 different tables by using innerjoin. I have 3 lakhs of records in that table.BY using cache Iam fetching all 3lakhs of records at a time and put in cache. by using the rowfilter i use the records.firsttime when iam fetching these 3lakhs records it takes 3min. want to improve the performance of time.How to improve the performance of time?
View 1 Replies'm using SQLServer Freetext for my search page. My Search page consists of a textbox where the user can enter freetext and next to the textbox I've got a dropdown which enables the user to refine the search (Catagories). My problem with my search is ... if a user type for exam Dog in the search textbox and he doesn't use the dropdown to refine his search ... no data will be displayed although Dog exists in my database. But if the user type Dog in the textbox and this time he select animal (as a catagory) from the dropdown ... then results will be displayed. In a nutshell I would like to have the functionailty that allows a user to search only by keywords typed in the search textbox apart from using the dropdown (catagory) as well.
View 2 Repliesi am trying but i am unable to do this one.
View 2 RepliesCurrently I am working in Sql server 2005. I do not know the Sql Server 2000 and Sql Server 2008. what is the difference between Sql server 2005 and 2008?
What is the Difference between Sql Server 2000 and Sql Server 2005
I am using asp.net3.5,sqlserver2008. I have retrieving data from Accounts,BUDGETS like this.
select a.AccountLink,a.Master_Sub_Account,b.* from Accounts a inner join BUDGETS b
on a.AccountLink=b.GLLink where a.AccountLink=1
output of my query...
AccountLink Master_Sub_Account GLLink AccType Budget01 Budget02 Budget03
[Code]....
Is there a way to connect to a database which was created with Visual Studio Express 2008 in Sql Server Express 2008?
View 1 RepliesThe below query produce the below output.
[code]...
select r.Name,c.Name,s.Name,(select count(p1.id)from profiles p1 where r.id=p1.religion and c.id=p1.caste and s.id=p1.subcaste and p1.Gender=1)as Male,(select count(p1.id)from profiles p1 where r.id=p1.religion and c.id=p1.caste and s.id=p1.subcaste and p1.Gender=2)as Female from religion r,profiles p,caste c,subcaste s where r.id=p.religion and c.id=p.caste and s.id=p.subcaste group by r.Name,c.Name,s.Name,r.id,c.id,s.id
give me a simple example to write an exception in stored procedure
View 2 Repliesi need record with id 1 and 3 only how do i get in sql server 2005.(means distinct empcod onl.
View 3 Replies