>>Thread-Topic: Importing from ODBC Connector
>>thread-index: AcZ4Plono0quD4I4QW+kto2BetA5Lw==
>>X-WBNR-Posting-Host: 66.191.71.66
>>From: =?Utf-8?B?RG9u?= <djw@nospam.postalias>
>>References: <ACB99F8B-A1D9-448C-8D44-5CDBBF8EB8C0@microsoft.com>
<Y3HnBi8dGHA.188@TK2MSFTNGXA01.phx.gbl>
>>Subject: RE: Importing from ODBC Connector
>>Date: Mon, 15 May 2006 09:41:02 -0700
>>Lines: 75
>>Message-ID: <2142E13C-2D63-4DED-B756-5655FCFB787B@microsoft.com>
>>MIME-Version: 1.0
>>Content-Type: text/plain;
>> charset="Utf-8"
>>Content-Transfer-Encoding: 7bit
>>X-Newsreader: Microsoft CDO for Windows 2000
>>Content-Class: urn:content-classes:message
>>Importance: normal
>>Priority: normal
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>>Newsgroups: microsoft.public.sqlserver.dts
>>Path: TK2MSFTNGXA01.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.dts:65892
>>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>>X-Tomcat-NG: microsoft.public.sqlserver.dts
>>
>>I found my issue with the driver (apparently it was too new of a driver)
but
>>it is checking for a query to import. I want to just import everything
but
>>it does not give me that option.
>>I tried to simply use SELECT * FROM *;
>>but it does not seem to like that, any suggestions?
>>Thank you again!
>>
>>"Vincent Xu [MSFT]" wrote:
>>
>>> Hi,
>>>
>>> Techniacally, I don't think we need to apply any updates, but I
recommend
>>> you install sql native client
>>>
>>> http://msdn.microsoft.com/data/ref/sqlnative/
>>>
>>> Hope it helps.
>>>
>>> Best regards,
>>>
>>> Vincent Xu
>>> Microsoft Online Partner Support
>>>
>>> ======================================================
>>> Get Secure! - www.microsoft.com/security
>>> ======================================================
>>> When responding to posts, please "Reply to Group" via your newsreader
so
>>> that others
>>> may learn and benefit from this issue.
>>> ======================================================
>>> This posting is provided "AS IS" with no warranties,and confers no
rights.
>>> ======================================================
>>>
>>>
>>>
>>> --------------------
>>> >>Thread-Topic: Importing from ODBC Connector
>>> >>thread-index: AcZ2CCeXhm9FROyMTGGFzvlQqvztmw==
>>> >>X-WBNR-Posting-Host: 66.191.71.66
>>> >>From: =?Utf-8?B?RG9u?= <djw@nospam.postalias>
>>> >>Subject: Importing from ODBC Connector
>>> >>Date: Fri, 12 May 2006 14:08:02 -0700
>>> >>Lines: 9
>>> >>Message-ID: <ACB99F8B-A1D9-448C-8D44-5CDBBF8EB8C0@microsoft.com>
>>> >>MIME-Version: 1.0
>>> >>Content-Type: text/plain;
>>> >> charset="Utf-8"
>>> >>Content-Transfer-Encoding: 7bit
>>> >>X-Newsreader: Microsoft CDO for Windows 2000
>>> >>Content-Class: urn:content-classes:message
>>> >>Importance: normal
>>> >>Priority: normal
>>> >>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>>> >>Newsgroups: microsoft.public.sqlserver.dts
>>> >>Path: TK2MSFTNGXA01.phx.gbl
>>> >>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.dts:65856
>>> >>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>>> >>X-Tomcat-NG: microsoft.public.sqlserver.dts
>>> >>
>>> >>I have a custom ODBC connector (ProvideX) for a system that I am
trying
>>> to
>>> >>import the data into SQL Server. I have setup the System and User
DSN
>>> and am
>>> >>trying to use the import wizard but cannot seem to use the correct
>>> driver.
>>> >>
>>> >>Is there any suggestions about how to set this up in SQL 2005 or do I
>>> need a
>>> >>new .Net Driver to do this with?
>>> >>
>>> >>Thank you in advance for your help.
>>> >>Don
>>> >>
>>>
>>>
>>