Connection string does not work

[Robert Dufour]

This is the error I get
Message "No error information available: DB_E_ERRORSOCCURRED(0x80040E21)."
String

This is the basic code with whicj I am testing it.

Dim MyConn As New System.Data.OleDb.OleDbConnection

MyConn.ConnectionString = "Provider=sqloledb.1;data source=MAX;initial
catalog=RmtTel; Integrated security=True"

MyConn.Open() This statement gives me the above error, however from reading
the docs it should be OK.

Can anyone tell me what's happening and how to fix this problem?

Any help appreciated,

Bob

[=?Utf-8?B?S2VycnkgTW9vcm1hbg==?=]

Bob,

You might try:

Provider=sqloledb

instead of:

Provider=sqloledb.1

Kerry Moorman
"Robert Dufour" wrote:

This is the error I get
Message "No error information available: DB_E_ERRORSOCCURRED(0x80040E21)."
String

This is the basic code with whicj I am testing it.

Dim MyConn As New System.Data.OleDb.OleDbConnection

MyConn.ConnectionString = "Provider=sqloledb.1;data source=MAX;initial
catalog=RmtTel; Integrated security=True"

MyConn.Open() This statement gives me the above error, however from reading
the docs it should be OK.

Can anyone tell me what's happening and how to fix this problem?

Any help appreciated,

Bob

[Cor Ligthert [MVP]]

Robert,

I think that it would be much easier to help you if you told us what kind of
databaseserver you are using.

Cor

"Robert Dufour" <bd*****@sgiims.comschreef in bericht
news:OC**************@TK2MSFTNGP03.phx.gbl...

This is the error I get
Message "No error information available: DB_E_ERRORSOCCURRED(0x80040E21)."
String

This is the basic code with whicj I am testing it.

Dim MyConn As New System.Data.OleDb.OleDbConnection

MyConn.ConnectionString = "Provider=sqloledb.1;data source=MAX;initial
catalog=RmtTel; Integrated security=True"

MyConn.Open() This statement gives me the above error, however from
reading the docs it should be OK.

Can anyone tell me what's happening and how to fix this problem?

Any help appreciated,

Bob

[Robert Dufour]

Using sql server 2000 and sql server 2005 (must run on both). I had tried
that before, same result.
BOB
"Kerry Moorman" <Ke**********@discussions.microsoft.comwrote in message
news:13**********************************@microsof t.com...

Bob,

You might try:

Provider=sqloledb

instead of:

Provider=sqloledb.1

Kerry Moorman
"Robert Dufour" wrote:

>This is the error I get
Message "No error information available:
DB_E_ERRORSOCCURRED(0x80040E21)."
String

This is the basic code with whicj I am testing it.

Dim MyConn As New System.Data.OleDb.OleDbConnection

MyConn.ConnectionString = "Provider=sqloledb.1;data source=MAX;initial
catalog=RmtTel; Integrated security=True"

MyConn.Open() This statement gives me the above error, however from
reading
the docs it should be OK.

Can anyone tell me what's happening and how to fix this problem?

Any help appreciated,

Bob

[Robert Dufour]

Using sql server 2000 and sql server 2005 (must run on both)bOB
"Cor Ligthert [MVP]" <no************@planet.nlwrote in message
news:uI**************@TK2MSFTNGP06.phx.gbl...

Robert,

I think that it would be much easier to help you if you told us what kind
of
databaseserver you are using.

Cor

"Robert Dufour" <bd*****@sgiims.comschreef in bericht
news:OC**************@TK2MSFTNGP03.phx.gbl...

>This is the error I get
Message "No error information available:
DB_E_ERRORSOCCURRED(0x80040E21)." String

This is the basic code with whicj I am testing it.

Dim MyConn As New System.Data.OleDb.OleDbConnection

MyConn.ConnectionString = "Provider=sqloledb.1;data source=MAX;initial
catalog=RmtTel; Integrated security=True"

MyConn.Open() This statement gives me the above error, however from
reading the docs it should be OK.

Can anyone tell me what's happening and how to fix this problem?

Any help appreciated,

Bob

[Norman Chong]

Hi Robert,

Like Kerry wrote: Replace Provider=sqloledb.1 with Provider=sqloledb

Have you already visited www.connectionstrings.com?

[vbnetdev]

Do not use OleDb. Use SqlClient for SQL databases.

off top of my head...

dim conn as New System.Data.SqlClient.SqlConnection
conn.ConnectionString = "Data Source=MAX;Initial Catalog=RmTel;Integrated
Security=True"
conn.Open()

"Robert Dufour" <bd*****@sgiims.comwrote in message
news:OC**************@TK2MSFTNGP03.phx.gbl...

This is the error I get
Message "No error information available: DB_E_ERRORSOCCURRED(0x80040E21)."
String

This is the basic code with whicj I am testing it.

Dim MyConn As New System.Data.OleDb.OleDbConnection

MyConn.ConnectionString = "Provider=sqloledb.1;data source=MAX;initial
catalog=RmtTel; Integrated security=True"

MyConn.Open() This statement gives me the above error, however from
reading the docs it should be OK.

Can anyone tell me what's happening and how to fix this problem?

Any help appreciated,

Bob