Error 80004005 with MSDE and VB 6

Hello
I am new to SQL Server / MSDE ... Strong with MS Access
I have MSDE loaded on 2 computers, a local computer (Windows XP Home) and on a Windows 2003 Server (WEB Edition). I have simplified the problem by trying to access the database only on the local computer (DEVELOPMENT).
I tried to open a Test Database on the Development computer using the following code snipplet:
Private ObjConn As New adodb.Connection
Private ObjRS As New adodb.Recordset
Private Sub Command1_Click()
On Error GoTo 0
With ObjConn
.ConnectionTimeout = 30
.CommandTimeout = 30
.Provider = "SQLOLEDB"
.ConnectionString = "DRIVER={SQL Server}; Server=Development; Database=Test; UID=sa; PWD="
End With
ObjConn.Open
end sub
I keep getting an error 80004005 -- Invalid character string attribute
I have checked all of the books that I have and looked all over the Internet, but can not figure out what I'm doing wrong ... can anyone offer any help
Thanks in advance
George
From http://www.developmentnow.com/g/100_...er-connect.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
Remove the "DRIVER={SQL Server};" portion of the connection string.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"George Slamowitz" <GSlamowitz@.COX.NET> wrote in message
news:6d371311-0877-499b-aeb3-c838647b3e2d@.developmentnow.com...
> Hello
> I am new to SQL Server / MSDE ... Strong with MS Access
> I have MSDE loaded on 2 computers, a local computer (Windows XP Home) and
> on a Windows 2003 Server (WEB Edition). I have simplified the problem by
> trying to access the database only on the local computer (DEVELOPMENT).
> I tried to open a Test Database on the Development computer using the
> following code snipplet:
>
> Private ObjConn As New adodb.Connection
> Private ObjRS As New adodb.Recordset
>
> Private Sub Command1_Click()
> On Error GoTo 0
> With ObjConn
> .ConnectionTimeout = 30
> .CommandTimeout = 30
> .Provider = "SQLOLEDB"
> .ConnectionString = "DRIVER={SQL Server}; Server=Development;
> Database=Test; UID=sa; PWD="
> End With
> ObjConn.Open
> end sub
> I keep getting an error 80004005 -- Invalid character string attribute
> I have checked all of the books that I have and looked all over the
> Internet, but can not figure out what I'm doing wrong ... can anyone
> offer any help
> Thanks in advance
> George
> From http://www.developmentnow.com/g/100_...er-connect.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
sql

Error 80004005 with MSDE and VB 6

Hello
I am new to SQL Server / MSDE ... Strong with MS Access
I have MSDE loaded on 2 computers, a local computer (Windows XP Home) and on
a Windows 2003 Server (WEB Edition). I have simplified the problem by tryi
ng to access the database only on the local computer (DEVELOPMENT).
I tried to open a Test Database on the Development computer using the follow
ing code snipplet:
Private ObjConn As New adodb.Connection
Private ObjRS As New adodb.Recordset
Private Sub Command1_Click()
On Error GoTo 0
With ObjConn
.ConnectionTimeout = 30
.CommandTimeout = 30
.Provider = "SQLOLEDB"
.ConnectionString = "DRIVER={SQL Server}; Server=Development; Database=
Test; UID=sa; PWD="
End With
ObjConn.Open
end sub
I keep getting an error 80004005 -- Invalid character string attribute
I have checked all of the books that I have and looked all over the Internet
, but can not figure out what I'm doing wrong ... can anyone offer any help
Thanks in advance
George
From http://www.developmentnow.com/g/100...ver-connect.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.comRemove the "DRIVER={SQL Server};" portion of the connection string.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"George Slamowitz" <GSlamowitz@.COX.NET> wrote in message
news:6d371311-0877-499b-aeb3-c838647b3e2d@.developmentnow.com...
> Hello
> I am new to SQL Server / MSDE ... Strong with MS Access
> I have MSDE loaded on 2 computers, a local computer (Windows XP Home) and
> on a Windows 2003 Server (WEB Edition). I have simplified the problem by
> trying to access the database only on the local computer (DEVELOPMENT).
> I tried to open a Test Database on the Development computer using the
> following code snipplet:
>
> Private ObjConn As New adodb.Connection
> Private ObjRS As New adodb.Recordset
>
> Private Sub Command1_Click()
> On Error GoTo 0
> With ObjConn
> .ConnectionTimeout = 30
> .CommandTimeout = 30
> .Provider = "SQLOLEDB"
> .ConnectionString = "DRIVER={SQL Server}; Server=Development;
> Database=Test; UID=sa; PWD="
> End With
> ObjConn.Open
> end sub
> I keep getting an error 80004005 -- Invalid character string attribute
> I have checked all of the books that I have and looked all over the
> Internet, but can not figure out what I'm doing wrong ... can anyone
> offer any help
> Thanks in advance
> George
> From http://www.developmentnow.com/g/100...ver-connect.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com

Error 5123 Operating System Error 32 on attaching a database

I have SQL Server loaded on my standalone laptop. I tried
to attach a database( xxx.MDF) and got an error as above.
How do I resolve this ?In your sp_attach_db statement, make sure the path to the
mdf, ldf files is correct.
Also, make sure the SQL Server service account has
permissions to the path, files that you are attaching.
-Sue
On Wed, 25 Feb 2004 10:19:26 -0800, "Kishore Kapadia"
<kishore_kapadia@.peoplesoft.com> wrote:

>I have SQL Server loaded on my standalone laptop. I tried
>to attach a database( xxx.MDF) and got an error as above.
>How do I resolve this ?