Can't Remote Access To SQL Server In Server Machine
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).
When am trying read Windows 2008 serivices Remotely from 2003 server by using following VB Script :
'Objective: TO check the SQLServicesHeartbeat of all SQL Server services and send email 'if any state of service is not running 'on error resume next Set iFSO = CreateObject("Scripting.FilesyStemObject") Set oFSO = CreateObject("Scripting.FilesyStemObject") [Code] .....
I am able to get read all windows 2003 servies, but not able to read Windows 2008 SQL Services Remotely, error throwing in the above line : Set objWMIService = GetObject("winmgmts:\" & strComputer & "ootcimv2").
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.
I've found a few examples of using vb.net to access an sql database, so far none of them have worked . They all involve using DataReaders. Maybe its the fact that the sql db is not on the same machine as the application.I was just wondering if anyone had a more comprehensive example of using VB.NET to access a remote sql server.
EDIT:I've received a few helpful comments an replies already. So far my connection string looks like: "server=sqlblah.myhost.com;uid=myuser;pwd=pass;database=testdb"
Probably also good to mention their is no editing of the tables a this point, just reading.
I am creating small application (desktop search engine) which uses sql server as back end. Sql server is used to store huge data using indexing (for quick search). Is it necessary that client should have sql server on his machine to run the application? I don't want to install sql server on client's machine, because my application is just a small utility.Is there any other way so that I can store huge data using indexing?
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.
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.
I am in the following situation: I have been requested to write an application for managing where we have customers - this must flag up when we try to add a customer too close to another one, so must be able to calculate distances based on post codes.I have chosen to use ASP.Net VB because I am fairly good at that and I like that the browser does all of the layout for me (using Java or C# would mean having to position each element individually).I have copied a few files from the company's website (which I also wrote) and modified them to account for the database structure we need for the new app.I have designed the database to account for the requirements of the new app.I have set up a website in IIS on port 81 through which to view the app.
I need a vb source to get the web server path files and download it to the local machine. actually a web html page in that i have href tag to call the vb exe file, in vb file i have to find current server path and download some supporting files to local machine
How can I connect to a database using sql server 2000 and stored in another PC with vb net (still in 1 LAN)?So that PC only stores the database, and another PC store the user interface and business logic.Is it related to the connection strings, on the datasource, we just put the IP address for that remote sql server?
I want to understand the concept of connecting to a remote PC or server. I'm working on an app that will connect to a remote server. Read a value from a registry key and then display the results in a text box. It will also connect and search for a specific log file on a server. I understand how to read the files. I'm just not sure how to connect to a machine remotely if I have valid credentials. There seems to be sever ways to accomplish this. I want the most efficient way using vb2008.
I'm been learning about connection strina I have been able to succesfully connect to a sql database stored locally on my Pc.The next logical step would be to connect to a database stored on a remote server. My question is does anyone of a sql database ( or any other type of database ) which can be openly accessed by the general public. Does anyone know if a web hosting service would allow me to remotely connect to a sql database ? Could I for instance upload my database onto a web hosting service and try connect to a remote database that way
i am having alot of trouble finding the source code to establish a connection to a remote sql server ( at my university) for vb. All i have is the IP adress and the username and password to the database. I tried coding it with a sqlconnection, sqlreader and a command to execute the statement with no luck.
I have looked into this for a while now with no success. out or lead me in the right direction. I am trying to control my application from an apache web server either locally or remotely.
Busy with vb2010 and we are busy to communicate with a server on a certain ip address. This server is sometimes sleeping and we can't communicate with the server in this situation.
I want to create a simple console application that has two input files and one output file. The code is very straightforward. The question is that I want to execute the application from the remote server or unix/dos batch etc instead of local machine.
how to send a log using vb.net console app to a external server? I have the application sitting in a store oulet, then I need this application to send over a log file.
I have a couple of ideas.. one is using a tcp listener and sender, then the listener logs it over in the server.
Another is using a ftp send.
but I would prefer it to be coded in the program itself.