|
thanks John,
But the problem is after a dialup connection established between the PC Client and the DB Server, I could not login through The SQL Query Analyzer which resides on the PC side also.
Error message says the DB ( on the DB Server) does not exist or access denied.
COuld this be that the OS running on DB Server is Pro instead of win 2k Server? Any other ideas?
JW
DJ
|
|
|
|
|
Did you try to connect to the database using the ip address instead of the machine name?
John
|
|
|
|
|
I tried the IP address in SQL QUERY Analyzer. It did not work either.
I am trying to access using code:
sDSN = "Provider=sqloledb;" &_
"Data Source=TEST\SEAN;" &_
"Initial Catalog=test;" & _
"User Id=sa;" &_
"Password=password"
\
thanks
DJ
|
|
|
|
|
Thanks a lots.
The problem was caused by some OS modules corrupted in Win 2k.
I changed to another SQL server on a third machine, now I can access via SQL Query Analyzer and my program.
DJ
|
|
|
|
|
I have an SQL Server 2k (personal edition) running on Windows 2000 Pro for testing.
I tried to connect from other PC running SQL server to this databse. However,
from SQL Query Analyzer on the local PC, I could not find the database once I clicked on the ... which is right to the SQL Sever: text box.
The connection between the PC and the Database machine is modem dialup. From either side, I can ping to each other without any problem.
Moreover, once I connected my PC to the intranet, I can access/login to any SQl server database which is within the intranet environment.
ANy help are greatly appreciated.
JW
DJ
|
|
|
|
|
What exactly isthe question??? 
|
|
|
|
|
Sorry I forgot the problem description itself.
The problem is that after the PC client and DB Server (currently SQL 2000 sever running on WIndows 2k Pro) were connected via a dialin service, from the PC site I can not see the DB on the DB Server, nor could I login to the SQL residing on DB Server of course.
ANy idea, again?
JW
DJ
|
|
|
|
|
Ok, I think i know the problem now,
You can access the DB when you are connected to the intranet but now able to access it via dial in. That is because the firewall of the intarnet is not allowing to make connection from outside the intranet.
This is to prevent hackers/viruses to connect to the network. You need to talk to the network administrator of your organization and how he can allow access to the DB only from outside the intranet.
|
|
|
|
|
But what I had done was to dial up directly into the DB Server from the PC client. and from either side, I can ping successfully to each other.
SO there is no firewall between the PC client and The DB Server.
Any suggestion?
JW
DJ
|
|
|
|
|
Thanks a lots.
The problem was caused by some OS modules corrupted in Win 2k.
I changed to another SQL server on a third machine, now I can access via SQL Query Analyzer and my program.
JW
DJ
|
|
|
|
|
I would like to know how to create an instance of a program run within the window of the calling program (like the start or web tab in the older versions of Kazaa when it would open an instance of Microsoft Word for example to view a document) could someone please help me.
Mr. Man
|
|
|
|
|
Look into COM and Embedded Document stuff. (I've just exhausted my knowledge on the subject...)
Anyone who thinks he has a better idea of what's good for people than people do is a swine.
- P.J. O'Rourke
|
|
|
|
|
I would like to know how to create an instance of a program run within the window of the calling program (like the start or web tab in the older versions of Kazaa when it would open an instance of Microsoft Word for example to view a document) could someone please help me.
Mr. Man
|
|
|
|
|
I'm brand new to C++ and I have to figure this out really fast. I'm almost completely lost so I could use all the help I can get. Thanks in advance. This is what I need to do:
Write a program that allows you to add two time durations expressed in hours, minutes and seconds. Your program should prompt the user to enter these fields for both times and the display the result including a day field. Here’s an example of what your output might look like:
First time duration
Enter hours: 12
Enter minutes: 23
Enter seconds: 32
Second time duration
Enter hours: 13
Enter minutes: 26
Enter seconds: 47
Total time is 1 day and 01:50:19.
|
|
|
|
|
double difftime(
time_t timer1,
time_t timer0
);
defined in time.h
|
|
|
|
|
And....?
What is your doubt, exactly?
We don't do your homework here, but we may help you to understand it better...
Perl combines all the worst aspects of C and Lisp: a billion different sublanguages in one monolithic executable. It combines the power of C with the readability of PostScript. -- Jamie Zawinski
|
|
|
|
|
If you expressed each field as a ratio of that part of a day, you'd have something like:
(12/24) + (23/1440) + (32/86400) =
0.5 + 0.015972 + 0.0003703 = 0.5163425926 (a little more than half a day) Do the same for the second duration yields 0.5602662037. The sum of those is 1.0766087963, which is 1 day, 1 hour, 50 minutes, and 19 seconds.
Or, you could add the fields individually, like:
s3 = s1 + s2
if s3 >= 60
s3 = 0
m1 = m1 + 1
end
m3 = m1 + m2
if m3 >= 60
m3 = 0
h1 = h1 + 1
end
h3 = h1 + h2
if h3 >= 24
h3 = 0
d3 = 1
end
print d3+" days,"+h3+" hours,"+m3+" minutes,"+s3+" seconds"
"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)
|
|
|
|
|
Hi all!
I have to do an enumerated type but I don't know how is it.
If my variable is "color" and it may have the value red, green, yellow, blue or pink, how would it be written?
Thank you in advance 
|
|
|
|
|
enum enCOLOR
{
enRED,
enGREEN,
enBLUE,
enPINK,
}
main()
{
enum enCOLOR mycolor;
mycolor = enGREEN;
....
switch(mycolor)
{
case enRED:
....
case enGREEN:
...
}
}
|
|
|
|
|
Does anyone remember the Win32 APIs to poke version info into an .exe? (The opposite of GetFileVersionInfo())
Thanks,
/ravi
My new year's resolution: 2048 x 1536
Home | Articles | Freeware | Music
ravib@ravib.com
|
|
|
|
|
I dont know why its required, if anyone can change it from outside, then integrity of the versioning is lost. Version no should be changed during the build time only.
|
|
|
|
|
I wouldn't change post-build either;
However, I'm fairly sure that versioninfo is a resource, so you need the UpdateResource call. Note, however, that it is not supported on 9x or ME.
I'm sure there's an article on it hereabouts...
Steve S
|
|
|
|
|
Thanks, Steve! I too am hestitant to change it post-build, and have come up with a pre-build alternative hack to burn the version into the .rc.
/ravi
My new year's resolution: 2048 x 1536
Home | Articles | Freeware | Music
ravib@ravib.com
|
|
|
|
|
However much of a hack it feels, it will inevitably be easier than post-build.
Steve S
|
|
|
|
|
Hi all, I am a total newb when it comes to program, I am currently in the process of writing my 3rd simple program, and I am having a whole bunch of trouble..becuase I am trying to teach myself, and I am lost trying to do this with online tutorials and whatnot
Alright this is my problem i found...I was given a file from a website....(studenttests.dat) It looked like this...
It gives the students name and his 3 tests scores then his average..
Smith Bill 85 75 74
Jones Ann 100 70 80
Walker Thomas 30 90 92
I have to be able to input the file into the program, Be able to calculate a certain students average by giving their name. and the program has to input the first 3 tests scores then average them...For some reason I cannot get the file into the program, I have tried from the A: drive and the C: drive, both to no avail...any help you experts out there could give a rookie like me would be GREAT...this is what I have so far..i know its very simple but like I said...Im a newb, ...this is the coding I have so far...but i am lost
<br />
#include <iostream><br />
#include <string><br />
#include <fstream><br />
#include <iomanip><br />
<br />
using namespace std;<br />
<br />
int main ()<br />
{<br />
<br />
float lastn1,firstn1, t1,t2,t3, lastn2, firstn2, t21,t22,t23,lastn3, firstn3<br />
,t31,t32,t33, avg1,avg2,avg3;<br />
<br />
ifstream inFile;<br />
inFile.open("C:\\studenttests.dat");<br />
inFile >> lastn1 >> firstn1 >> t1 >> t2 >> t3 >> lastn2 >> firstn2 >> t21 >> <br />
t22 >> t23 >> lastn3 >> firstn3 >> t31 >> t32 >> t33;<br />
<br />
<br />
if (! inFile)<br />
{<br />
cout << "Cant find file joe...." << endl;<br />
return 0;<br />
}<br />
<br />
avg1 = (t1+t2+t3)/3;<br />
avg2 = (t21+t22+t23)/3;<br />
avg3 = (t31+t32+t33)/3;<br />
<br />
cout << setprecision(2);<br />
cout << " S T U D E N T G R A D E R E P O R T"; <br />
cout << endl << endl;<br />
cout << "STUDENT TEST TEST TEST FINAL";<br />
cout << endl;<br />
cout << " NAME ONE TWO THREE AVG" << endl;<br />
cout << endl;<br />
cout << setw(3) << avg1;<br />
cout << "lastn1", "firstn1";<br />
cout << avg1, avg2, avg3;<br />
<br />
return 0;<br />
<br />
}<br />
And this is what it SHOULD look like...
S T U D E N T G R A D E R E P O R T
STUDENT TEST TEST TEST FINAL
NAME ONE TWO THREE AVG
BILL SMITH 85 75 74 78.0
ANN JONES 100 70 80 83.3
THOMAS WALKER 30 90 92 70.7
AVERAGE 71.7 78.3 82.0 73.3
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
