Make Connection Between Attendance Machine And Database?
Mar 21, 2010
i want make a attandance software but i need coding for make connection between attandance machine and databass. so i can connect to machine and downloadd attandace logs.
we are using Punch Machine for Attendance with zkemkeeper.dll and geting AttLog using Vs.net 2010.How can Get Records from SQL Query? my table structure like this
I've created a small DLL, an addin for Autodesk Inventor, this addin saves some information provided by the user and the program to an access(mdb)database.The whole idea behind this is that it allows users to quickly find drawings, assemblies and so on.The DLL works great on x86 systems however it has issues on x64 because I used ado.net.In a attempt to solve it I forced .net to compile it with the target x86 CPU settings.
However using this I'm unable register the dll (C:WINDOWSMicrosoft.NETFramework64v2.0.50727RegAsm.exe /codebase SavetoDatabase.dll )It says its not a proper .net dll file and therefore cannot be registered.
is there any other access-database connection provider (like dao or ado.net) that works on a 64 bit machine? Or do I need to change from mdb databases to another type (like mysql)? because sooner or later all machines its running on will be converted to x64.Or do I need to register the dll in another way?I've also tried to replace the conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0 with ACE, with no luck however
im trying to make an attendance monitoring system using vb.net 2005. i have a little experienced programming, i used vb6. But vb.net is much more different in vb6 because of its codes. my problem is that in dtpicker, it do not accept any value that came from a textbox.
my code is like this
dtpicker1.value = textbox1.text
but an error existed..then i coded like this hoping that it will work
I want to create small database which handles Student Attendance Record it will store the roll calls of students on daily basis that teachers collect from the students in the class on paper and then later transfer it on computer .So my database Must contain Month, Year, Program (BCS, BIT, MS, MCS, MIT etc) Batch (1st, 2nd etc) and Subject (English, Math, Geography etc)
Suppose I want to Search for the Attendance Sheet of any month, year, Program, Batch or Subject, it returns me the required dataSo i come up with the Datadase which includes 5 dimension tables and one fact tableDimension Tables1. Student (StudentID, Name, other Attributes)2. Program (Program_Name, other Attributes)3. Date (Date, Week, Month, Year)4. Batch (Batch_Number, Description)5. Subject (Subject_Name, other Attributes)Fact TableAttendanceTable ( StudentID, Program, Date, Batch, Subject, Status)but the problem come when certain columns are repeating again and again which is time consuming for database operator and shows inconsistent behaviour of database.
Look at it: my Fact table would be like this [code]....
problems:1. The StudentId is repeating which shouldn't (Primary Key),2.It wastes a lot of time coz i'm repeating the data again and again Like Program, Date and Batch which shouldn't be in consistent Databases.
I develop an application using vb.net.application will run on client server architecture.when we try to execute the program in client side then it will give me an error which is related to sqlclientexception.how can i handle this situation.i used vb.net 3.5 as front end and sql server 2000 as back end.i have done total coding with system.data.sqlclient namespace.
Now I know we can not do a system like the SQL of the...[code]He only opened the database, is there any way to open and use Access database login information for it?I am unfamiliar with this program , someone people can help me?Empty, You can be a example to me !!I just want a can connect to the network database (Access Database) VB programming
I'm using VB.NET 2010, and Microsoft SQL Server 08 Express. I've never done a data bound project before so forgive me if I have no clue what I'm doing.
I'm trying to use crystal reports in my database that i have made using vb 2010 and access 07, I'm trying to make a new crystal report in vb, have gone add new item, crystal report, etc but when i go to specify the new connection using the Microsoft office 12.0 access database engine )LE DB provider i keep getting a catastrophic failure error 0x8000fff?
I am doing a project on window application but the problem is that I want to connect the connection of database to the SQL Server database. Does anyone knows the connection strings of the connection.
i make a connection with SQL server 2005 database using Wizard in Express Edition 2008,I have got data in my text field using dataset , but now I want to execute query for insert, select and update but I don't know my connection vaiable and how to execute query and get data .what kind of connection is this Adodb or oledb etc
I am trying to make an oledb connection to an Access database.
1. I added a component class.It said drag from the toolbox to add components.
2. I dragged over the Oledbconnection and OledbdataAdapter
3. I clicked on new connection string for the oldeb Connection and try to connect to the SHX.mdb datababase in the debug/ bin folder I don't have a username or password for the database and do not want to set one up.( is this possible in .net?)
4.As soon as I try to test the connection, I get the "invalid authorization specification" message. I can't get past this and do not really understand why I am getting this message.I have vb 2005 standard edition, not express edition.The exact same thing happens when I try to set up the data adapter to the shx.mdb database.
I am on XP2 and not logged in with a password or username. Could this be the issue or is there something else I am overlooking.Also, since I am coming from vb6 and ADO is there anyway to just write the code without having to use datasets, adapters and oledb connections to bound controls?
I have developed a 32-bit VB.NET application that runs fine on 32-bit systems. Some of the folks in engineering, however, are using 64-bit machines, so we have created 32-bit virtual PCs and installed the application on the Virtual PC. When we try to run it, however, the application fails to establish a connection to the SQL server (remote, SQL 2000) for login validation.
I'm having an issue here with making a WMI connection to a remote machine using specified administrator credentials.I have the WMI code inside a function, I pass it the computer's name and it returns the WMI information that I am requesting as a string (or in this particular case, an integer) from the remote machine. I'm positive it works, and returns the information I need using specified admin username/password. NOW, the issue I am having is related to (it seems) calling this function from a backgroundworker. [code] "Value does not fall within the expected range." I literally have no clue why this would throw that exception, yet when I call this function from lets say just a random button on my form, it works beautifully. The key here is that I need my WMI requests/processing to run in the background.
I'm in the process of upgrading my web pages from asp classic to asp.net.My previous code used CDO to send emails.[code]This code works fine but I'd like to send emails from my asp.net pages. When I send from the .net pages, I get the error message: "No connection could be made because the target machine actively refused it xx.xx.xxx.xxx:2 " [code]I'm rather new to .Net but I've searched for hours and can not come up with a reason why the old code works but the new doesn't.
I have my tcplistener on port 5000, 127.0.0.1 as the ip and when i connect using my internal ip, 192.168.1.141 it "refuses the connection", same with the external but if i connect using 127.0.0.1 it works. how do i fix this?
I made 2 simple VB .Net applications.One is listening on a port and echoing received message to sender (server side), and the other sends messages to it (client side).When I run them both on my machine, everything goes fine.
The problem arised when I tried running each of them on different machines. The client throws an error : "No connection could be made because the target machine actively refused it"
chat application i getting error: No connection could be made because the target machine actively refused it.?? my english wasn very good..Is there another way to connect from first app. to second app. ? Maybe using webservice like
I get this error "No connection could be made because the target machine actively refused it 69.69.247.18:80." when executing this code. It is caught on the line indicated with..[code]
How to make a chat program. Well I just copied code in and the program worked. I can send a message to the server and it sends it back just fine. But I can only send a message once. If I try to send another message I get an error and it says this "A first chance exception of type 'System.Net.Sockets.SocketException' occurred in System.dll" then it "No connection could be made because the target machine actively refused it 127.0.0.1:500". Here is the link to the tutorial and code: [URL]
I want to refactor my existing application to work with as a client/server app, and was looking at introductions to Remoting.I got a simple system up and running 2 days ago, and haven't touched it since until just now, but now I'm getting an error message when trying to instantiate a class from the remoted DLL : "No connection could be made because the target machine actively refused it".The server and client are both actually running on the same machine for simplicity at the moment. I have three "applications" involved - a class library containing the server functionality, a listener application sitting with the server, and then a client applicaition.Most of the articles I can find online referring to this error seem to apply primarily to asp.net but I'm just using traditional vb.net (2008)I initially suspected the cause may be firewall related (as when I first got it running I was prompted to allow access) but I've turned off my McAfee firewall and also my Windows firewall with no joy, and besides - the error message seems to imply that communication with the server has been established but that it doesn't want to play ball.
94.69.250.128:8888 ( My external IP:Port that I've configures the task ) I'm kinda stuck in it, whilst my Chat application is ready, it seems it can't connect to the Internet now. The error is happening on the line :
I am trying to make a client server form application using VB2005. I am using VS2005 Professional for development.
The problem is as follows: When more than one client tries to connect to the server. The connection is refused and the Client gets an exception in Connect() method - Target machine actively refused the connection.
This problem occurs only when 2 or more clients try to simultaneously connect to the server. For a single client accessing at a time the problem does not occur. The code segment is as given below:
-----------1 Module Imports System.Net.Sockets Imports System.Net Public Class FrmMdiParent Dim WithEvents wsServer As New Winsock2005DLL.Winsock Private Sub FrmMdiParent_FormClosing(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles Me.FormClosing [Code] .....
The above exception is thrown when more than 1 clients try to access the server simultaneously.
[ERROR] System.Net.Sockets.SocketException:No connection could be made because the target machine actively refused it 192.168.0.59:500 at system.Net.Sockets.TCPClient.Connect(String hostname, Int32 port) at WinClient.Form1.btnSignIn_Click(Object sender, EventArgs e) [/ERROR]
Though I dont believe the issue is with the code here it is:[code]......
When I am developing an application and I use the 'Data Source' tab to create a database, will that database be automatically created when I use the software on another machine?