|
The first hit it is NOT! I spent a fair bit of time Googling through this.
Reasoning behind this is
1). the application code runs 100% fine 100% of the time on one user account that has admin privileges but not another admin account that is local (no domain or other policies exist affecting this).
2). The data inputted is not greater than the max size of the Access database column, I have analyzed the data source (every last row and column of every row) and no data is larger than the limit (if the data for a column was too large then the code would not work fine with the exact same data as it did on the first user account)
3). There is a string limiter function that has been tested and it is not possible for the data that gets passed onto this insert code to exceed the limit because it will chop it off at the allowed limit at code level this is actually well below the limit of the columns in the access database.
I just regret this application has to have a sh*tty Access backend. I would have been done and dusted and had the bugs ironed out weeks ago had been on a proper database server backend.
M Access sometimes sux
|
|
|
|
|
Change your OleDbParameter creation code to explicitly define the fields being sent as paramters, such as field type and width. Do not rely on the OldDbParameter class to use its defaults like you're doing now.
|
|
|
|
|
I need a script to upload a file to an FTP server on a daily basis. The code can be in VB Script or Active-X or DOS commands in batch file. I can use window's scheduler to run that script daily. The FTP Server will have user name, pw to upload files.
Please help me in above regard.
Thanks in advance
Srinivas Mateti
|
|
|
|
|
|
Sir i Did nt get u.PLz can u b more clear
Thanks
Srinivas Mateti
|
|
|
|
|
Read the sticky posts on top (The first two posts).
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
You made me hover mouse on that link to see if you really searched that code.
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
renatcoder ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Christian Graus wrote: renatcoder ?
rentacoder for dyslexics 
|
|
|
|
|
How to plug/unplug USB serial port problematically?
I am facing some strange issue with my USB serial port.
I want to unplug and plug the USB Serial port Programitically, as i need to refresh the connection between system and hardware connected.Kindly help.......
Thank in advance for the great programmers
|
|
|
|
|
...
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
hi you can do this using the registry.
set the DWORD of "Start" in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\{driver}\ to "4" for disable and 3 to enable.
this may help  never tested ^^
|
|
|
|
|
I am looking for some one who did it problematically.
But still thanks for your Solution
|
|
|
|
|
WTF is 'problematically'? I did it while using a problem?
|
|
|
|
|
OP means through code.
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
whats the exactly problem you have with usb plugged devices ?
i may can help you out, i wrote a serial component in c# that checks wheather the connection needs to be
closed after unplugging the device and reopend after replug the device to usb without running into exceptions..
|
|
|
|
|
I have connected the usb serial port and started getting the data from the hardware.
Suddenly i will stop the hardware and re run it .Now the problem is when i return the hardware and try to re connect the my application back and try to connect the COM port, it throws me a message the port is already connected and because of this i can not receive the data, kindly help me to understand the stuff
|
|
|
|
|
If you kill the hardware, the classes relating to the serial comms have probably bombed, and your application itself is holding the serial port resource on one of its async threads. I have seen this while programming to a usb/serial device (resol solar controller). When you exit the application the lock is released and then when you start the app again all is fine.
You should check that when you kill the external hardware or pull the connection, the necessary exceptions are being caught and the serial connection is closed gracefully to ensure all resource locks are released.
|
|
|
|
|
The problem is that the stream in the SerialPort class will not be closed if the external hardware will be removed. this is an bug in the framework. to prevent this behaviour the solution is to rewrite a serial port class using unmanaged code or to kill the application like daveauld described above..
serial port communication was not designed to work during the hardware will be removed. in ealy cases this was not possible because the COM was an integrated hardware in the pc not an usb plugalbe device.
i had the same problem and sovled it by rewriting the serial port (internal catching read/write errors and than closing and reopening the filestream on COM).
bless
|
|
|
|
|
and it may be wise to call DiscardInBuffer() and DiscardOutBuffer() right after creating your serial port, and before connecting any event handlers to it.
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
|
|
|
|
|
i want to display report in a3 sheet. while display only one half of report is shown but when export report to excel full report is available
|
|
|
|
|
Not sure if this sending you down the right route, but does the default printer on your PC support A3 printing?
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
Want Remote Connection in Sql Server with C# application ... via Sql Server Authentication... Data Souurce name was created Successfully ... But Could not Access that DataSource name from our C# appliction...Wht is Trusted in Sql Server ....
Thanks
|
|
|
|
|
Well, the best place to ask this would be the C# forum, not the vb one, but anyway check out http://www.connectionstrings.com. It would also help if you posted the error.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
1. Wrong forum. This should go to C#/General database forum depending on your problem.
2. If connection string is the problem, take a look at ConnectionStrings.com website.
3. If remote conection is the problem, check if your SQL server allows remote connection. You can change the settings through Surface Area configuration provided you have the authority to do so.
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
