Has anyone managed to create an SSL server in VB2005 on XP platform?
I am having issues with the certificate side of things, and I am at the point now where I feel that it cant be done in XP.[code]...
i have installed visual studio 2005 in my computer i want to create a sql server 2005 file i saw a sql server 2005 option in my installed components i want to know how to create a sql server 2005 from my visual studio 2005 it is possible or not.
View 1 RepliesI have one problem in which i simply want to know how i can create a table that can easily Used as a back end for my solution that is in Vb 2010.
I also want to know that when we choose a data source in a vb.net that is for sql server Which we want to choose....simply which can be used Because there is 2 or 3 with little different name...
I am developing a project where i have to copy a table from ms-Access to ms-SQL Server, for which i wrote a code and it goes like this
[Code].....
Here every thing is predecided, i.e i have already created a table in SQL Server with name Test and Assigned fields same as that of access.
But i want to create a table in SQL Server 2005 dynamically with same table parameters or Structure of Access table
I want to create a CHAT server?
View 4 RepliesTo create a dynamic table in sql server 2005 with all its privilages(constraints,..) from a xml file.
View 1 RepliesHow to create a primary key as A1/D-M/100000 in SQL Server 2005 in Visual Studio 2008 ?
View 4 RepliesI want to create a stored procedure in SQL server 2005 in order to check if there a specific value in a table. As I don't know how to do this can someone give me a link or an example on how to create and store the stored procedure? Secondly I wrote this for my the above stored procedure: CREATE PROCEDURE dbo.dokimi -- Add the parameters for the stored procedure here
[Code]....
One of the things that I am not sure is that I want to check the value that the user passes throuhg my application that I am creating. In the above code this exists in the select query @txtUserName.text. Is this right? Can I use it like this or should I declare something more after the create procedure statement?
I am a beginner in vb.net and I need to customize our application based on end user requirement in the office, I need to create Login Box for the Application to protect my database. I have a loguser table in SQL with field on userid, username and a hashed password for everyuser. Now I created a new project in vb.net and I am confused to what to use on the toolbox? First I use the windows forms to create the txtbox, command button and labels, but then I am confused already I can only create local login in my pc windows account, I need the log-in on my database application based on their username and password saved on the tables.
me..ExampleSQL(datainformation):ServerName=Aries,
DatabseName=Jupiter, TableName=UserLog,
FieldName=Username, Userpassword,
Example in VB.net forms I created lblUsername, txtusername, lblpassword, txtpassword and btnLogin.
how to create table in mysql server 2005 dynamically through vb.net
View 2 RepliesI want to create a setup which requires Microsoft SQL Server 2005 and .NET Framework 3.5. If this software isn't installed, the Setup should offer the user to install them now.
View 2 RepliesMay I ask a question to you all.I have vb.net project that generate sales report from SQL Server Database.I changed SQL Server 2005 Express to SQL Server 2005 Standard Edition.
After that my program can't run properly and every time I got Time Out Expire message.
That program work properly with SQL Server 2005 Express.May I request suggestion how to fix this.
I need to read the email from the mail server that is in my intranet from my application server.
View 9 RepliesHow can I write a connection string? I has four different computer that can be connect via ethernet.How can I maintain a inserting data if to computer insert on same table at a single time..??
View 1 RepliesI am tring to make the below application work with SQL Server 2005 Database Currently it works for test.mdb, which is in the same folder with the application. How shoud I modify the MapPath to work with SQL Server.
[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 RepliesI am using memorystream to get and store images into sqlserver 2005 table image field. This process is working and I am able to display image in picture box. I need to be able to store PDF files into the same field and be able to display in a picture box.
View 2 RepliesI 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 wrote a software which would work perfectly fine on vb.net with connection string: [code] but if i try and run it on a pc with sql server 2005 installed it fails to run what changes do i need to do to make it run
View 5 RepliesI had made a project in VB.NET 2005 with SQL SERVER 2005 used as database. Now i want to make a setup of this project but i am unable to integrate sqldatabase and .net framework in this setup project. Is there any way to do this. Because it is assumed that the client does not have .NET Framework installed nor he has SQL Server on his system and the worst condition would be he does not have even internet connection from where these two setups can be downloaded if we give the condition for downloading these programs from the net if the client does not have these programs installed on his machine.
View 2 Repliesbasically i just want client to say "C: emp" ENTER
then, server must reply with all its files in c: emp
Ran into this problem of connection string using vb.net and sqlserver 2005 express. My current connection string works well locally but when deployed on a client, i get a connection. Can anyone help with the right connection string to us in order to deploy to other client(pc's).
View 2 RepliesUsing vb.net 2005, how can i backup MS SQL Server 2005?
View 6 Repliesim using SQL Server 2005 as my back end for an information system im currently developing. Im a total beginner with SQL, so i came across a huge blockade.An error appeared while i was configuring my server,"Login failed for 'username'. Reason: Account disabled".i tried searching EVERYWHERE in the net, but nothing helped me.
View 1 Repliesi am trying to develop a multi user application. this is the first time i am doing it. my database is sql server 2005. and using vb.net as the programming language.i have few questions,
1. my database is in one computer. this computer is not actually a database server. it is just a computer. and the database is created in local drive (e:) of the computer. when i develop the application. so, if i am writing an application for the computer where the database is created. i can give the location of the database as my connection string (is there any better way to do this. because there might be problems, if the database location is changed). how can i connect to the database from the other computers in the same network?
2. this is my second question. i have a table which stores customer details (customer id is primary key and its auto number). one customer can have many hobbies. so i took it as a separate table (customer ID as the foreign key of that table) . when i enter data, i use single form to enter the customer details and their hobbies. so when i insert the record into two tables, will the second table take the new customer ID automatically into dat tables customer ID which is a foreign key.
I making a connection through word 2003 VBA to SQL server 2005 using the following codeDim cn As ADODB.ConnectionSet cn = New Connectioncn.ConnectionString = "Provider=SQLNCLI;Server=LEXAE29150SQLEXPRESS;" & _"Database=MCarter.mdf;Integrated Security=SSPI;"cn.openetc.cn.close.All runs fine up to cn.open.I then get the message error 'Cannot open database "MC.dbf" request by the login. The Login failed'.Tryed websearching but no succes. Been on it a week and the boss is doing his nut. I'm lost and unsure what wrong.The SQL server is set for windows authenticity and SOL Server login.In the MC database under security users my user name (Login) is their and setup as owner and sysadmin.SQLServer is running on the same machine as the word.dot.
View 3 Repliesi want to learn connectivity of vb.net 2005 and sql server 2005
View 5 RepliesI am developing an application with "Visual Studio 2008" (in language VB.NET, Framework: 3.5) with data server as "SQL SERVER EXPRESS 2005".
i have one table with name [fyr] and it contains two columns 'fyid' (integer) and 'fyear' (nvarchar(50)).following queries are showing exception as "No data exists for row/column"
Dim cmd As New OleDbCommand("SELECT * FROM fyr WHERE fyear= '" & DateTime.Now.ToString("yy") & "-" & DateTime.Now.ToString("yy") + 1 & "'", Connection.Instance)
Dim cmd As New OleDbCommand("select * from fyr where fyear = '12-13'", Connection.Instance)
Dim bdr As OleDbDataReader = cmd.ExecuteReader()
both queries above has same result.but all these queries are working if executed directly in "SQL SERVER Management Studio" and showing the expected results.and connection is in open state all other queries in the project are executing correctly and successfully.The table has the data like this:
fyid fyear
1 11-12
7 12-13
I have an application that collects digital signatures, and saves them as a bitmap to a specified directory. After the code saves the bitmap, I use a SQLDataAdapter to insert the path to the bitmap into a text field. All the code works on my computer, but on customer computers it does not. I do not get an error msg, but the string value of the path is not inserted. All security works because they can write any other records to the same database. [Code]
View 6 RepliesI would like to know how can I use tinyint in SQL Server 2005 with VB.NET. someone know all data types in SQL Server 2005 are matching to which VB.NET Data types. I face that problem now. For example: tinyint in VB.NET, money in VB.NET, smalldatetime in VB.NET.
View 1 Replies