I am a little rusty at this but i think if you change the uid and pwd to "Uid=" & username & ";pwd=" & strPw & ";" you should have it

there may be another way but off the top of my head you can use "or"

SELECT id FROM dtlstbl WHERE refid = 1 OR refid = 2

actually i just did a quick search and found

SELECT id FROM dtlstbl...

Your missing your join from.

SELECT product.product_id, product.product_description, price.price_list_id from product join price on product.joiningfield = price.joiningfield where...

so you can change the table name in vs? i didnt think you could thats why i recommended sql management studio

I am a little confused. I am assuming that the ref_id is a uniqueid from another table?

How are you keeping track of the times accessed? Is it a history table? If you try to access a record that lets say has a history and has been accessed 5 times it adds it to history. programmatically...

Not sure if that is possible. Can you not install management studio express to make any changes to your DB?

in management studio right click the table you want to edit. you will see modify. click it. this will bring up the column properties. from here you can change anything you would like.

I had changed the sp a bit and got it to work in the program. It now takes about 10 seconds program side to run the report.
This is the original problem.

ALTER PROCEDURE [dbo].[MAR] ...

I have a program that uses a Stored Procedure to create a report. Unfortunatly the SP has a problem in the VB6 code. The program could pull the information perfectly until 2 days ago. Now the program...

1.

CREATE TABLE IF NOT EXISTS `tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tag_name` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`tag_id`)
)


you do not have a field called...

so you have 247 different countries that can be entered into the same table multiple times. in other words you could have millions of records in this single table?
anyway sorry about rambling just...

Try this:

CREATE PROC SaveFileToTable
@Database VARCHAR(50),
@Table VARCHAR(50),
@Column VARCHAR(50),
@WhereClause VARCHAR(200),
@FilePath VARCHAR(500),
@Server VARCHAR(50) =...

try this

USE Persons;
GO
BACKUP DATABASE Persons
TO DISK = 'Z:\SQLServerBackups\Persons.Bak'
WITH FORMAT,
MEDIANAME = 'Z_SQLServerBackups',
NAME = 'Full Backup of Persons';
GO

just to get an idea can you show your connection strings to both instances?

Primary key is the unique identifier of a row of data. like:
table Dogs:
dogid=1(pk)unique
dogname=spot
dogbreadid=5(fk)
age=3

dogid is the dog spots unique identifier in the db. dogbreadid...

looking in your db i noticed that you do not have any orders in February. This will be one reason why you cant pull anything from the first query. change the date to 6/2/2008 and BAM its full of data...

try this link and page out. great for referencing...
http://www.java2s.com/Code/VB/Database-ADO.net/Database-ListView.htm

You are looking for Joins. This link is a good starting point.
http://www.w3schools.com/Sql/sql_join.asp