ADO, VB6, String data, right truncation

Hi,

I get the following error message when i try to open a ADODB Connection from
a Visual Basic 6 application.

Error: "String data, right truncation"

Actually, this application works with no problem at all of the customers
except one of them.

The code is something like that:

Dim cn As New adodb.Connection
Dim rs As New adodb.Recordset
Dim cServer As String
Dim cProvider As String
Dim cDatabase As String
Dim cCn As String
Dim cPass As String
Dim mp As New clsModProcs
Dim cc As New clsCrypto
Dim gCpassword As String

cServer = cServerName 'S.C.
If cServerName = "" Then
cServer = Me.Get_ServerName()
End If

cDatabase = "MASTER"
cProvider = "SQLOLEDB.1"
gCpassword = "my password"

cCn = "Data Source=" & cServer & ";Provider=" & cProvider
cCn = cCn & ";DATABASE=" & cDatabase & ";Trusted_Connection=NO"

cn.Open cCn, "user name", gCpassword

.....

The username and password are no longer than 20 characters.

I searched for this error in google, but could not find the reason and a
solution to this problem. Can anyone help me please?

thanks in advance,
Senc.


.

Relevant Pages

  • Search pattern
    ... Dim strfile As String ... Dim bAddressFound As Boolean ... Dim strCurrentChar As String ...
    (comp.databases.ms-access)
  • Re: multiplatform (pocketPC & desktopPC) (Daniel !!)
    ... Friend Versione As String ... Public Sub GetMyConnectionPalmare() ... Dim errorMessages As String ... Private Function GetDS_Desktop(ByVal SQL As String) As DataSet ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: multiplatform (pocketPC & desktopPC) (Daniel !!)
    ... Friend Versione As String ... Public Sub GetMyConnectionPalmare() ... Dim errorMessages As String ... Private Function GetDS_Desktop(ByVal SQL As String) As DataSet ...
    (microsoft.public.dotnet.framework.compactframework)
  • Help answer these 70-310 questions
    ... One argument is the string ... Dim output As New StringBuilder ... EmployeeLocations. ... You create a strongly named serviced component. ...
    (microsoft.public.cert.exam.mcad)
  • Help answer these 70-310 questions
    ... One argument is the string ... Dim output As New StringBuilder ... EmployeeLocations. ... You create a strongly named serviced component. ...
    (microsoft.public.cert.exam.mcsd)