Invalid object name dbo.Images

Question

Invalid object name dbo.Images

Cliff Estes 1

Database:
aspnet-BorrowedLightImages2022-31ddfd69-3493-469b-8cb0-3f0d286226b2; (Name copied from connectionstring)
aspnet-BorrowedLightImages2022-31ddfd69-3493-469b-8cb0-3f0d286226b2 (Name copied from SSMS)
aspnet-BorrowedLightImages2022-31ddfd69-3493-469b-8cb0-3f0d286226b2 (Name copied from VS2022 Server Object Explorer)

contains a table, dbo.Image

SQL for that table:

CREATE TABLE [dbo].[Image] (  
	[Id]          INT            IDENTITY (1, 1) NOT NULL,  
	[ImgName]     NVARCHAR (MAX) NOT NULL,  
	[ImgPath]     NVARCHAR (MAX) NOT NULL,  
	[ImgKeywords] NVARCHAR (MAX) NOT NULL,  
	CONSTRAINT [PK_Image] PRIMARY KEY CLUSTERED ([Id] ASC)

);

Connection string

Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=aspnet-BorrowedLightImages2022-31ddfd69-3493-469b-8cb0-3f0d286226b2;Integrated Security=True;Connect 	Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False

SQL INSERT statement that throws the error:
"INSERT INTO dbo.Image (ImgName, ImgPath, ImgKeywords) VALUES ('1.jpg','Images\Slider','')"

Exception message
Invalid object name 'dbo.Image'

The INSERT query runs fine in SSMS.

I've tried surrounding "dbo" and "Image" with brackets thusly:
[dbo].[Image]
``to no avail.

Jack J Jun 25,296 Reputation points

2022-11-30T01:11:19.427+00:00

@Cliff Estes , Welcome to Microsoft Q&A, based on my test, dbo.Image and [dbo].[Image] both work for me. Also, I find that the direct name INSERT INTO Image works for me. Could you have a try?
Cliff Estes 1 Reputation point

2022-11-30T01:17:13.223+00:00

I tried
"INSERT INTO [dbo].[Image]..."
and
"INSERT INTO Image ..."

with the same result:

Invalid Object name
Jack J Jun 25,296 Reputation points

2022-11-30T01:28:13.217+00:00
@Cliff Estes , The Possible reason is that the word Image is a special, which may have been defined in the database. Have you considered to use another name to replace it, like ImageDetail?
Also, you could also try the following method to check if it works for you.

insert into [database name].[dbo].[table name] values('value1','value2',……)
Dan Guzman 9,401 Reputation points

2022-12-01T13:05:29.91+00:00

@Jack J Jun , image is not special. Although it is a data type name, it's not in the list of current or future reserved keywords so there are no special considerations with using it as an identifier name.

1 answer

Your answer

Jack J Jun 25,296 Reputation points

2022-11-30T01:11:19.427+00:00

@Cliff Estes , Welcome to Microsoft Q&A, based on my test, dbo.Image and [dbo].[Image] both work for me. Also, I find that the direct name INSERT INTO Image works for me. Could you have a try?
Cliff Estes 1 Reputation point

2022-11-30T01:17:13.223+00:00

I tried
"INSERT INTO [dbo].[Image]..."
and
"INSERT INTO Image ..."

with the same result:

Invalid Object name
Jack J Jun 25,296 Reputation points

2022-11-30T01:28:13.217+00:00

@Cliff Estes , The Possible reason is that the word Image is a special, which may have been defined in the database. Have you considered to use another name to replace it, like ImageDetail?
Also, you could also try the following method to check if it works for you.

insert into [database name].[dbo].[table name] values('value1','value2',……)
Dan Guzman 9,401 Reputation points

2022-12-01T13:05:29.91+00:00

@Jack J Jun , image is not special. Although it is a data type name, it's not in the list of current or future reserved keywords so there are no special considerations with using it as an identifier name.

Answer 1

Cliff Estes 1

Resolved.

Somehow the connectionstring was pointing to

initial catalog=master

I can't count how many times I checked the cs.

Grrrr.

Thx for the help.

Share via

Invalid object name dbo.Images

1 answer

Your answer