Hi,
I am currently trying to link a ODBC database from a server into my MS Visual Studio 2010 asp.net web application. I have the ODBC connection set up on my workstation and all data on the SQL Server. My problem is this: Whenever I access the page it comes up fine, but when I enter a search into the text box and click "submit" I get this error:
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name...
dascott20
Last Activity: Feb 28 '11, 10:30 PM
Joined: Jul 30 '10
Location:
-
ODBC Connection Error
-
This is to let everyone know that I have solved this issue, the answer posted by Frinavale below was very helpful in that process. If you are reading this to solve a simisare problem, below is a solid setup, with two important factors to remember.
1)Declare All your variables.
2)Keep in mind what order you are coding youre commands. -
orangeCat is correct the contains statement isn't available in MS Access however the data tables and queries are being set up in MS Visual Studios 2010 (more specifically I'm using VB to dynamically change them.) and are using Access for the information only. I have the CONTAINS statements set up and they do work, but without further defining them they act the same way as the LIKE statement does.
For clarification: I am not looking...Leave a comment:
-
Can I use whitespace to add new wildcard?
Hello,
I am working on a web page that queries a microsoft access database for our library using wildcards, I have set up the queries using the CONTAINS expression, like so
...Code:'"Select Command" Value part 1 Dim SelStat As String = "SELECT [Full Title] AS Full_Title, [Author List] AS Author_List, [Title Call Number] AS Title_Call_Number, [Series] AS Series, [Location] -
Keep In mind, that I was hired on as a student in net admin, not programming or web development. However this is my tasking at work so I can't hand it off. So please leave clear suggestions (Small words and color pictures appreciated :P)....Leave a comment:
-
asp.net where I'm at now
I apologize there seems to be miscommunicatio n. The Access Database is already up and functional. Where I am having trouble is with Asp.net. In Access for a wildcard query if a field is left blank then acess automatically ignores that field and pulls up the rest of the results based on the the others(i.e. if i have four fields for search criteria and leave one blank, Access will ignore that one and search...Leave a comment:
-
Lol Sorry the first suggestion was the code I am currently using and it doesn't display null values. I'll try this approach though. Messy is ok It has to be easy on the user end not necessarily for me :P. I could use an OR statement but that risks information overload on the user end....Leave a comment:
-
Code
The SQL code is:
Code:SELECT [Full Title] AS Full_Title, [Author List] AS Author_List, [Title Call Number] AS Title_Call_Number, Series, Location FROM Library WHERE ([Full Title] LIKE '%' + ? + '%') AND ([Author List] LIKE '%' + ? + '%') AND ([Title Call Number] LIKE '%' + ? + '%') AND (Location LIKE '%' + ? + '%') AND ([Search Terms] LIKE '%' + ? + '%') ORDER BY [Full Title]
Leave a comment:
-
Help With Null Value Problem in asp.net DB Query
I've been working on building a back end on an access database that allows users to search records using a web search box. I've been able to successfully set up simple search query's but have run into trouble where multiple criteria with "AND" statements (OR statements would return too much to be useful). My problem is this, when all five text boxes are filled out the query returns records no problem, but if even one is left blank i get...
No activity results to display
Leave a comment: