Connecton string problem with classic ASP running within Net SDK

[John Morgan]

When I run the following connection code in classic ASP on a machine
without the NET SDK installed it works perfectly and has done for some
time.

When I run it on a computer with the Net SDK installed it fails with
the message given below.

The code is:

dim strconnect
strconnect="Provider=sqloledb;DataSource=CMS2\NetS DK;Database=testThursday;uid=sa;pwd=;"

set myConn= Server.CreateObject ("ADODB.Connection")
myConn.open strConnect

The error message is:
Microsoft OLE DB Provider for SQL Server error '80004005'

Invalid connection string attribute

I would be most grateful for advice as I urgently need to solve this
problem. I

I should perhaps say that the datasource and database names are
slightly different in the two computers but I have double checked that
the names are correct and that the form of the sting is the same.

I can make a connection using the Visual Studio tool but I cannot get
what looks like a complicated VS generated string to work in the asp
file.

I am wondering if I need to use a different connection string in the
Net environment ?

Best wishes, John Morgan

[Bob Barrows]

See [url]www.connectionstrings.com[/url] for the correct syntax.

Bob Barrows

John Morgan wrote:

> When I run the following connection code in classic ASP on a machine
> without the NET SDK installed it works perfectly and has done for some
> time.
>
> When I run it on a computer with the Net SDK installed it fails with
> the message given below.
>
> The code is:
>
> dim strconnect
>

strconnect="Provider=sqloledb;DataSource=CMS2\NetS DK;Database=testThursday;u
id=sa;pwd=;"

>
> set myConn= Server.CreateObject ("ADODB.Connection")
> myConn.open strConnect
>
> The error message is:
> Microsoft OLE DB Provider for SQL Server error '80004005'
>
> Invalid connection string attribute
>
> I would be most grateful for advice as I urgently need to solve this
> problem. I
>
> I should perhaps say that the datasource and database names are
> slightly different in the two computers but I have double checked that
> the names are correct and that the form of the sting is the same.
>
> I can make a connection using the Visual Studio tool but I cannot get
> what looks like a complicated VS generated string to work in the asp
> file.
>
> I am wondering if I need to use a different connection string in the
> Net environment ?
>
> Best wishes, John Morgan

[John Morgan]

Thanks Bob,
I appreciate your help - I looked up the page and the first string I
tried worked perfectly,

Best wishes, John Morgan

On Fri, 10 Oct 2003 17:16:36 -0400, "Bob Barrows"
<reb01501@NOyahoo.SPAMcom> wrote:

>See [url]www.connectionstrings.com[/url] for the correct syntax.
>
>Bob Barrows
>
>John Morgan wrote:

>> When I run the following connection code in classic ASP on a machine
>> without the NET SDK installed it works perfectly and has done for some
>> time.
>>
>> When I run it on a computer with the Net SDK installed it fails with
>> the message given below.
>>
>> The code is:
>>
>> dim strconnect
>>

>strconnect="Provider=sqloledb;DataSource=CMS2\Net SDK;Database=testThursday;u
>id=sa;pwd=;"

>>
>> set myConn= Server.CreateObject ("ADODB.Connection")
>> myConn.open strConnect
>>
>> The error message is:
>> Microsoft OLE DB Provider for SQL Server error '80004005'
>>
>> Invalid connection string attribute
>>
>> I would be most grateful for advice as I urgently need to solve this
>> problem. I
>>
>> I should perhaps say that the datasource and database names are
>> slightly different in the two computers but I have double checked that
>> the names are correct and that the form of the sting is the same.
>>
>> I can make a connection using the Visual Studio tool but I cannot get
>> what looks like a complicated VS generated string to work in the asp
>> file.
>>
>> I am wondering if I need to use a different connection string in the
>> Net environment ?
>>
>> Best wishes, John Morgan

>