In the following bunch of code, I get an Invalid Authorization Specification Error. I find search results with that error, but never anything related to what I am doing =(
I have not set a password inside mar.sdf. It should be left blank right?
I am using Visual Studios express 08 to build the database and I have not found
a place to enter a user name?
What am I missing here?
Many thanks
Nick
VB.NET:
Dim SQL_Conn_Obj As New ADODB.Connection
Dim RecSet As New ADODB.Recordset
Dim filename As String = Application.StartupPath & "\Mar.sdf"
Dim SQL_Conn_Str As String = _
"Provider = sqloledb;" & _
"Data Source=" & filename & ";" & _
"Initial Catalog=Mar.sdf;" & _
"User ID=;" & "Password=;"
SQL_Conn_Obj.Open(SQL_Conn_Str) ' INVALID AUTHORIZATION SPECIFICATION ERROR HERE!
RecSet.Open("select * from Call_Records", SQL_Conn_Obj,
I have not set a password inside mar.sdf. It should be left blank right?
I am using Visual Studios express 08 to build the database and I have not found
a place to enter a user name?
What am I missing here?
Many thanks
Nick