[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

Informix

Mirek

8/12/2002 10:48:00 AM

I can't connect to DSN (Informix ODBC Data Driver 3.34)
from Microsoft ASP.Net Web Matrix.
How shall I set connectionstring in SqlDataSourceControl?

Thanks very much.
4 Answers

(Hussein Abuthuraya(MSFT))

8/13/2002 3:03:00 AM

0

Mirel,

Once you created a DSN to your Informix server, you may check if it is a valid connection from the ODBC Administrator by click ing on the second tab (not sure it's name) that
you specify all the different parameters for the host name and the database with the user name and password. On the same tab, it should have a test button that verifies if the
connection is successful or not.

If that button verifies OK then in your code you should be able to use a DSN connection string:

txtConn.Text = "DSN=testInfo;uid=xxx;pwd=xxx;"

If you prefer to use a DSN-Less conenction then :

txtConn.Text = "Provider=MSDASQL; DRIVER={INFORMIX}; DB=test;HOST=xyz;SRVR=server;SERV=sqlexec;PRO=onsoctcp;UID=xxx;PWD=yyyy;"

I hope this helps!


Thanks,
Hussein Abuthuraya
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.co....

Mirek

8/14/2002 1:58:00 PM

0


Sorry,
it's not OK.

1. txtConn.Text = "DSN=testInfo;uid=xxx;pwd=xxx;"
ERROR: Unknown connection option in connection string: dsn.

2. txtConn.Text = "Provider=MSDASQL; DRIVER={INFORMIX};
DB=test;HOST=xyz;SRVR=server;SERV=sqlexec;PRO=onsoctcp;UID=
xxx;PWD=yyyy;"

ERROR: Unknown connection option in connection string:
provider

Thanks.

Bob Beauchemin

8/14/2002 4:05:00 PM

0

If you are using an ODBC data source, you must download and use the Odbc
data provider for .NET. The OleDb data provider does not support the MSDASQL
provider (2) which is also the default if you leave the provider out (1).

Bob Beauchemin
http://staff.develo...


"Mirek" <m.senkerik@seznam.cz> wrote in message
news:332f01c24392$57652d90$9ae62ecf@tkmsftngxa02...
>
> Sorry,
> it's not OK.
>
> 1. txtConn.Text = "DSN=testInfo;uid=xxx;pwd=xxx;"
> ERROR: Unknown connection option in connection string: dsn.
>
> 2. txtConn.Text = "Provider=MSDASQL; DRIVER={INFORMIX};
> DB=test;HOST=xyz;SRVR=server;SERV=sqlexec;PRO=onsoctcp;UID=
> xxx;PWD=yyyy;"
>
> ERROR: Unknown connection option in connection string:
> provider
>
> Thanks.

(Hussein Abuthuraya(MSFT))

8/16/2002 1:22:00 AM

0

Isn't that what Mirek was using?


Thanks,
Hussein Abuthuraya
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.co....