I want to do a master key, but the following error occurs
my error is
Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'master'.
my code is
USE EncryptTest
GO
create master key encryption by password='al4jklklkl@kjkjkFdi';
GO
I was using access but I want to upgrade as access doesn't handle bulk inserts well. I end up with orphan child records at times.
View 32 RepliesAfter inserting into masterTable it returns an ID. With that ID I want to enter more than one row into a transaction table.
I am using two separate procedures. The problem is, after inserting the record into master, and while inserting into the transaction table, if any interruption occurs I want to abort the corresponding insert of the master table.
I am new ASP.net/Vb.net. I want to create a master page with my company's logo and want to include that page in every other page. And I want to have an header in master page which should look something like .
Orders Notice Other logout
-Add/Edit - view -Search
I would like to take all my vbs Admin Scripts and create 1 master script ...with a Menu .
View 2 RepliesI created a dataset.xsd and it contains two table adapters and these table adapters use stored procedure for select.in my vb form, i get value in text box and then fill table using tableadapter and pass parameter to sp. Till this point everything is working fine. Now these tables have relations and i want to create relationship and show the data from child table on basis of master table. How i can do it?
Example
Me.MasterTableAdapter.Fill(Me.dataset1.spMaster, 1) --1 is parameter which is passed to sp
Me. ChildTableAdapter.Fill(Me.dataset1.spChild,1) --same parameter is passed to child table.
Now i have the records in spMaster and spChild. how i create the relationship so that when i move thru Master the child have corresponding records?
I am getting the following error at runtime:"Object reference not set to an instance of an object." - the code in question in my code-behind is as follows:Dim MinDateDataView As DataView = CType(SqlMinDate.Select(DataSourceSelectArguments.Empty), DataView)Dim MinDateDataRowView As DataRowView = MinDateDataView.Item(0)
View 3 RepliesI have one SQL Server database with two tables:
CREATE TABLE [dbo].[Invoice]
(
[IdInvoice] [int] IDENTITY(1,1) PRIMARY KEY,
[code].....
posted again but this time its regarding both the webclient and the web reuqest giving me this error :S
View 1 RepliesI am trying to use Authorize.net's SIM payment gateway process and am using the base code provided on the developer site. The problem is I am using Master Pages with my site and the hidden field names are getting concatenated with the nested control IDs as an example:
[Code]....
I have a nested master page that has its own master page. The parent master page has a property defined in its code behind.
Public ReadOnly Property SelectedPage() As String
Get
Return _selectedPage
End Get
End Property
How can I reference the parent master page's property from within either the child master page's code behind Page_Load or aspx template page?
I'm using Visual Studio Development Server (Visual Basic 2010) and it works fine. Now I've enabled NTLM Authorization because I want to test the website using a different user account. Now when I try to access the website I always get the following error page:
Server Error in '/' Application.
HTTP Error 403 - Forbidden.
Version Information: ASP.NET Development Server 10.0.0.0 .I'm using a test account which is a normal user within our domain. I've already set the access rights in my project folder to Full Access for this user but it does not help.
When I deployed my project on a server, in certain circumstances, I get an error page that indicates I should create a custom error page. I was wondering how exactly I would implement this custom error page the server asks for to give me a precise and helpful message or preferably, how I would get the error to just display on the main page?This is the error message I got below
Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
[code]....
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
[code]....
I am trying to create a simple chat server over vb that can relay messages back and forth using an echo server. Could someone point me in the correct direction to begin?
View 3 RepliesI am trying to copy upload files to remote server i get below exception.[code]...
View 1 RepliesI have several programs that I wrote in Visual Basic.net 2003 that I run from a server at work. We upgraded to Visual Studio 2008 recently and I converted my code to that version. I rebuilt the .exes and tried to run it from the server. It said I needed to upgrade the framework on the server, which I did. Now when I run the .exe file from the server I get a runtime error:
Runtime Error!
Program: d:...
This application has requested the Runtime to terminate it in an unusual way. Please contact the applicaiton's support team for more information.
These programs are very important to the day-to-day operations of the company I work for. I did backup the software before converting it, so we're running normally right now, but there are modifications and upgrades I need to make as soon as possible, but cannot due to the programs crashing when I run the on the server.
I m getting the following error when i upload my site to Production Server using Database in App_Data ASPNETDB.MDF
Server Error in '/' Application.
Runtime Error
[code]..... ...
the remote server returned an error: (503) server not available m getting this error...wen i m trying to extract email id from a webpage...
View 2 Repliesremote server returned an error:(503) server not available-vb.net
View 5 RepliesI am running my application and at random times when it is unable to connect to the database I get an error saying "A Transport-level error has occurred when receiving results from the server. (provider, TCP Provider, error: 0- The specified network name is no longer available.) How can I stop this pop up from coming up? It comes up every once in a while and I want to disable that.
View 6 RepliesI am trying to upload a file to Mainframe machine from my VB.net application. I am getting the following error.The remote server returned an error: (501) Syntax error in parameters or arguments
[code]...
the next issue, that is only shown when the server is a Windows server 2008 machine , this is the information that I've found
[Code]...
Using vb.net 2005 - FtpWebRequest for ListDirectory always gets 550 error The remote server returned an error: (550) File unavailable (e.g., file not found, no access).
On both FTPListDirRequest.Method = System.Net.WebRequestMethods.Ftp.ListDirectory
FTPListDirRequest.Method = System.Net.WebRequestMethods.Ftp.ListDirectoryDetails
[Code]...
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) error: 26 - Error Locating Server/Instance Specified.
This error is doing my head in.I have a client running Windows XP SP3 logged into a domain. It is running MS VB 2010 Express to access the server.I have a Server called dataserver3 which from the client, I can do a start, run "\Dataserver3" and it comes up and yes I can browse to the Test.mdf file, which is a new database that was created using MS SQL Server 2008 R2 Standard edition.
[Code]...
When I tried to read the data of a http link using VB.net, an error occur. The error is:The remote server returned an error: (406) Not Acceptable.This error is only occur for some links.
View 2 RepliesI 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:
strFilePath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fdlgFileOpen.FileName + ";Extended Properties=Excel 8.0"
connExcel = New OleDbConnection(strFilePath)
connExcel.Open()
[Code]...
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 am trying to make a copy of an existing database, I use .net framework data provider for SQL Server.I get error "Unable to connect to source server for Transfer" when it runs to oPackage.Execute().
oConnection = oPackage.Connections.New("what the providerID should be?")
oStep = oPackage.Steps.New
oTask = oPackage.Tasks.New("DTSTransferObjectsTask")[code]......
basically i just want client to say "C: emp" ENTER
then, server must reply with all its files in c: emp
I'm connecting to my mysql server using ODBC in vb.net, the database is shared throughout the company because it is used in an accounting program (simply accounting), each user has their own account user/pass to login to the database. I have developped a program that uses the accounting database and combines it with other information, my problem is that at least once a day I get this error when I run my program: "(10061) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on"and the error persists for at least 4 hours, for some reason it starts to work again later on in the day.
View 1 RepliesI am developing a tool to get all elements of a web page (images, links etc...) and I am having a small problem with the Download button. I click it, and becuase we use a proxy at school no matter what I try it will always throw the error: "The remote server returned an error - (407) Proxy Authentification Required"How do I detect that the user is using a proxyAnd then if so, authenticate with it so that I can download the file?
View 4 Replies