Does ASP2ASPX support JScript and JavaScript code in server side ?

No, ASP2ASPX can not convert JScript and JavaScript code to ASP.NET.

Top

How to convert Third-Party ActiveX/COM to .NET ?

Please use Tlbimp.exe to convert Third-Party ActiveX/COM to .NET assembly(RCW), and put the .NET assembly in </asp2aspx>/com/ .

Top

How to resolve 'Not Found nce Namespace' error ?

In this case, please copy <asp2aspx>/bin/nce.scripting.dll, nce.mswc.dll and nce.adodb.dll to the bin directory of your ASP.NET project.

Top

How to do if ASP2ASPX expired ?

ASP2ASPX trial version is limited to thirty (30) days from the date ASP2ASPX is installed. Please contact sales@netcoole.com to purchase the final version.

Top

How to reference Microsoft.VisualBasic.dll ?

By default, the ASP.NET engine will reference a few default assemblies and all the assemblies in the bin directory of your application. So you may copy Microsoft.VisualBasic.dll to the bin directory of your ASP.NET project.
Or better yet, registering this in your web.config file. If you register this on the web.config file, all the files in the current directory will be compiled with those settings, e.g:

<?xml version="1.0" encoding="utf-8"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
 <system.web>
  <compilation defaultLanguage="c#">>
   <assemblies>
    <add assembly="Microsoft.VisualBasic, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"  />
   </assemblies>
  </compilation>
 </system.web>
</configuration>

Top

How to connect Ms Access with nceADO.NET ?

Before you run ASP2ASPX, you need to change the original connection string as following:

Provider=Microsoft.Jet.OLEDB.4.0; Data Source=Path to mdb file;

for example:

conn.Open "DSN=BIBLIO;"
or
DBPath="d:\test\biblio.mdb"
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath

Change above connection string as following:

conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=d:\test\biblio.mdb"

Then run asp2aspx command with '-adoole' option.

Top

How to connect SQL Server with nceADO.NET ?

Before you run ASP2ASPX, you need to change the original connection string as following:

Data Source=<Your_SQLServer>;Initial Catalog=<Database name>;User Id=sa;Password=;

<Your_SQLServer> is the name or network address of the instance of SQL Server to which to connect.
<Database name> is the name of the database.

for example:
conn.Open "Data Source=localhost;Initial Catalog=pubs;User Id=sa;Password=;"

Then run asp2aspx command with '-adosql' option.

Top

How to connect Oracle with nceADO.NET ?

Before you run ASP2ASPX, you need to change the original connection string as following:

Data Source=<Oracle Data Source>;User Id=;Password=;

<Oracle Data Source>: Oracle Net Services Name, Connect Descriptor, or an easy connect naming that identifies the database to which to connect.
for example:
conn.Open "Data Source=oracle9i;User Id=scott;Password=tiger;"

Top

How to resolve the SQLServer login error ?

Please do step by step:
1. open a command prompt
2. cd "C:\Program Files\Microsoft SQL Server\80\Tools\Binn"
3. run following commands:

osql -E -S localhost -Q "sp_grantlogin 'YOURCOMPUTER\ASPNET'"
osql -E -S localhost -d Pubs -Q "sp_grantdbaccess 'YOURCOMPUTER\ASPNET'"
osql -E -S localhost -d Pubs -Q "sp_addrolemember 'db_owner', 'YOURCOMPUTER\ASPNET'
osql -E -S localhost -Q "sp_grantlogin 'YOURCOMPUTER\ASPNET'"
osql -E -S localhost -d Pubs -Q "sp_grantdbaccess 'YOURCOMPUTER\ASPNET'"
osql -E -S localhost -d Pubs -Q "sp_addrolemember 'db_owner', 'YOURCOMPUTER\ASPNET'

then you can login the database 'Pubs'.

Top

Why can't change the recordset value ?

Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.

You must have a primary key defined in your database tables.

Top

Why can't execute UPDATE USERS SET PASSWORD = 'PWD' command for MS Access ?

'Password' is an Access reserved word, please replace 'Password' with '[Password]' in your SQL Command:
UPDATE USERS SET [Password] = 'pwd' WHERE UserName = 'test'

Top

Does nceADO.NET support AutoNumber Value ?

No, nceADO.NET is the same as ADO.NET. It can not retrieve the AutoNumber value as soon as you add a new record.

Top