2. ASPRunnerPro General questions
  3. Access App to MSSQL
This topic is locked

Access App to MSSQL

 		4/22/2008 2:01:59 PM
ASPRunnerPro General questions
Y
 yairilan author

Hi,

I've created an aplication using Access's tables and queries and now I wnat to use it with MSSQL tables and views. Is there a way to use the Asprunner wizard with the same old aspr file in order to keep al the parameters such as: Fields name, master tables, authorizations etc?
And in other words, How can I "connect" the old aspr file to the MSSQL tables without losing everything I did with the Access tables?
Tx very much,

Yair. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=8246&image=1&table=forumtopics' class='bbc_emoticon' alt=':unsure:' />
Sergey Kornilov admin 4/22/2008

You can try trasnfer tables and data to SQL server keeping tables and field names.
Then open ASPRunnerPro project file in text editor and modify connection string pointing it to SQL Server database. Cross your fingers and open project in ASPRunnerPro.
Y
 		yairilan author 4/22/2008

You can try trasnfer tables and data to SQL server keeping tables and field names.

Then open ASPRunnerPro project file in text editor and modify connection string pointing it to SQL Server database. Cross your fingers and open project in ASPRunnerPro.


Tx - I'll try it.

Did you mean: "m_strConnectionString"?

Is it the only one?

What about "m_strDatabaseFileName"?
J
 		Jane 4/23/2008

Hi,
I recommend you to create new test project with SQL server, save it, then open in the any text editor and copy connection info to your old project.