I need to obtain the sql server name of a server based on its DNS name.
I have looked at the system.net methods
servername = Dns.GetHostEntry("ReportServer")
servername = Dns.GetHostByName("ReportServer")
But they return ReportServer.Group.Local rather than the sql server name SQL0001.
Is there another method I could try?
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 RepliesMulti-User Chat Program (Server & Client) with Main Server?
View 1 RepliesCase : I'm creating an application (desktop application) with VB.NET (actually windows form), and using SQL Server Express 2008 for its database.
[Code]...
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.
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?
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 RepliesWe 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]...
how to create a client/server... But I couldn't... I don't want anything fancy. Just want the client to send the server 4 numbers, depending on the user's choice; after that, the server would turn off the pc, restart it, etc. It all depends on the number received. Is there a rather "simple" way to do it? If it's not to much trouble you could use Atheist's example. (Btw I don't understand the code and, yes, I've checked on [URL])
View 9 Repliesproblem use Visual Studio 2005,2008 with Microsoft SQL Server 2008 R2 , when open vb.net choose : add new data source and choose database and add connection when choose Microsoft SQL Server (SqlClient) show error this version not supported
View 2 RepliesI recently installed vb express 2008 and with that download i also installed Sql server 2008. Earlier i have been working in MS Access so i have no experience in SQL server. My first problem is how to start sql server. I can see only following:
Start>All Programmes>MS SQL server 2008>Configuration Tools, Import and Export Data(32 bit)>SQL server configuration Manager,SQL server Error and Usage Reporting,SQL server Installation Centre. Moreover in Programme Files i have two folders:
1. MS SQL SERVER and
2. MS SQL SERVER COMPACT EDITION
how to start to create a database in SQL server with Vb express 2008.
I have this code, to read image (saved as varbinary(max) in database):
Private Sub ReadImage()
Dim connection As New SqlConnection(strConnectionString)
Dim command As New SqlCommand("SELECT [Image] FROM z1 WHERE x=1 AND y=1", connection)
[code]....
But it isn't very convenient code. It reads bytes from table, save them to file, and finally open file as image.How can I read it directly to image, without saving as file?
i m developing a window application using vb.net & ms sql server 2008. The date is by default mm/dd/yyyy. But i wanna change this to dd/mm/yyyy. How is it possible and where do i hv to make changes?
View 3 Replieswindows service app I am developing to audit events in the Windows Security Event Log. I am using the EventLog class to read entries from the "Security" event log. I have set the log to raise events when an entry is written so I can parse the data. Here is where my problem comes in. If I run the service on Windows 2003 I can get all the data I need from each entry, but when installed on Server 2008 the EventLogEntry ".message" property comes back with useless data like this, "The description for Event ID '4738' in Source 'Microsoft-Windows-Security-Auditing' cannot be found." Under Server 2003 the message property has good data. Using the Event Log Viewer in Server 2008 I can see that it is rendering the correct data, but I am having a heak of a time doing the same. The "replacementStrings" property has the corresponding data that I need, but it appears to involve some other steps to get the data localized to the event provider, but I do not know how to do that.
I also checked the registry HKLMSystemCurrentControlSetServicesEventlogSecuritySecurity on both the 2003 servers and 2008 servers. They are identical execpt the 2003 has an entry the 2008 server does not:
String Type: GuidMessageFile
Value: %systemroot%system32NtMarta.dll
how to update the data of an SQL server 2008 express using vb.net 2008? My raw data actually from excel file only and i want to transfer all the data and merge it in my newly installed SQL server 2008.Normally im updating it daily that is why i want to create code.
View 6 Replieshow to make the provider of sql server 2005.because I have install sql server on 2005 .and I want prepare the sql with visual BASIC 2008 for the dmarch
View 6 RepliesI am new to VB 2008 and ADO .net and Sql Server 2008 (Management Studio). I am working through a book about professional vb programming. I have downloaded the sample Northwind database and have connected and used this database without any problem. I wanted to connect to my database that I created but to no avail.
I'm having access problems. It appears that the permissions are granted for users to select, update, but, in running the program, debug stops at the open line and can't access the database. The connection string is: "Data source=.SQLEXPRESS;AttachDbFilename=C:Program Files (x86)Microsoft SQL ServerMSSQL10.SQLEXPRESSMSSQLDATACustomer1.mdf;Integrated Security=True;User Instance=True". The error message is: Access is denied. By the way, these are all express editions.
I am trying to connect vb.net with sql server 2008. The following is the code i tried. but i couldn't get to connect vb.net to sql server.
vb
Imports System.Data
Imports System.Data.SqlClient
Public Class Form1
[code]....
im a beginner wid vb .net and need to clear the air wid connecting a database file created on sql server 2008r2 wid vb.net 2008 for a project..plz nebody help from scratch regardng retriving,insertng n modifyng data using vb.net code..awaiting....
View 5 RepliesI making a software in VB 2008 that connects to a SQL database. I have setup the connection on my machine but the problem is that this software is a project for university and i have to present it on a laptop, so is there a way for me to move the software to the laptop and connect it to the database on the laptop, which already has SQL installed, without changing a lot of code, because right now every time i move to program to the laptop i end up changing the connection code for every Form. I know this is a bit off the topic, but is there also a way to move my SQL database files to the laptop or do I have to create the same database on the laptop again.
View 2 Replieswhat is wrong with my code?
Dim x As Integer
Dim sql As String
ModConnectDb.OpenDatabase()
[code].....
I got this code to open a .txt at a server. But what to do to pup up this if no connection to server is established?
[Code]....
i'm using Visual Basic 2008 Express and SQL Server 2008. I have created a database using SQL Server 2008, but when i try and connect to the data source within VB 2008 there is no option for Microsoft SQL Server(SQLClient)
when i go to add References to my project System.Data.SQLClient is not available.
I have a database on SQL Server 2008 and am trying to run code on Visual Basic 2010 to connect to it. I have the following code but am getting the error 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) on the line SQLConn.Open(): [code]I have been working on VBA code and know the serverinstance and database names are correct. Not sure why it's not working under VB.NET 2010.
View 2 RepliesI have installed Visual Basic 2008 express edition, but I didn't get SQL server. Therefore, I installed SQL server 2008 separately, and it works fine..But I want to use the SQL server in Visual Basic, but it doesn't show up when i click Add New Item. Is there some way of connecting VB to SQL server?
View 5 RepliesWhen I try to run a program I've written from a network drive on a windows server 2008 machine it always gives me: Open File - Security Warning The publisher could not be verified. Are you sure you want to run this software? Unknown Publisher This file does not have a valid digital signature that verifies it's publisher.... I need this message gone.
View 2 RepliesI need to import a .csv file into a table in SQL Server.I need for the user to be able to select the file and then click to import that file.
View 2 RepliesI have created a DLL using Visual Basic 2008. It is installed on a Windows Web Server. A PHP web site uses the DLL. I want to make sure the DLL is properly removed from memory after each use.In VB6 there is Instancing and Persistable. Instancing can have the following values:
Private
PublicNoCreatable
SingleUse
GlobalSingleUse
[code]...
When creating a DLL in Visual Basic 2008 is there an equivilent to these properties?
I set timeout to 0 but the connection close prematuraly, what is wrong with this statement ?
[Code]...
I am trying to write two integers into an SQL Server 2008 database.
QuizID and Answer have their data type in SQL set as 'int' and Question is 'varchar'. ReadQuizID and FinalAnswer are integers. When I run this code to write to the server I get an error saying "Conversion from string "Insert Into Questions(QuizId,Que" to
type 'Double' is not valid.".
myCommandWrite.CommandText = "Insert Into Questions(QuizID,Question,Answer) Values('" + ReadQuizID + "','" + FinalQuestionString + "','" + FinalAnswer + "')"
If I replace the string with:
[Code]...