odbc or ole db

[michaelkrauklis]

I'm doing data transfer between a vc++ program and mssql2k. I was wondering what the differences in performance are between odbc and ole db. ODBC seems to be easier and thus has a faster development time, but speed is an issue in the transfer so I might be willing to put the extra effort in to use ole db. Any suggestions or advice? MYenigmaSELF
myenigmaself@yahoo.com

http://myenigmaself.gaiden.com

 

[mmetze]

Personally, I have found ole db to be pretty straight forward (in a VB environment, anyway) and yes, I would suspect there would be some (not sure how to quantify 'some') overhead in using ODBC drivers. Perhaps the following MSDN Library article could give additional insight...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoledb/html/choosingcomponents.asp

 

[michaelkrauklis]

Thanks, that did help a lot, but my primary problem is that I don't have what everyone seems to consider to be an actual "data source." I have a database set up that I wish to connect to, but I don't want to be bound to a specific table. All the examples that I've seen and when you run the MFC Wizard in VC++ and add OLE DB support mandate that you have a pre-existing table in your database that you will be using as the data source. But in my program I'm going to be needing to drop and add tables. Is this possible with OLE DB/ADO? I know it is with ODBC. Might I need a combination of the two? ODBC to create/manipulate tables and OLE DB to transfer mass data more quickly?? Thanks again for your help. MYenigmaSELF
myenigmaself@yahoo.com

http://myenigmaself.gaiden.com

 

[mmetze]

I'm a VB guy with no VC experience. However, when you use ADO in VB, you use thee connection object to connect to the datasource (not a specific table). For example...

Dim cnMyConnection as Connection

Set cnMyConnection = New Connection
cnMyConnection.Provider = "SQLOLEDB"
cnMyConnection.ConnectionString = _
"User ID=jdoe;" & _
"Password=spoon;" & _
"Data Source=MyServer" & _
"Initial Catalog=MyDatabase"

 

[michaelkrauklis]

Thanks for the advice. I think my route will be doing table manipulation using odbc, seeing how I've already written that part, and then data transfer using ole db. Thanks again for the help. MYenigmaSELF
myenigmaself@yahoo.com

http://myenigmaself.gaiden.com