hello! i have shifted my application from mssql server 2000 to mssql server 2005 , now the prob is the command object is not returning the recordset if command text is stored procedure , here is my code please check it and guide me through errors . [ICODE] dim cmdsp as command dim rs as new ADODB.recordset set cmdsp = new commadn cmdsp.activeconnection = cn cmdsp.commandtext = "MyStoredProcedure" cmdsp.commandtype = adcmdstoredproc set rs= cmdsp.execute 'here i got an error the state of rs is zero , but if i used this code at mssql server 2000 then it will return …

Member Avatar
Member Avatar
+0 forum 2

I am trying to display the result from a query in to a table. I can do this pretty easily when doing queries from mysql, but cannot get it to work with mssql. Below is the code I used to actually make sure I could get the data (and it works fine). I just cannot figure out how to get it to display in a table. If anyone could point me in the right direction I would appreciate it. [CODE] <?php $myServer = "server"; $myUser = "user"; $myPass = "password"; $myDB = "db"; //Connection to the database $dbhandle = mssql_connect($myServer, …

Member Avatar
Member Avatar
+0 forum 2

I am facing the problem when i m attaching the ms sql 2005 database file in win7... MICROSOFT SQL SERVER ERROR 5120

Member Avatar
Member Avatar
+0 forum 3

Hi There; I have a MS-SQL 2005 in my computer. There is a [I]person [/I] table, and this person table have three columns; [I]name[/I], [I]surname [/I]and [I]address[/I].They are nvarchar(50). I hold the data of my company on it. User can make some queries over it via HTML. PHP code does the following: 1- get the data from user via PHP, with [I]$_POST['name'][/I] 2- prepare a SQL query sentence such like that: SELECT * FROM person WHERE name = '$_POST['name']'; 3- connect to database; 4- send the query 5- And print the result. The problem is that database contains Turkish names, …

Member Avatar
Member Avatar
+0 forum 2

I have a view with two tables and three fields tables are called SC011000 and SC33013 the fields are called SC01049 and SC33013 both are datetime fields. I want to make the third field show the biggest date. but i am doing something wrong I am typing in case when dbo.SC331000.SC33013 > dbo.SC011000.SC01049 then dbo.SC331000.SC33013 else dbo.SC011000.SC01049 I get unable to parse experession. please can someone help?

Member Avatar
Member Avatar
+0 forum 2

i have a private sub that reads 4 lines of data from a text file, and then uses whats read and stores them in varibles. see below [CODE] Dim FileName As String = configfileV Dim TextFromTheFile As String ' Whole text Dim Lines() As String ' File splitted to lines Dim LineSeparator() As String = {Environment.NewLine} ' Line separator 'character' ' Use My namespace If My.Computer.FileSystem.FileExists(FileName) Then ' Read the file TextFromTheFile = My.Computer.FileSystem.ReadAllText(FileName) ' Get lines. I used StringSplitOptions that removes empty lines Lines = TextFromTheFile.Split(LineSeparator, System.StringSplitOptions.RemoveEmptyEntries) ' Now you have Lines() array ready ServerV = Lines(0).Substring(Lines(0).IndexOf("="c) + 1) …

Member Avatar
Member Avatar
+0 forum 10

I am trying to create a view and by linking two tables together, VLP_QC_Results_Batch1000 and VLP_Stock_QC1000. (see below pics) The issue I have is in the VLP_QC_Results_Batch1000 has the testNo within a field called TestNoName and is separated by a “-“ I need to link these so that we can show the upper and lower limit for each test and the test results I am unsure if i can link on the BatchID and the QCID as I don’t know how these tables interact with each other. Is there a simple way to get all the characters before the “-“ …

Member Avatar
Member Avatar
+0 forum 9

afternoon everyone, I am new to using MSSQL and need help with SUBSTRING function. i have a strings like below s2-Total Solids - Std Method V1E-RVT4/2.5@20degC Initial V1Y-LVT2/60@20deg Initial A2-Alkalinity - ISO Method(%) I would like to only get the data before the first "-" IE s2 V1E V1Y A2 so that i can link two tables in a sql view, would anyone know how i would complete this can it be done like so? RTRIM(LEFT (QCTEST.TESTNAME, 10))

Member Avatar
Member Avatar
+0 forum 8

Hello to all, I got problem in my vb.net program in publishing it. I am using Microsoft Visual Studio 2008, when I publish my program and I got the setup file and when i tried to run into another computer I got some error saying that it cant connect into the database. Actually I used msSQL 2005 server in my VS 2008. I will appreciate for any help. thanks Sorry for my bad english.

Member Avatar
Member Avatar
+0 forum 7

How do I retrieve data from MSSQL Server using Javascript? I am used to doing things in PHP, but I want to have an interactive form which is able to display Sales Tax after user types in his zip code. My query is similar to: "select top z.rate from zipcodes z where z.zipcode = $zipcode"

Member Avatar
Member Avatar
+0 forum 1

gud day.. is it possible to have a database with password? i mean not setting a password for database users, but for the database itself.. i do not want the database users to see what's inside of my tables.. is it possible?? thank you..

Member Avatar
+0 forum 0

Hi there. Im new to asp programming. And I am doing a research project for my school. I'm create a website with MS SQL SERVER 2005 with ASP. But the problem is the right connection. I have searched the web almost 2 weeks but nothing happened. Here's what my code for the connection [QUOTE]<% <% dim con, Rs set con=server.CreateObject("adodb.connection") con.Open "Provider=sqloledb;SERVER=localhost;DATABASE=SMS;UID=sa;PWD=;" set Rs=server.CreateObject("adodb.recordset") %> [/QUOTE] and here's the error message [QUOTE]Microsoft OLE DB Provider for SQL Server (0x80004005) Login failed for user 'sa '. The user is not associated with a trusted SQL Server connection. /SEARCH MANAGEMENT SYTEM WEBSITE/sample.asp, …

Member Avatar
+0 forum 0

The End.