|
Hi All,
I have to write some VB 2005 code that will capture barcode data sent via TCP/IP. I will then put the captured data to a SQL 2000 database table. I have no problems with the database stuff, where I really need HELP is how to capture the data beginning sent via TCP/IP port.
I have the scanning hardware setup on my desk and working. Using the scanners setup software I can see that it is sending data out from its IP address on port 1024. The output string has a starting Header of “STX” and an ending footer of “ETX”.
Example (STX**************ETX)
* = Barcodes Data
I would appreciate any help. Have not done any coding with TCP/IP before.
Regards Woodsy
|
|
|
|
|
Normally, I'd say you'd write a TCP/IP client to capture this data. You'd connect to the IP and port of the device and setup a NetworkStream object to read the data comming from the scanner. Exactly how you implement this, though, should be documented by the manufacturer of the scanner.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
can any body help me??
LRESULT CALLBACK WndProc(HWND hwnd, UINT Message, WPARAM wParam, LPARAM lParam)
i'm trying to convert this c++ code into vb 6.0 can i?, any recommendation for the message sending function i should use in vb?
thx
|
|
|
|
|
If I understand your question correctly, this can't be done in VB6. This is the Window Procedure function declaration that already exists in all VB6 Forms and controls. If you want to subclass the form, you'll have to supply your own, alternate, WndProc. You can find an example of installing your own message handler here[^].
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi Gyes,
I have an application built on vb.net and this application connect to Oracle server database and retrieves data from it. What are the requirements needed when I wanna install this application into a new PC. I mean is there a need to have Oracle installed in the PC or not.
|
|
|
|
|
No, you don't need to install Oracle on the client.
---
Year happy = new Year(2007);
|
|
|
|
|
But the .Net uses some files exist in the Oracle home like OCI.DLL which enables the .Net to connect to Oracle DB and retrieves data from it. So how do you say that we don't need to install Oracle on the PC????
|
|
|
|
|
If you are using any libraries in your application, of course you have to include them when deploying the application. That has nothing to do with the fact that the libraries comes from Oracle. You don't need to install Oracle to connect to an Oracle database.
---
Year happy = new Year(2007);
|
|
|
|
|
As I told you, we need a library called OCI.dll which comes from the Oracle home (bin folder inside Oracle home) and also other DLLs to enable the application to connect to Oracle, so how do we not need to install Oracle on the PC if we need these DLLs which are coming from Oracle and not embedded in the .Net framework???
|
|
|
|
|
You need to install the Oracle client on the users machine. You will also have to configure the tnsnames.ora file to be able to connect to the database.
Mike Lasseter
|
|
|
|
|
What Guffa means is that you do not need to install the Oracle database server on the PC. You may need to install some small redistributable parts of Oracle to allow the client to connect to the server. This should be documented in the .NET data provider you are using.
|
|
|
|
|
The system requirements for the .NET Framework Data Provider for Oracle state that the machine must have the Oracle Client, 8i Release 3 or greater or 9i or greater if your accessing a UTF16 database, installed in order to work.
System Requirements[^]
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
So gyes, if we wanna finish this conversation about my question, we can say as a result that we should install the Oracle client on the PC and also change the TNS names...realy I did that before but it is realy not good thing in the .Net framework that it needs some files from Oracle client to connect to Oracle DB. I think the .Net framework team developers must include those files inside the .Net framework to be more flexible and to less the need to install Oracle client each time you install your application into some machine in your company. Finally thank you very much gyes.
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
Kind Regards
OBarahmeh
Palestinian Central Bureau of Statistics (PCBS)
Ramallah-Palestinian Territory
|
|
|
|
|
obarahmeh wrote: but it is realy not good thing in the .Net framework that it needs some files from Oracle client to connect to Oracle DB.
Why not? Besides, there are licensing issues here. Microsoft can't package parts of the Oracle client in the .NET Framework because Oracle won't let them. There's also an issue of functionality with different versions of Oracle. Like was stated, if you have a UTF16 database, you neeed to change out the underlying Oracle Client. This saves you from having to recompile your code and release a different version just to support the different encoding! How is this a bad thing????
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
hai...
recently, just this afternoon i being asked by my superior to do vb function for retriving data(collect data and save in database)using vb6,in order for me to be transfered from acc to it department(web developer assistant)...it just a simple one but means a lot for me..imagined that i haven't touched vb since 2 years after my graduation in 2004...the rest software maybe..but not vb...
any guys know...a simple coding for this..thks..i have to submit this thursday morning......even i asked help from my friends...
i need to study and review all the thing again...oh gosh..i trying to sort out this mess...
 ,
sissy12
|
|
|
|
|
Dim DbaseConn As ADODB.Connection
Dim RecSet As ADODB.RecordSet
Set DbaseConn = New Connection
Set RecSet = New Recordset
DbaseConn.open(dsn="dsnname")
'For reading the records...........
RecSet.open ("Select * from tablename")
do while not RecSet.EOF
msgbox(RecSet!column1)
msgbox(RecSet!column2)
...........................
RecSet.movenext
loop
'For Add new record..................
RecSet.open ("Select * from tablename")
RecSet.addnew
RecSet!column1="value1"
RecSet!column2="value2"
RecSet.update
'finally close the connection
RecSet.close()
DbaseConn.close()
''''''''It's helpful for u
Keep Smiling !!!
Parwej Ahamad
g_parwez@rediffmail.com
|
|
|
|
|
In my application I have a typical setup:
* Dataset with numerous DataTables, each with a TableAdapter
* Various BindingSources
I want to add a new record to a table of which I only fill one record at a time into my DataTable, meaning the DataTable in the DataSet will always only have 1 record.
The table in my database (SQL2000) has an Identity(1,1) column as the Primary Key.
When I add a new record to my DataTable, the first problem I get is that the Primary Key for the new record is wrong, probably because it doesn't know what the last identity insert value in the SQL table is. But even when I specify a value an Exception occurs at my BindingSource.EndEdit() section of the code. This exception reports that I cannot insert a NULL value into Column "ID"(or whatever my PK column is named)
Where can I find an example of adding a user entered record to a datatable with an Identity column. This must be done using the controls on the form that are bound to the datasource.
(WinForms VB.Net, Visual Studio 2005)
you can't forget something you never knew...
"Watching Migthy Joe Young made me hate my life..................................I want a gorilla!" A. Havemann
|
|
|
|
|
Google is the short answer.
Long answer follows:
Ideally, you should populate the data table, post the data back to the DB and get the newly added ID back (using stored procs?)
Shreekar
|
|
|
|
|
It's when I attempt to update the DB when the exception occurs. All I want is for the DataSet to update the DB without supplying a PK, and not through an exception because one wasn't supplied.
"you can't forget something you never knew..." M. Du Toit
"Watching Migthy Joe Young made me hate my life..................................I want a gorilla!" A. Havemann
|
|
|
|
|
evilnoodle wrote: the first problem I get is that the Primary Key for the new record is wrong,
why do you say this?
Shreekar
|
|
|
|
|
Because the DataTable is filled with only one record, when adding a new one, I basically clear the data from the DataTable to enter the new record, but the communication between the actual DB and my application is lacking because it the identity that's automatically entered into the PK column is one bigger than the last record the DataTable was filled with, and from there on, every new record is given a PK value of 1 more than the last one.
Say the next entry in my DB requires a ID of 2110, but my DataTable is loaded with a record ID:1152, clicking my new record button which does a BindingSource.AddNew() adds a record with ID 1153.
"you can't forget something you never knew..." M. Du Toit
"Watching Migthy Joe Young made me hate my life..................................I want a gorilla!" A. Havemann
|
|
|
|
|
Hi,
I am working on a project that uses a VB.NET application for sending e-mails. This application works as a scheduler and is scheduled to start after every 1 min. It works as follows:
1. It picks up the projects that are scheduled to run(send mails).
2. It picks up the contacts to which the mail needs to be sent.
3. It sends the mail.
Now I have used threading so that each project picked up in the 1st step is executed as a different thread. Now the problem is that when the scheduler starts again after 1 min, the projects picked by this instance have to wait for completion of all the threads belonging to the previous instance. I want these new threads to also start concurrently with the previous threads that are already running.
Any suggestions on this will be highly appretiated.
regards,
Sandeep
|
|
|
|
|
Perhaps if you can't finish the task in a minute, you need to run it less often ? I mean, you can't get more speed out of having all those threads, the older ones will just wait longer, for the ones that have been started.
You can create all the threads you want, that's not an issue. But, I wonder how many is practical.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
Hi,
Thanks for the reply but why it is happening that threads(say 4 project threads) belonging to the one instance of the scheduler(our application) and other threads belonging to separate instance(2nd instance that will be created after 1 minute), what exactly prevents threads from 2nd instance to start.Is there any background and foreground threads kind of issue.
Regards
Sandeep
|
|
|
|
|
Nothing, I don't see how that is possible. What makes you think it's the case ? Why is it running twice ? How many instances will be running, over time ?
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
