This topic is locked

Error when Opening Project in version 4.1

12/11/2006 1:54:14 PM
ASPRunnerPro General questions
S
semleon author

Since switching to ASPRunnerPro 4.1 (Build 164) I seem to be having problems re-opening projects I have saved.
I've built a project using a SQL ODBC with the following details

Data Source Name: RCDB on eESM

Data Source Description: RCDB on eESM

Database: eESMmaster
I successfuly built the site, and saved it. Now, when I try to re-open the project I get this error:
SQL Error State:42000, Native Error Code: FDC, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'eESMmasterDSN=RCDB on eESM'. Login fails.
I click OK, then get this very long error that shows:

Error connecting to database:

DSN=RCDB on eESM;UID-rcdbuser;PWD=rcdbuser123DNS=RCDB on eESM;Description-RCDB on eESM;UID-rcdbuser;PWD=rcdbuser123;APP=AspRunner Professional Application;WSID=RCONBK52937;DATABASE=eESMmasterDSN=RCDB on eESM;Description=RCDB on eESM;UID=rcdbuser;PWD=rcdbuser123;APP=AspRunner Professional Application;WSID=RCONBK52937;DATABASE=eESMmaster
Not a SQL guru, but noticed that the Database= string and the DSN= string are not seperated by a ";" (i.e. DATABASE=eESMmasterDSN=RCDB on eESM)...Does that matter?
I have not changed my ODBC connection in anyway, and verifyed/tested that it connects as is. Basicly, nothing has changed between the time I saved the project and the time I re-opened it.
Unfortunatly, If I point it back to the same ODBC connection, I loose all of the work I have done. I tried to rebuild it and save it again, but the same thing happens. It is also happening on another site I build using a different ODBC connection/database.

C
chris 12/11/2006

Since switching to ASPRunnerPro 4.1 (Build 164) I seem to be having problems re-opening projects I have saved.

I've built a project using a SQL ODBC with the following details

Data Source Name: RCDB on eESM

Data Source Description: RCDB on eESM

Database: eESMmaster
I successfuly built the site, and saved it. Now, when I try to re-open the project I get this error:
SQL Error State:42000, Native Error Code: FDC, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'eESMmasterDSN=RCDB on eESM'. Login fails.
I click OK, then get this very long error that shows:

Error connecting to database:

DSN=RCDB on eESM;UID-rcdbuser;PWD=rcdbuser123DNS=RCDB on eESM;Description-RCDB on eESM;UID-rcdbuser;PWD=rcdbuser123;APP=AspRunner Professional Application;WSID=RCONBK52937;DATABASE=eESMmasterDSN=RCDB on eESM;Description=RCDB on eESM;UID=rcdbuser;PWD=rcdbuser123;APP=AspRunner Professional Application;WSID=RCONBK52937;DATABASE=eESMmaster
Not a SQL guru, but noticed that the Database= string and the DSN= string are not seperated by a ";" (i.e. DATABASE=eESMmasterDSN=RCDB on eESM)...Does that matter?
I have not changed my ODBC connection in anyway, and verifyed/tested that it connects as is. Basicly, nothing has changed between the time I saved the project and the time I re-opened it.
Unfortunatly, If I point it back to the same ODBC connection, I loose all of the work I have done. I tried to rebuild it and save it again, but the same thing happens. It is also happening on another site I build using a different ODBC connection/database.


Try downloading the latest build 181 and see if you get the same problem. Use the link that is found in the sticky forum message at the top, that will give you latest build almost always.
Hope that helps.

Chris.

S
semleon author 12/12/2006

I've installed the latest build, but I am still unable to open any of my projects. I'm getting the same error message.

S
semleon author 12/20/2006

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=14017&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' /> Still having the same problem. Cant figure out why. Having to re-create my projects everytime I want to make a change. VERY time consuming and needless. Please help........

Sergey Kornilov admin 12/20/2006

Connectiong string seems to be corrupted.
Send me your project file and I'll fix this.