Showing posts with label home. Show all posts
Showing posts with label home. Show all posts

Wednesday, March 21, 2012

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

Friday, February 24, 2012

Error 26 - SQL Connection Error

I was working on my office computer where I had Visual Web Developer Express Edition installed. I moved to my home office and installed Visual Web Developer and tried to run my application on my new computer and I get the following error message:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Please let me know if you need further information, any help would be appreciated.

Thanks.

Never mind, I just realized I had issues with my SQL Server....I reinstalled it and it all works fine now.

Thanks.

Wednesday, February 15, 2012

error 1937 installing sql express

Please help me!

Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows XP Home Edition Service Pack 2 (Build 2600)
Time : Sat Jul 15 12:51:21 2006
Machine : JIMMY
Product : File di supporto dell'installazione di Microsoft SQL Server (Italiano)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\programmi\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_JIMMY_SQLSupport_1.log
--
Machine : JIMMY
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\programmi\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_JIMMY_SQLNCLI_1.log
--
Machine : JIMMY
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\programmi\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_JIMMY_SqlWriter_1.log
--
Machine : JIMMY
Product : Parser MSXML 6.0
Product Version : 6.00.3883.15
Install : Successful
Log File : C:\programmi\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_JIMMY_MSXML6_1.log
--
Machine : JIMMY
Product : File di supporto dell'installazione di Microsoft SQL Server (Italiano)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\programmi\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_JIMMY_SQLSupport_2.log
--
Machine : JIMMY
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\programmi\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_JIMMY_SQLNCLI_2.log
--
Machine : JIMMY
Product : Parser MSXML 6.0
Product Version : 6.00.3883.15
Install : Successful
Log File : C:\programmi\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_JIMMY_MSXML6_2.log
--
Machine : JIMMY
Product : Servizi di database SQL Server
Error : Errore durante l'installazione dell'assembly 'Microsoft.SqlServer.SmoEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"'. Firma o catalogo non verificabili o non validi. HRESULT: 0x80131045.
--
Machine : JIMMY
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install : Failed
Log File : C:\programmi\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_JIMMY_SQL.log
Last Action : InstallFinalize
Error String : Errore durante l'installazione dell'assembly 'Microsoft.SqlServer.SmoEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"'. Firma o catalogo non verificabili o non validi. HRESULT: 0x80131045. interfaccia assembly: IAssemblyCacheItem, funzione: Commit, componente: {FD5D8A34-6302-4B57-A51D-65A834A1EF6F}
Error Number : 1937
--

Hi Agostino,

Please check the file at C:\programmi\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_JIMMY_SQL.log to see if it offers additional information.

I'm moving this to the setup form so they can troubleshoot for you.

Mike

|||

hi Mike,

the log above (from the file you suggested me in the previous message) tells something about the error but i can't understand. Can you help me?

Bye,

Ago

MSI (s) (44:30) [12:56:11:359]: Executing op: End(Checksum=0,ProgressTotalHDWord=0,ProgressTotalLDWord=366409477)
MSI (s) (44:30) [12:56:11:453]: Assembly Error:Strong name signature verification failed for assembly '%1'. The assembly may have been tampered with, or it was delay signed but not fully signed with the correct private key.
MSI (s) (44:30) [12:56:11:468]: Note: 1: 1937 2: {FD5D8A34-6302-4B57-A51D-65A834A1EF6F} 3: 0x80131045 4: IAssemblyCacheItem 5: Commit 6: Microsoft.SqlServer.SmoEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"
MSI (s) (44:30) [12:56:32:203]: Prodotto: Microsoft SQL Server 2005 Express Edition -- Errore 1937. Errore durante l'installazione dell'assembly 'Microsoft.SqlServer.SmoEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"'. Firma o catalogo non verificabili o non validi. HRESULT: 0x80131045. interfaccia assembly: IAssemblyCacheItem, funzione: Commit, componente: {FD5D8A34-6302-4B57-A51D-65A834A1EF6F}

Errore 1937. Errore durante l'installazione dell'assembly 'Microsoft.SqlServer.SmoEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"'. Firma o catalogo non verificabili o non validi. HRESULT: 0x80131045. interfaccia assembly: IAssemblyCacheItem, funzione: Commit, componente: {FD5D8A34-6302-4B57-A51D-65A834A1EF6F}
MSI (s) (44:30) [12:56:32:281]: User policy value 'DisableRollback' is 0
MSI (s) (44:30) [12:56:32:281]: Machine policy value 'DisableRollback' is 0
Fine operazione 12.56.32: InstallFinalize. Valore restituito 3.

|||Typically, the "Strong name signature verification" error has something to do with a corrupt package (possibly during download, transfer across network, etc). Can you try to download the package one more time and try again? Also, for future debugging help, are you trying to install the Italian SQL Express on an English OS or an Italian OS?

Thanks,
Samuel Lester (MSFT)