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 3205 Restore SQLServer 2005 Express to MSDE

I am trying to restore a database backed up using SQL Server 2005 Express Edition to a server using MSDE. I get an error 3205 "Too many backup devices specified...64 max..."

I'm only specifying one file for the restore.

Ideas?

Once a database has been attached to a 2005 version it can not be restored to a 2000 version.

MSDE is 2000 and Express is 2005.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

Color me sad...

I control my server completely. If I install 2005 (either express or full version) on my server, will it migrate my existing msde database(s) automatically? Is there a way to do that? I have no problem upgrading as long as I can pull my existing db's up with me.

Can you help me?

Again, thanks for your answer. It's the only definitive answer I've received.

Jim

|||

More information about upgrading MSDE to SQL Server Express can be found here: http://www.microsoft.com/sql/editions/express/upgrade.mspx.

Migrating your MSDE to the full version is also a viable option.

From 2000 to 2005 is not a problem only the other way around.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

Error 3205 Restore SQLServer 2005 Express to MSDE

I am trying to restore a database backed up using SQL Server 2005 Express Edition to a server using MSDE. I get an error 3205 "Too many backup devices specified...64 max..."

I'm only specifying one file for the restore.

Ideas?

Once a database has been attached to a 2005 version it can not be restored to a 2000 version.

MSDE is 2000 and Express is 2005.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

Color me sad...

I control my server completely. If I install 2005 (either express or full version) on my server, will it migrate my existing msde database(s) automatically? Is there a way to do that? I have no problem upgrading as long as I can pull my existing db's up with me.

Can you help me?

Again, thanks for your answer. It's the only definitive answer I've received.

Jim

|||

More information about upgrading MSDE to SQL Server Express can be found here: http://www.microsoft.com/sql/editions/express/upgrade.mspx.

Migrating your MSDE to the full version is also a viable option.

From 2000 to 2005 is not a problem only the other way around.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

error 21268

I have msde version 8.00.760 and when I try a sqlmaint it tells me
[Microsoft SQL-DMO] Error 21268: [SQL-DMO]Row or column specified is outside
the
range of the specified query result set.
this refers to sql 200 sp2 .. when I try upgrade to service pack 3 it tells
I do not have sql 2000 on my system
Please help
Frank
hi Frank,
frank wrote:
> I have msde version 8.00.760 and when I try a sqlmaint it tells me
8.00.760 is service pack 3

> [Microsoft SQL-DMO] Error 21268: [SQL-DMO]Row or column specified is
> outside the
> range of the specified query result set.
> this refers to sql 200 sp2 .. when I try upgrade to service pack 3 it
> tells I do not have sql 2000 on my system
>
how are you trying to upgrade to sp3 (BTW, you already have it installed...
you eventually should go for sp4)?
pleas post the command prompt line you execute including all parameters as
long as your original instance name..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply

Error 21007 Cannot add remote distributor

Hello,
I've been trying to set up an msde database for replication. I've fixed
some problems but I can't get past thisone. I've read every topic about
this error but nothing worked.
I've set up msde with 'setup SAPWD="***"', I didn't set the instance
name or any other parameters.
Thanks.
Thijs
http://www.imm.be/
I've solved the problem.
I registered the server as 192.168... and not as 'servername' in the
enterprise manager.