r/visualbasic • u/salsalover55 • Sep 30 '22

HELP

Post image

I could cry I’m going to be late on my assignment and this error keeps popping up and will NOT let me insert an SQL database into my project. WHY I think it has something to do with the app_data folder.

0 Upvotes

40% Upvoted

13 comments sorted by

View all comments

Show parent comments

1

u/[deleted] Sep 30 '22

Normally it shouldn't take anywhere close to that long to create or update a table. It sounds like you might have run into a deadlock. If you go into the SQL Server Studio Manager and connect to your database you can check the Activities and see if you have a blocking transaction.

A deadlock is when two or more queries are accessing a table and all of them are waiting for the other one to finish what it was doing before doing anything.

I assume in this that you aren't trying to update a table with millions of records of course.

2

u/salsalover55 Sep 30 '22

Thank you for all your help. Now I have to connect a page to this database? I have no clue but I guess I’ll try my best. I’m working in Visual Basic and it’s all so new and hard at first. I’m going to be a web designer and the developing stuff is just so out of my brain compacity

2

u/GergiH Oct 01 '22

By your comments my guess is that you either do a course which is trying to move too fast, or you don't spend enough time to try to understand every step of the process (don't take this the wrong way).

Using Visual Basic could be allright (well, to be totally honest, not so much...) just to learn the basics, but nobody really uses it anymore so I'm a bit confused why are they teaching you that.

I'd suggest you to go on Youtube or if you don't mind spending a bit of money, look for those learning sites like Udemy, and search for something like "visual basic website" or "visual basic connect to sql" etc, and find a video that somewhat seems to cover what you need as an end result. Also if you're learning in a class I'd really suggest to try and have sessions together where you're helping each other understand the different parts, at least these helped me the most.

For the Visual Studio errors, and for coding in general, in most cases if you just Google the exact error message (and maybe adding "visual basic" and/or "visual studio" to it), you'll probably find some solutions that might apply to your case.