Just wondering if you guys can answer this question for me. I'm connecting dreamweaver to sql server via asp.net and keep coming up with this error message:

System.Data.OleDb.OleDbException: Invalid object name 'dbo.instructors'.
at System.Data.OleDb.OleDbDataReader.ProcessResults(I nt32 hr)
at System.Data.OleDb.OleDbDataReader.NextResult()
at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior behavior)
at System.Data.OleDb.OleDbCommand.System.Data.IDbComm and.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable)
at DreamweaverCtrls.DataSet.DoInit()

I have given myself all the proper permissions to access sql and display the database information. I really have no clue to why it isnt displaying the information because if you test the data it shows in the test dialogue box.

why are you using a WYSIWYG editor if you are familiar with ASP???

student didn't actually say they're familiar

This is not an answer to your problem but why are you using oledb for sql server instead of sqlclient which is made specific for sqls erver?

Tony

Hey Student,

Check your table permissions for your userID AND for ASPNET user. I have made the mistake of creating a table with the wrong owner by accident.

If that doesn't fix it, write me and we'll try something else.

How do you like Dreamweaver.NET? I'm doing ASP.NET thru Visual Studio and was considering trying Dreamweaver.NET. Any suggestions?

Good luck,

jk

What is Dreamweaver.NET? There's Dreamweaver MX 2004.