SQL SERVER ODBC ERROR (invalid object name), but when I add an SQL query, mydb.dbo.mytable everything works fine

Question

I have an old asp.net 1 project (it works fine on the old server, mytable exists in db. Now I'm trying to upgrade it to asp.net 4

My connection string:

<add key="SqlConnection" 
     value="DRIVER={SQL Server};SERVER=bel\SQLEXPRESS;Trusted_connection=yes;DAT­ABASE=mydb;option=3;"/>

I get an error

ERROR [42S02] [Microsoft] [ODBC SQL Server Driver] [SQL Server] Invalid object name "mytable".

OdbcCommand dataCommand = new OdbcCommand ("select * from mytable", DataConnection);
dataCommand.CommandTimeout = 900;
OdbcDataReader dataReader = dataCommand.ExecuteReader (CommandBehavior.CloseConnection);

When I wrote SQL like select * from mydb.dbo.mytableeverything works fine

db (security, schema, dbo) ?

Answer 1

, ODBC, , ODBC .

:

• , "Database = myDBname" "InitialCatalog = myDBname"
• ODBC-, XP/Server 2003

Answer 2

: ODBC SQL-Server- ODBC Firedac-

:
Param MetaDefSchema sqlserver:

FDConnection1.Params.AddPair('MetaDefSchema', self.FDConnection1.Params.UserName);

:

MetaDefSchema = . >> & lt; & lt; !! SQL-Server-Authenticationname, MetaDefSchema.

:

dbname.username.tablename  -> invalid object name

MetaDefSchema sqlserver-username:

dbname.tablename  -> works  !

. embarcadero-doc.