borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder

AndreaVB | Forum | News | Downloads | Register | Help | Member List | Statistics | Search | PM | Profile

Print This Topic
Previous Topic (How to update it?)Next Topic (VBA Autocad) New Topic New Poll Post Reply
AndreaVB Forum : Database : MSDE
Poster Message
lbuntha
Level: Scholar

Registered: 05-05-2006
Posts: 39

icon MSDE

How can i write code to connect to MSDE when i build file setup with Install Shield?
My software is developed  in VB6.
I have problem when i take my software to install on other computers without SQL server.
Thank for your reply!

____________________________
ly buntha

22-06-2006 at 04:44 AM
View Profile Send Email to User Show All Posts Visit Homepage | Quote Reply
JLRodgers
Level: Moderator

Registered: 04-04-2002
Posts: 1617
icon Re: MSDE

I'm thinking it's the same was as connecting to a MS SQL server... but I've never had it nor tried, so can't say for certain.

If you do have it, I'd say to try it and see.

____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)

22-06-2006 at 08:40 PM
View Profile Send Email to User Show All Posts Visit Homepage | Quote Reply
yronium
Level: Moderator


Registered: 14-04-2002
Posts: 907
icon Re: MSDE

I can say it for certain: it's the same of SQL Server.
But I didn't understand what are you attempting to do. In the setup packet you have to put your executable, not any database.

Perhaps you might want to create a database into the MSDE server: that case you got to provide an sql script to run.
Perhaps you might want to provide some data to an existing MSDE database: so you got to provide a backup file to restore, and an sql script to execute restoring.
But running sql scripts is not expected to be done by the setup packet, as it is a separated operation than the bare setup process, or at least I don't know how could we make InstallShield automately do it.

I can tell you how to write a small VB application that launches the sql scripts, and that's what I do: I create a setup pack with all the files, but I don't launch it directly. Instead, I run a small app that first launches the setup pack and then run the scripts. Alternately, you can run the scripts at the first execution of your main app, but that's it. I have not the skill to program InstallShield (nor VSI, that's what I use) to do it automatically, and I think few have it.

Hope it helps, ask if you need to know more on what I said.

____________________________
Real Programmer can count up to 1024 on his fingers

23-06-2006 at 12:42 PM
View Profile Send Email to User Show All Posts | Quote Reply
AndreaVB Forum : Database : MSDE
Previous Topic (How to update it?)Next Topic (VBA Autocad) New Topic New Poll Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
Partners: Download Actual Software | Free Software Download
borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder