problem: Specified cast is not valid. (System.Data)

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "wildthink" <wild@xxxxxxxxx>
Date: Wed, 13 Jul 2005 17:23:18 +0200

i'm a new user of sqlserver2005 and i have a problem connecting with ".Net
framework data provider for odbc" to a oracle rdb database.

i have install all driver for oracle rdb and the connection running when i
do "test connection"
but when i do "import data" from sql server 2005 with the same connecting
string i
recive a message error:

TITLE: SQL Server Import and Export Wizard
----------------------------------------
Cannot get the supported data types from the database connection "[...]".
----------------------------------------
ADDITIONAL INFORMATION:
Specified cast is not valid. (System.Data)
----------------------------------------

can someone help me!?

thanks..

R.

.

Prev by Date: Re: Problem with reading in packet mode
Next by Date: RE: Transaction Log filling up
Previous by thread: ODBC driver for SQL Server - what versions are available?
Next by thread: Re: Problems executing DML via linked server
Index(es):
- Date
- Thread

Relevant Pages

Re: How to connect a workstation to SQL Server 2005 thru ODBC?
... and open the port in the Windows XP ... Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... Either SQL Server Management Studio or Management Studio Express. ...
(microsoft.public.sqlserver.connect)
Re: Cannot connect a remote sql server
... I too have written quite a bit about connecting. ... Hitchhiker's Guide to Visual Studio and SQL Server ... such as the server's firewall, SQL Server's remote connection setting, ... Microsoft MSDN Online Support Lead ...
(microsoft.public.dotnet.framework.adonet)
Use Single Sign on to connect to sql server
... connection in an excel file that connects using an odc file connecting using ... The logon account information that you configure here must match the logon ... Name: SQL Server ... If I'm connecting using a sql username, do i need to use the domain piece ...
(microsoft.public.sharepoint.portalserver.development)
Re: Problem connectin SQL Server 2005
... Have you configured the SQL Server 2005 to allow remote connections? ... Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... Configuring a Fixed Port ...
(microsoft.public.sqlserver.connect)
Re: Problem connectin SQL Server 2005
... > Have you configured the SQL Server 2005 to allow remote connections? ... > Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... > Configuring a Fixed Port ...
(microsoft.public.sqlserver.connect)