Solved

sql server 2005 invalid database name error

Posted on 2012-04-04
3
339 Views
Last Modified: 2012-04-09
Hello. I have a page that keeps giving me an error that says "invalid database name". I don't know why I get this error. I know my connection string in my web.config is correct b'c the referring page uses the same web.config file to access the same database and the same table.  I have a file with an online form. When submitted the information from the form is dumped into my sql database and then the user is sent to another page which pulls that information that is just dumped into a printable format.  My problem is that when the print page is called I get an error that says "invalid database name". Here is the code that actually pulls the information from the database:
Protected Sub Page_Load(sender As Object, e As System.EventArgs)
        If Not Page.IsPostBack Then
            Master.Section = "forms"
            'Binds listview to database
            lv.DataSource = ExeReader("AAC", "SELECT * FROM [Interact_Plan] ORDER BY                        
                                                         firstName ASC")
            lv.DataBind()
        End If
    End Sub

And here is my connection string in my web.config
<ConnectionString>Data Source=MYDB1;Initial Catalog=AAC;User ID=sa;Password=*****</ConnectionString>

I don't understand how it can work for one page and not the other.
0
Comment
Question by:cdlciddit
  • 2
3 Comments
 
LVL 23

Accepted Solution

by:
wdosanjos earned 500 total points
ID: 37807216
I suspect the problem is on the ExeReader code.  Can you post it?
0
 

Author Comment

by:cdlciddit
ID: 37823565
Hello. Yes. That was it. That ExeReader only took one variable and I was passing in two.  It is funny how that would give me a database error. Thanks for your help
0
 

Author Closing Comment

by:cdlciddit
ID: 37823572
That was the problem. Passing in too many variables into the ExeReader function.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
ASCX file or a newer alternative? 1 36
Addition to SQL for dynamic fields 6 38
Sql server insert 13 32
Help with exporting to excel 4 28
ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question