i have problem with connecting Vb.Net with MSSQL database i have a shared host for windows server and i have to insert each ip trying to connect with the MSSQL database through my program and its impossible to insert each ip to the Whitelist so while i was thinking for a solution an idea came to me that i can change the ip address of any user for the program to a unique ip such as ( 174.162.45.23 ) and i whitelist this ip i do this or a solution for this problem because i cant continue my project with this problem
I have designed a project that connects to MsSql Server 2008. The local machine that I use to create the software is able to connect to the database but when I try connect from another machine remotely, It doesn't find the server.This is the connection string I'm using Dim Connection As New SqlConnection("Server=MyServer-PC;Database=MyDatabase;Integrated Security=True")
I created a project in vb.net and I'm able to connect to an Mssql server remotely using the host machine name. However, I can't connect using the IP Address. This is my connection String.
It is web based and conects to remote SQL Server If i run a query on database connecting using Sql Server management studio this query give correct results which is to find minimum value in a column called TIME1.
The query on database is SELECT MIN(TIME1) AS Fastest FROM Athletes WHERE (ATHLETE = 'Joe Bloggs') AND (Session = '600m')
This works great showing correct result under Alias column name Fastest
My problrm is i want to get this result from code behind page
here is Query in code behind page
SqlDataSource1.SelectCommand = "SELECT MIN(TIME1) from Athletes WHERE (Session ='600m') AND (ATHLETE = 'Joe Bloggs')"
I need to extract min value of TIME1 and pass it to a variable
Dim cnn As OleDbConnection connetionString = "Provider=SQLOLEDB; Data Source=****; Initial Catalog=****; User ID=***; Password='****';" cnn = New OleDbConnection(connetionString) Try cnn.Open()
[Code]...
I have been working with this for awhile, and I can't get it to work, I have all the correct names where the connection string is, but I just can't get it to work. It is telling me the server does not exist, but I am using a hosted solution that I know is up.
Am using vb.net 2005. when vb starts i try to connect to mssql server uut i cant. unlike mssql7 desktop edition there is a consol in the start menu where one can configure mssql, creat database, tables etc.
We are trying to view reports with MS SQL 2008 reporting services for a custom web application.We have MS SQL 2008 Express full install. We've tested the application from our IDE and it works. Once published to the web server we get the following error:
404 - File or directory not found.The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.I syuspect this may have something to to with IIS 7.0 setting, since it works in the IDE but not on the server, but I have been unable to figure out what the issue is.Here is our code.[code].....
I wish to save an image in a mssql database.My function is: Public Sub CalcNomogram(ByVal uid As String, ByVal mNavn As String, ByVal mId As Integer, ByVal ruhed As Single, _ByVal valgteDim As String, ByVal img1 As Image)
I need to write a String Array to a field in a MSSQL Database, however, I'm not sure how to do the connection from javascript to the backend VB.NET to send the data to the DB. Do I need to create a web service and use ajax/json?
I'm watching tutorials about creating Web Site and about controls.I think I added SQL Database to the project (it's not empty) properly. Suppose it has two columns: FirstName, LastName.I have TextBox1, TextBox2 and Button1 on the web site form.I enter any integer number (5, 10, 15 or whatever) into TextBox1. I want to press Button1 and get a value of 5th person (10th, 15th or whatever) from SQL Database into TextBox2.Who can help me with that? Should I read about ADO.NET and use something from there?Later I want to use VB for work with that strings.
people plix help me with ASP code for login. am using MSSQL i want users who have registered using their emailadress and passwords to be able to login.
i am trying to create an vb.net program to transfer or copy tables from my access database to an MSSQL DB.I got it working to copy from MSSQL to access but not the other way around.
I need to save pictures in my database, my database is MSSQL as of now, my code for getting the picture is this:
Private Sub browsepic_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles browsepic.Click With dialogpic 'Open File Dialog sa toolbox .InitialDirectory = "C:UsersCAMILLEPictures"
I have one textbox basically the user is going to enter in a 9 digit number or letters. From there I want to have a buttonclick event that validates this against 2 columns in a MSSQL Database. First to check if the number exists, next to check if it is active or inactive.
There are about 27000 rows of numbers so my main question is what is the best approach to handling something like this.
Should I create a view and validate in the click event. Should I create a stored procedure in sql that takes an input parameter and call it in the click event.
I was also reading about storing the information in a dataset however with that many records i am assuming that is going to be a slow process.
I have 2 problems, this may sound odd but is there an easy way to store and read vba/vbs inside a database (MSSQL)? Second problem, how to create vba/vbs so i can use it to interact with my own software?
I have recently started programming in vb.net (or trying to) I have made a application that gets some info from a mssql server. I can get the information perfectly, but one of the items called "date" i get in to my program is a date field in UNIX time. Is there a easy way to convert that into GMT time?[ code]
My website connects to a Microsoft Access DB at the moment, im about to upload it to the internet - its a VB.NET web application but i'm advised to convert it to MySQL or MSSQL for better performance.How would you recommend I export the DB ? there isn't too much data in at the moment so mainly all of the tables and fields.
I am trying to Insert/Delete records in a MSSQL database based on if a checkbox is checked or unchecked. The checkbox is an item template in a datagrid, I can check/uncheck the checkbox but it doesn't do an insert or delete. Here is my code:
[Code].....
But then I get the error that the control chkmap has not been declared. I am confused as to how this needs to be declared, do I set a variable to the FindControl("chkmap") and then set it as variable.checked = true ?
Is there a problem with an ampersand in the name of an MSSQL table name.? I'm converting an Access db to MSSQL and a table like Ta&ble1 gets upsized to SQL Server no problem. Do you guys see this as a problem in subs that use a reader when used with a stored procedure that uses this table?
I was creating an enrollment system for my Thesis, and my adviser told me that I must have a Code in my program that Synchronize database from client and server so that if the terminal connection is "Up" the data will go to the server and if the connection is "Down" the data will go to the installed server on the the local machine. and every 20 mins or 30 mins will sync the database.
currently developing the backup and restore procedure of my database....and im using the SQL UTILITY[URL]..but...i was thinking if is it possible to obtain the Data Source or the Server name automatically...when the form load.
I have a question on a datagrid object in vb.net 2008, that I what to be populated with certain values of a parameter from mssql database. The connection is made, the column header are loaded, but I what, when the form is loaded, to populate the datagrid only with certain values, doing a select commnad where id has a value given by me.What is the command to have this select done and display the values in the datagrid?
