9,022 Topics
I'm very new in vb.net. Please help to do :- 1) create login form, which validdate the username and password. 2) Import and export txt file to the sql server. thanks
I am using a connection object from code and a DataEnvironment in a VB application Set CON = New ADODB.Connection CON.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\AA.MDB;Persist Security Info=False" CON.Open Set RS = New ADODB.Recordset If RS.State = 1 Then RS.Close RS.ActiveConnection = CON RS.CursorType = adOpenKeyset RS.LockType = adLockPessimistic RS.CursorLocation = adUseClient …
Hi all, Need to get this thing running. Need to develop in VB6 and hook up the back end to sql server express. VB6 and sql server express are installed locally. Please tell me how to do this to get it up and running. It is urgent. thanks, b
Hi is it possible to do a search based on checkboxes, so for instance a user clicks on a few checkboxes and clicks on a search button, how can i then implement this into a stored procedure and does the stored procedure to have a format to take in the …
hello guys, i really need help....i have a transaction table in ms access N i want to retrieve last 10 transaction from the table from my vb form...how am i suppose to do it???i used the folloing code but it is displaying all transactions of a specific account number. N …
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 …
Ged Feeney just returned from a Mountain Rescue callout to search for two divers reported missing in Ullswater, in the English Lake District; they turned up safe and well, no further details to hand. This is by way of an introduction. I am Statistics Officer for the national organisation Mountain …
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 currently making a register page. which include user name, password, retype password, name, nirc, address, contact number and email. can tell mi the code for SQL server and linking? thx for the help
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 …
Hi Guys, I have completed a vb6 application that uses sql2000 database. I have sql client installed on my pc. I want to install the application on a machine that does not have sql on it. Will it work or do I need to install sql on the clients machine. …
Hi, My project is related to Hand Held device. We are using emulator. The total code is written in C#. There is some data of 83,000 records, I have to upload the data into the emulator. After uploading some 50,000 records it is showing some error like "Storage memory is …
Here is my code, it works when I leave away the line in bold, I can't figure out what's wrong with my line in bold, I've been checking my database so many times already, can you help me [QUOTE]With gridMieter .Cols = 5 .TextMatrix(0, 0) = "Frist_id" .TextMatrix(0, 1) = …
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] …
i want to create a dropdownlist and when i click the dropdownlist, then it should show the all databases which is present in SQLserver. (now i m using SQLSERVER 2005 and Microsoft VISUAL STUDIO 2005) can anyone help me plz? thanks in advance. CLEAR MY DOUBT IF U GENIUS
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 …
Can someone please help me figure out what I am doing wrong here? It is supposed to find the checkboxes per dataitem and see if that specific dataitem needs to be deleted. And if it does, to delete them all after adding it to one SQL statement. Please look below …
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 all , i m using Ms-Access applicaion in c# bt getting error while using a datareader again after closing it. here is the code. can any one please help me?????????? if (sCl.Read()) { if (!(sCl.GetValue(0) is DBNull)) code = sCl.GetInt32(0); if (!(sCl.GetValue(1) is DBNull)) court = sCl.GetInt32(1); if (!(sCl.GetValue(3) …
I have Vb SQL Software I want apply it on a WAN network Is it possible.please give an explanation for me. How a WAN network established
I'm using a typed dataset with several master:detail levels. I've already discovered I must set EnforceConstraints to false to load the data or I will get constraint conflicts. Now I am trying to discover how to delete related child records when a master record is deleted. The master gets deleted …
Dear all, I allow users to hit enter in my TextArea control (for address). The value is saved to SQL table. I show data in child form in GridView. If users click GridView row, will display in parent form. I get problem with address because it contains vbCrlf and JavaScript …
Hi all, Can you guys explain how can I connect a SQL database to a C++ application(actually my application is a MFC) through ADO.Net I've use Visual Studio .Net 2003 and SQL Server 2005 Express edition(because I work on WinXP) If you guys have a simple example, its better to …
Hello Friends.. I have a query ... I have connected to the database and retrieved some data from the database. All the info is in the SqlDataAdapter... There are some 10 rows of data in the sql data adapter. I want this row of data to be displayed in a …
Hi guys, sorry in advance for the following question: So, I've downloaded the adequate SQL Server 2000 driver, from the Microsoft's website. I've installed it to C:\JDBC\. I've set the classpath variable using the command promt by typing: set CLASSPATH=.;c:\jdbc\lib\msbase.jar;c:\jdbc\lib\msutil.jar;c:\jdb c\lib\mssqlserver.jar; The problem is that the following error message appears, …
Hi, I have a calendar w/data stored in SQL Server. People can reserve multiple dates for an event. Before a reservation is confirmed, I want to be able to see if the dates have already been reserved. I first query the dates for the unconfirmed reservation. I then want to …
I do not want to misguide anyone responding, I am a newbie to the C++ arena. I am just doing little starter programs to figure things out, but for the life of me I don't get the whole hInstance thing. The objective I have is to learn C++, write a …
Weird ASP/SQL Problem Consider the following HTML Form, it has a textbox and a search button. [CODE]<form method=post action="search.asp"> <input name="txtName" type="text" id="txtEmail" /> <input type="submit" name="Submit3" value="Search" /> </form>[/CODE] The search.asp page: [CODE]select * from tbl_group_contact where userName ='"& request("txtName") &"'[/CODE] if I put this query in the search.asp …
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, …
Hi am Raphael: I have developed An Access xp database with sql server as backend my problem has only been that if I want to deploy updates to clients, I Must go to the client and update tables Sp,views. I have tried using text files to update but so far …
Can a VB6-SQL2000 softwre can execute in WAN network.How it is possible what is the procedures to create a WAN network
Hi all, I have been trying to drop a stored proc for sometime using SMO. I can create with ease but can't seem to drop. Any ideas? I thought it might be permission but for testing used SA account. No luck... [CODE] private void btnCreate_Click_1(object sender, EventArgs e) { SqlConnection …
I am trying to get a value from a stored procedure: [code=SQL]SET @RowCount = @@RowCount IF @RowCount = 1 BEGIN SET @Ret = 1 PRINT 'Insert a success' END IF isnull(@RowCount,0) = 0 BEGIN SET @Ret = 2 PRINT 'Insert a failure.. Terminating Proc...' RETURN END[/code] I should be getting …
Hi there I'm now using Microsoft Access and i have a column called VT. I stored it into a variable called vibrotactile. [INLINECODE]vibrotactile = ds.Tables("maskingSimulator").Rows(s).Item("VT")[/INLINECODE] The problem is the column contains checkboxes. If my VT column is not checked, it will carry out Case 1. Else, if my VT column …
Here I am again with my next sql problem. I'm not sure if I can use insert into for what I need. What I want to do is the following. My tables I have tblreminder with userid workid workdate I have tbluser with userid and username My textbox I have …
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
Hi I am a self-taught asp.net developer - MCP / MCAD / MCSD - with a very good academic knowledge in Microsoft technologies. I haven't work for a company as a developer and lack of that experiece gets in the way against my progress. If any one can help me …
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
The End.