Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peuj
Starting Member
2 Posts |
 Posted - 2004-12-03 : 13:01:32
|
| Hi,new on this forum I need some help with a DB2 issueWhen I use this code: Dim Conn As New ADODB.Connection Dim TablesSchema As ADODB.Recordset Conn.Provider = "MSDASQL" Conn.CursorLocation = adUseClient Conn.Open "PROVIDER=MSDASQL;dsn=" + sDSN + ";uid=" + USER + ";pwd=" + PASS + ";" Set TablesSchema = Conn.OpenSchema(adSchemaTables)I got an error : "Object or provider is not capable of performing requested operation."I work with DB2 v8.1 and MDAC 2.8I don't have this issue if I work on DB2 v7.1Does somebody knows what's wrong ?Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-12-03 : 13:11:06
|
| Well, we're a SQL Server site, not DB2. If I had to hazard a guess, your ODBC driver for DB2 needs to be upgraded to one that works with v8.1. The DSN would probably also have to be recreated to use the new driver. |
 |
|
|
Peuj
Starting Member
2 Posts |
Posted - 2004-12-06 : 06:17:12
|
| Sorry to disturb, I've asked on a lot of sites and I don't take care...Thanks to answer, I will checked you suggestion. |
|
|
|
|
|
|
DB2 issue with OpenSchema(adSchemaTables)