SQLServer Nvarchar unicode test [for Tommy et al]

[malik641]

I'm having trouble connecting to the Server:

[stanl]

That would be the major issue which distinguishing testing server code versus local code. I can post what works for me, but others have to ensure that they are connecting to a valid catalog on their own server, and as I said modify any file/paths to their own configuration. Please post your connection string, it's a lot easier to work with than an error message. Stan

[malik641]

At first, I tried it the way it was. Then I tried adding my name to the "\SQLExpress" since that's how it's stated in my object explorer in SQL Server Management Studio express:
[vba]cConn = "Provider=SQLOLEDB.1;Integrated Security=SSPI;" & _
"Persist Security Info=False;Data Source=,JOSEPH\SQLEXPRESS;Initial Catalog=NCS"[/vba]
What is a catalog? What does it do?

[stanl]

What is a catalog? What does it do?

A catalog is similar to a database. See my remarks on my post under your regex thread.