[connection-string] Forum Topics

Hello, kindly look at my php code to insert registration data into a MySQL database. Here is the code below and further below, the error response I keep getting. <?php error_reporting(E_ALL); ini_set('display_errors', 1); $servername = "localhost"; $username = "emiola"; $password = "emmybaba2020"; $dbname = "tutors"; // Create connection $conn = …

I am now in a problem to prompt user at the first run of my program. The Server is msSql Server 2008 R2 and Plaform vb.Net 2010. At the time of starting, the program starts to search the file, where the ConnectionString is saved. If it get then well else …

Hi to all, Im going through JDBC currently, I got struck with Java.lang.ArrayIndexOutofBounds Exception:0. I'm not getting the solution to this exception. Please help me to solve this exception, thanks in advance. import java.sql.*; class Select { public static void main(String args[]) { try { Class.forName("jdbc.oracle.driver.OracleDriver"); Connection con = DriverManager.getConnection …

Hy guys, . Please assist in advicing whch toolbox conncetion controls to add in my form. I want to connect to access 2007 using vb.net 2005 and im struggling. I have two textboxes(username and password) and two buttons(submit and cancel). When I click on the submit button it supposed to …

Hi guys pls help, Im trying to connect to access 2007 database in vb.net 2005 woth no luck.....im using a login form with two text boxes and two buttons, Im tring to log into the database using the below connection string....... (i only get the catch message box error)... Plz …

Hi Guys I have an asp.net application developped using C# asp.net 4.0 , It is running perfectly with .net inbuilt server , but it throws an exception when running on IIS server 5.1 (Win XP sp-3) There i have a connection string encryption method , that is the place it …

Hello everyone! I am posting this code for anyone who may be having issues with connecting to a database. Feel free to use this code as you wish. This will be using the OLEDB library. [CODE] 'Imports Imports System.Data.OleDb Public Class Form1 'Declarations Dim con As OleDbConnection Dim cmd As …

I have developed a windows application. My development environment is win7, office2007, C#, VS2010, Winforms. My application stores data in MS Access. Is there any way with which i can create a connection string based on Oledb driver version present in PC?

Hello ım writing a program that it will work with sql database. i loaded a database which name is b.sql. but i need to connection string abouth user name , pasword and where is the location of database.

I am working on a VS2010 Winform (not ASP web form). I have a copy of the local database on my computer. In this application, I have 3 forms in my application that need to connect to the same database, but different tables. Right now I am defining my connection …

Hello, I m new in asp. I need to run asp website with access database. Pls help me to do this.. i got problm with connection string i think. Broswer reply : ------------------------------------ Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a …

I was wondering if there is a way to open an SQL file and execute it from a c# application without prior connection to a database and also get the name of the default server that is used when SSMS is opened. at the moment i can open SSMS but …

I have the following code for connecting to an Oracle DB [code] using Oracle.DataAccess.Client; // C# ODP.NET Oracle managed provider OraDb= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=ORASRVR)(PORT=1521)) ) (CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAME=ORCL) ) ) string oradb = "Data Source=//192.168.100.108;User Id=hr;Password=hr;"; // C# string oradb = "Data Source=(DESCRIPTION=" + "(ADDRESS=(PROTOCOL=TCP)(HOST=ORASRVR)(PORT=1521))" + "(CONNECT_DATA=(SERVICE_NAME=ORCL)));" + "User Id=hr;Password=hr;"; …

Okay, So I have an application which uses MSSQL server as datasource. Is there anyways I can avoid using any database server and use a local file as datasource ? If yes , what are options. AND HOW ? PS: this is very important guys. please help. THANK YOU.

I have this OLEDB connection string connectionstring as string = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ data.toString & ";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=2 I just want to know what is the meaning of HDR and IMEX, and what are their purpose on the connection string Thanks..

hi, i have a project written in visual studio 2008. and i copied the folder to the network drive. and from another pc when i run the exe file of the application an error occurs because the connection string is different, how can i make the application which is in …

Hello, I have one more question. I am connectinag to SQL Server 2008, not express, and I keep getting the "login failed for user "..."" The connection string I am using is: [CODE] Dim connStrg As String = "Data Source=" _ & ServerAdressTextBox.Text & _ ";Initial Catalog=" & _ DatabaseNameTextBox.Text …

I'm trying to connect a SQL database to a Classic ASP site. I keep getting the following error message no matter what I do: ADODB.Connection error '800a0e7a' Provider cannot be found. It may not be properly installed. I have an ODBC entry for this database, as well as have the …

i have a private sub that reads 4 lines of data from a text file, and then uses whats read and stores them in varibles. see below [CODE] Dim FileName As String = configfileV Dim TextFromTheFile As String ' Whole text Dim Lines() As String ' File splitted to lines …

This is my first foray into the world of programming. I'm doing a practice project for the consulting firm I work for, and my current objective is to make my submission page textboxes insert the user input into specific tables in my database. Later I'll need to retrieve the data, …

Hi guys, I'm new here and in dire need of help for a problem that I've worked on hours. I created a table 'tblProductCat' in the webform and wanted to populate the table with the code below: [CODE]Imports System.Data Imports System.Data.SqlClient Partial Class ProductCategories Inherits System.Web.UI.Page 'Define DA and DS …

Hi! I need to be able to change the location of the database at runtime through a menu in my program. My question is how to best achieve this. If for example the ip to the server change, the user need to be able to update the database path; i.e. …

hi, im about to finish a winform app for a client and I was wondering about the most common ways to handle connection strings. I know you can change the path from within appConfig to whatever the path may be on the destination server but are there any established approaches …

Hello Frends, I have an application where I am trying to connect MS Access DB with a ASP.Net(C#) Page and the same application also connect to the MS SQL Server (Working Fine). While connecting I am having following [B]error:[/B] _____________________________________________________________________________________ [B]Server Error in '/manager' Application. The Microsoft Jet database engine …

How to make clients on sql server i mean when i will install my application on clients how i will connect it with sql server?

I have been making some changes to an application that uses an ASP.NET Membership services database for authentication. I can access the database locally using windows authentication, and using my SA user. However, after moving the application to the prod. server, I can't access the DB at all. I wrote …

Hello guys. I'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 …

Hello, I am currently working on a project for my degree using asp.net, C# and Sql. The problem I am having is with my connection.cs file that I have created, the code I have is as follows: [CODE] using System; using System.Configuration; using System.Linq; using System.Data.Linq; using System.Xml; using School.SchoolCore.Core.Domain; …

Hello Everyone, I have developed an application for website using ASP.NET and SQL Server 2005. Recently I have uploaded it to server, but after uploading its showing the following error message - [B] Login failed for user ''. The user is not associated with a trusted SQL Server connection.[/B] [B]Description:[/B] …

Hi! I want to Upload and Attach my SQL server 2005 database and my Asp .net site to server please help me. and my connectionstring setting is in web.config tank you.