2. ASPRunnerPro General questions
  3. SQL Error
This topic is locked

SQL Error

 		11/5/2006 3:46:20 PM
ASPRunnerPro General questions
P
 pharaon_98 author

Hi tested the new 4.1 version
Works perfectly fine on my system with SQL Server. But once on the web, it doesn't work anymore.
I had to change the connection string from
strConnection = "DRIVER=SQL Server;SERVER=MY_PC_NAME;UID=USERNAME;APP=AspRunner Professional Application;WSID=MY_PC_NAME;DATABASE=MY_DB_NAME;Network=DBMSLPCN;Trusted_Connect

ion=Yes"
to
strConnection = "Driver=SQL Server;Server=localhost;Database=MY_DB_NAME;Uid=USERNAME;Pwd=PASSWORD;"
Since it wasn't working, i had to change the ..._variables.asp page. I had to modify the line

gstrSQL = "select [No], [Dealer], From [dbo].[horaire] where Dealer LIKE 'ABC'" like

gstrSQL = "select [No], [Dealer], From [MY_DB_NAME].[USERNAME].[dbo.horaire] where Dealer LIKE 'ABC'"
Now, i can see the _list.asp page, but i cannot delete, add or modify
Delete : Nothing happens

Add : << Record was not updated >>

Operation is not allowed when the object is closed.
Edit : Can't find the page (and it's there).
Thanks
Sergey Kornilov admin 11/6/2006

First of all I would recommend to rebuild your project using SQL Server authentication. Trusted connection won't work in most cases.
If you still have issues after that send your files to support@xlinesoft.com for investigation.
P
 		pharaon_98 author 11/6/2006

Did what you said
Still ain't working.
Still have connection is closed when trying to add.
Sergey Kornilov admin 11/6/2006

If you still have issues after that send your files to support@xlinesoft.com for investigation.
P
 		pharaon_98 author 11/10/2006

Found the problem. It was about the database owner...
Now that this is fixed, I can list, add, and delete. But, there is a but, i cannot edit. This is the message i receive
BOF or EOF is equal to true or the actual record has been deleted. the operation requires an actual record.
/include/commonfunctions.asp line 1242
What is this about ?
Sergey Kornilov admin 11/10/2006

If you still have issues after that send your files to support@xlinesoft.com for investigation.
C
 		clig 11/16/2006

First of all I would recommend to rebuild your project using SQL Server authentication. Trusted connection won't work in most cases.

If you still have issues after that send your files to support@xlinesoft.com for investigation.


instead of multi-protocol have your tried DBMSSOCN (tcp/ip) in your connection string?