9,022 Topics
Can anyone help me with SQL? I am really strugling to try and figure this out.
I have an issue like, I need to insert data from an XML file into MS Access table. I am able to do this with ADO as one by one row. But this terribly hits the performance when the number of rows to be inserted exceeds 1000. Kindly help with …
i'm creating a password using VB6 and SQL 2000 as da db. my problem is i don't no how to connect the password table in db wt the textbox. so guys, any idea ?
Hi, I have a csv file and I need to remove the quotation marks from it (i need then to import the data in SQL server, and all the data has " eg "1543"). Can some one pls help; i am not a C# programer... actualy I started reading C# …
Hello, I am new to Python and I am just starting to figure things out but this one has me stumped. I need to capture the exit code of my processes in order to track them in a database. I have all the other components working except this. In DOS …
hello!! this is my hijackthis log: Logfile of HijackThis v1.99.1 Scan saved at 14:09:52, on 22.8.2005 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe C:\Program Files\Sygate\SPF\smc.exe C:\WINDOWS\system32\spoolsv.exe C:\PROGRA~1\Grisoft\AVGFRE~1\avgamsvr.exe C:\PROGRA~1\Grisoft\AVGFRE~1\avgupsvc.exe C:\Program Files\Common Files\LightScribe\LSSrvc.exe C:\Program Files\Common Files\Microsoft Shared\VS7Debug\mdm.exe C:\Program Files\Microsoft …
I have made created a databse MSSQL and want to upload it to my web space how do i go about it.
I got as far as being able to execute a dts package from vb.net. The dts package passes a global variable to a stored procedure. How can I capture the returnValue of the stored procedure in vb.net? I'm stuck and can't figure it out. Can anyone please help me? Thanks, …
Hi Everyone, ColumnName DataType Length AllowNulls sampleKey char 10 engDesc char 40 Yes frDesc char 40 Yes When I try to add a record,if the Textbox is empty then I am getting an errror. If it's not empty then it adds to the table. But in database, I checked those …
Hey guys i'm busy with a project my group is struggling with connecting database to server.We are using VS asp.net with sql for our database so we are failing to get the connection right.And we are trying to update,delete,add into our tables it seems to give a source error can …
Kindly help me. I am new to VB and also in SQL database programming. I am doing a small library system consisting of 3 tables namely: Member which has Mem_Code as primary key, Name etc., Book which has Book_Code, Book_Name etc.and Issue which has both Mem_Code, Name, Book_Code and Book_Name …
hi...i have an assignment which is to develop a registration system by using SQL 2000 and vb 6...the problem is i don't know how to integrate vb 6 with SQL server 2000. any idea how can i do that?
I want to return an XML stream from a SQL 2000 database using a URL query. I have been trying to get a simple M$ Northwind example to work on a Windows 2003 server but I can't get it to work. I can get the simple example to work on …
Hi everyone, I have a SQL statement that runs just fine: select distinct(b.swName), a.mwBillToCompanyID, a.mwPaymentTerm, c.swCountry, d.mwCommCode, e.mwGRWarehouse, e.mwDongle, case when e.mwExportStatus in ('B','C','EL','EUS') then 'End Use Required' else 'No End Use Required' end as 'EndUse', dbo.mw_Get_Distrib_Countries(a.mwBillToCompanyID) as 'Countries in Territory', mwDiscountName, dbo.mw_Get_Distrib_Discounts(a.mwBillToCompanyID) as 'Discount Amounts' from mw_office_info a join …
hi i just like to check if this database can be connected to or accessed by many computers...or is it only one computer can be connected to the database? please reply.. thanks! =)
I'm creating a sales invoice order form and whenever a purchase is made, the quantity of a certain product ordered is deducted from the product database. how do i do that? I am using this sql query to get the product details input from vb to the database. SELECT Invoice_Detail.[InvoiceNo], …
Hi I have a problem with making a setup file for my application If a setup file is not possible please tell me how would I be able To move the application around…. I have made an application with front end in C# and dbms SQL Server (ie. ADO.net)… As …
Hello! I've been searching the web for nearly a week now trying to figure out how to read the information a user can enter into an interactive web excel spreadsheet. More precisely, I need for a user to enter an unlimited amount of numbers and I need to be able …
I have this kind of error: (and i can't seem to solve this) Error Type: Server.MapPath(), ASP 0172 (0x80004005) The Path parameter for the MapPath method must be a virtual path. A physical path was used. /proj/save.asp, line 12 this is my code: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> …
ok, here is the script I ran to create the stored procedure [code] SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE [insertFunction] (@Id [int], @class [nvarchar], @type [nvarchar], @name [nvarchar]) AS declare @classID [int] select @classID = tblClass.ID from tblClass where tblClass.Name = @class INSERT INTO tblFunction ([ID],[Name],[ReturnType],[Class]) …
Hi, I have a dts package that I created which uses an odbc connection to go and copy a dbf file using visual fox pro drivers. The package runs fine when I execute it. But whenever I try to use the sql server agent to run it as a job …
[COLOR=DarkOrange][FONT=Verdana]hi fellows, here i have successfully installed the nokia mobile internet toolkit and nokia mobile browser 4.0 on xp machine... and can run the wml pages both in th nokia browser and internet explorer. Right now i want to connect it with MS sql 2000 database. How can i connect …
I do need some help I am building up an asp application that will access an SQL server [database] so what I want is for the admin access to add, update and delete in all the tables I have about 13 different tables so my questions is do I have …
Greetings, We have recently released our new component for Delphi and C++ Builder that allows end-users to build SQL queries visually. Of course, we understand that we are not the first guys who make such a component, but our component differs from other query building solutions in the ability to …
I found the test 70-228 to contain a wide variety as far as question difficulty. About 1/3 of them were very easy, about 10 (of the 45) questions were quite hard and had me second guessing myself a little, and the rest fell somewhere in between. I passed on my …
Here is the code I use in the World recipe random record. I've been looking all over the net on how to display random record using access db on ASP .NET, but found most for SQL server like NEWID(), doesn't work on Access. This could be easily done in ASP …
The MS SQL 7.0 Server is installed on a Windows server, not placed in my home. I want to make a SQL query from my home, using java JDBC, but I get an error: java.sql.SQLException: Network error IOException: Connection timed out: connect - This error I don´t get if I´m …
Please help me in ASP is support many style of ContentType = "video/x-ms-asf" ,"vnd.ms-excel" ... but not support style foxprox (.dbf) I want to use SQL select database and export to file dbf Thank you !
Hey all, Heres the code of an ASP I'm working on... ------------------------------------begin ASP------------------------------------- <%@ Language=VBScript%> <% artist=Request("artist") album=Request("album") Set con1 = server.CreateObject ("ADODB.Connection") Set rs1 = server.CreateObject ("ADODB.Recordset") con1.Provider="Microsoft.Jet.OLEDB.4.0" con1.Open (server.MapPath ("\databasecore\mediaguide.mdb")) sql = "UPDATE artistinfo SET UserAlbumReview='"&TRIM(Request.Form("AlbumReview"))&"' where artist ='"&artist&"' and album = '"&album&"'" rs1.Open sql,con1 %> <html> <head> …
Hi, I am in the process of deciding the database and application language. We have exising MS SQL server running on windows OS, to save the company's product data, right now I need to build another seperate system for intranet use, as I am more familiar with PHP+Mysql, I want …
I need a help. I have a SQL SERVER database where I have put persons with their birthdate. I need to calculate ages of them. For examble my birthdate is 12/27/1982 and I have to debit (minus) from current date. Does anyone have any idea how to solve this problem.
Hi everybody! I am having a strange problem, Im working with a remote access database, i have one application to introduce info to de database and other for making a query. The firt one works perfect...but in the second one the application jumps to the error code when tries to …
Can a tuple hold a URL that points to a particular file, so that when a SELECT is made on that tuple it will open up the file itself? What I'd like to do is within the db store the URL like "C:\MyDocuments...\Image1.jpg". When I use a SELECT statement on …
Can someone enlighten me on this issue ? I have data source A - with a stored procedure in which I'd like to select records from tables in a different data source, B.
hi, please help me ... how to create dynamic menu using vb.net (webform)?? and my menu should be displayed base on data on the database. i'm recently using ms sql ... thanks for your helps
SELECT NZDate - CAST(NZDate - '2005-01-01' AS int) % 7 AS WeekStarting, sum(score)/7 from myTable where (NZDate between '2005-01-01' and '2005-01-21') and name IN ('John','Bob','Harry') group by NZDate - CAST(NZDate - '2005-01-01' AS int) % 7 order by weekstarting Hi, I have a query (above) that given any start date …
anyone can help with data navigation in vb and ms sql 2000?
Current app runs a stored procedure which runs 16 nested procedures and takes from 3 to 10 min depending on how must data needs download from the as400. The problem is that there are some other web apps on the web serverr that use old com objects that have memory …
Hi, all! I need to load base from ODBC-source into MSSql base using MsSql DTS at my customer's side with automatic as much as possible('Pushing 1 buton'). I have found such an example: DECLARE @object int DECLARE @hr int --create a package object EXEC @hr = sp_OACreate 'DTS.Package', @object OUTPUT …
Hello there, we are converting our applications from a sybase server over to MS SQL Server 2000 and have run across a query that is acceptable in sybase but not ms sql. It is giving us a table name correlation error that we can't figuire out. In sybase the sql …
Hello, I have two questions, first some background info: We are running SQL 2000 on a Windows 2003 server for out aircraft parts database software. There are 7 workstations (windows 2000 and XP) that run the parts database. 4 of those workstations run really fast, the database calls are near …
HI 1. I have a typical problem.We have a 2003 server which is a user authentication server.I have a sql server 7.0 on NT platform.I am logging in to the 2003 server from my XP workstation. 2. I am authenticated to 2003 server & simultaniously to NT server which has …
im new to vb, i need to use vb6 to connect to local sql server with the local system account and get all the databases. ill be very thanksfull for any help.
Please help !!! I am designing a database system and I am a bit stuck and do not know my next step forward. I am using SQL Server 2000 to develop a database system from scratch for a medium sized company which does not have an IT dept therefore I …
I'm having trouble thinking how to write a query ... i have two tables customer and contact ...they share a common element of customerID ... their is a login form based on the contactID, contactPassword within the contact table, based on that i want the contactID and customerID of contact, …
Here is my [b]Stored Procedure [/b] stored in SQl DB. [code] CREATE PROCEDURE qparmVerifyLogin @First_Name varchar(30), @Last_Name varchar(30), @SSN varchar(9) AS Select First_Name, Last_Name, SSN, ADDRESS1, CITY, STATE, POSTAL, DEPTID, EMPLID FROM PERSONAL_DATA_TBL WHERE First_Name = @First_Name AND Last_Name = @Last_Name AND SSN = @SSN; GO [/code] [b]Below is the …
I've been having continuing pop up problems for weeks now. It started with a "surf" something or other .exe file, which I deleted / fixed usunf hijackthis etc. Now I still have this pop up ...but can't delete it. I'm also getting "pocker" and "casino" icons popping up onto my …
Hi, I've made a web application, and now I want to be able to distribute it with a copy of MSDE SP4. MSDE has to be installed via command line, and the web application takes a certain database setup. I've got all the scripts and commands ready to install the …
hey guys, i don't program at all , i just run and maintain the servers,so i really don't know much about php but my manager is trying to create web based bill menu for our company using php. he wants to be able to create a user, without being logged …
Hi, all! I run in PHP процедуру MSSql-procedure: $Stmt= mssql_init( 'ProcName', $Con ); ... $Result= mssql_execute( $Stmt, true ); if ( !$Result ) { echo mssql_get_last_message(); ... The problem is that if this proc generate an error(for ex breaking the unique index), mssql_get_last_message() gives "The statement has been terminated." but …
The End.