ADO connection on Visual Basic .NET

[ronnetp]

I am having problems connecting to SQL Server using
ADO in Visual Basic .NET

I am using this code:

Dim xconexion As ADODB.Connection
Dim xrecordset As ADODB.Recordset
Dim tconexion As String
xrecordset = New ADODB.Recordset()
xconexion = New ADODB.Connection()
tconexion = "uid=test;pwd=test;driver=
SQLServer};server=ENTERPRISE;database=PRODUCTION"
xrecordset.Open("select * from proddta.f0101", tconexion, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)

But it returns this error

An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in Invnetario.exe

Additional information: [Microsoft][Administrador de controladores ODBC] No se encuentra el nombre del origen de datos y no se especificó ningún controlador predeterminado

 

[zemp]

Check out the link below. It has plenty of examples for almost any type of connection.

http://www.able-consulting.com/ADO_Conn.htm

Thanks and Good Luck!

zemp