Click here to Skip to main content
15,899,006 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Error while read Text File Pin
Anubhava Dimri27-Oct-09 22:57
Anubhava Dimri27-Oct-09 22:57 
GeneralRe: Error while read Text File Pin
Christian Graus27-Oct-09 23:51
protectorChristian Graus27-Oct-09 23:51 
QuestionMy Application Issue. Pin
Nanda_MR27-Oct-09 18:57
Nanda_MR27-Oct-09 18:57 
AnswerRe: My Application Issue. Pin
Christian Graus27-Oct-09 19:46
protectorChristian Graus27-Oct-09 19:46 
GeneralRe: My Application Issue. Pin
Nanda_MR27-Oct-09 19:59
Nanda_MR27-Oct-09 19:59 
GeneralRe: My Application Issue. Pin
Christian Graus27-Oct-09 21:32
protectorChristian Graus27-Oct-09 21:32 
GeneralRe: My Application Issue. Pin
Nanda_MR27-Oct-09 22:30
Nanda_MR27-Oct-09 22:30 
QuestionVB.Net code wont ework propertly under certain account conditions Pin
Martin Stevens27-Oct-09 17:34
Martin Stevens27-Oct-09 17:34 
Hi
I’m having some problems with a small vb.net application I wrote that inserts data into an Access database.

When I run the application as my self it works comepletely fine on the Windows 2003 server or my desktop XP box.

But when I run it under a local admin account on the Win 2003 server box it does not work and spits our the following error for each insert.

“The field is too small to accept the amount of data you attempted to add.”

The bit I’m having a difficult time understand is why it works under my logon and not a local server logon. There are no domain policies or restrictions in place over the server or local account function on the server. It seems to have something to do with jet/eledb.

It is not possibly for the data to be to large because;
1). I’ve got a string limit function which chops of anything larger that what the field should be and this is far less than the Access DB memo field that most columns are set at.
2). I’ve done a thorough analysis of the data and none if it exceeds the maximum column size.

My vb.net code it fairly typical……

Try
Dim ConnectString, SelectStatement As String
Dim Connect As OleDb.OleDbConnection = New OleDb.OleDbConnection

ConnectString = (My.Settings("Access_db_tests"))
SelectStatement = "INSERT INTO test_information (pk_test_information, department_name)"
Connect = New OleDb.OleDbConnection(ConnectString)
Dim Cmd As New OleDb.OleDbCommand(SelectStatement, Connect)

With Cmd.Parameters
.Add(New OleDb.OleDbParameter("@parameter_pk_test_information", pk_test_information))
.Add(New OleDb.OleDbParameter("@parameter_department_name", department_name))
End With

Connect.Open()
Cmd.ExecuteNonQuery()
Connect.Close()
Connect.Dispose()

Catch Ex As Exception
Dim details As String = "pk_test_information = " & pk_test_information & _
" insert_row_to_Access_database - error message >> " & Ex.Message
log_exception(details)
End Try


Does anyone have any ideas?

Any feedback would be much appreciated.

MSmile | :)
AnswerRe: VB.Net code wont ework propertly under certain account conditions Pin
Luc Pattyn27-Oct-09 18:58
sitebuilderLuc Pattyn27-Oct-09 18:58 
GeneralRe: VB.Net code wont ework propertly under certain account conditions Pin
Martin Stevens27-Oct-09 20:33
Martin Stevens27-Oct-09 20:33 
AnswerRe: VB.Net code wont ework propertly under certain account conditions Pin
Dave Kreskowiak28-Oct-09 4:02
mveDave Kreskowiak28-Oct-09 4:02 
QuestionFTP UPLOAD SCRIPT Pin
sris 42627-Oct-09 5:49
sris 42627-Oct-09 5:49 
AnswerRe: FTP UPLOAD SCRIPT Pin
EliottA27-Oct-09 6:46
EliottA27-Oct-09 6:46 
GeneralRe: FTP UPLOAD SCRIPT Pin
sris 42627-Oct-09 7:08
sris 42627-Oct-09 7:08 
GeneralRe: FTP UPLOAD SCRIPT Pin
dan!sh 27-Oct-09 7:12
professional dan!sh 27-Oct-09 7:12 
GeneralRe: FTP UPLOAD SCRIPT Pin
dan!sh 27-Oct-09 7:09
professional dan!sh 27-Oct-09 7:09 
GeneralRe: FTP UPLOAD SCRIPT Pin
Christian Graus27-Oct-09 11:10
protectorChristian Graus27-Oct-09 11:10 
GeneralRe: FTP UPLOAD SCRIPT Pin
Richard MacCutchan27-Oct-09 11:51
mveRichard MacCutchan27-Oct-09 11:51 
QuestionHow to plug/unplug USB serial port programitically? Pin
pallaka27-Oct-09 0:57
pallaka27-Oct-09 0:57 
AnswerDo not cross post Pin
dan!sh 27-Oct-09 2:14
professional dan!sh 27-Oct-09 2:14 
AnswerRe: How to plug/unplug USB serial port programitically? Pin
freakyit27-Oct-09 2:17
freakyit27-Oct-09 2:17 
GeneralRe: How to plug/unplug USB serial port programitically? Pin
pallaka27-Oct-09 3:00
pallaka27-Oct-09 3:00 
GeneralRe: How to plug/unplug USB serial port programitically? Pin
EliottA27-Oct-09 3:02
EliottA27-Oct-09 3:02 
GeneralRe: How to plug/unplug USB serial port programitically? Pin
dan!sh 27-Oct-09 3:30
professional dan!sh 27-Oct-09 3:30 
GeneralRe: How to plug/unplug USB serial port programitically? Pin
freakyit27-Oct-09 3:37
freakyit27-Oct-09 3:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.