|
Thanks - that was what I needed.
Have a great day!
CiscoKid55
|
|
|
|
|
|
Use a stored procedure and have it find you the max value of the primary key column and add 1 to it and then insert the record using the new value.
Declare @NextID int;
Select @NextID=(case when Max(ID) is null then 1 else Max(ID)+1 end) From Table1
Insert Into Tablel (TStamp,ID,...) values (GetDate(),@NextID,...)
|
|
|
|
|
Is it possible to have eg 8 threads in a Blocking status waiting for a multicasts from 8 different feeds.
Whats the best way of doing this. i have 8 different senders of UDP packet and i need to know when ech is transmitted and from what machine its coming from
|
|
|
|
|
1) setup 8 different listeners on 8 different ports. then there is no confusion on who's sending you the packet because each sender is assigned to his/her own port.
2) setup 1 listener and in the packet have some identifier of who's doing the sending or resolve the sender's ip address to know who it is.
i would opt for #2 unless there is a lot of traffic coming from each sender but obviously your call...
Nathan
|
|
|
|
|
Sounds good. but
1) Is it possible to have all 8 broadcasting on the same port?
2) Is it possible to get the IP address of the sender by reading the header of the UDP?
|
|
|
|
|
1) (hopefully I understand your question) yes each sender can send a packet to your program using the same port (1 listener) at the same time. there maybe some queuing involved but as along as the transaction isn't long, there will be notice of any delay.
2) the socket itself should give you the ip address of the sender. i believe there is an ariticle or 2 within codeproject.com that will give an example.
|
|
|
|
|
Hi - Would like to disable this option in my Windows Installer project - how would we go about doing this?
Thanks for your time.
|
|
|
|
|
One more time this day !
I would like to find the equivalent of ReadXml under CF1.0 for CF2.0.
Thank you,
Ch'Portos.
Yop Yop !!
|
|
|
|
|
sorry i dont get any seperate section for VB
i have a problem related to vb.
i have developed an application thru vb and sql-server.
when i m using it frm my pc it works fine
but frm client pc it does not connect to database.
error on this line....
conn.open()
on client pc sql-server client utility is installed
wht to do..
i m very much confused
reply ASAP..
Ajay
|
|
|
|
|
What is your connection string? Are you using a DSN or DSN-Less connection?
BLee
|
|
|
|
|
my connection string is
Constr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;password=;Initial Catalog=TestCapex;Data Source=192.168.41.2"
m using DSN-Less connection.
plz help
i m very upset..
|
|
|
|
|
192.168... is an internal IP address. Make sure you use the correct IP address if your client is outside of your local network.
Jonathan Sampson
www.SampsonResume.com
|
|
|
|
|
ya my client is in our local network..
and one thing which shd be noticed here is that
i m getting access frm my PC
but not frm my client's PC..
now i have given public access to the database.
any suggetion
|
|
|
|
|
Unless the IP you gave us is fake, the 192.168 is a "safe" ip address used internally for networks. can the user's PC get to that IP address? ping it from the user's pc to check.
|
|
|
|
|
i have pinged and getting the reply frm 192.168.41.2 frm my clients PC.
also my client is in our local network..
any suggetion
|
|
|
|
|
1) by chance is your sql server using a different port then what is the default? try adding the port to the data source 192.168.41.2,????? i've seen where my PC doesn't have to give the port but other pc's do...explain that...
2) if that's not the case, try setting up a temporary DSN and make sure the PC itself has no issue connecting to the database.
3) is the PC up to speed on MDAC versions
|
|
|
|
|
May i know anyone have any example of access database using vb6?? I am new to vb6 and when i look at vb6 book i found out that it is quite diff from .net. Please help...
|
|
|
|
|
Check out any book using classic ADO. If you know vb script for classic ASP pages, then apply that knowledge. Sorry can't be more specific but I haven't used VB 6 with Access for a few years.
|
|
|
|
|
What exactly are you trying to do with VB6/Access and find difficult?
|
|
|
|
|
cos when i look through the vb6 book. it is very different with .net. Their framework and syntax all different. i actually need to retrieve stuff from access and enter stuff in. Sumthing like staff record and information tracking.
|
|
|
|
|
If you look through the database chapters in that book, you will probably be able to get a few examples of interacting with Access, I think.
In any case, just Google for VB6 + Access, and you are likely to get a ton of stuff.
|
|
|
|
|
ya i know.. but the problem is my company got no internet..
|
|
|
|
|
Oh... tough luck...
How about the book then? Did you find a chapter on database access?
|
|
|
|
|
ya.. tt bk is database for vb6 but somehow i dun really understand... the recordset make me very blur...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
