I have a vb6 ap that connects to a sqlserver 2000 database. I'm running the program on a machine without sqlserver and using a database stored on another machine. I cannot get my application...
Hello good people on this forum.
Here is the quesition from - disorgonized MS SQL db administrator.
I had this nicely done custom grown database for one of our web based application that...
How can I import an excel spreadsheet in a SQL db?
I'm using SQL+
filename is "in_prods.sql"
The sql statements are very simple, as shown below.
INSERT into product (product_name,
...
I need to change LOV property during the runtime by modifying select statement.
I have LOV defined as
Select col1, col2, col2
from table a.
I need to add an additional condition and ma...
Hi,
I have a db named "Distribution" that's is in Suspect mode ... I need to drop this and keep getting this error:
"Error 3274: cannot drop the database "distribution" because it is bei...
Hello everyone,
I need to do a SQL string where, as result, i can get the number of times that a value appears inside the records.
I.e.:
I got the fields date, referer and id. I'd like ...
I have a system DSN on most of our clients that now needs to be changed. Is there a clever way to remove a DSN, and install a new one (Old and new are both MSSQL server, but server name/and mo...
hey all,
This is a link to my previous question.
http://www.experts-exchange.com/Databases/MS_Access/Q_21014113.html
Criteria is still the same only I have a form where I can export a c...
Hi,
I am trying to load data into a collection and use it for processing in the procedure. I got the syntax for the collection but I need to know how to use the collection for validation, u...
I have a text file into which my vb program transfers data. May be I can give u information on how my text file looks.
In my textfile the data looks like the follwing,
primary or second...
We've been tasked with extracting the data (and hopefully any stored procs and/or views) in an existing database. I've asked everyone involved, and no one can identify the exact type of databa...
How can i write the column names of a table used in a query along with the query results into excel sheet.
select distinct empname from employee. here empname should be dumped into excel shee...
Hi, do someone has code for printing an Access report to postcript file?
thanks in advance,
augstef
I'm tearing my hair! Why the bloody h... wont this work???
I'm creating an access database file in ASP and ADOX.
This works great, but no records get put in it. no errors or anything just pl...
Hello,
Why, does 15 / 60 return 0? For example, in transact-sql, if I execute the query
print 15 / 60
SQL returns 0 instead of 0.25.
I guess it is assuming an Integer datatype for...
Hi all,
I've just installed SQL Server 2000 and MS Access 2000
I want to make an Access 2000 project. when creating such a project the wizard asks me
which server to connect to, and a v...
Hi experts,
i have a small problem.. i have sqresus.dll file in my system but when i run a software which use this file in ODBC Connection ..
i get an error message that the specified modul...
hi
i need to select unique values based on date(the recent date)
the table is like this
name created
aa 5/5/03
bb 6/3/04
cc 3/3/04
aa 8...
Hi,
I have a main form "Customer company", that has a subform "Customer Contact"
In the main form, there is a txtbox that is called "Customer Contact ID".
Depending on this txtbox, the co...
500 points to the one who solves my problem.
I am facing a lot of problems installing MSDE on my machine. I have downloaded the latest MSDE from the Microsoft web site (which is service pac...
Hello,
How do I display a number in engineering notation? That is, scientific notation where the powers are constrained to multiples of three?
e.g. 23.456E15 instead of 2.3456E16
tha...
Hi,
Can someone explain me what this error means? I've read short description of this error on Oracle site but it still obscure for me.
Thanks,
Peter
Hi All,
I have two Paradox Tables:
1- Cust.db // Customers File
CustNo CustName FirstDebit FirstCredit
1 John 200 0
2 Pete...
I am creating a VB6 appliation that logs live data and inserts it into a Access table. This database also has a main table that contains pertinanent information to the test being run. This m...
how do i decide which to use: cast() or convert() in t-SQL
