foxuma2001
MIS
Dear friends,
I made a mistake. Plz tell me how to rectify this as Iam desperate.
The problem is:
In controlpanel -> ODBC 32 bit in User DSN tab in the list of User DSN items, we have MS Access Database know. By mistake I went to that configuration and changed the name as mydsn instead of MS Access Database. Also I selected my mdb file for that.We should not change this configuration I suppose.
(FYI: I actually want to create a new User DSN yaa. But by mistake I selected that existing MS Access Database and made all modifications there.)
Now I have one VB project and the connection coding there is:
Set cn = New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\mastdb\client.mdb;Persist Security Info=False"
Now after I changed that configuration in ODBC 32 bit its giving an error "Activex component cant create object" and showing error in the line - Set cn = New ADODB.Connection.
I think some system configuration has changed. Plz help me as to how to come out of this.
Earlier suggestion in this will be of much help to me.
Thanx in advance.
I made a mistake. Plz tell me how to rectify this as Iam desperate.
The problem is:
In controlpanel -> ODBC 32 bit in User DSN tab in the list of User DSN items, we have MS Access Database know. By mistake I went to that configuration and changed the name as mydsn instead of MS Access Database. Also I selected my mdb file for that.We should not change this configuration I suppose.
(FYI: I actually want to create a new User DSN yaa. But by mistake I selected that existing MS Access Database and made all modifications there.)
Now I have one VB project and the connection coding there is:
Set cn = New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\mastdb\client.mdb;Persist Security Info=False"
Now after I changed that configuration in ODBC 32 bit its giving an error "Activex component cant create object" and showing error in the line - Set cn = New ADODB.Connection.
I think some system configuration has changed. Plz help me as to how to come out of this.
Earlier suggestion in this will be of much help to me.
Thanx in advance.
