How To Link To ACT7 With SQLexpress,both On Same Notebook.

Apr 9, 2007

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

View 2 Replies


ADVERTISEMENT

Link A Db To SQLExpress

Dec 3, 2005

I just reinstalled SQLExpress and all the dbs that I created are no more linked. The files still exist in the folder where the current version stores dbs (...Microsoft SQL ServerMSSQL.1MSSQLData) but they are not "linked" (don't know the right term).

Is there anybody who could help me how to "relink" these dbs to the actual .SQLExpress instance?

Thank you very much for any help!

Regards,
Fabian

my favorit hoster is ASPnix : www.aspnix.com !

View 2 Replies View Related

Hi How To Link Two Tables In Sqlexpress?

Apr 20, 2008

 Hi Everyone, I have a webform. I need to save the data inside the form into 2 tables. For that i have 2 separate buttons inside the form. tbl_jobPost(JobId,JobName,StartDate,EndDate,phone,email,jobFile_id) tbl_jobFile(FileId,Filename) 1st i ll be inserting the data into the tbl_jobFile:-(FileId,Filename) like this:-                                                                      (1,abc)                                                                      (2,xyz)                                                                      (3, fsd)Then i will be inserting the data into the next table:-tbl_jobPost(JobId,JobName,StartDate,EndDate,phone,email,jobFile_id)   like this:-                                                                                          (1,job1,2008,2009,4534535435,zzz@eee.com,jobFile_id)My question:-How should i pass all the jobFile_id from tbl_jobFile into tbl_jobPost row no. 1?Can you suggest any good solution for this?I m new to Foreign key.Do i need to use here.?Thanks.jack.                  

View 14 Replies View Related

How To Link To An Existing SQLExpress 2005 Table From Access 2003

Nov 22, 2006

I initially created an Access application within Access 2003 which I subsequently migrated to SQLExpress 2005 (Tables only) using Microsoft SQL Migration Assistance for Access 2003 (SSMAA) and continue to use Access 2003 as a front end, this really was easy and worked perfect. Now I added a new table to my SQLExpress DB and need to link to it from my Access application but can not find a way to do so in the same way that the SSMAA does. I need to run the Access 2003 application in share mode from multiple PC in the LAN. If I try linking to the table using an ODBC connection I can only access from the PC where the link was done! Any ideas? THanks in advance.

View 4 Replies View Related

Like Google Notebook

Jul 25, 2007

Hi All,

Has anyone tried writing a db structure that would replicate a google notebook heirarchy?

I'm very interested in learning to do this. My knowledge of MSSQL is poor. I had someone else develop a db in MSSQL for me. I'd like to add a similar functionality for my website to that of google notebooks. I don't need the browser plugins and stuff, only the ability to create new notes and sub notes which can have a few fields. For instance.

A - History
----a1.Name: World War 1
----a2.Name: Germany 1918-1945
----a3.Name: World War 2
------a3i.Name: Causes of World War II
------a3ii.Notes: bla bla bl a
------a3iii.Description: These notes are about the causes of WWII
------a3.SubTopic.a1.Name: Hitler's actions prior to WWII
------a3.SubTopic.a1.Notes: notes notes notes
------a3.SubTopic.a1.Description: desc desc desc

I need to develop a max of two level heirarchy for my website to provide my students a google notebook like functionality. I want to develop it for my school's website. Can someone help?

Navs

View 4 Replies View Related

Need Script That Can Shrink Copy Of DB To Fit On A Notebook

Feb 11, 2004

I need a script that will take a 40GB 300+ table database and shrink it to the 1st 1000 rows in each table and delete security tables like tblchargecard. Want to get size to about 1gb to fit on a notebook for development. Any suggestions would be appreciated.

View 3 Replies View Related

Transfer Of Subset Of Data To/from Notebook

Mar 25, 2004

I have a need to dump a subset of a database from the server (SQL Server) to a notebook via the network, for data entry to be done on the notebook when it is in the field & not connected to the network & then the changes made to this data on the notebook to be applied to the database on the server.

The application for the front end to this is in Access. Would MSDE be the way to go for the database on the notebook ?

It's a small application with not many users, likelihood of conflicting edits is small.

Would the data transfer best be done with replication or with DTS ?
Presumably replication would allow options for control over conflicts, such as the same bit of data being changed on the server & on the notebook’s copy of the data ?

I need guidance re direction to head in with this.

Thanks

View 2 Replies View Related

Can't Start SQLEXPRESS So That I Can't Install Latest SQLEXPRESS Security Updates.

Mar 13, 2007

I can't start SQLEXPRESS.

The SQL ERRORLOG shows: Error is 3414, Severity 21, State 2 and says: "An error occurred during recovery, preventing the database 'model' (database ID 3) from restarting." Just prior to this, I get a warning: "did not see LP_CKPT_END".

Any thoughts why this might be and how I can fix this?

View 3 Replies View Related

Installing SqlExpress (Advanced Services) Will This Break Existing SqlExpress?

Sep 21, 2006

hiya,

I have sqlExpress and sqlServerManagementStudio on my XP pro box.

Will the installation of sqlExpress (Advanced Services) cause any problems?IS thereanything that I shold be aware of in advance?

many thanks,

yogi

View 3 Replies View Related

How To Install Windows Application(C#) With SQLExpress In A System Which Is Having SQLExpress Already?

Jan 19, 2007

Hi All,

I have created an installation application which will install the application with SQL Express and .NET Framework 2.0.

If i install this application in a Fresh system(i.e which is not having SQL Express), it is installing the application with new database instance successfully.

But if i try to install the same in a system which is already having SQL Express, throwing "Object reference exception" because it is not able to create the new database instance.

Can anybody help me out .

Regards,

Doppalapudi.

View 2 Replies View Related

Access2003 Cannot Link (but Excel2003 Can Link) To Tables In Access97 Database

Feb 20, 2008

I have created an Access2003 project (existing data) that links to external data. First I connected to a SQL Server 2000 database. Success. Then I tried to set up a Transact SQL data connection to a legacy MDW-secured Access97 database. (A third-party VB6 application goes against it, and we don't have the source code, so we cannot upgrade it.)

The Transact SQL link tests OK but I cannot select any of the tables or queries from the list presented. However, with the same credentials, I can use these same objects in Excel 2003.

When setting up the link in Access2003, I specify JET 4.0 OLE DB Provider, I enter the MDW file on the All tab, a username and a password on the Connection tab where I browse to the MDB file, and specify Shared Deny None on the Advanced tab. When I test the connection, it tests OK ("Test connection succeeded"). Yet on the "Select the Database and Table/Cube which contains the data you want" dialog, "(Default)" appears in the grayed-out dropdown. Then, beneath that dropdown, there is a grid with Name and Description columns. The grid contains query names but the grid is not enabled. The list of queries is this table is grayed out. Neither of the scrollbars works.

BUT... if I use the SAME username and password in Excel2003, and specify the same MDW, there is no problem working with these same database objects in the legacy Access97 database. WHAT IS DIFFERENT ABOUT THE WIZARD IN EXCEL THAT ALLOWS IT TO SUCCEED AND THE WIZARD IN ACCESS THAT CAUSES IT TO FAIL HERE? In Excel, the list of available providers says Microsoft Access Driver, not JET 4.0 OLE DB Provider.

Thanks
TR

View 1 Replies View Related

Cannot Link To SQL Tables Using ODBC Link Table In Access 2003

Feb 3, 2006

When trying to link to an SQL table in Access 2003, the software appears to be malfunctioning. 

The sequence of events is File - Get External Data - Link Tables - Files of Type: ODBC Databases().

The Problem: On two of my computers, the select data source window does not pop up, preventing me from linking to any ODBC data source. 

Observations:  This function has worked normally in the recent past and works on other computers running Access 2003.  One difference between the computers working and non-working computers is Norton Antivirus 2006 (recent upgrade).

Has anyone experienced anything like this?  What's going on?

View 8 Replies View Related

Sqlexpress Installer Doesn't Believe Sqlexpress Has Been Uninstalled

Mar 21, 2006

Because of numerous problems trying to get sqlexpress working, I uninstalled it with the intention of reinstalling (via Add or Remove Programs). However, now when I try to reinstall it, I get a message that the I am not making a changes so it won't let me install it.

I do have sql server 2005 developer's edition installed; is that the reason? and does that mean I cannot have both installed on the same machine?

View 1 Replies View Related

Convert A SQLExpress File Based DB Project To SQLExpress Server DB Project

Jul 1, 2006

Hi All,I've been struggling with this for hours...Could someone please advise me on how to convert my current File based SQL Server Express website to a Server based SQL Express one.Particularly interested in what I need to do in the SQL Express management tool, changes I need to make the projecvt itself and changes needed to get IIS to understand things have been changed.Thanks,Martin.

View 1 Replies View Related

SQLExpress?

Aug 6, 2006

Hi
I'm pretty new to all of this. I downloded a starter kit and am a bit confised as to SQLExpress. I have SQL Server already installed and just wondering what the option are.
I am currently using Visual Web Developer Express Edition and in the config file data source is SQLExpress and can't go any further. I don't want to mess with my current setup so just want to get some sugestions first.
Anyway hope this makes sense.
Thanks
GP 

View 6 Replies View Related

Help With SqlExpress PLZ

Apr 2, 2007

I have just created a website with membership just using the standard SqlExpress auto generated file
Everything works fine until I upload it to webspace :(
I get the following Error
An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I don't have SQL Server 2005 :(

View 3 Replies View Related

Just Asking About SqlExpress And Ado.net

Apr 3, 2007

if my SQl server/COnnection is "SQL EXPRESS"..Im using an Import name "Import System.SqlClient" on every web form that i have...
as well as other SQl command name like "SQLConnection,SQLCommand etc..."is this the correct that im using all sqlcommand in my webform???
well sorry for this im just new..and one more thing..can i include Ado.net on it if my connection is "SQLEXPRESS" just i said?
Thanks for the answer....

View 1 Replies View Related

/SQLEXPRESS

Jun 20, 2008

Hi

I am new to this forum .
I am running through few problems for sqlserver account settings .

I) My registery key entry for MSSQLserver just has a client folder .
2) My sql server configuration manager just has
sqlserver 2005 services , native client configuration and 2005 network configuration.


I can't see any server name or databases under it.


3)I normally work on EMS lite so I can see my ./SQLEXPRESS as server and databases under it and i can create logins etc ..I assigned db_owner role to one of my recent created database.
but when I try to connect it says :

The user is not associated with sqlserver connection.

5) i have sqlserver express service running, vss and sql server browser running.


I googled and searched for the solution and it says the authentication mode should be turned to mix mode form win authentication.

But from where. Have i missed some installation .I am able to connect to my other database from EMS.





Please help me out.
Thanks in advance
SJ

View 1 Replies View Related

SQLExpress

May 25, 2007

I am trying to write an application for a MSSQL database, using SQL Express,and Visual Studio (Express edition)I tried to connect to an existing database (named testing) but to no avail.Visual Studio claims the database does not exist.Any ideas?TIA--Q: What is the difference between a mathematician and a philosopher?A: The mathematician only needs paper, pencil, and a trash bin for hiswork - the philosopher can do without the trash bin...

View 3 Replies View Related

SP2 On SQLEXPRESS

May 27, 2007

Installation of SP2 in step "Feature Selection" shows SQLEXPRESS unchecked and can''t be edited/checked.
I tried it many times on different servers with different OSes, etc

Does it mean that SP2 for Expres Edition should be downloaded and applieв separately?

View 1 Replies View Related

SQLExpress ASP.NET Confusion

Jul 19, 2006

Hello,I am just getting reaquainted with programming and all. I work in GIS mapping and am having diffilculty using  a ASP.net internet Map site and adding records to a needed database.I would like to be able to add records to a linked SQLExpress table when the user clicks on a map location. I adapted the following code snippet from an example that does what I would like only using an .mdb file.CODE:    // create connection to database                        var connection;                        connection = Server.CreateObject("ADODB.Connection");                        connection.Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=OutdoorsExp;Data Source=NOLOGOSQLEXPRESS;");                        status = "Can't access 'FishSQL' table.";                        // create recordset                        var recordset;                        recordset = Server.CreateObject("ADODB.Recordset");                        recordset.CursorType = 1                        recordset.LockType = 3;                        recordset.Open("dbo.FishTable", connection);                                                status = "Can't append new record.";                        // append record for clicked location                        recordset.AddNew();                        recordset.Fields("LongitudeI").Value = xco;                        recordset.Fields("LatitudeI").Value = yco;                                                recordset.Update();                        recordset.Close();                        // release the .mdb file                        connection.Close();However, this does not add anything to the SQLEx table. What am I missing? I am thinking that it might have something to with the primary key.I had a table with way more columns then just lat/longs (as above) but only coded it to add data to the latitude and longitude fields. Nothing got added of course. Would have to add data to every field that doesnt allow nulls.How do I generate a random, unique ID for a primary key on the fly and for example add it to the appropriate column.Thanks you in adavnce for any insights.

View 1 Replies View Related

SQLExpress To SQL 2000

Jul 22, 2006

To be as brief as possible:I had Visual Studio 2005 installed with SQLExpress 2005.  worked reallll good :) I needed to convert an excell spreadsheet to SQL, so I migrated it to Access.  Then the upsizing wizard would not/could not create an sql table with the data.  Just would not take the data when the table was created. Argh.FINALLY figured out that the SQLexpress 2005 doesn't come with import/export.So I uninstalled the sqlexpress and installed SQL 2000 - Developer.  Veeola, able to convert and created the table I needed.Now Visual Studio 2005 won't let me touch the sql file, says it requires sql server express 2005.My ISP does not support SQL 2005 yet.  Is there anyway to get Visual Studio 2005 to work with SQL 2000 (only?)If I install SQLExpress over again, will it create problems when I go to publish my website, and more importantly right now, will anything bad happen when I reinstall sql express, or do I need to uninstall SQL 2000 first?  Thanks...

View 2 Replies View Related

Problem With Sqlexpress

Sep 29, 2006

hi:I set up a DSN via Adim tools, then I specify the connection string as "DSN=UserAppSample;Trusted_Connection=True".When I run my aspx page, it says: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL
Server]Cannot open database "UserAppSample" requested by the login. The
login failed. It asks for login, but I use windows authentication. So what is wrong with this? :(  

View 1 Replies View Related

What Is The Limitation Of SQLEXPRESS?

May 4, 2007

** For those 20 users (or fewer) who've read http://forums.asp.net/thread/1692306.aspx, I'm sorry that I ask the same question.Like I said above, what is the limitation of SQLEXPRESS, in terms of performance and scability?I'm creating a new webboard application that will replace the old one. I intend it to handle 200 concurrent users + 70000 records (9 years of data)The current system use Microsoft Access, which is reaching it's limit in performance and size. I took a look in the SQL Server product information page : http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx.It didn't tell me what I want, like how many connections it can handle, for example.If there are limitations that might cause my application to not reach the required specification (above), I may need to switch to MySQL. I've no intention buying a licensed SQL Server 2005.Thanks in advance.PS: Why there're so few users viewing my posts? Anyone know a more active forum that may help me?

View 9 Replies View Related

Sqlexpress ENABLE_BROKER

Oct 2, 2007

i'm using sqlexpress edition for my application and i'm wondering whether i will be able to execute the below sql statement
use masteralter database <dbname> SET ENABLE_BROKER
when i execute the above two lines its executing from last 30+ minutes...
i'm wondering will that support in sqlexpress edition ?
also, in order to use sqldependency do i have to enable broker service?
thanks.
 

View 2 Replies View Related

How To Back Up SQLExpress?

Nov 28, 2005

Ok it seems to me that if you use the ms recommended code to connect your apps using the app_data folder etc, that the dbs never show up in the SQLExpress manager.So I can't back them up like I can databases I connect to SQLExpress the 'old fashioned way'. Only 2 out of 6 dbs are visible in SQLExpress manager.What is the proper way to do this?Thanks,Jamey

View 3 Replies View Related

Two Problems With SQLExpress

Dec 6, 2005

1. Is there a white paper on how to upgrade an SQLExpress DataFile to a SQLServer attached database? 
2. More importantly:  Is there a way to upgrade a Beta 2 SqlExpress database to a RTM version?  This lack of compatibility between beta 2 and RTM is killing me.  Are their any resources for this transformation?  Would be great!

View 3 Replies View Related

Connecting To SqlExpress

Apr 17, 2008

As of right now I have two networked machines. I have a sql database on one that I have no problem connecting to, but I cannot connect to the database from the second machine.

From the second machine, I've come up with this connection string after all my research...

"server=[MACHINE_NAME]SQLExpress;databse=[NAME];User ID = sa;Password=[PASS]"

I keep getting a cannot connect to database error.

Any ideas?

View 5 Replies View Related

Net Use CMD. How To Map Drive W/SQLExpress

Apr 23, 2008

I know this isn't exactly SQL help, but I alwasy get great help here and thought someone might know why I'm having problems. I'm trying to map to a drive where I have a SQLExpress database on another computer within a workgroup. This is the cmd line I'm using...

NET USE * \XPPRO1SQLExpress /USER:Admin /SAVECRED /PERSISTENT: YES

I'm thinking the problem is with the * (which names the new drive with the next available letter), or that I have to use a password. Everything I've found says nothing about specifying a password though.

The error message I get says "A command was used with conflicting switches."

View 1 Replies View Related

Uninstall Sqlexpress

Feb 14, 2006

Hi friends
I insalled Visual Studio 2005 standard edi on XP machine. as you all know it also installs sqlexpress. i want to uninstall this sqlexpress as i also have sql server 2005 standard edition on my machine.

but i dont see any option to uninstall in add/remove programs or in start menu for sqlexpress.
any ideas on this ?
Thanks for your help.

Cheers

View 13 Replies View Related

Can't Reinstall Ms SQLEXPRESS

Sep 1, 2006

I made a big mistake and deleted this program and now I cannot reinstall it. I get error messages stating that an instance is already on my machine and I need a unique name to restart install. I also get messages that say to install from the command line but I cannot get there the only access I have is error reporting. Is there any way I can make a FREASH install of this program????

View 2 Replies View Related

HELP: ASP.NET Won't Connect To SQLexpress After De

Jul 31, 2007

Hello,

I have finish building my ASP.NET site using VS 2005 and it compile just fine. Than I try hosting it to the web via IIS v5.1 and I am getting permission error from SQL express.

I have posted a detail question in experts-exchange.com and since you need a user account to even view the thread, I have taken the liberty to save the thread as .html file and host it to my ISP site. You can see the detail problem I am having here: http://users.accesscomm.ca/mm/EEdetail.html

I am going to list out some stuff I have done:

1. I have two database that need access, the ASPNETDB.mdf for user login and another database (PhotoDataBase.mdf) to store information relating to the photo I uploaded to my ASP.NET site.

2. I have already follow this How to site: http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx and setup:
- TCP/IP enable, as shown here:
- I have started SQL Browser service
- The firewall part I am not so sure about. I am currently using Zonealarm....

3. I have installed SQL Server Management Studio Express(SSMSE) and attach the two database to it.

4. I have set SSMSE server properties to accept both SQL and window authentication.

5. I have made sure that both database "read only" setting to false

6. I have setup SQL login with User ID = SQLLOGIN

Here is the original connection in web.config:
<add name="ConnectionString"
connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|Da
taDirectory|PhotoDataBase.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />

and here is the new connection I just type in web.config that replace the original one:
<add name="ConnectionString"
connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|PhotoDataBase.mdf; Server=MINGDESKTOP; Integrated Security=False; uid=SQLLOGIN; Password=XXXXXX;"
providerName="System.Data.SqlClient" />

and the error i get are the follow:

Server Error in '/' Application.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

7. I did haven't done much to ASPNETDB.mdf yet and the error i get right now are the following:

________________________________________
__________________
Server Error in '/' Application.
Cannot open user default database. Login failed.
Login failed for user 'MINGDESKTOPASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'MINGDESKTOPASPNET'.
_______________________________________________


Please help! I am really running out of ideas.... and I need to have this setup in a few days....

Thanks!

View 17 Replies View Related

Cannot Connect To SQLExpress

Dec 1, 2006

Hi, I'm using Microsoft SQL Sever Management Studio Express. But all of a sudden, if I clicked connect button, the messageBox pops up and it doesn't let me connect. It says "TITLE: Connect to Server
------------------------------

Cannot connect to YOUR-4105E587B6SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
I didn't have such a problem before. If someone could help to solve to this problem, I appreciate it. Thanks.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved