HOW TO LOGIN IN TO SQL EXPRESS AND HOW TO ATTACH DATABASE PLZZ ITS URGENT

Hi

i am developing an installer for our produce where there is a need to install sqlexpress and then i have to attach the database to that but i am unable to understand how to do that , i any one can help in this issue plss

To install SQL Express you need to include the installer and then pass command line parameters to it. This link will help http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/EmSQLExCustApp.asp

Now to attach a database, you need to create the database, then detach it, now you have an .mdf and an .ldf file. You need to include that in the installer, then once SQl Express is installed on the customer machine you need to re-attach it, you can do this by using the sp_detach, called through sqlcmd on or a sqlclient sqlcommand object.

How to link to ACT7 with SQLexpress,both on same Notebook.

How to link to ACT7 with SQLExpress,both on same Notebook.

I tried to make ODBC via settings Adm.Tools for Sql Server, and I made System DNS,

From Msaccess 2003 I try to male "get external data" and via ODBC databases,.... but it did not work. I don't see

and popping up if listing/prgs/database or whatever, it remains dead.

I can however via Start,Programs work with Sql express studio and with a demo database it is working,but I need the ACT7 tables to work with.

What my main task is, is to connect via Msaccess/ODBC to my ACT7 ( Sql) in order to do some update/import etc etc.

because standard Import features very poor for Additional Contacts etc.

Thanks for any help.

William

Hi William,

ACT! does not support access to their database outside of their defined API, which I'm not 100% familiar with. My understanding is that they do have an OLEDB provider for use with reporting engines such as Crystral reports, but I'm not sure if they support ODBC access to their tables.

I recommend you check out the ACT! support site at http://www.act.com/support/index.cfm to find your answer. The have both a knowledge base and customer forums that should help you figure out the correct way to do this.

Mike

|||

Thanks Mike sofar, I am trying further somewhere somehow.

William