This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 21%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGR%3C/text%3E%3C/svg%3E)
While attempting to convert an Excel VBA to VB.NET, got BC30002 error. After reviewing some of the logs, still unable to resolve. Here is some information on my code:
The BC30002 error info is provided below. Statement Line 35 is also provided.In addition, the Imports statements as well. Please let me know if you need any other information. I am currently using Visual Studio 2022. Thank you for your help.
-------
Severity Code Description Project File Line Suppression State
Error BC30002 Type 'SqlConection' is not defined. HOHAdminWin C:\Users\HOH-IT-Admin\source\repos\HOHAdminWin\HOHAdminWin\HOHAdmin.vb 35 Active
------
(1st 7 lines of HOHAdmin.vb)
Option Explicit On
Option Strict On
Imports System
Imports System.Configuration
Imports System.Data.SqlClient
Imports System.Data
Imports System.Data.OleDb
Imports System.Windows.Forms
-----
(line 35) Dim conn As SqlConection
That's exactly what Line 7 has.
Look carefully -- SqlConection vs. SqlConnection. :)
I wish we could delete comments for situations like this where I just didn't hit save fast enough.
My apologies on the Line statement number. The statement number is not 7, but 35. On a separate note, although I haven't seen a DIM statement with a trailing period, I tried it anyway. That did not solve the issue.
If line 35 is
Dim conn As SqlConection
then try to change it to
Dim conn As SqlConnection
My apologies for the typo on SqlConnection, my bad. The typo has been fixed; however, I still get SqlConnection is not defined. Any additional help would be greatly appreciated.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 27%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
You should provide more information, like what version of .NET are you targeting? Is it .NET or .NET Framework? Is it a Windows Forms app? Is it a Console app?
You may be missing the System.Data.SqlClient NuGet package, try adding it.
With the additional comments provided by Andy, this solved the issue.
Try this: Dim conn As SqlConnection.
Copy and paste this and see what happens
Dim conn As System.Data.SqlClient.SqlConnection
A couple of comments (and thanks in advance for your continue help):
#1. Question for Andy: Adding the NuGet package. I don't know how to do this. Can you provide detailed steps?
#2. From a previous question from Andy, the Target Framework is .NET 6.0 and Windows Application.
#3. Dewayne: When changing the statement to fully-qualified statement: "Dim conn As System.Data.SqlClient.SqlConnection", I get BC31424 error. Here are the details of that error:
Error BC31424 Type 'System.Data.SqlClient.SqlConnection' in assembly 'HOHAdminWin, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' has been forwarded to assembly 'System.Data.SqlClient, Version=0.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. Either a reference to 'System.Data.SqlClient, Version=0.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' is missing from your project or the type 'System.Data.SqlClient.SqlConnection' is missing from assembly 'System.Data.SqlClient, Version=0.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. HOHAdminWin C:\Users\HOH-IT-Admin\source\repos\HOHAdminWin\HOHAdminWin\HOHAdmin.vb 35 Active
Try right-clicking on the project and see if Manage NuGet Packages is there, or try right-clicking on the Dependencies item under the project.
Cached delay.... there is a bug with this site..
To Andy: I was able to get to the "NuGet Package Manager". There are 3 tabs: "Browse, Installed, Updates". When I ran the "Browse", I got back "Error occurred". Then I thought I had to select from the pull-down. So, I selected "sqlclient". Same result. When I selected "Installed" tab, Message came back indicating no packages installed. The same thing with "Updates". So, I think your comment about NuGet not being installed may be correct. How do I install it? And what did I do wrong previously to cause this error? Again, thank you very much for your help. regards, Giacomo
With you having a .NET 6 app, I think that those packages should have been pulled in automatically for you. It requires internet, but if that computer has access to the internet, you may need to initiate a repair on visual studio as something may be corrupted. It should work fine. The "Installed/Update" tab would be empty if you haven't installed any packages.
You normally choose Browse, type in the package name you want, select it, then install/add it.
Here is the current status:
---- below is the message when I attempted a build
Build started...
NuGet package restore failed. Please see Error List window for detailed warnings and errors.
Error occurred while restoring NuGet packages: The operation failed as details for project HOHAdminWin could not be loaded.
Should I update to Windows 11 and simply install VS 2022 Community version from scratch? Please advise. I'm stuck. Thanks for all your help.
Try creating a brand new project and see if you can do these simple tasks. If you can, then perhaps something is wrong with the current project.
Andy, great suggestion! Thanks for sticking it out, helping to resolve this issue. So, I created a small project, (Windows Form App (.NET Framework) and the simple logic compiled. I must have used the wrong template when I created my project. Is there a way to change the template for my existing project? Again, thanks for helping me with this issue. regards, Giacomo
The template and stuff is all pretty open for easy editing these days, when you choose a non .NET Framework project. The SDK-style project system, which is the latest project system, can be detected easily by double-clicking on the project file in Visual Studio. If it opens and looks something like this link, https://learn.microsoft.com/en-us/nuget/resources/check-project-format#check-the-project-format you have an SDK-style project. If you can't open it and have to first unload then edit it, and it's a couple pages long, you have a Framework-style project.
Paste the content of your SDK-style project (if that's what you have) and I'll help identify any problems with it.
Andy, after reviewing some of my previously converted VBA to C#, I realized I was mixing SqlClient with ADODB logic, which really caused the compile errors. Once I limited the code to ADODB (and eliminated any SqlClient statements), the compilation was without errors. So, having said that I prematurely thought it was the incorrect template. Again, thanks for your help.