I've run my program on one computer fine, however when I run it on another PC which has high security settings I have a OleDB permission problem, can I access my DB another one which will avoid the IT department getting to involved to much? (they just very busy right now)
View 7 RepliesI've got a problem whereby I get Permission Denied while accessing a database via OleDB. I know how to unlock this but i'm not permitted to do so. I was wondering if ODBC would work? I'm not sure on the settings around this on my the PC where I'm going to use this application but wonder if this has less security around it. your thoughts until I can test this next week. Or is there another way you may know that I can use a database. (access)
View 2 RepliesI am trying to save data to my table but i am getting a error message.Here is the code. It tells me a parameter is missing. The amount of fields in the table is the same as the fields i am inserting into.
'''''''''''''''''''''''''''''''
'' Now the ingredient table
'''''''''''''''''''''''''''''''''''''''''
Try
[code]....
I'm trying to updatesome records, currently my table is blank apart from the user id which is correct. but i get the error below.
My UserSettings table is as follows
ID is a Integer
MonthID is a Integer
YearID is a Integer
UserName is a string
Balance is a Integer
PhotoAddress is a string
GameSpeed is a Integer
This is my code and below that is my error in my ErrorTXT box.
[CODE]...........................
I am concatinating a couple of text files and then deleting the individual files. (Not the output file)
The only problem is that I am getting a permission error "Exception from HRESULT: 0x800A0046 (CTL_E_PERMISSIONDENIED)" when I try to delete the files.
I can delete the files using the code below if I do not concatinate the files but as soon as I do I cannot delete them.
To concatinate:
Public Sub MeltText()
Dim SW As New IO.StreamWriter(OutPutFile)
Dim Files As String() = IO.Directory.GetFiles(StartDirectory, "*.txt")
Dim File As String
SW.WriteLine("Sw
I use a custom tool to translate a flat text to xml text. I then create the file, with over-write set to True. When I try to write the text to the file, I get the error. The error says "Error: Invalid procedure call or argument", "System: Access is denied." It seems like the Create command is holding the file locked, so the Write command fails.
Running in VbsEdit IDE, I can see it fail. If I copy the text which is trying to be written, and paste it into UltraEdit, then attempt to save the file there, I get the same error This is expected, because the VBScript execution is holding the file locked. It should NOT be holding it locked for the script itself, right?[code]...
I need video chat application in my project.I had created VB.NET user control in class library project for Video Chat and its working.
But when i am trying to load user control in c# web page. While Executing i am getting security error as....
Application attempted to perform an operation not allowed by the security policy.<br/>
To grant this application the required permission,<br/>
contact your system administrator, or use the Microsoft .NET Framework Configuration tool.<br/>
If you click continue, the application will ignore this error and attempt to continue.<br/>
System.Security.Permissions.SecurityPermission<br/>
[Code]...
When I am trying to connect to database from VB.net, I am getting error.
This is my code.
Public g_Conn As new SqlClient.SqlConnection
With g_Conn
.ConnectionString = "user id=sa ;data source= CCTSRV8; " & _
"persist security info=True; " & _
"initial catalog=pubs ;password=mrwizard"
.Open()
End With
I am getting system.data.sqlclient.sqlclientpermission error.
I have an old app, a VB5 front end with access 97 databases all works Ok using the ...program files... folders in XP but I now have a user on Vista and we have problems opening up, and I am braced for problems saving and closing down, if we ever get there.
I sent him a c# applet which found the users folder using string Dpath = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData);
I have moved the data and all settings files to a folder C:Users[Username]AppDataLocal[My app Name][My app data Path]
The start up routine checks a settings file uses the path in the settings to re-attach the front end database to a backend database, test to see if the database uses replication and set the default data path for the rest of the app. we are failing somewhere in here I am sure. I have checked and there are no updateable files in program files
Have I got the wrong path or is there something else I should be looking for?
I have an vs2008 version of the app which is using a similar location but a SQL server database- no problems
This is a simple fragment of my code:
[Code]...
The last line throws an exception "Cannot open file" with certain end-user profiles. It works perfectly fine when executing from an Admin account. I just cannot figure out what user privileges and access settings may cause the error. Note that it also works with some end-user accounts (not admins). What missing user rights can cause this?
my program read and writes into registry and has been working fine, until today when i tested it on a new server i got this error request for the permission of type system.security.permissions. registryPermissions, mscorlib,version=2.0.0.0. i checked the registry permission and made sure all allows are ticked.
View 3 Replieswe are making our program in other computer it runs, without errors, but then when we transfer the program to another computer it has an error that says
An error occurred creating the form. See Exception.InnerException for details.The error is: Request for the permission of type
'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
My.Computer.FileSystem.DeleteDirectory("folder location here", FileIO.DeleteDirectoryOption.DeleteAllContents)
I created a program which was deleting a particular directory for me. The program was compiled and working. Today I run the same program...did not do any system updates and now it won't delete my specified directory. I ran tests to make sure the directory is there when testing...I keep getting access/permission errors.
I rebooted system, ran my application...still gave me error. I turned off Windows Defender...still got error. If I manually delete the directory...no problem.
Is there a way to get system permission to delete the directory? I am being given an 'access denied' error...I do not have permission. I tried running my application as administrator...no good. - VB 2008 Express - VISTA OS
For my current Project I need to fetch the data from an excel file.Each second the data in the excel file is changing... What I want to do is, copy it from the excel and Validate it in every second.So I use an Oledb connection to get the data from Excel file... s working excellent for two hours... After 2 hours I am getting an error that"the connection for viewing your linked microsoft excel worksheet was lost......"
View 1 RepliesI'm trying to get a connection established for an OLEDB connection, but since I've never used it, I don't really know what I am doing wrong. I managed to get a connection in the web.config file, I think, but now I get the 'must declare scalar variable' error. I thought I declared it, but it. [code]
View 1 RepliesHow can i make ms access and vb.net program setup compatible with windows 7. my program setup give oledb connection error in windows 7 but it successfully run in xp.
View 4 Replieswhen i tried to saving value to My.Settings its just work fine on windows xp. but when i ran on windows 7, VS2008 told me to change permission on My.Setting to writeable.
View 4 Replieshow do I clear the permission for a certain user and also add a new user with some security permission?
View 2 RepliesI am once more having throuble linking my visual basic code to the acompanying database. this current error is when I'm trying to add a new record to the database, using an OleDb dataAdapter: Whenever I run it, I get the error "Syntax error in INSERT INTO statement."
[Code]...
I do not have a lot of experience in vb.net, but I am trying to use OleDB to insert a record with String,string,Yes/no(studentname, number, gender). However when I insert it , there's a exception raised stating that I have invalid syntax for the "insert into" query. I could not spot the error.
Test case:
txtName.Text = "asdasdasd"
txtPhone.Text = "123456789"
rGender.Checked = True
[Code]...
Getting an unspecified error (wonderful description btw, microsoft) on the constructor of an oledb connection. Here is the stack trace
[code]...
I'm trying to protect a folder and the files inside it. I'm able to protect the folder itself, so that if somebody clicks on it he will get a message: "You don't currently have permission to access this folder!"
[Code]...
Just wondering if i might hit a snag in my program. Ive got 10+ users using the same files, via a Oledb to put info into an excel spreadsheet. If 2 or more people save there file at the same time will the program go into read only on one person. Normally one 3 will use the file at one time. I know Sql itself would be better to use. best way i can describe it, normally using excel if you manage to open the same file twice one opens as normal but the other opens as a Read only file, will the same thing happen if im using Oledb connections?
View 2 RepliesMy application using Ms Access DB. when i connect to DB from client machine it show error at conn.open. the error was "you need permission to view its data".If I login to the server, it works perfectly.
[code]...
Is there any way to access the DB from code without server login?
I use the following code to write to a Foxpro DBF. The SQL table I am reading from has 9500 rows. When I loop through the following code, I get an error after about 940 rows. There is nothing wrong with the SQL data. The message I get is 'Variable Q940P65 is not found'
Public g_OLEDB_ConnectionString As String = "Provider=vfpoledb;Data Source=N:;Collating Sequence=machine;"
dim strSQL as string = "INSERT INTO STATEUSR(DATEFIELD, STATECODE, MINAMOUNT) VALUES(?,?,?)"
[Code]....
I have created an application in VB.Net 2010 and am using an Access 2010 db. Connecting to this DB I use the Provider= Microsoft.ACE.OLEDB.12.0 and it works fine on my machine. This was a recent update from using Jet as that provider was having issues on client Win64 computers that had Access 2007 or 2010 installed.Basically my issue is that I get the error that Microsoft.ACE.OLEDB.12.0 is not installed when I try to run the application on the client.
The problem however, is that I do not want ask the users to install Data Access Objects in addition to .Net 4.0. I want a simple install that they can run and upgrade to .net 4.0 if they need to. The above thread states a solution as "You can also consider to use ADO.NET object in System.Data.OleDb namespace to connect to the Access database instead of the Provider. In my opinion, this is the best choice since the ADO.NET provides you the powerful data access objects." This sounds like a great option, however I cannot find any way to install the ACE dll and get it to work on the client.what do I need to include in the client installer to get my application to run on systems without Access installed? Do I just include the ACEODB.dll or is there something else that needs to be done?
I have a situation in which I must execute a dynamically built stored procedure against tables that may, or may not be in the database. The data retrieved is then shunted to a VB.Net backed ASP based report page. By design, if the tables are not present in the database, the relevant data is automatically hidden on the report page. Currently, I'm doing this by checking for the inevitable error, and hiding the div in the catch block. A bit kludgy, but it worked.I can't include the VB code-behind, but the relevant stored procedure is included below.However, a problem with this method was recently brought to my attention when, for no apparent reason, the div was being hidden even though the proper data was available. As it turned out, the user trying to select the table in the dynamic SQL call didn't have the proper select permissions, an easy enough fix once I could track it down.First and foremost - is there a better way to check for a missing table than through catching the error in the VB.Net codebehind? All things considered, I'd rather save the error checking for an actual error. Secondly, is there a preferred method to squirrel out a particular OLE DB error out of the general object caught by the try->catch block other than just checking the actual stack trace string?
SQL Query - The main gist of the code is that, due to the design of the database, I have to determine the name of the actual table being targeted manually. The database records jobs in a single table, but each job also gets its own table for processing data on the items processed in that job, and it's data from those tables I have to retrieve. Absolutely nothing I can do about this setup, unfortunately. [code]
Im working on an AutoUpdate class for a small application I've been working on, and with Windows 7 and Vista machines I get a permissions error when trying to replace some of the files in the Application folder. The only way to get it work is to run the application as an administrator. Is there a way I can either attempt to automatically run the app as administrator, or a way of replacing the files that won't be blocked by Vista/7's permission gatekeepers?
View 1 RepliesI'm Connecting VB.NET 2008 and MS ACCESS 2007 using this code.
LocalConn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|inDebugDatabaseDatabase.mdb;Persist Security Info=True")
LocalConn.Open()
But it always return an error of The 'Microsoft.Jet.OLEDB.4.0 provider is not registered on the local machine.Im using Windows 7 Home Premium 64 bit.
i have an VB.Net 2003 Application Program that use MS Access, that works fine in Windows XP and Windows7. But when i create that same program to VB.Net 2005 Application Program that use MS Access.it works fine in Windows XP. but in Windows 7 it shows this error Quote:microsoft.jet.oledb.4.0 provider is not registered on local machine
[Code]...