>>>>Hi All,
>>>>
>>>>I am running Mere Mortals but this exception is being thrown fromt he SqlAdapter.Fill method so shouldn't matter much.
>>>>When adapter.Fill(ds, tableName); is called I am getting an exception of "Invalid object name dbo.CompanyAccess"
>>>>
>>>>I am not sure if this means the connection is not working or it can't find this table. The table does definately exist and I tried a different table access with the same result. What might cause this to happen?
>>>>Tim
>>>
>>>Would have something to do with the database name changing between your local copy and the site? Maybe some of the generated SQL refers to the other server?
>>
>>
>>The connection string has "Data Source=(local)". Is this a problem for running in the dev server; do I need to explicitly name the SQL server?
>>Tim
>
>It should only be a problem if there is more than once instance of SQL Server running.
>
>Is "dbo" the actual owner of these tables?
Apparently, as when I look in Sql Server Management studio they are listed as dbo.CompanyAccess. I just changed my login credentials to use the sa account but still no change. also I rechecked to make sure the BLG can access the tables and it works fine. I wonder if this is an MM issue.
Tim
Timothy Bryan