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?
It is possible to load the DataGridView (VB 2010) with an Sql Query file that is saved in My Documents Folder?
I searhed everywhere but have not found a good reference that i can use. I have a database on SQL Server. Created an SQL Query that join two tables and a function from SQL (among other things) that extract a report. This Query is saved within My Documents files in the C: drive. I want to show this report on the DataGridView. Don't know how to do it.
lately I've been experiencing LinqToSql + Sql Server Express 2005, and it was a great journey (muddy) anyway .... I'm at the point that I want to make a Backup/Restore for the database backup for SSE is as easy as a simple copy paste of the mdf file, but the problem that I can't copy the file while the server is using it, server doesn't let the file go untill the app is closed or after about 4 - 6 minutes of idle time,
I am using SQL server express 2005 as an backend. I created a backup file programmatically. If I use same server , then it restore the data successfully. however if we try to restore on different server, then it fails. and throw following message: "The Backup set Holds a backup of a database other than the existing 'DatabaseName' database. RESTORE DATABASE is terminating abnormally." On both server, Sql server instance name and database name is same. How can I resolve this error?
I am trying to do something fairly simple.. allow my user to import thier data from Excel into SQL Server, where it can be used by the application.To do this, I'm using the fairly simple code that is common everywhere I look:
Now, on my development computer this code works perfectly. The data imports, and I can go on my merry way.
On the TEST computer, this code throws the error: "ODBC -- Connection to {SQL Server} servernamesqlservername failed." This seems very odd to me, because I'm using exactly the same SQL Server and database to interact with the application, and all the other screens in the application work perfectly. The test computer CAN connect to this SQL Server, but it keeps throwing this error whenever I try import data from Excel.I've tried everything I can think of - using the server's IP address instead of the server name, sending the SQL Server administrator data along with the request, taking out the Trusted_Connection=Yes... nothing works. What is going on here? How can this code work fine on my computer, and hiccup on another?
I cannot connect to my local sql server using the following line [Code]. I get login failed for user tedpottel. I have security set to window authority i believed, so my other programs (reporting services and cold fusion do not take in a password. (as long as I log in as tedpottel) So I tried conn = SqlConnection("server=(local);database=by") which said failed for user''.
The above codes runs inside a loop. The above code runs quite well without any issues. But once or twice a month, I get the following error message and application stops. System.Runtime.InteropServices.COMException (0x80040213): The transport failed to connect to the server.
I'm changing old, vulnerable SqlCommands with SqlParameters but get a SqlException: System.Data.SqlClient.SqlException {"Conversion failed when converting datetime from character string."}
on sqlCommand.ExecuteScalar: Dim sqlString As String = _ "SELECT TOP 1 " & _ "fiSL " & _ "FROM " & _
I'm currently upgrading my sql server from 2005 to 2008 enterprise server. I used VB to connect to the database. It worked fine in the previous version of sql, but when upgrading it seems doesn't recognize my connection string.
Below is my connection string:
myConnection = New SqlConnection("server=RAVY-PCRAVY;uid=;pwd=;database=CIEDC"); myConnection.Open();
Where Ravy-PCRAVY is my server name at the sql server login dialogue box. And I used the windows authentication mode.
I'm trying to develop some code to send a fax automatically from a ASP webpage.
[code].....
Basically on my development machine (XP Pro) the fax sending works correctly via our SBS 2003 server which has the fax services installed. Now I want to upload the ASP webpage to our Windows 2003 Standard server under IIS. When I try to send faxes using this server (via the SBS2003) server I get the exception "Operation Failed".I've installed/uninstalled the Fax Service on our Windows 2003 Standard server but still the same error message.
I am using VB 2008,I am trying to make a launcher my private server but, I failed it always say 'This exe can't execute independent" I tried these method Shell ("Game.Exe") And System.Diagnostics.Process.Start("Game.exe")
I'm using Visual Basic Express 2010 and SQL Express 2008 in Windows XP. At first I couldn't add a datasource (the .mdf file for the database) because of a "Operating system error 32" which I seemed to have resolved by giving myself full permissions for .mdf file (by right clicking on the file and going into properties and then Security) and restarting the SQL SERVER (SQLEXPRESS) service. The dataset for the database is in my solution explorer but when I right click on a table adapter to add a query and attempt to open up the query builder, I get the error in the title above.
Dim sqlConn As New SqlConnection("Server=.\SQLEXPRESS;uid=;pwd=;database=ContactManager") sqlConn.Open()
Above is my connection string, The programs runs up until sqlConn.Open() and then i get the same error, using no UID and Pass, or using a uid and pass.
Login Failed For User ''. The user is not associated with a trusted sql server connection
I have the SQL Servers authentication se to Windows Authentication and SQL Authentication. I'm using Visual Studio 2005 and SQL Server 2005.
I'm using Visual Basic Express 2010 and SQL Express 2008 in Windows XP.I created a database on my local PC HDD. At first I couldn't add a datasource (the .mdf file for the database) because of a "Operating system error 32" which I seemed to have resolved by giving myself full permissions for .mdf file (by right clicking on the file and going into properties and then Security) and restarting the SQL SERVER (SQLEXPRESS) service.The dataset for the database is in my solution explorer but when I right click on a table adapter to add a query and attempt to open up the query builder, I get the error in the title above.
I created a typed dataset a day or so ago, then I added a whole bunch of tableadapter/tables with some relationships etc... suddenly out of nowhere it decides my dataset "is not defined". everywhere in my code where i use this dataset now has an error. I tried not to pull out my hair and do a Clean then Rebuild solution... out of nowhere it just refuses to generate code. Object reference not set to an instance of an Object. It would be nice if it was my object so i could find it but it's not.
Curiously I also lost the little database icon on the dataset in the solution explorer.I can still open it in the designer and preview my queries etc... it just wont make the code. it's driving me insane. anyone got a solution?
I was trying to improve my graphics. I have imported a picture on my resources. Then I don't know why all went wrong and it doesn;t regognise the resources.When i debug, like always it runs when all are fine and ok with not errors. Can I restore that debug?
I have used MS Backup to do a file backup of my entire computer. This completed without error. I needed to restore one page in an ASP.NET application to the version in the backup.
I used the Restore Files option and saw my Page.aspx file and it's Page.aspx.designer file. I chose the two and restored them.
When I looked at my application, however, Page.aspx.vb and Page.aspx.designer.vb had been restored (ie. the page behind's but not the pages themselves)
I created a SQL DB named MainDB.mdf and a small VB 2010 application with some forms and datasets.Everything was working OK until i got a new computer and re-installed Visual Studio 2010 and SQL server 2010 on it. I copied my DB from the old to the new computer and also copied by VB 2010 project to it. I used Windows Authentication to connect to the DB in the old computer and also in the new one, i am using different Windows user account names though.
I was able to connect to the DB in the new computer in the Server Explorer section, i created a new connection string to the DB and i can seed there is data in the tables. When i run my VB 2010 application created in the old computer get error:
"Cannot open database "MainDB" requested by the login. The login failed. Login failed for user 'D630Admin'."
I need to get rid of that error and be able to add/mod/del data from my DB using my VB application as i used to.