cancel
Showing results for 
Search instead for 
Did you mean: 

Can I connect to SAP database directly with ODBC?

Former Member
0 Kudos

I need to read data from SAP and write them into ms sqlserver. I wrote a RFC in SAP and used VB.NET to call RFC. I wonder that the RFC efficency is very slow while reading a great lot data. RFC also cannot support complex condition string, and it cannot fetch my data flexibly.

I found that the user who was included in a user group "db<sid>adm" could connect to db2 udb with ODBC in VB6.0 or VB.NET. I also can use the SQL sentence to get data flexibly.

Please tell me whether I can use this user to read (just using select sentense) data from DB2 UDB directly, or whether I can use the newly created user to get data. Will this method cause any problem ?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

post it in basis forum.

Answers (1)

Answers (1)

Former Member
0 Kudos

I post it in basis