3,481 Topics
 | |
| | I'm a bit of a beginning to PHP, so I hope that this question isn't too terribly simple. I'm trying to write a flexible query that will use data from an HTML form to create a SELECT statement for a MSSQL database. I've tried writing a sample query, but I … |
| | I'm working on several scripts that form a small, custom build appointment scheduling application. I'm having some trouble with a function that I'm using to check whether appointments for individual times during a given day exist in the database. The function: 1) creates a table 2) uses the date function … |
 | Hello, First I apologise if this isn't the right forum... I have a vbscript that is non-asp. It is run in a program called EFI-Logic that is an ERP. EFI-Logic caonnects to our MSSQL database for normal operation. The problem is that on some computers I get the following error: … |
| | hi, i'm just stumble upon this forum when i look for help for ip tables configuration, hope someone can help :) i think i can stay a long time mingle in this community, looking for help ;) ups i almost forgot, hello my name is Ridwan from Jakarta, Indonesia. i'm …  |
| | Hi every one, I am Working On SSRS, In Reports I am Showing One Column As A Paragraph , Eg: ApplicationSIPNTCCBApproved, May 8 2007 7:05AM ApplicationICCBApproved, Feb 12 2007 1:42PM ApplicationAITApproved, Nov 6 2006 7:24AM ApplicationCRSubmitted, Oct 14 2006 8:42A I need To show It in new Break line ApplicationSIPNTCCBApproved, … |
| | HI all i want to use the apache torque tool to connect to the ms sql server 2000.As i am a beginner can any one advise me from where to start to understand the working.Any pointers in internet or any books will be appreciated. Thanks Umadas |
| | Good Afternoon All, I'm new at this so hopefully I get this right. About 2 weeks ago my desktop stopped working. I had restored to an earlier point because my system was running slowly. When that didnt work, I undid the restore and my desktop icons wouldnt load (no start … |
| | Hi, My computer is running very slowly and I get numerous errors such as: Windows Security Alert Your Computer is making unauthorized copies of your system and internet files. Run full scan now to prevent any unauthorised access to your files! Click yes to download spyware remover My task manager …  |
| | Hi, I work in a university library in the music area. I'm not really a tech person, but I've been working with a programmer to create a mysql database for the library's streaming audio service. We are streaming with Real Media files. We would like to generate SMIL files automatically … |
| | Hi, I would appreciate your help. I have been following advice I found of people with similar problems but it does not seem to be working. After downloaded an .exe file I appear to be infected with the above trojan, if not more. I have the security pop ups from … |
| | I'm having trouble with the following scenario: drivers may have any of the 16 types of certificates, tasks may require any of the 16 types as well. What I need to do is build a query that will selectd all the tasks a certain driver can perform. Example: driver has … |
| | Hello All.. I am a new Member in this forum, and Iam new user to SQL Server Express. I need to make instal to my project . my project C# with DB sql server express my Question is: How to make instal the sql server express with my project to … |
| | hi, i am using vs.net 2003 and mssql 2000. currently my db size is 2.5gb including DB transaction Log File. For (.BAK extension) is 1.55 gb. May i know how to expand or improve my DB because when it reach the size (2.5GB). i will always get error message : … |
| | We have an Access database that another department is taking over and considering switching over to FileMaker and using on our website (which we manage) with Sequel but - we have heard there are problems with using FileMaker with Sequel....does anyone know if this is true? and if so what … |
| | Is it somehow possible to retrieve a string and then convert it into a mathematical expression? for example i have this string '14200 * 5' and then i want to convert this into a mathematical formula so that i could get the result of it which is 71000.. .. i … |
| | Hello, I have a quick question. I'm currently using MS SQL 2005. I have a main table which has many fields. I created a view#1 which imports all the rows from the main table but I only select the "City" field, "PurchaseDescription" field and a "Cost" field. Only the city … |
| | Hi guys, I have two tables one for that holds Customers details and one that holds Potential Customers details. The Potential Customer table is needed so the company can see who has enquired about the products but not bought them. I need to be able to automatically transfer details from … |
| | Hi! I'm a bit of a beginner at PHP, and I'm having trouble comparing two strings in a conditional statement. Both of the variables are strings, but one of them them is assigned from a MSSQL database. In this database, it of the unicode varchar data type. It doesn't seem … |
| | I am new user I have a system which has Apache2.2.4, PHP 5.2.3 in windows xP proffessional service pack 2. My MSSQL server is in remote place . I have access to the server by using the windows authentication only. when I use script $host='mass.com '; $user='gs\amk123'; $pass='Almn!2345';( windows password …  |
| | Greetings, I've posted this question in other news groups (msdn and a few others) without any response.:sad: I hope I don't get into any trouble for posting this question here, but I reach out for your help.:confused: I have an excel file stored in a data base table as an … |
| | Hoping someone can shed some light on this one, using MSSQL 2000, I have a query like this; Select T.TransactionRecordClass, T.ClassDetail from [remoteserver].otherdb.dbo.Data T where T.TransactionRecordClass like '10000002%' which will return around 10000 records in under 1 second. My issue is that I need to make this part of a … |
| | Hi, I have a problem. I have questions, to a question there can be arbitrary groups and to every group there can be arbitrary conditions. To have permission to “see” an question you have to have at least one condition from every group which is in the question. I have …  |
| | I'm using C# Express and SQL Server Express. I can connect to sample databses I have downloaded to the default location (..\MMSQL.1\MSSQL\DATA) but I cannot connect to a new database I create using SQL Server. The error is "You don't have permission to open this file. Contact the owner or … |
| | my second thread of the day... hey guys, I was wondering if someone could help me. I am new to SQL Server therefore new to T-SQL, I have worked with SQL before. I am trying to reference foreign keys when creating tables. The code I have in SQL is :- …  |
| | OK.. I want to start trying to develop a web app using an SQL Server 2000 database. The only language I know comfortably (but not totally) is VB (although VB.NET is giving me lots of problems). What should I use to develop this program? Dreamweaver? Visual Studio.NET has web development … |
| | Hey guys! I am new to SQL Server and as I am still a student I have never created a database completely from scratch before. I believe that at the very start of development I have to create the database with the following code:- [I]CREATE DATABASE <database name> [ON [PRIMARY] … |
| | Hi , I use MSsql server 2005 with the compatability mode set to 2000.One of the tables, has an IDENTITY Column.I need to restore a earlier backed copy of the table.So, i did the following : set IDENTITY_INSERT MYTABLE ON insert into MYTABLE(ID,NAME) values(23,'XYZ') However, i get the following error … |
| | i wanna see all sql instance in local ? and wanna know their connection string ? |
| | Hi guys! I've never used SQL Server before and I don't want to fall at the first hurdle. SQL Server is installed and connected to the server but how do I go about actually creating the database? I am developing a web based database using dreamweaver and asp.net. Do I … |
| | I have a table on an offline database having let say 2000 rows and same table on an online database with let say 3000 rows. Now I want to copy just those records (1000) from online database that are not in the offline database table. Also, both tables have same …  |
| | Since there is an OLE DB for Directory Services, can you do more than view AD objects? ADSI is an OLE DB provider and it can, so can you manipulate AD using SQL queries once you establish a linked server?  |
| | Hi there, I hope someone out there might be able to help me, im doing my nut in here...!!! Recently I have been getting pop-up internet explorer windows, mainly aimed at gambling. Also my pc has been running like a dog..!!!! Thirdly I now get an error message when I … |
| | TITLE: Connect to Database Engine ------------------------------ Cannot connect to CHESF-HIMRIO\SQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing 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. …  |
| | Hey, I am creating a recruitment database and will be using a managed hosted service. I have read MSSQL is more expensive, but does this matter if I am paying someone else for hosting? The site is going to be in .NET, and I initially was planning to use MySQL, … |
| | I am programming in vb, I always get stuck on my sql select statement(I seem to have problems with my syntax,It takes me hours to get my syntax right) Can anyone suggest a good tutorial for sql with many examples and exact syntax |
| | I can't move, copy, or delete two files that I downloaded for Ragnarok Online. When I even try to right click them, they freeze up the folder window, and lags up my entire computer. They're setup files, and are named RAG_Setup1010 and SAK_Setup1010. When I end task for the folder, … |
 | I am creating a db that needs a very high security level. I have multiple users on the server, but I need to restrict the access to my db to only one of them. I tried setting the "Single User" option for my db, but then none of the users … |
| | Hello, I am trying to write a single query to run a report. I have it working for a single farm, but I need it to work for a list of farms. I am having trouble linking the farm number for the inner query to the farm number for the … |
| | Hi guys! I am developing a web based database for a company for my year work placement for university. As I'm still a student I am still learning so I am not 100% on what i am doing. I was wondering if someone could provide me with some help?...please! :) … |
| | I want to insert 2 table at the same time . There are relationship between them .My tables are: Topic : topicId, topicDate,topicInformation Reply: replyId,topicId, replyInformation |
| | Hi, I need to make a copy of a ms sql 2000 database and send it to another person. They are asking me to send the database schema. I would like help on this since is something I never done before. Thanks Javier |
| | I am installing SharpForge on my computer. I am getting error when i went through the intallation wizard. Error exception details System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the … |
| | Noob question - I have MSSQL 7 running on my machine, although I'm not sure how it got there. I have one DB program using it along with the UPS Worldship program. The latest version of Worldship (9)will not install unless it sees SQL 2000 or better. My DB people … |
| | Has anyone attempted virtualizing Microsoft SQL Server 2000/2005 using VMWare or MS Virtual Server? I've heard from others in the field that they wouldn't virtualize a database server relating to high availablity restrictions. We know for sure that we will virtualize our web servers, mail, and possibly domain controllers. Just … |
| | I am using rowcnt column in sysindexes to report some database statistics. I used the "max" to get a valid row count (as I found multiple records for many tables) for each table, and added status<>0 in the conditions to get valid results. All went OK except for some rare … |
| | Alright, been having an issue lately regarding something that's causing: 1) popups to show up fairly often, usually beginning with a "CiD" 2) Internet Explorer to mess up more 3) my computer to slow down. Been trying AVG, AdAware, Trend Micro, even Windows OneCare safety scanner.. no luck grabbing this … |
| | I have a VB program that needs to count number of events between two datetime values. Something like this: SELECT COUNT(*) FROM Report WHERE WeigthTime BETWEEN "Time1" AND "Time2" Time1 is now. I get it with "SELECT GETDATE()" I need to calculate Time2 by decrementing it for X hours. X … |
| | It's me again...the newbie. I have a web application that I am developing for a school project. Quick overview; the user submits one of multiple different types of "requests" and then a technican begins work on the project. Anyway; with the help of others I have gotten the EXTREMELY long … |
| | [COLOR=midnightblue] HI all, I am very new to SQL server and have been working my way through a book to learn ASP.Net v2 and SQL by building a e-commerce site. There are 3 stored procedures which are used to implement paging from retrieving products from the catalog, which are either … |
| | Hi Guys, I've created a recordset which is saved in a txt file using following code [code] Private Sub Command0_Click() Dim Conn As ADODB.Connection Dim Rs As ADODB.Recordset Set Conn = New ADODB.Connection Conn.Open "DSN=movex" Set Rs = New ADODB.Recordset Rs.CursorLocation = adUseClient Rs.Open "Select * from PESALES", _ Conn, … |
The End.