Hi There: I have a .Net application that I run on a PDA Handheld. When I try to connect to a System.Data.SqlServerCE, I use this connection string:

Dim connection As New SAConnection
Dim connectionString As String = String.Format("UID={0};PWD={1};DBF={2", userId, password, Caseman_db_file)
connection = New SAConnection(connectionString)
connection.Open()

Everything works fine Except that when connected it opens up a Sybase window that shows: Different status like Running Windows CE, 600 K memeory, Database sevrevr stopped etc. Ques: How can I hide this Sybase window on my PDA when I connect to this iSQL. This DB file is on my PDA. What connection parameter do I need to hide this screen. I would prefer to add another paramter that would hide this screen. I built my code, deploy it on the PDA and then on the PDA I am running my application that connect to the Sybase DB(On my PDA).

Thanks Syed Zaman

asked 05 Dec '12, 11:39

SybaseLearner's gravatar image

SybaseLearner
75446
accept rate: 0%

edited 15 Mar '13, 17:23

Mark%20Culp's gravatar image

Mark Culp
23.0k9129270


 Dim connectionString As String = String.Format("UID={0};PWD={1};DBF={2}", userId, password, Caseman_db_file)

You will want to add the START connection parameter to point to the server executable and pass the server switch "-qw" (hide the main window, keep the system tray icon) or "-qi" server switch (hide the window and system tray icon).

i.e.

 Dim connectionString As String = String.Format("UID={0};PWD={1};DBF={2};START=\Program Files\SQLANY12\dbsrv12.exe -qi", userId, password, Caseman_db_file)
permanent link

answered 05 Dec '12, 13:30

Jeff%20Albion's gravatar image

Jeff Albion
10.7k171174
accept rate: 24%

edited 05 Dec '12, 13:30

OMG!Thanks Jeff. It worked. I checked the dbsrv11.exe on my PDA and then added this parameter and worked in 1st shot. I spent 5 whole hours digging-in here and there and finally your response saved me. Braveo! and again thanks a lot. Syed

(05 Dec '12, 14:01) SybaseLearner

Ok Jeff. I found it takes some time to connect to the Sybase DB file on my PDA by using the above string. I tried all possible ways: START=Program FilesSQLANY12dbsrv12.exe -qi START=Program FilesSQLANY12dbsrv12.exe -qw START=Program FilesSQLANY12dbsrv12.exe -q -c 3M

But in each case, it takes a noticable time. Why when both dbsrv11.exe and the db file , all remain on the PDA?

(05 Dec '12, 14:33) SybaseLearner
Replies hidden

I found it takes some time to connect to the Sybase DB file on my PDA by using the above string

How much time, exactly? Now that you have "START" line in-place, can you add after the -qi / -qw switch, a console log output switch to generate a log to record what's happening at start-up?

Dim connectionString As String = String.Format("UID={0};PWD={1};DBF={2};START=\Program Files\SQLANY12\dbsrv12.exe -qi -o \console.txt", userId, password, Caseman_db_file)

Be careful that the database is not undergoing automatic recovery if the database server was forcibly shut down during its last run.

(10 Dec '12, 13:25) Jeff Albion
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×56
×34

question asked: 05 Dec '12, 11:39

question was seen: 1,896 times

last updated: 15 Mar '13, 17:23