Linking New DB Application To Existing MAS200 DB

Apr 7, 2008

Hey all,

 Firstly, thank you for a fantastically developed source of information for beginners such as I. The knowledge base here is outstanding in every regard and is walking me step by step through my future development issues.

 I've begun setting up a SQL DB using VB Web Developement Express 2008 and have made some good headway as to mapping out the required relational data. However, as I look into the future of this project, I realize that whatever database I develope will need to communicate with MAS200 on many levels. I've done some looking around over the internet and it looks like it is possible because MAS200 is indeed a simple database.

 My question/s are partly multiple so I'll list them all:

 A) Can VB Web Development Express Edition 2008 connect with MAS 200? Or - do I need to purchase the PRO Edition?

B) If communication between VB Web Developement Express/Pro Edition 2008 IS possible, what other components may be required (ie: drivers, software, hardware, etc)

C) I will need to retrieve data as well as input data into and from MAS 200 as well as the new application - does this present a problem?

I appreciate any help that could be offered in regards to this question.

 Regards,

 Matt

View 1 Replies


ADVERTISEMENT

Info On MAS90 / MAS200 For SQL Server

Jul 20, 2005

I was looking thru the mas90 info site ofhttp://www.accountingsoftwareconsul...ng_software.htmfor detailed info on MAS 200 SQL server.There's some info on that page, but I need more.Is there any more detailed info anywhere else on that site, or anywhere else?

View 1 Replies View Related

Reporting Services And Existing Application

Jul 11, 2007

 Hello everyone I have a small application in asp.net now I’m trying to use the SQL reporting services.  But as soon as I try to connect to the DB on the “connection propertiesâ€? window I get this error. 
Unable to open the physical file "C:myAppsmydb.mdf". Operating system error 32: "32(The file is in use by another process.)".

Thanks
 

View 3 Replies View Related

Application Will Not Allow Edit Of Existing Data On Certain Customers

Jul 14, 2015

I am using a business management software application that uses SQL Server 2012 for data storage.  The application is one that stores data about the customer, and then displays as requested. On certain customers, once saved, no save of future edits will work.  Once the save button is clicked, there is a momentary hula hoop, followed by nothing. You have to cancel to get out, and then going back you see that the data was not saved. This only happens on certain customers (however, once the problem develops for a certain customer, it is consistent) and newly created customers seem to work fine.  I am thinking that the software app is fine since the save process would be the same each time the button was clicked, so I am thinking its a database problem.

View 10 Replies View Related

How Can You View The Connection String Of An Existing Datasource? How Do You Delete Existing Dataset?

Nov 14, 2007

I went to look at the connection string previously entered for a dataset created in a new report, and am not seeing anything intuitive for bringing up the associated datasource dialog box that was used to enter name, type and connection string. I'm also noticing nothing intuitive for deleting an existing dataset. How do you do these two very simple things in an existing project? I dont see the dataset in solution explorer, I see it only in the text box on the data tab and in a limited kind of way on the dataset view where the columns show and maint is allowed mostly on the columns only. I tried hilighting the dataset here and hitting the delete key to no avail.

View 1 Replies View Related

Force To Close Existing Connections When Restoring Existing Database

Aug 13, 2007

Hi All,

I would like to restore database using RESTORE DATABASE ... REPLACE command.
If database exists already and has any open connections this command will fail.
I would like to close all existing connections to specific database before running RESTORE DATABASE ... REPLACE command.
I can do closing from Management Studio using checkbox "Close Existing Connection" when deleting database. Actually I need to do the same but from script.

Please advice me how to do it.

Thanks in advance,
Roman

View 3 Replies View Related

Distrib.exe Application Error , Application Failed To Initialize Properly(0xx0000142)

Apr 13, 2008

have SQL Server 2005 std edition SP1 installed on Windows 2003 Std edition .Configured Transactional (single Publisher and no clustered environment.)
Replication past two months working fine, Now
1.Distrib.exe application err is coming.

Due to which my job is failing (Distributor to Subscriber).
Iam attaching thw file.
Thanks
Sandeep

View 1 Replies View Related

Linking 2

Apr 4, 2007

i already find the answer
thanks

View 1 Replies View Related

Linking To SQL Server 5.0

Sep 2, 2007

I'm writing my first web site using VS 2005 and with my login page I'm trying to link with my SQL database using the following setting in my web.config file
<appSettings> <add key="SQLDB" value="server=STEVE-LT; database=MasterDB; uid=sa pwd="/></appSettings>
Then in my Login.aspx file I use the following code to access the SQL database
Dim Sc As SqlConnection = New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("SQLDB"))Dim SqlCmd As SqlCommand = New SqlCommand("Select Password, Name from Login")SqlCmd.CommandType = CommandType.StoredProcedure
Sc.Open()SqlCmd.Connection = Sc
 This raises the following error message
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Could someone please tell me where I am going wrong. Thanks

View 2 Replies View Related

Linking Servers 7.0 To 6.5

Jun 27, 2001

I need to have database access via an
application to both sql server 6.5 & 7
the 6.5 uses mixed mode security,
the 7.0 uses trusted. Using
sp_addlinkedsrvlogin I can get from a client to
the 7.0 server, but not to the 6.5.
Is this even possible?

View 2 Replies View Related

Linking To Oracle

Nov 7, 2000

Can anyone tell me how to link to a oracle user? DO I use a predefined DSN? Do I just specify the server and the user and password?

Your assistance is appreciated,
David

View 2 Replies View Related

Linking 6.5 Server

Mar 8, 1999

I can't seem to link a 6.5 database from 7.0 and there's nothing in help which seems to help. Is it a "SQL Server" or do you have to use the OLE DB Provider? If the latter, what's supposed to be in the Product, Data Source, Provider String and Catalog fields? What about security? I've tried everything I can think of and can't get it to work. I also get errors creating a new DTS package that says "Could ot create Component Categories Manager", and then "Error during creation of DTS Package". I installed the desktop version of 7 on an NT Workstation. Has anyone successfully linked a 6.5 server in this environment?

View 4 Replies View Related

Linking Php Forms To SQL

Nov 28, 2001

How would you link an online application form done in php to an SQL 7 server?

View 1 Replies View Related

Help Linking Tables

Jan 11, 2005

this is the query I need help with

select a.RecordID,a.RelocateID,a.WhenConfirmed,b.RequestI D,b.DocumentID,b.RequestWhen from RelocateeDTA a inner join
docRequests b on ({a.RecordID}=' + CONVERT(VARCHAR, a.RecordID)'= b.WhereClause)

because I am trying to link RelocateeDTA that has RecordID to docRequests that has the same piece of data in field WhereClause but is a varchar, and I am getting an error message (syntax error or access violation)

Could somebody help me please

View 14 Replies View Related

Setting Up And Linking A DSN

Oct 14, 2005

Hello there, im new here and wanted some help, i would be very grateful to anyone that can help:

I am setting up a DSN for my website (www.t-f-l.com, it may make more sense if you visit the site) i need it so members can sign up to the site (for the exact problem, click 'sign up now' on the website

I have set up the DSN but it says i need to link it to the database tables via MS access, im not sure at all how to do this...please can someone help

please explain in real idiot language....as i am new to this

View 1 Replies View Related

Linking 2 Tables

Apr 24, 2007

dear experts,
i have two tables, tblcustomer and tblform. in tblcustomer i have cutomerid PK and i have also a field that link these two tables customername. in tblforms i have formname. customername and formname are not PK and customername has a lot of null values.
my question is that i want to link these two tables in customerid not the name and also to get the forms used by this customer. the thing is that i have to write a join query.
any suggestion to do that?

thanks my friends

View 14 Replies View Related

Linking Up Two Different Databases

Aug 22, 2007

I am not a database manager, but I work with people that use databases for sales and customer service... so I am not too familiar with the code and lingo... please bear with me.

We use two databases - one is in SQL, and it is for pre-sales customer service... i.e. tracking notes, phone calls, emails, and opportunities.
The second database is in Progress, and it is for actual quotes, tracking time, labor, materials, cost, and revenue.
As of now, our sales people have to enter new customers in the SQL database, and then duplicate the information in the Progress database. It's very frustrating, because everything needs to be entered twice - name, address, phone, shipping info, etc. etc. etc... When we first started this - 10 years ago - we were told that it could all be linked.

So my question is - is it possible to link these databases together? When our sales people enter a new contact in CRM, I'd like it to be automatically entered into the Progress database. If they make a change to a phone number, I'd like that to be updated in the Progress database. Also the other way around - if a shipping address is changed in the Progress database, I'd like it updated automatically in the SQL database.

Please tell me this is possible - and easy!!! Thanks for any help you can provide at all.

Jon

View 3 Replies View Related

Linking To Exchange From SQL

Mar 16, 2004

Does Exchange 2000 and SQL 2000 have to be the same machine to use exoledb.dll?
I want to link to an Exchange server and gain access to a Public Folder Contact Object for use as a lookup table within an Access front end. Someone directed me to use the Exchange OLE DB Provider, but it does not exist on my SQL machine.

Any help is appreciated

View 14 Replies View Related

Linking To Oracle9I

Apr 30, 2008

Sorry If I have posted this in the wrong head,

I would like to Establish connectivity to a Oracle9i DB thro Linked Server, Can any of you guide me to suitable links...
Thanks

View 3 Replies View Related

Linking Efficiency

May 6, 2008

I would like to use MVJ's formula for creating a date table.

I would like to use it with our main ERP database. However, I am reluctant to make changes to it because I fear that at some point when we upgrade that software and it's database that the upgrade program will delete my table.

So, here is my question. Performance wise, does it matter whether I add the date table to our ERP database or if I create another database (on the same server) for the custom date table? Does linking between databases take substantially longer than linking within the same database?

View 1 Replies View Related

Linking Tables

Mar 24, 2006

I know it's possible to link tables between Access and SQL Server using ODBC....however can u use DAO to do this? If there's a way i would appreciate some help. Thanks in advance.

View 2 Replies View Related

After Linking A Tabel To SQL

Nov 16, 2006

I link to a sql server for the first time.
I change my .provider and .connectionstring to ADO
And know in one of my forms i get a debug Error; Invalid table Name "tablename"
can someone help me with this.
Thanks eddied

View 6 Replies View Related

Linking 2 Databases

Mar 28, 2007

We are considering to implement Microsoft CRM 3.0 in our (small) organization. But we already have some customer information in another system (Unit4). We want to duplicate this information to our new CRM-system. This data will be read-only in the CRM-application.

Both the applications are installed on different servers with their own SQL databases(server 2000 and server 2005)

How can we duplicate the customer information from the unit4-system to Microsoft CRM? Can we simply link those databases using ?ODBC? (I heard something about ODBC but don’t know what it really is.)

Could someone clearly explain me what we have to do to make a construction as described above. (you don't have to give me all details) Is this construction possible anyway?

Thanks!

View 4 Replies View Related

Linking From Access

May 4, 2007

I am have created a test table in enterprise manager v8 and linked this table to an access database. I am able to append to the table from access but cant delete or update.

Ive set the permission settings to allow the user to update and del so cant work out why this isnt working?

ANyone got any ideas?

View 2 Replies View Related

Linking 2000

Jul 20, 2007

Hi,

I have a default instance that is Server1 (2000) and a named instance Server12005 (2005)

How do I link theses servers together so that my 2005 database can query the 2000 database.

Cheers

Leon

View 1 Replies View Related

Linking Two SQL Servers

Jul 23, 2005

Two SQL Servers1) "Test"Payroll DBTransaction Tablepr_SubmitTransaction in Payroll DB********************************************2) "Production"Payroll DBTransaction TablePr_SubmitTransaction in Payroll DBAccounts DBPr_VerifyAccounts (@AcctNumber)********************************************I want to use same pr_VeriftAccounts in both test and productionPr_SubmitTransaction stored procedure.The pr_SubmitTransaction in production works fine when I sayExec Payroll.dbo.pr_VerifyAccounts as it is on same server. (WORKSFINE)Exec [PRODUCTION].Payroll.dbo.pr_VerifyAccounts (DOES NOT WORK)Should I use sp_addlinkedServer ?? to do this ?. Please provide me somefeedback.I know I can acheive this by front end, but I was do it in one storedprocedure.

View 7 Replies View Related

Linking A Table

Nov 10, 2005

Little puzzle this.I need to link from SQL2000 to Access to get to a table held within anAccess DB. Now you can link within Access to a SQL table, but can thisbe done the other way round ? It's the first time I've needed to dosomething like this.What I have is an application which was written (by me) with an Accessbackend (to run on a CD) and now it needs to run on SQL. However, Iwant to be able to swap over between backends so that I can choosewhere this runs from. I've done this with the sole exception of onetable. Previously most of the data was held in one MDB file and a linkto another (one local copy and one on CD). My queries use the link toquery both local and the CD copy data together.I can re-write things if I need to, but I was curious about there beinga way of doing this. What I want in effect is to query a view on SQL,but the data will be held in Access instead of on SQL.I suppose I can import as I need it as the data is purely read only. Idon't think this can be done, but wanted to check first. I can alwaysmove the remainder of the data over to SQL if needed. It's not a bigproblem, just something I'm curious about.Any pointers would be appreciated.Thanks in advanceRyanp.s. In case anyone wonders why I have taken this approach it isbecause we have a query tool and data that we send out to clients onCD. Some now want this web based, so I will publish the application ona Citrix server, and by changing a config file can swap within theapplication to point to SQL (by changing the ODBC settings). This way,I only need one copy of the application and can change backends as Ineed to.

View 2 Replies View Related

Linking Error

Mar 5, 2008

I am trying to compile a simple ODBC and C example on Windows XP SP2.I have Cygwin_NT 5.1.This is the code (obtained fromhttp://www.easysoft.com/developer/l...#dm_fns_drivers)i am attempting to compile.ODBCTest.c


Quote:

View 3 Replies View Related

About Linking Server

Oct 27, 2007

About linking server













Hi,
I am using sqlserver2005, when i make linked server connection between sqlserver2005 and oracle10g . It shows an error like that " Particular table doesnot exist or user doesn't have permission to connect ti this table"and below this one message is shown which is " Message 7314, line16".But i am giving it a proper "username/password ". In this linked server i am using Oracle10g new provider "ODAC101040.exe". so, please elaborate my such problem and also gives me the solution of this problem.
Thanx
regards
gautam

View 3 Replies View Related

Linking To Access Db

May 1, 2008

Hello,

Could someone please tell me (step by step as I am new!) how to establish a link from reporting services to an access database?

Thnaks,
RC

View 1 Replies View Related

Linking 2 Database

May 28, 2007

hi,

I have 2 databases from which my data will be coming from. How can I join this 2 databases in reporting services?



cherriesh

View 1 Replies View Related

Linking To Oracle

Sep 21, 2007

I need to query both Oracle and SQL Server tables for reporting and processing, ....no updates, insert or deletes.

Is creating a linked server the only way? My company does not want me to see the entire database.

Can you just link tables? Like Access or Excel does?

Any articles or links would be appreciated.

Thanks,

Mike


View 1 Replies View Related

Linking File In SQL

Nov 5, 2007

I want to link a file in the table, and want to open in the particuler programme, but the basic problem is by executing the T-SQL command this file open. Like creating the Hyperlink because I want to implement this command in my ASP project page.

Is the procedure is helpful for inserting, linking or opening the file in appropriate programme?

View 1 Replies View Related







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