i have installed windows application in sql server 2008,it has been installed but when
i click the icon in desktop error getting is [DBNETLIB][CONNECTION OPEN(connect()] SPECIFIED SQL SERVER NOT FOUND.How can i over come this error.
I doubt you have installed a windows application into SQL Server 2008.
Member 9999112 wrote:
How can i over come this error.
By actually providing real information.
First this site is for the people who create applications not those who use them. So if you have an application that you got from somewhere then you need to go where you got it and ask there. This presumes of course that you already read all of the documentation that comes with the application.
But if this is an application that your wrote yourself then you need to provide some more detail about the code that is failing.
I am getting conversion error when i try to execute the following query... please help i need this scenario to be fixed for another business logic
Conversion failed when converting the varchar value '12r'to data typeint.
insertinto@tselect'1'unionselect'2'unionselect'3'unionselect'4'unionselect'et'unionselect'4'unionselect'6'unionselect'7'unionselect'8'unionselect'9'unionselect'12r'select * from@twhere cast(val asint) > 3
This question really does ask for a disparaging response.
If you can't work out that declaring a field of type int and trying to stuff text into it is going to fail and then cannot understand the very clear error message you should stop now and get an education.
Never underestimate the power of human stupidity
Because you have stored you MSNUM as a comma separated string (idiot) you are going to have to split the string. For this you need a split function that will return a table with the date and 1 ID per row. You then use this table to join you 2 existing tables.
This is the direct result of crappy design where someone is too bloody lazy to create the additional table to store the Date/MSNUM as discreet records.
We are just switching over to SQL Server 2012 from SQL Server 2008 and we are having some trouble with an XML Source (from a URL dontcha know).
It works fine on 2008, but always reports that it can't find the file on 2012 -- even though it is able to find the file to generate an XSD.
Even on the same server under the same user.
The file exists and the user has access to it.
Has anyone else seen this? Any ideas? A quick search didn't turn up any clues.
I'm relatively new to sql and need help to accomplish what should be a straight forward task.
I need to insert record templates in a database table. The records are identical except for IDfield which is a sequence from n to n+count. I can't use Autoincrement because I want to be able to enter different templates where I can define the base index n.
I'm currently using transactions to insert records in batches but need a faster method using a single SQL statement.
2000 Apple Fruit Granny Smith
2001 Apple Fruit Granny Smith
2002 Apple Fruit Granny Smith
2900 Apple Fruit Granny Smith
A different fruit may have a base index of 6000 and so on.