VBA + MS SQL

From: Piglet (piglet_at_box44.gnet.pl)
Date: 07/28/04 

Date: Wed, 28 Jul 2004 09:04:22 +0200

I insert data into table in SQL Server 2000
I use ADODB.Command object with parameters like this:

Set CommandObj = CreateObject("ADODB.Command")

CommandObj.CommandText = "INSERT INTO TABLE1 VALUES (?,?)"
With CommandObj.Parameters
    .Append CommandObj.CreateParameter("P1", 8, 1)
    .Append CommandObj.CreateParameter("P2", 8, 1)
End With

CommandObj.Prepared=True

With CommandObj
    .Parameters("P1")="QWERTY"
    .Parameters("P2")="ABC"
    .Execute
End With

and after executing that code the table in MS SQL looks like this:

P1 | P2
-------------
Q | A

and where the rest of those strings?
I have no problems with other data types (numeric,date etc)

Thank you for any help 

-- 
Piglet

Relevant Pages

  • Re: Execute Persmission denied on object sp_OACreate
    ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
    (microsoft.public.sqlserver.security)
  • Re: SSIS - OLE DB Command - how to retrieve query results ???
    ... my side according to your process, and I managed to execute the task. ... Data Destination: <My SQL Server 2005 Instance>.TestDB ... OLE DB Command: ...
    (microsoft.public.sqlserver.dts)
  • Re: 3 Simple Security SQL Statements
    ... Kalen Delaney, SQL Server MVP ... window and execute. ... Builds a list of text commands. ... EXEC sp_addrolemember 'WebUsersRole', 'WebUser' ...
    (microsoft.public.sqlserver.security)
  • Re: DTS Error EXCEPTION_ACCESS_VIOLATION
    ... >>We have some DTS jobs that runs every night called via a ... >>Package ... If this is no help, then please describe how you execute the package, ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: Problem with the Legacy ASP files and the Sql Server Express
    ... It looks like it is not going to be an easy job getting it to work on the SQL Server 2005 and Express:(. ... 'Then you can execute the command and then retrieve the ID ... I am 100% sure this code works against any version of SQL Server, as long as the connection is OK and the SP has two parameters @varCompany as Input and @Return_Value as Output. ... I do not think your problem is due to difference of SQL Server2000 and SQL Server2005, unless your stored procedure has some thing that only works in SQL Server2000, not SQL Server 2005. ...
    (microsoft.public.dotnet.framework.aspnet)