| Author |
Message |
    
dbmaven
New member
Username: dbmaven
Post Number: 1
Registered: 11-2006
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, November 28, 2006 - 04:07 pm: | 
|
I just installed SVC 4.0 Build 10.
I created a new project and placed a VB6 project into SVC. When I check-out the project, the files are not readable by VB6. Any ideas?
P.S. Clicking on "Purchase SVC" takes me to a web page for InnoScript? How do I purchase SVC or donate to the website? |
randem
Moderator
Username: randem
Post Number: 87
Registered: 04-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, November 28, 2006 - 04:54 pm: |
|
Aloha dbmaven,
You can donate on the SVC webpage at http://www.randem.com/svc.html
Look for "Support SVC".
I will check on the addition/extraction of the project. |
randem
Moderator
Username: randem
Post Number: 88
Registered: 04-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, November 28, 2006 - 05:00 pm: |
|
dbmaven,
I just check-in a VB6 project folder then checked it out to another folder and it opened as expected.
Could you give me a little background on the process you are using?
The Registration page has been updated to include SVC.
Thanks. |
dbmaven
New member
Username: dbmaven
Post Number: 2
Registered: 11-2006
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, November 28, 2006 - 07:09 pm: |
|
I'm using the SQL Server version. I checked out my code to the same folder. Maybe that was the problem. |
randem
Moderator
Username: randem
Post Number: 89
Registered: 04-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, November 28, 2006 - 07:14 pm: |
|
Not sure... But that is one thing one should never do is to check files out into the development environment.
Let me know of your testing results. |
dbmaven
New member
Username: dbmaven
Post Number: 3
Registered: 11-2006
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, November 28, 2006 - 07:16 pm: |
|
I tried checking out to another directory. Same problem. The files seem to be corrupted.
How do I recover these files? |
randem
Moderator
Username: randem
Post Number: 90
Registered: 04-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, November 28, 2006 - 07:22 pm: |
|
What are the steps you are taking for checkout?
Did you get any errors on Check-In?
Could you post the vbp file so that I can take a look? |
dbmaven
New member
Username: dbmaven
Post Number: 4
Registered: 11-2006
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, November 28, 2006 - 07:33 pm: |
|
No errors with the checkin.
I tried checking out individual files and the entire project. |
randem
Moderator
Username: randem
Post Number: 91
Registered: 04-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, November 28, 2006 - 07:36 pm: |
|
You would need to zip it first. Please re-post |
dbmaven
New member
Username: dbmaven
Post Number: 5
Registered: 11-2006
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, November 29, 2006 - 07:57 am: |
|
Sorry, here is the project. |
randem
Moderator
Username: randem
Post Number: 92
Registered: 04-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, November 29, 2006 - 11:33 am: |
|
I looked at your file and the reason it is not able to be loaded is because it is saved in Unicode format.
I will look further into this. |
randem
Moderator
Username: randem
Post Number: 93
Registered: 04-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, November 29, 2006 - 11:52 am: |
|
If the Unicode parameter for the SQL database in the ini file is UniCode = False, Set it to True and try to check the files out again.
Let Me know... |
dbmaven
New member
Username: dbmaven
Post Number: 6
Registered: 11-2006
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, November 29, 2006 - 12:36 pm: |
|
It was set to True. I tried setting to to False and then checked out the project again. The vbp file is corrupted. |
randem
Moderator
Username: randem
Post Number: 94
Registered: 04-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, November 29, 2006 - 12:45 pm: |
|
Look in the database in the table "ProgramList" for the vbp file and tell me what the field ACT_LTH is and what the Windows file size is and also what the field LTH in the table "ProgramData" is. |
randem
Moderator
Username: randem
Post Number: 95
Registered: 04-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, November 29, 2006 - 02:01 pm: |
|
BTW: you can convert a UniCode text file by opening it in notepad then cut and paste it to a new text file. |
randem
Moderator
Username: randem
Post Number: 96
Registered: 04-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, November 29, 2006 - 07:28 pm: |
|
Try this file to export your data. Just replace the one in the folder where you installed SVC.
Is there anyway to get a screen shot of the programlist and programdata tables. A copy of the whole database would be helpful. |
dbmaven
New member
Username: dbmaven
Post Number: 7
Registered: 11-2006
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, November 29, 2006 - 07:33 pm: |
|
Thanks, I'll send you the database on Thursday. |
randem
Moderator
Username: randem
Post Number: 97
Registered: 04-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, November 29, 2006 - 07:44 pm: |
|
Usethisone. |
dbmaven
New member
Username: dbmaven
Post Number: 8
Registered: 11-2006
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, November 30, 2006 - 09:31 am: |
|
I placed the new exe in the Program directory where SVC runs from. Now, when I try to check out anything it locks up? |
randem
Moderator
Username: randem
Post Number: 98
Registered: 04-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, November 30, 2006 - 10:57 am: |
|
I need to see the tables in your database. None of those things happen here.
Look in the titles table for your project find the SYS_ID then look in the programlist table for the LTH and ACT_LTH fields and the programdata table for the LTH field.
It could be easier to export the database to Access then post that. |
dbmaven
New member
Username: dbmaven
Post Number: 9
Registered: 11-2006
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, November 30, 2006 - 11:56 am: |
|
Here is a back up of the SQL Server database. I restore my projects so I can reinstall SVC and start over if needed. |
randem
Moderator
Username: randem
Post Number: 99
Registered: 04-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, December 01, 2006 - 10:05 pm: |
|
I seemed to have found the problem. Your database seems to be storing data in Wide Character Format not UniCode.
I am researching this... |
randem
Moderator
Username: randem
Post Number: 100
Registered: 04-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Saturday, December 02, 2006 - 09:34 pm: |
|
Ok, found the problem. It was in the creation of the table ProgramData for the field Data. It was set incorrectly as text when it should have been varbinary (max).
If you need the text project, I can retrieve them.
I have uploaded new scripts for SQL Server and a new update installation. Replacing the exe won't do. Sorry for the inconvience and thank you for bringing this to our attention. |
dbmaven
New member
Username: dbmaven
Post Number: 10
Registered: 11-2006
Rating: N/A
Votes: 0 (Vote!) | | Posted on Sunday, December 03, 2006 - 10:29 am: |
|
Thanks!
I'll reinstall and use the new script. |
randem
Moderator
Username: randem
Post Number: 101
Registered: 04-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Sunday, December 03, 2006 - 12:41 pm: |
|
That setting seems to have migrated from when the software only handled text files. it was never changed in the script.
Let me know how it works... |
randem
Moderator
Username: randem
Post Number: 103
Registered: 04-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, December 05, 2006 - 08:44 am: |
|
Any progress? |
dbmaven
Junior Member
Username: dbmaven
Post Number: 11
Registered: 11-2006
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, December 05, 2006 - 09:35 am: |
|
In your script for the ProgramData table,
your have "[DATA] [varbinary](max) NULL," listed?
Did you mean the max length of a varbinary field, 8000?
The max setting doesn't work so I put in 8000 to continue testing. |
dbmaven
Junior Member
Username: dbmaven
Post Number: 12
Registered: 11-2006
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, December 05, 2006 - 09:52 am: |
|
On my first import, I see this error dealing with the Programdata.data column.
 |
randem
Moderator
Username: randem
Post Number: 104
Registered: 04-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, December 05, 2006 - 11:36 am: |
|
Did you use the new script that is on the website to create the database? |
dbmaven
Junior Member
Username: dbmaven
Post Number: 13
Registered: 11-2006
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, December 05, 2006 - 12:02 pm: |
|
Yes. |
randem
Moderator
Username: randem
Post Number: 105
Registered: 04-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, December 05, 2006 - 12:56 pm: |
|
There should be no limit to a varbinary field. This is the correct field type. I have tested it here. What version of SQL Server are you running? |
randem
Moderator
Username: randem
Post Number: 106
Registered: 04-2004
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, December 05, 2006 - 07:31 pm: |
|
dbmaven,
I have figured it out. In SQL Server 2000 that field needs to be IMAGE (other version of SQL Server are different). I have corrected the script and reuploaded it. I have double checked it on SQL Server 2000 for accuratcy and all is well.
Thanks for your time and sorry for the inconvience...
BTW: SVC also supports SQL Server Express 2005. |
SVC - General Questions, Report Bugs, Problems etc... 
Project files