Re: Syntax
- From: jhofmeyr@xxxxxxxxxxxxxx
- Date: Tue, 27 May 2008 05:51:01 -0700 (PDT)
Hi Jamie,
My understanding is that you have a SQL Server database with a table
of values related to MDB files, and that you are having trouble
getting a stored proc to run against this (SQL Server) database to
retrieve some details. Please correct me if I'm wrong.
Based on the error messages you've posted, it looks as if the
Expression is not being evaluated correctly. There are a number of
pointers:
1) ... " the expression "EXEC CREATECOUNTRYTABLE
@[User::TagetDBNames]" failed. " - This indicates that the variable
name (not the variable value) is being substituted into the
expression. Check that you have the "'s in the right place.
2) ... " Description: "Incorrect syntax near '='.". " - This indicates
a syntax error. Look again at the expression you posted:
<quote>
"select left(abc,110)abc,left(cityname,90)cityname from
fips.dbo.encryptedcities where
cc1="+REPLACE( UPPER(RIGHT(@[User::TargetDB],6)),".MDB","")
</quote>
There should be a ' after the "=" in that expression, and another one
in the REPLACE statement (inside the ""). So:
"select left(abc,110)abc,left(cityname,90)cityname from
fips.dbo.encryptedcities where
cc1='"+REPLACE(UPPER(RIGHT(@[User::TargetDB],6)),".MDB","'")
The error messages in your last post look like they're related to the
Access database connection string, and not the Expression issue you're
having with the stored proc execution. Maybe once we have the sproc
returning correctly we can address the Access connection manager
settings.
Good luck!
J
.
- Follow-Ups:
- Re: Syntax
- From: thejamie
- Re: Syntax
- References:
- RE: Syntax
- From: thejamie
- RE: Syntax
- From: Jamie
- RE: Syntax
- From: thejamie
- RE: Syntax
- Prev by Date: Problems with code page in Vista
- Next by Date: Re: Fuzzy Lookup and Job Agent
- Previous by thread: RE: Syntax
- Next by thread: Re: Syntax
- Index(es):
Relevant Pages
|
Loading
