Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > .aspx.vb code syntax

Reply
Thread Tools

.aspx.vb code syntax

 
 
slinky
Guest
Posts: n/a
 
      08-09-2007
I'm making a OLE DB connection in code and was wondering if anyone
could identify what the syntax errors would be in this just as it is
pasted (I tried putting & _ at the end of the first line and that
only brought up other errors):

New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=" & Server.MapPath(~/App_Data/Lowes.mdb) & ";" & _
"Initial Catalog=Assets;Integrated Security=SSPI")

Thanks!!

 
Reply With Quote
 
 
 
 
=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=
Guest
Posts: n/a
 
      08-09-2007
Have you looked at connectionstrings.com? Its a good url to bookmark.
Peter
--
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com



"slinky" wrote:

> I'm making a OLE DB connection in code and was wondering if anyone
> could identify what the syntax errors would be in this just as it is
> pasted (I tried putting & _ at the end of the first line and that
> only brought up other errors):
>
> New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data
> Source=" & Server.MapPath(~/App_Data/Lowes.mdb) & ";" & _
> "Initial Catalog=Assets;Integrated Security=SSPI")
>
> Thanks!!
>
>

 
Reply With Quote
 
 
 
 
slinky
Guest
Posts: n/a
 
      08-09-2007
I looked on connectionstrings.com but it did not have specifics for
what could be wrong with the syntax... thanks though

On Aug 9, 11:20 am, Peter Bromberg [C# MVP]
<(E-Mail Removed)> wrote:
> Have you looked at connectionstrings.com? Its a good url to bookmark.
> Peter
> --
> Recursion: see Recursion
> site: http://www.eggheadcafe.com
> unBlog: http://petesbloggerama.blogspot.com
> BlogMetaFinder: http://www.blogmetafinder.com
>
>
>
> "slinky" wrote:
> > I'm making a OLE DB connection in code and was wondering if anyone
> > could identify what the syntax errors would be in this just as it is
> > pasted (I tried putting & _ at the end of the first line and that
> > only brought up other errors):

>
> > New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data
> > Source=" & Server.MapPath(~/App_Data/Lowes.mdb) & ";" & _
> > "Initial Catalog=Assets;Integrated Security=SSPI")

>
> > Thanks!!- Hide quoted text -

>
> - Show quoted text -



 
Reply With Quote
 
David Wier
Guest
Posts: n/a
 
      08-09-2007
try removing all continuation characters and see if it all works

David Wier
http://aspnet101.com
http://iWritePro.com - One click PDF, convert .doc/.rtf/.txt to HTML with no
bloated markup



"slinky" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed) oups.com...
> I'm making a OLE DB connection in code and was wondering if anyone
> could identify what the syntax errors would be in this just as it is
> pasted (I tried putting & _ at the end of the first line and that
> only brought up other errors):
>
> New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data
> Source=" & Server.MapPath(~/App_Data/Lowes.mdb) & ";" & _
> "Initial Catalog=Assets;Integrated Security=SSPI")
>
> Thanks!!
>



 
Reply With Quote
 
slinky
Guest
Posts: n/a
 
      08-09-2007
I just did that with this line:

New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
Server.MapPath(~/App_Data/Lowes.mdb) " &";""Initial
Catalog=Assets;Integrated Security=SSPI")

I used no continuity characters and the line showed no errors, except
one - it noted the ~ symbol as being not valid, but then errors showed
up in other unexpected places like: 'cnn' is not declared... when my
code (in its entirety below) shows that it IS declared.
__________________________________________________ _______________________________

Imports System.Data
Imports System.Data.OleDb
Public Class Default5
Inherits System.Web.UI.Page
Private Sub Page_Load(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles MyBase.Load
Dim cnn As OleDbConnection = _
New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=" & Server.MapPath(~/App_Data/Lowes.mdb) " &";""Initial
Catalog=Assets;Integrated Security=SSPI")
Dim ds As DataSet = New DataSet()
Dim da As OleDbDataAdapter = New OleDbDataAdapter()
If Not IsPostBack Then
Dim cmdSelect As OleDbCommand = _
cnn.CreateCommand()
cmdSelect.CommandType = CommandType.Text
cmdSelect.CommandText = _
"SELECT ([Asset Number], Description, [Serial Number], Mfg, AssetType,
RDCnumber) FROM Assets"
Dim cmdInsert As OleDbCommand = _
cnn.CreateCommand()
cmdInsert.CommandType = CommandType.Text
cmdInsert.CommandText = _
"INSERT INTO Assets " & _
"([Asset Number], Description, [Serial Number], Mfg, AssetType,
RDCnumber) " & _
"VALUES(@AssetNumber, @Description, @Serial_Number, @Mfg, @AssetType,
@RDCnumber"
cmdInsert.Parameters.Add("@txtAsset_Number",
OleDbType.Double, 12, "[Asset Number]")
cmdInsert.Parameters.Add("@txtDescription",
OleDbType.WChar, 40, "Description")
cmdInsert.Parameters.Add("@txtSerial_Number",
OleDbType.WChar, 30, "[Serial Number]")
cmdInsert.Parameters.Add("@txtMfg", OleDbType.WChar, 30,
"Mfg")
cmdInsert.Parameters.Add("@txtAssetType", OleDbType.WChar,
30, "AssetType")
cmdInsert.Parameters.Add("@txtRDCNumber", OleDbType.WChar,
30, "RDCnumber")
Dim SourceVersion As DataRowVersion
SourceVersion = DataRowVersion.Original
da.SelectCommand = cmdSelect
da.InsertCommand = cmdInsert
da.Fill(ds, "Assets")
End If
End Sub
Private Sub btnAdd_Click( _
ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles btnAdd.Click
Dim cnn As OleDbConnection = _
New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=" & Server.MapPath(~/App_Data/Lowes.mdb) " &";""Initial
Catalog=Assets;Integrated Security=SSPI")
Dim ds As DataSet = New DataSet()
Dim da As OleDbDataAdapter = New OleDbDataAdapter()
Dim dr As DataRow = ds.Tables("Assets").NewRow()
dr(0) = txtAsset_Number.Text
dr(1) = txtDescription.Text
dr(2) = txtSerial_Number.Text
dr(3) = txtMfg.Text
dr(4) = txtAssetType.Text
dr(5) = txtRDCnumber.Text
ds.Tables("Assets").Rows.Add(dr)
da.Update(ds, "Assets")
End Sub
End Class
__________________________________________________ __________________________________________________ __




On Aug 9, 12:25 pm, "David Wier" <(E-Mail Removed)>
wrote:
> try removing all continuation characters and see if it all works
>
> David Wierhttp://aspnet101.comhttp://iWritePro.com- One click PDF, convert .doc/.rtf/.txt to HTML with no
> bloated markup
>
> "slinky" <(E-Mail Removed)> wrote in message
>
> news:(E-Mail Removed) oups.com...
>
>
>
> > I'm making a OLE DB connection in code and was wondering if anyone
> > could identify what the syntax errors would be in this just as it is
> > pasted (I tried putting & _ at the end of the first line and that
> > only brought up other errors):

>
> > New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data
> > Source=" & Server.MapPath(~/App_Data/Lowes.mdb) & ";" & _
> > "Initial Catalog=Assets;Integrated Security=SSPI")

>
> > Thanks!!- Hide quoted text -

>
> - Show quoted text -



 
Reply With Quote
 
Alexey Smirnov
Guest
Posts: n/a
 
      08-09-2007
On Aug 9, 7:33 pm, slinky <(E-Mail Removed)> wrote:
> I just did that with this line:
>
> New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
> Server.MapPath(~/App_Data/Lowes.mdb) " &";""Initial
> Catalog=Assets;Integrated Security=SSPI")


I guess

Server.MapPath("~/App_Data/Lowes.mdb")

 
Reply With Quote
 
Alexey Smirnov
Guest
Posts: n/a
 
      08-09-2007
On Aug 9, 7:39 pm, Alexey Smirnov <(E-Mail Removed)> wrote:
> On Aug 9, 7:33 pm, slinky <(E-Mail Removed)> wrote:
>
> > I just did that with this line:

>
> > New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
> > Server.MapPath(~/App_Data/Lowes.mdb) " &";""Initial
> > Catalog=Assets;Integrated Security=SSPI")

>
> I guess
>
> Server.MapPath("~/App_Data/Lowes.mdb")


and finally

New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
Server.MapPath(~/App_Data/Lowes.mdb) " &";Initial
Catalog=Assets;Integrated Security=SSPI")

you should understand that the goal of that concatenation is to have a
properly formatted string, for example:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\InetPub\wwwroot
\App_Data\Lowes.mdb;Initial Catalog=Assets;Integrated Security=SSPI

 
Reply With Quote
 
slinky
Guest
Posts: n/a
 
      08-09-2007
So would this work? I added a couple of continuity characters. Looks
OK but it still doesn't allow the ~ symbol AND it still says the cnn's
are not declared.

New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
_
Server.MapPath(~/App_Data/Lowes.mdb) " &";Initial & _
Catalog=Assets;Integrated Security=SSPI")


 
Reply With Quote
 
Alexey Smirnov
Guest
Posts: n/a
 
      08-09-2007
On Aug 9, 8:13 pm, slinky <(E-Mail Removed)> wrote:
> So would this work? I added a couple of continuity characters. Looks
> OK but it still doesn't allow the ~ symbol AND it still says the cnn's
> are not declared.
>
> New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
> _
> Server.MapPath(~/App_Data/Lowes.mdb) " &";Initial & _
> Catalog=Assets;Integrated Security=SSPI")


oh, sorry a silly copy typo:

Server.MapPath("~/App_Data/Lowes.mdb")

 
Reply With Quote
 
slinky
Guest
Posts: n/a
 
      08-09-2007
OK I put this in:

New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
_
Server.MapPath("~/App_Data/Lowes.mdb") " &";Initial & _
Catalog=Assets;Integrated Security=SSPI")

But then the " &" part of the second line errors
with: "Comma, ")", or valid expression expected"

Plus any clues as to why the 'cnn' isn't recognized?

On Aug 9, 2:21 pm, Alexey Smirnov <(E-Mail Removed)> wrote:
> On Aug 9, 8:13 pm, slinky <(E-Mail Removed)> wrote:
>
> > So would this work? I added a couple of continuity characters. Looks
> > OK but it still doesn't allow the ~ symbol AND it still says the cnn's
> > are not declared.

>
> > New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
> > _
> > Server.MapPath(~/App_Data/Lowes.mdb) " &";Initial & _
> > Catalog=Assets;Integrated Security=SSPI")

>
> oh, sorry a silly copy typo:
>
> Server.MapPath("~/App_Data/Lowes.mdb")



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Syntax Checker that's better than the normal syntax checker Jacob Grover Ruby 5 07-18-2008 05:07 AM
Syntax error? What syntax error? Assignment fo default values? Mark Richards Perl Misc 3 11-18-2007 05:01 PM
Syntax bug, in 1.8.5? return not (some expr) <-- syntax error vsreturn (not (some expr)) <-- fine Good Night Moon Ruby 9 07-25-2007 04:51 PM
[ANN] SqlStatement 1.0.0 - hide the syntax of SQL behind familiarruby syntax Ken Bloom Ruby 3 10-09-2006 06:46 PM
Syntax highligth with textile: Syntax+RedCloth ? gabriele renzi Ruby 2 12-31-2005 02:44 AM



Advertisments