SQL Server Native Client 10

[sparkbyte]

OK What have I done wronge?

Set objSQLDataBaseCat = New ADOX.Catalog
cnn.Open "Provider = SQLNCLI10;" & _
            "Data Source = strServer;" & _
            "Initial Catalog = strDatabase;" & _
            "Integrated Security = SSPI;"
            
Set objSQLDataBaseCat.ActiveConnection = cnn

Thanks

John Fuhrman

 

[PHV]

I guess that strServer and strDatabase are variables:

cnn.Open "Provider = SQLNCLI10;" & _
            "Data Source = " & strServer & ";" & _
            "Initial Catalog = " & strDatabase & ";" & _
            "Integrated Security = SSPI;"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886