This is a discussion on sql2005, access pure odbc data from sp within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> in sql2000 I use msdasql, oledb provider for odbc (using openrowset) -- and this works good to import odbc ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| in sql2000 I use msdasql, oledb provider for odbc (using openrowset) -- and this works good to import odbc data right in a stored proc... is there a clean way to access odbc data in sql2005? in a stored proc?, also since msdasql is being phased out & its altogether not avail on x64 thanks!! |
| ||||
| this is a 64-bit prob, I got it working in 32-bit "S c o t t K r a m e r" <sckramer2000@hotmail.com> wrote in message news:274f3$43882378$a227293d$30979@ALLTEL.NET... > in sql2000 I use msdasql, oledb provider for odbc (using openrowset) -- > and this works good to import odbc data right in a stored proc... > > is there a clean way to access odbc data in sql2005? in a stored proc?, > also since msdasql is being phased out & its altogether not avail on x64 > > thanks!! > > > |