Hi,
I have a strange problem , connecting to a ms access file using oledb. The same piece of code works when used in Windows application, but fails when i execute the same in my SQL CLR code. Assembly is set to unsafe to give full control to the code.
It gives ‘Unspecified error’ when tried to open connection . Piece of code taht fails is as below.
Dim cmd As OleDbCommand
Dim dr As OleDbDataReader
Dim mdbConn As OleDbConnection
Dim mdbConnStr, mdbSQL As String
mdbConn = New OleDbConnection(“Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\temp\kamlesh\dcsims.mdb;”)
mdbConn.Open()
Exception raised at this point –
A first chance exception of type ‘System.Data.OleDb.OleDbException’ occurred in System.Data.dll
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at Tomworks.StoredProcedures.tw_UploadDCSIMS(String szFilePath, String UploadDt, String szSQLServer, String szDatabase, String szUID, String szPwd)
