I am trying to connect to my local SQL database with the following script:
'* Configure connection object connection string to be used throughout
'* the form.
sqlConNW.ConnectionString = _
[Code]....
im 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've been doing a self studies on visual basic and I thought I've learned a lot but still I realized that I still have something more to learn. I want to learn the basic fundamentals on SQL for its database operations such as adding,editing, and deleting records. I would say I'm new to SQL because as far as I've used VB, I've been using LINQ(Language Integrated Queries) for database operation. I've been doing a lot of research online on how to start and connect to SQL but I find hard to make it on my own cause all I've got is an error during runtime.
[Code]...
I am trying to connect to SQL Server Express locally using VB.NET 2005. I pulled my connection string directly from the app.config file. When I run, I get NO errors and the connection states returns open, however the commands are not being processed.
Imports System.Data
Imports System.Data.SqlClient
Public Class frmAddMovie
[code]....
How can i retrieve a list of local sql server 2005 instances on a machine with sql servers 2000, 2005 & 2008 installed?
View 4 RepliesI have Windows Vista Business on my machine and running visual studio 2005 (Version 8.0.50727.867 (vsvista.050727-8600)) as well as "ENU Service Pack 1 (KB926601)" and "Update for Microsoft Visual Studio 2005 Standard Edition - ENU (KB932232) "I'm trying to connect to SQL server 2008 Express via Visual Basic and I've gone through all the forums to try to resolve my issue and it seems that I have to install " Microsoft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support" However, when I try to do this I keep on getting the error "The upgrade patch cannot be installed by the Windows Installer service because the programme to be upgraded may be missing, or the upgrade patch may update a different version of the programme.
View 9 RepliesI need to impersonate with an account that is local on the remote server not the server where the application is running.
View 1 RepliesAn Error has occurred while establishing a connection to the server. When Connecting to a SQL Server2005, this failure may be caused by the fact that under the default settings SQL server doesn allow remote connection (provider: Named Pipe Provider, error: 40- Could not open a connection to SQL Server)I want to connect to the SQL Server 2005 Express Edition which is running on my system from a VB.NET application. I am using Visual Basic 2008 Express Edition. Here is the Coding,
Dim sqlConn As SqlClient.SqlConnection
sqlConn = New SqlClient.SqlConnection("server=localhost" & "initial catalog=LIB")
Try
[code].....
I want to know how to connect to a remote system having some shared folder.(ex, \myservermysharedfolder).Actually, I was supposed to copy a particular file which is available in a shared location of a system. To copy that file, first i need to connect to that system with an user id and password.I know copying of file (), But not getting clear idea on how to connect to the shared folder. I have tried with System.Management class, but no use..
View 2 RepliesI am trying to make make a database in vb.net but I am having troble I want to have a form that a user could add and edit columns and rows to the tables in my database. Now a sevice based database would not work on my computer because i did not know how to set up the correct sql sever for vb.net 2008 so I used a Local SQL database i have tried to write some code to connect to it.
i will need further help on try to add the controls to edit the database but i will attempt that befor eposting for help. so here is my connection code i am trying to use a data grid to alow the data base to be edited.
also do I need to add the QNA table to data souces for it to be accessed ?[CODE...]
I am trying to connect a simple VB program (Form, button and label) to my local oracle 10g XE and keep getting errors. The most recent errors is the TNS listener
"Oracle.DataAccess.Client.OracleException ORA-12154: TNS:could not resolve the connect identifier specified "
Here is what I have done:
Went to control panel > odbc and created a connection to 10g XE and called it:
oraconn (this was from other tutorial so it is not used in code but still resides)
Copied tutorial about connecting to oracle and have the following code:
Imports System.Data
Imports Oracle.DataAccess.Client
Imports Oracle.DataAccess.Types
[Code].....
I am very new to NTLM/LDAP and trying to authenticate using NTML running on a local machine. The code provided by Microsoft [URL] seems to work, I just do not know how to connect to it.
I know that the authentication service is running because Contos 8 has been set up to authenticate using NTLM and it is working. I just do not know what the "connection string" should be:
I am trying: LDAP://CN=machinename with no luck.
Dim adAuth As LdapAuthentication = New LdapAuthentication("LDAP://CN=LOCALMACHINENAME")
Dim entry As DirectoryEntry = New DirectoryEntry(_path, domainAndUsername, pwd)
I moved my web application to a server and im getting this error below, but on my localhost it works great. Im finding that the error has to have something to do with the dataset not pulling back any data, when I do a for each statement. But the weird thing is that I do a for each statement on another page and it works fine. Here is my for each statement, that im assuming doesnt work. The reason im assuming it b/c when i test it on local it works fine:
Dim retObj As New ClassLibrary1.sql_class
For Each row As DataRow In retObj.sel_all_email_list(company).tables(0).rows
email += row("EMAIL_ADDRESS") & "/"
Next
[code]....
Error:Exception Details: System.IndexOutOfRangeException: Cannot find table 0.
I am writing a small VB 2008 application which connects to a SQL Server 2008 database,which is hosted with Fasthosts in the UK. The connection string I am using is;"connectionString="Data Source=xxx.xxx.xxx.xxx;Initial Catalog=xxxxxxxxxx;User ID=xxxxxxxxxxx;Password=xxxxxxxxxxxx"I can connect to the remote data using the "add data source" within Visual Studio and can preview thehosted data without anyssues however when I try to run the application I get an error stating;"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)"
View 1 RepliesI have a MySQL database I've created for my website, [URL]. I want to query the database, but I am unsure how to connect.
This is the code I'm using:
Code:
Dim sConnection As String = "Provider=MySQLProv;Data Source=my_database;User Id=my_user;Password=my_pass;"
Dim bSuccess As Boolean = True
[CODE]............
The MsgBox() returns a message that says: "Error: The 'MySQLProv' provider is not registered on this local machine". All I want to do is access the table in my database, is it possible? (also, without installing anything additionally?)
Does the .NET framework include ways to access MySQL databases easily?
I have this connection string (IP and port number changed)Public ConnectString As String = "Data Source=207.167.717.614,8711;Network Library=DBMSSOCN;Initial Catalog=TableName; User=User; Password=Password;"It does not all a connection, i've opened this port for port fowarding and have unlocked the TCP port of the firewall what else could be wrong?
View 24 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 am bignner in vb.net and i have develo[ed a small application of vb forms in which i have use a service based sql server databas(.mdf)i want to make its msi installer last time i have made it and after installation application giving error for connecting to sql server
View 1 RepliesI am using this code to connect to my exchange server using POP3.
I am trying to retrieve an inbox of basically emails that have not been read however, i am just getting a bunch of gibberish and its reading an email.
modify my code to just read the most recent messages.
Try
tcpClient.Connect(hostName, 110)
Dim networkStream As NetworkStream = tcpClient.GetStream()
[Code].....
its been a long time but sincerely, am happy to be back. now i've got a problem on my mind and that is; am trying to develop a database application but i want it to be a console application. the major issue is that i dont know how to go about connecting vb.net console application to sql server or if its possible at all, but am sure its possible in this world of ours...
View 2 RepliesI would like to create a OPC Client... But fist of all how do I connect a OPC-Server to me application. anyone who have done this? and maby hade some sample code??
View 8 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 RepliesI want to understand the concept of connecting to a remote PC or server. I'm working on an app that will connect to a remote server. Read a value from a registry key and then display the results in a text box. It will also connect and search for a specific log file on a server. I understand how to read the files. I'm just not sure how to connect to a machine remotely if I have valid credentials. There seems to be sever ways to accomplish this. I want the most efficient way using vb2008.
View 3 RepliesI'm been learning about connection strina I have been able to succesfully connect to a sql database stored locally on my Pc.The next logical step would be to connect to a database stored on a remote server. My question is does anyone of a sql database ( or any other type of database ) which can be openly accessed by the general public. Does anyone know if a web hosting service would allow me to remotely connect to a sql database ? Could I for instance upload my database onto a web hosting service and try connect to a remote database that way
View 1 Repliesi am having alot of trouble finding the source code to establish a connection to a remote sql server ( at my university) for vb. All i have is the IP adress and the username and password to the database. I tried coding it with a sqlconnection, sqlreader and a command to execute the statement with no luck.
View 2 RepliesI'm building an application that connects to a SQL Server 2008 database via connection string. The thing is, since the computer loading the app (or the user, in either case) is outside the Active Directory domain, I can't use Windows Authentication to connect to the DB. But when I include the database credentials, it won't let me connect either, telling me that since the computer logging in is from an untrusted domain, access is denied.
The connection string goes like this:
connectionString = "Data Source=" + ServerName + ";Initial Catalog=" + DatabaseName + _
";Integrated Security=SSPI;User ID=" + UserID + ";Password=" + Pwd
[code]......
I always get error to connect my project in vb.net to sql server on remote computer?
View 7 RepliesI created application database by vb.net and sql server 2005 now I have some computer on the one of them I installed sqlserver 2005 and other (Clients) computers I installed Application how I can connecting my application to sql server on the pc1 or how I can using connection string.
View 2 RepliesI am trying to connect with SQL Server Database using VB.Net. In Datasource of Binding Source, I selected 'Add project datasource' Clicked 'Database and New Connection in Choose Connection Wizard.
In New Connection, what to select 'SQL Server' or SQL server Database? I tried both but when Tested Connection, it failed to connect.Also, what type of password to be chosen, Windows based or SQL Server based?