Home > Archive > MS SQL Server ODBC > November 2005 > sql2005, access pure odbc data from sp









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author sql2005, access pure odbc data from sp
S c o t t K r a m e r

2005-11-26, 3:23 am

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!!



S c o t t K r a m e r

2005-11-28, 11:23 am

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@ALLTE
L.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!!
>
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com