Comments by Member 13474292

Member 13474292 31-May-24 20:04pm View

Mr. Kreskowiak, you have my great thanks! The old grey matter just isn't turning over like it once was for me! This has allowed me to push my project over the finish line! It may sound dated, but in my eyes, "You are DA MAN!"

Member 13474292 31-May-24 12:09pm View

I also tried this with no joy:

Dim sConnection As String = "Server=.\SQLExpress;Database=MusicCollection;Trusted_Connection=True;"

My Google-fu is failing me!

Member 13474292 31-May-24 12:06pm View

Well, stuck again! Apparently connection strings have also changed. This is what I used to use (and which still works in my old code):

Dim sConnection As String = "Data Source=" + System.Environment.MachineName + "\SQLEXPRESS;Initial Catalog=MusicCollection;Integrated Security=True"

When I use that now, I get this error:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)

Any ideas on how to connect to my local SQLExpress instance?

Damn! I used to know all this stuff!

Member 13474292 31-May-24 11:50am View

Thank you, sir! This has allowed me to continue to work on my little data migration project. Boy! You leave the industry for six or seven years and they have the nerve to go changing things!

Member 13474292 30-May-24 19:41pm View

The target framework is .NET 6.0. I suspect you're right about not having a reference to the appropriate library but I'm not sure where to look. It's been 7 years since I've retired and I sometimes think I've forgotten more than I ever learned! Other than the Imports statement, I can't think how to reference a library that would include support for working with SQL Server. Simply adding a reference to System.Data.SQLite.dll was enough to get me going with the output but the input from SQL Server not working is making me feel stupid!

Comments by Member 13474292 (Top 5 by date)