Database Discussion Boards

shoaibadshah4-Jun-06 20:27

4-Jun-06 20:27

I want to know how i can transfer data from one MS ACCESS table on one computer to another MS ACCESS table on another computer by using a phone line on each computer using VISUAL BASIC 6.0

Shoaib Hussain

Re: Transfer Data Over Phone Line [modified]

albCode4-Jun-06 21:01

albCode

4-Jun-06 21:01

Please read rules

Re: Transfer Data Over Phone Line

Rob Graham5-Jun-06 2:25

Rob Graham

5-Jun-06 2:25

Don't shout!

It's rude, and no one will answer you if you shout

Re: Transfer Data Over Phone Line

Garg Vikas5-Jun-06 4:34

Garg Vikas

5-Jun-06 4:34

Shoaib,
Please ..... !!!

<no comments="">

Vikas G

Vikas Garg

Re: Transfer Data Over Phone Line

Stephan Samuel6-Jun-06 3:55

Stephan Samuel

6-Jun-06 3:55

1. Install hex viewer.
2. Load Access file in hex viewer.
3. Call person on other end of phone line.
4. Read hex codes to other person so they can type them in.
5. Save file on remote end.

Error converting data type DBTYPE_DBTIMESTAMP to datetime.

dabuskol4-Jun-06 18:53

dabuskol

4-Jun-06 18:53

Hi,

I am trying to retrieve data from Oracle database using SQL server but after running the statement I encountered an error message. Need help..

select tm_tfr_no from SMSS..NI.NI_TFR_MAIN a <br />
where tm_tfr_received_date_by_lt ='2000-05-21'

Error converting data type DBTYPE_DBTIMESTAMP to datetime.

Dabuskol

help with sql query.

aakar4-Jun-06 18:45

aakar

4-Jun-06 18:45

Hi,
I am writing a query that returns me the various figures all the salesperons:

My query goes like this :

Select Usr.user_name as SalesPerson,
isnull(ReqNo,0) ReqNo,isnull(ResSubToSalesPerNo,0) ResSubToSalesPerNo,
isnull(ResSubToClientNo,0) ResSubToClientNo,isnull(InterviewNo,0) InterviewNo,
isnull(ConfirmNo,0) ConfirmNo,isnull(RejectionNo,0) RejectionNo
from
xr_user Usr
left Join
(select sales_person_id,count(requisition_date) ReqNo from xr_sales_reqs where
requisition_date between convert(varchar,'5/1/2006',101) and convert(varchar,'5/29/2006',101)
group by sales_person_id) Reg on
(Usr.User_Id = Reg.sales_person_id)
left join
(select A.sales_person_id,count(date_sub_sales_per) ResSubToSalesPerNo
from xr_sales_reqs A left join xr_candidate_links B on A.sales_req_id=B.sales_req_id
where B.date_sub_sales_per between convert(varchar,'5/1/2006',101) and convert(varchar,'5/29/2006',101)
group by A.sales_person_id) cl1 on
(Usr.User_ID = cl1.sales_person_id)
left join
(select A.sales_person_id,count(date_sub_client) ResSubToClientNo
from xr_sales_reqs A Left join xr_candidate_links B on A.sales_req_id=B.sales_req_id
where B.date_sub_client between convert(varchar,'5/1/2006',101) and convert(varchar,'5/29/2006',101)
group by A.sales_person_id) cl2 on
(Usr.User_ID = cl2.sales_person_id)
left join
(select A.sales_person_id,count(date_interview) InterviewNo
from xr_sales_reqs A Left join xr_candidate_links B on A.sales_req_id=B.sales_req_id
where B.date_interview between convert(varchar,'5/1/2006',101) and convert(varchar,'5/29/2006',101)
group by A.sales_person_id) cl3 on
(Usr.User_ID = cl3.sales_person_id)
left join
(select A.sales_person_id,count(date_of_start_entry) ConfirmNo
from xr_sales_reqs A Left join xr_candidate_links B on A.sales_req_id=B.sales_req_id
where B.date_of_start_entry between convert(varchar,'5/1/2006',101) and convert(varchar,'5/29/2006',101)
group by A.sales_person_id) cl4 on
(Usr.User_ID = cl4.sales_person_id)
left join
(select A.sales_person_id,count(date_of_rejection) RejectionNo
from xr_sales_reqs A Left join xr_candidate_links B on A.sales_req_id=B.sales_req_id
where B.date_of_rejection between convert(varchar,'5/1/2006',101) and convert(varchar,'5/29/2006',101)
group by A.sales_person_id) cl5 on
(Usr.User_ID = cl5.sales_person_id)
Where isnull(ReqNo,0) > 0 or isnull(ResSubToSalesPerNo,0) > 0 or
isnull(ResSubToClientNo,0) > 0 or isnull(InterviewNo,0) > 0 or
isnull(ConfirmNo,0) > 0 or isnull(RejectionNo,0) > 0

now I need to join 1 more table i.e. xr_client cos I need to figure out how clients has each salesperson responded to :

xr_sales_reqs and xr_client have client_id as the common field.

can anybody help me out?

Thanks in advance,
Aryan.

Error Message

peter timmins4-Jun-06 14:07

peter timmins

4-Jun-06 14:07

Hi i keep getting this error message while trying to start a hook dll,
"Error s800D failed to connect," also this discription of my error mesage "%s: Failed to prepare the command SQL = %s." this i know is a syntax error, is their a programme or xp regedit trick to help me out and get this third party dll hook working, any suggestions would be appreciated thxs
peter.

THANX FOR YOUR HELP PETER

Re: Error Message

Paul Conrad21-Jul-06 7:21

Paul Conrad

21-Jul-06 7:21

Is there a log file or anything like that in which you can dig around at this more? Consult documentation with the third party .dll provider Smile | :)

ms Access/DAO

Tara143-Jun-06 22:12

Tara14

3-Jun-06 22:12

Hi,

I am sure whether this is the right place to post this question. But it is to do with database.

I have a program coded in vc++6 and MS ACCESS as the database.The data connection is done using DAO.

Suppose I run this program on a computer that does not have microsoft office installed, will it still work? i.e. will it still be able to connect to the database?

If not, will installing the MICROSOFT JET ENGINE be sufficient?

Thanks,
Tara

Fortitudine Vinsinues!

Re: ms Access/DAO

Stephan Samuel4-Jun-06 3:12

Stephan Samuel

4-Jun-06 3:12

Yes, the (free) Jet runtime, which automatically gets installed on many computers and can be repackaged into your installer, is sufficient for connections to the Access DB. Many programs do this.

Re: ms Access/DAO

Tara144-Jun-06 4:24

Tara14

4-Jun-06 4:24

Thanks a lot.

Fortitudine Vinsinues!

query

kjosh3-Jun-06 15:08

kjosh

3-Jun-06 15:08

Hi,
How to write a query to get 5th highest salary.
Thanks in advance

Re: query

Dinuj Nath3-Jun-06 17:45

Dinuj Nath

3-Jun-06 17:45

Select *,sal From Emp X Where 5 =<br />
(<br />
Select Count(Distinct Sal) From Emp Where sal >=X.sal<br />
)

Re: query

r.stropek4-Jun-06 6:16

r.stropek

4-Jun-06 6:16

Hi!

In SQL 2005 you should use CTE and the new ranking functions; write

<br />
with EmpCTE ( EmpNo, ..., Sal, SalRank ) as (<br />
  select EmpNo, ..., Sal, dense_rank() over ( order by Sal desc )<br />
)<br />
select *<br />
from EmpCTE<br />
where SalRank=5;<br />

Rainer Stropek
cubido business solutions gmbh
Email r.stropek@cubido.at
Visit my blog at http://www.cubido.at/Blog/tabid/176/BlogID/4/Default.aspx

Re: query

albCode4-Jun-06 21:06

albCode

4-Jun-06 21:06

select top 5 * from table order by salary desc

Re: query

Eric Dahlvang5-Jun-06 4:47

Eric Dahlvang

5-Jun-06 4:47

SELECT TOP 1 * FROM (SELECT TOP 5 salary FROM employees ORDER BY salary DESC) AS EMP ORDER BY salary ASC

----------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters

Need Query Help

Rabbit173-Jun-06 8:48

Rabbit17

3-Jun-06 8:48

I have multiple tables that I'm pullng into a C# DataSet.

My first method was to run a query and merge the data I need into one table using the MySQL command.

But here's my problem. I have a shared field x_ID where in one Table A it is null and in Table B it is the primary.

For example:
I have
Table A
Customer_Purchase $5, $4, $3
Customer_ID 1, 2, null

Table B
Customer_ID 1, 2, 3, etc
Customer_Name ...

My return for Who purchased what would only have 2 rows and I'd rather have all three, even though one would have no name in it.

Thanks!
RABB17

Re: Need Query Help

Stephan Samuel4-Jun-06 3:16

Stephan Samuel

4-Jun-06 3:16

You've posted this question before, and it's been answered. Please check your previous posting.

See here.[^]

Re: Need Query Help

Eric Dahlvang5-Jun-06 4:57

Eric Dahlvang

5-Jun-06 4:57

Outer joining is the key:

SELECT b.Customer_ID, b.Customer_Name, a.Customer_Purchase FROM a LEFT JOIN b ON a.Customer_ID = b.Customer_ID

This way you get everything from {a} regardless of what is in {b}

----------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters

Re: Need Query Help

Rabbit175-Jun-06 4:59

Rabbit17

5-Jun-06 4:59

Thanks guys, that works perfectly!

RABB17

Lost connection error using mysql & asp.net 1.1

Amit Agarrwal3-Jun-06 3:19

Amit Agarrwal

3-Jun-06 3:19

hi all
how r u? u guys might be fine. but i'm not fine in these days.

one bug is going to kill me.

porblem i s that i'm making aporject using asp.net with mysql.

i have made the project & uploaded on the server.

when i try to access my site some time pages run well but some times i founf a "LOST CONNECTION ERROR".

this bug does not come on the same page it can at any time.

plz somebody help me.

i tried to sound on net but not find any appropriate solution.

plz tell me if any one have faced the same problem & solved successfully
thanx

writting a log file through store procedure in SQL SERVER 2000

Praveen_S3-Jun-06 1:56

Praveen_S

3-Jun-06 1:56

Hi,

I have written a store procedure in SQL SERVER 2000. It contains lot of transaction. Some times as data is not in proper form transaction gets rolled back so i want to write log file of the error msg that are generated.
How can i do it.

Praveen

Re: writting a log file through store procedure in SQL SERVER 2000

Stephan Samuel3-Jun-06 4:13

Stephan Samuel

3-Jun-06 4:13

You can write to files and all sorts of other places, but the easiest thing would be to write to a DB table. If you're just debugging, that shouldn't be a problem: just create a table called something like Log, and write to it every time there's a problem.

If you do this in production and there are a lot of problems, the table can fill quickly. It's probably not the best way to do it in a production environment unless you've got a process to clean it out regularly.

Re: writting a log file through store procedure in SQL SERVER 2000

Prasad Dannani6-Jun-06 3:05

Prasad Dannani

6-Jun-06 3:05

use dos commands to log your errors. These dos commands can be executed using xp_cmdshell procedure in SQL Server.

you can also write console applications and run these application using sql server's xp_cmdshell command

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.