I am trying to copy a text file into a sql server database but I am
having problems with an undeclared variable error. The variable in
question is a reference to the connection string name in the web.config
file. Here is the connectionstrin g section of my web.config: There
are 2 strings, one called ConLocText and one called ConSQLLocal
*************** *************** ***********
<connectionStri ngs>
<add name="ConLocTex t" connectionStrin g="Driver={Micr osoft Text
Driver (*.txt;
*.csv)};default dir=C:\Inetpub\ wwwroot\Locatio nsUpload\FileUp loading\Locatio nCSV;driverid=2 7;extensions=No ne,asc,csv,tab, txt;fil=text;fi ledsn=C:\Progra m
Files\Common Files\ODBC\Data
Sources\Locatio nsTxtFile.dsn;m axbuffersize=20 48;maxscanrows= 25;pagetimeout= 5;safetransacti ons=0;threads=3 ;uid=admin;user commitsync=Yes"
providerName="S ystem.Data.Odbc " />
<add name="ConSQLLoc al" connectionStrin g="Data
Source=EBIZDEVA PP02;Initial Catalog=Atlas;P ersist Security
Info=True;User ID=username;Pas sword=password"
providerName="S ystem.Data.SqlC lient" />
</connectionStrin gs>
*************** *************** *************
Here is the start of my asp page; the last two lines are the one that
are reporting undeclared variables in visual studio:
*************** *************** *************** **********
Imports System.Data.Ole Db
Imports System.Data.Sql Client
Imports System.Configur ation
Imports System.Web.Conf iguration
Partial Class _Default
Inherits System.Web.UI.P age
Protected Sub btnUpload_Click (ByVal sender As Object, ByVal e As
System.EventArg s) _
Handles btnUpload.Click
Try
FileUpload1.Sav eAs(MapPath("~/LocationCSV/" & _
FileUpload1.Fil eName.ToString( )))
Dim connections As ConnectionStrin gSettingsCollec tion = _
ConfigurationMa nager.Connectio nStrings
Dim sourcecon As String =
connections(Con LocText).Connec tionString
Dim destcon As String =
connections(Con SQLLocal).Conne ctionString
*************** *************** *************** *******
Where and how do I declare these?
