Access 97 And Windows Server 2008 R2 Farm Server?
Oct 26, 2010
We are currently using Access 97 as our database. This resides on the remote farm server (which is a Windows 2008 R2 server). We are using a front end vb6 exe which accesses the back end data.Occasionally we are getting corruption to our database and we have to make sure everyone exits the software to allow us to repair/compact it. There are 2 physical servers, each running 2 virtual machines. When the user logs onto the farm using RDP, they go to one of these 4 virtual machines.We are getting all kinds of corruption, some where # characters have been inserted into the top of one table, some where the indexes are corrupted, and some where access needs to repair the database.
View 1 Replies
ADVERTISEMENT
Apr 6, 2012
Case : I'm creating an application (desktop application) with VB.NET (actually windows form), and using SQL Server Express 2008 for its database.
[Code]...
View 1 Replies
Mar 21, 2011
I'm having an issue with my app where IE will get brought to the front of the screen when I am switching between forms. Basically I have a form with the man menu which consist of a few command buttons that will start up another form once a user clicks on the button. I do not want the users loading up multiple forms in my application, so once they load one form I end up hiding the main form. So my code looks as shown below when a button is clicked.
[Code]...
View 6 Replies
Sep 2, 2009
We recently upgraded our job server to Windows Server 2008. We have jobs we run manually in a folder (c:Custom Programs). Some programs are console programs others are have a gui. This one program has a gui.It also has a progress bar that shows the progress of the job when you click the go button. Of course it spawns a thread to do the processing. This thread creates a log file to write errors and other things too.
The problem is when the program goes to create the log file an access not authorized error is thrown. I checked the permission on the folder. All users are allowed to create/edit/append/execute. Pretty much everything except take ownership. Also, there's nothing that denies anything. So I see no reason why this isn't working. We can get this to work by using the run as administrator option when we first run the program. However, we don't view this as unacceptable solution. My only thought is the spawned thread isn't getting the same permission set as the program. Am I correct or does something think it's something else.
[Code]...
View 11 Replies
Mar 12, 2010
I have a .net Windows Service developed in VB.net. I have a settings file in the root directory called Connections.XML and I am setting the basedirectory [code]...
When I schedule the service this is working absolutely fine in my Windows XP machine. But when I installed the same service in our development server (Windows 2003 64 bit Server) for some reason it is not able to locate this file.
View 1 Replies
Nov 22, 2011
The error is raised after a normal user changed his password on - Windows Server 2008 Standard server joined to a workgroup
View 4 Replies
Aug 20, 2010
Web service uses SQL Server based authentication how to change to windows based authentication both web server & Database service resides in different domain .
View 1 Replies
Dec 21, 2011
how can i access remote sql server 2005 work on windows 7 ? and in the seem time i donot like turn off firewall .
and how i can make sql server listen to it port 1433
View 6 Replies
Sep 23, 2010
My windows application was written in vb.net and i recently added a web service to it so that I could place the access database in it and connect to it via the web server. I've been succesful in receiving data when doing select statements; however, I'm stuck when trying to do a simple insert statement to it.
[Code]....
View 4 Replies
Feb 3, 2009
I am trying to access a file using the following
CODE:
However I am getting the following error: "Object reference not set to an instance of an object."
View 3 Replies
Jan 11, 2010
I have programs written in VB2005 accessing mdb database in server. When the server run XP, it was never a problem (at the time, the folder was shared to all). There is a new rule in the company and we have Win 2003 server, and my mdb file must be stored in a folder in the server that the administrator (not I) have installed password. And clients are supposed to access it as user only. I can ask password as administrator, but the users of my program must not have the administrator password (which I can included in my program if necessary). How can I modify my program so that it can access the database? I assume I must modify my connection string, but I do not know how. I am currently using this:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= C:Integrity ERPPBF.mdb;Jet OLEDB:Database Password=ABC"
View 9 Replies
Aug 24, 2011
I have a situation where I need to create a session in a Windows server using a specific Username and Password.
View 1 Replies
Jun 8, 2012
I want to build an application, which can remote access to SQL Server in Server Machine.I used to build one, and it also can access to SQL Server in other pc. But when i promote it to become a Server(to become a Domain Controller). My application has never access to SQL Server. I don't know what to do now?
remember: I want to build an application, which is accessing to SQL Server in Window Server(Client/Server Application).
View 2 Replies
Jul 6, 2010
I want to know how you can export data from a disconnected database that could be access or ms sql to an sql server database.
Here is the scenario:
I have several software in a remote sites on either sql or ms access databases as back-ends...and I have another sql server database that i want to consolidate data from the remote sites.
One solution I have been thinking about is to use email to send incremental backups of the databases to the main database using a separate piece of software and have another one on the main server to pull that data into the database.
Basically am looking at setting up the remote databases as linked servers at the main database and then having incremental backups sent by email to the main database.
I have thought of replication but the internet link at the sites is terrible.
Is that a good implementation? If yes
How do i get to send the incremental backups and get them imported?(the code)
Tools:
Visual basic 2008 standard edition..Net 3.5
SQL Server 2005.
32 bit architecture.
View 2 Replies
Nov 17, 2011
We have migrated one of our websites from a windows 2003 machine with IIS5 installed.Search within the website also used an indexing service to search within a Catalog "index_pdf".The catalog indexed a folder on the server and Adobe iFilter 6.0 was used to be able to search through the pdf files. While migrating, we switched to another OS -> Windows 2008 (x86). On this machine we installed but now searching through .pdf documents doesn't work. We tested the website on a different server with different versions of PDF iFilters but unfortunatly without any result. Even on a Windows 2008 (x64) server with the 64 bit version of Adobe PDF iFilter we couldn't search through .pdf files.
Our findings:The classic Indexing Service in combination with classic ASP works. (filtering on pdf hasn't been tested)The classing Indexing Service in combination with ASP.NET doesn't work.On windows 2008 servers we have to use Windows Search, because IIS7.x communicates on a different way with the Indexing Service.Now we have to find a way to rewrite our excisting VB.NET code to a way in which it wil work with the new Indexing Service which we don't know to well yet.My question is how to approach this.
View 1 Replies
Aug 6, 2011
does anyone have a sample on how to impersonate on a windows 2008 server? my impersonate does not seem to work with 2008 server
[Code]...
View 7 Replies
Mar 2, 2009
I am NOT allowed to install into Windows Server GAC. I am allowed to upload my program files to a shared drive, not the operating system drive.To begin, I created a simple Class Library .dll and uploaded the entire project folder to the shared drive. I have absolute permission to do anything with this drive and the computer. This class library has only (1) public property.I created a client exe. with a reference to the shared drive .dll. I do not want a local copy of the .dll into my client folder. I want all clients to use this shared copy on my shared drive. And I repeat, I do not want to install into the GAC. I also have full permissions on my terminal.I have created a key file (.snk) for my .dll, and set up assembly information (public id) and tested.I have tried without key(.snk file), and removed assembly information, and tested.Can someone point me into the direction to install/or not to install a MyClass.dll on a shared driveand be able to reference it from other applications?I do not want to use ASP.NET. This is just a base class. This is not a Web service. It seems Windows server 2003 wants this installed into the GAC (C:WindowsAssembly)I have to be missing something.
View 5 Replies
Aug 11, 2010
i'm tying to send email in my application directly by the smtp server but the server doesn't allow me to do that.The application its used by everyone in the company, so i set the smtp client UseDefaultCredentials to True, but the server replies with this when i try to send an email:[code].....If i set the credentials by hand, the server sends the email. So my problem is how to make this work to everyone? I don't want to have one public/friend var all time in the application with the credentials of the current user?
View 9 Replies
Aug 10, 2009
Multi-User Chat Program (Server & Client) with Main Server?
View 1 Replies
Nov 2, 2011
I have developed a VB.NET program using a strongly typed dataset. This dataset has its connection to a SQL Server 2008 R2. The software should now be additionally used offline. The database should be exported to a *.sdf database. If no connection to the SQL server is produced, the software have to try to connect to the *.sdf database.I would like to achieve:
1. Export the data in the SQL Server 2008 R2 database to a local *.sdf file.
2. This *.sdf file has to work as an alternate connection string in the strongly typed dataset.
View 1 Replies
Nov 14, 2009
Is there any difference in using the GUI in VB2008 when creating database tables in SQL SERVER or Access. ? Using the Database Designer
View 5 Replies
Aug 18, 2009
I have simple code that connects to Sql database... (well it doesn't)
VB
Dim objConn As New SqlConnection("Server=localhost;uid=***;pwd=***;database=***")
objConn.Open()
ERROR MESSAGE:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)But looks like something is wrong with "localhost" thing. Any help? Where can I get name of (my) server?
View 34 Replies
Dec 4, 2009
I have a windows service written in .net framework 2.0. This service installs and runs perfectly fine on both XP and windows server 2003.We have a new 2008 box that we are migrating over to, so need to get this windows service up and running.When i try to 'start' the windows service on the 2008 machine, i get "Windows could not start the <service> service on local computer. Error 1053: The service did not respond to the start or control request in a timely fashion."I have searched everywhere looking for an answer, and all I could find was a fix attributed to .net framework 1.1 for this same error. That; however, is not applicable here, as the service was written in 2.0.
View 3 Replies
Dec 15, 2011
I have one more question. I am connectinag to SQL Server 2008, not express, and I keep getting the "login failed for user "...""[code]
View 7 Replies
Mar 8, 2011
how will i take the registry backup in windows server 2008?
View 1 Replies
Feb 23, 2010
I have a VB.NET executable program that I've been running nightly as a Windows Scheduled Task on a Windows Server 2003 machine. I have the source code, and it was compiled using VS 2005. Now I want to run it on a Windows Server 2008 R2 machine. If I try to "open" it from Windows Explorer, I get "The version of this file is not compatible with the version of Windows you are running." It is in Program Files(x86), so doesn't the OS know to run it as a 32-bit application? Do I have to load this in VS2008 and recompile it there as a 64-bit app? But all my old VB6 and VBScript scheduled tasks are running fine, why is the OS only complaining about this program?
View 1 Replies
May 26, 2010
The configuration is as follows
Remote SQLserver 2005 back-end
Windows Forms Front end (Visual studio 2008)
Is there a way to provide the username and password for the data connection from a Login form and not have it stored in a Connection string? Even better, is there a way to invoke the SQL login window each time the app starts? I need each user to be able to use his own (sqlserver) login everytime the application is started.
View 5 Replies
Oct 5, 2011
The configuration is as follows
Remote SQLserver 2005 back-end
Windows Forms Front end (Visual studio 2008)
Is there a way to provide the username and password for the data connection from a Login form and not have it stored in a Connection string?Even better, is there a way to invoke the SQL login window each time the app starts?I need each user to be able to use his own (sqlserver) login everytime the application is started.
View 1 Replies
May 9, 2012
I wanted to create some CLR functions that will access Active Directory, but I discovered I can't add a reference to "System.DirectoryServices" to my CLR project.
I googled it, and found that I have to add the AD dll as an Assembly to the SQL Server. Like so:
CREATE ASSEMBLY [System.DirectoryServices]
FROM 'C:WindowsMicrosoft.NETFrameworkv2.0.50727System.DirectoryServices.dll'
WITH PERMISSION_SET = UNSAFE
GO
The problem here is that I have to set the "PERMISSION_SET = UNSAFE" to the dll... this means that I have to set the database as "TRUSTWORTHY ON", and this opens a can a worms!
View 5 Replies
Dec 10, 2011
I would like to create a server program that accesses an "ms access" database. I will also need a client program that connects to the server. The reason for this is that the server is a mediator for several clients. Since I am using access, I plan on maybe having 20 or 30 clients connect to the server only. The client will have access to a virtual market. So when a person buys or sells something on the market, the server mediates the transaction and etc. At the same time, the access database saves each clients data as well as the overall market data.
View 1 Replies
