Senthil.P

Hi All,

When i tried to connect Oracle database(8i) .I am getting an error "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".

My Connection string is :

"Provider=msdaora;DSN=U500.WORLD;Uid=xyz;Pwd=123;"

Please help me out to clear this task.

Thanks in Advance



Re: Visual C# General ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Ashish Basran

Have a look at following

http://www.connectionstrings.com/

Should help you.

As you are trying to connect to Oracle Database, you might need to have Oracle Client installed.






Re: Visual C# General ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

RizwanSharp

Make sure you have required driver installed and provide that driver and server name in connection string too like:

DRIVER={XXXX Driver V XXXX};Provider=msdaora;DSN=U500.WORLD;Uid=xyz;Pwd=123;SERVER=localhost;"

Best Regards,

Rizwan aka RizwanSharp






Re: Visual C# General ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Senthil.P

Thanks.I have a oracle 8i clent installed .I have a Oracle server in another system and i created a DSN for that i an using DSN to connect that. I don't know waht is the driver for Oracle 8i. Can you please help me out ..

Thanks





Re: Visual C# General ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Ashish Basran

 

try this

Driver={Microsoft ODBC for Oracle}






Re: Visual C# General ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

RizwanSharp

Try frist from this page:

http://www.connectionstrings.com/ carrier=oracle

Best Regards,

Rizwan aka RizwanSharp






Re: Visual C# General ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Senthil.P

thanks . I tried the connection strings web site .That doesnt help me alot.





Re: Visual C# General ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

RizwanSharp

Same Error again




Re: Visual C# General ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Senthil.P

Thanks.I tried using driver,.I got the following error "{"ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed\r\nERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).\r\nERROR [01S00] [Microsoft][ODBC driver for Oracle]Invalid connection string attribute" }"

Help me out





Re: Visual C# General ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Ashish Basran

System.Data.OracleClient namespace is the .NET Framework Data Provider for Oracle. I hope you are using that.






Re: Visual C# General ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Senthil.P

Hi ... I am using vs 2003 till !!!!!!!!!!!



Re: Visual C# General ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Senthil.P

No .. Different Error ...

Thanks.I tried using driver,.I got the following error "{"ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed\r\nERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).\r\nERROR [01S00] [Microsoft][ODBC driver for Oracle]Invalid connection string attribute" }"

Help me out





Re: Visual C# General ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Ashish Basran

 

I think it should be there in .NET 1.1 (2003)

 

http://msdn2.microsoft.com/en-us/library/system.data.oracleclient(VS.71).aspx

 






Re: Visual C# General ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

RizwanSharp

This may help you too like that guy,

use System.Data.OracleClient namespace. For this you need to add reference to System.Data.OracleClien.

Best of Luck.

Best Regards,

Rizwan aka RizwanSharp