 | |
Importing from ODBC Connector
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Importing from ODBC Connector -
05-12-2006
, 04:08 PM
#2
| |||
| |||
|
|
Thread-Topic: Importing from ODBC Connector thread-index: AcZ2CCeXhm9FROyMTGGFzvlQqvztmw== X-WBNR-Posting-Host: 66.191.71.66 From: =?Utf-8?B?RG9u?= <djw (AT) nospam (DOT) postalias Subject: Importing from ODBC Connector Date: Fri, 12 May 2006 14:08:02 -0700 Lines: 9 Message-ID: <ACB99F8B-A1D9-448C-8D44-5CDBBF8EB8C0 (AT) microsoft (DOT) 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 |
#3
| |||
| |||
|
|
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 (AT) nospam (DOT) postalias Subject: Importing from ODBC Connector Date: Fri, 12 May 2006 14:08:02 -0700 Lines: 9 Message-ID: <ACB99F8B-A1D9-448C-8D44-5CDBBF8EB8C0 (AT) microsoft (DOT) 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 |
#4
| |||
| |||
|
|
Thread-Topic: Importing from ODBC Connector thread-index: AcZ4Plono0quD4I4QW+kto2BetA5Lw== X-WBNR-Posting-Host: 66.191.71.66 From: =?Utf-8?B?RG9u?= <djw (AT) nospam (DOT) postalias References: <ACB99F8B-A1D9-448C-8D44-5CDBBF8EB8C0 (AT) microsoft (DOT) com Y3HnBi8dGHA.188 (AT) TK2MSFTNGXA01 (DOT) 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 (AT) microsoft (DOT) 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 (AT) nospam (DOT) postalias Subject: Importing from ODBC Connector Date: Fri, 12 May 2006 14:08:02 -0700 Lines: 9 Message-ID: <ACB99F8B-A1D9-448C-8D44-5CDBBF8EB8C0 (AT) microsoft (DOT) 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 |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.