NeXTensio Forum :: Recordset returns blank column

I'm using the insert/update transaction to update a very long text description.

The problem is that the recordset created by the transaction will not display a particular table column im using even though there is valid data within the column.

The table column is in MS SQL and is set as "Text" rather than "Varchar" as the column usually requires more than 8000 characters. However, the transaction only seems to display column if it is set as Varchar. Is there a way around this via either the transaction or changing the datatype of the database column?

Im using ASP VB on a MS SQL database.

Many Thanks
Rob.

Hello,

There is a bug in the MSSQL driver regarding TEXT fields. Try editing your connection file and replace the connection string with this one:

"Provider=sqloledb;Data Source=serverName;Initial Catalog=DBName;User Id=userName;Password=password"

where you should replace serverName, DBName, userName and password with their actual values. After this, the text areas should be correctly prefilled.

Regards,
Razvan RACASANU 

Hi,

Thanks for this. How do I know what my servername is?

I am currently using the following string, but have obvisouly changed the passwords :-)

MM_pushproperty01_STRING = "dsn=romans_pushproperty01;uid=sa;pwd=PASSWORD;"

So I modified the string to this, but it does not work:

MM_pushproperty01_STRING = "Provider=sqloledb;Data Source=romans_pushproperty01;Initial Catalog=pushproperty01;User Id=sa;Password=PASSWORD;" 

Can you help?

Thanks,

Chris.

The string your using looks correct to me, just make sure your using the correct server name, username and password.

I use a MS SQL Server hosted by a company called Hostway, where the server name looks like the following.

Data Source=wdb1001.lon.gb.securedata.net;

HTH
Rob

thanks for the reply.

I wonder if the data source is the server IP address maybe? I assumed it was the DSN name, but yours doesn't look like that.

What do you think?

Thanks.

I would of thought that the servers IP would also work.

However if you are using a commerical host for the database, just send them an email requesting all the information you require.

Rob