Hi I am wondering if anyone knows of a way of synchroniseing two versions of a database one in access and one in sql server so they can both run in parrallel in ssis for updates etc.
Also can anyone recommend a book which is easy to use or resources as I can't find what I am looking for in the online help.
Thanks in advance
Dear All,
i have a question abt winCE 4.2 and SQL server CE.
i am using VB.net of Visual Studio 2005
My platform is using a PDA with winCE 4.2 and SQL server CE. The Host program is using dbf files on desktop side.
I got a problem of how to sync / read the sql CE data from a windows application.
so, i wanna ask,
1. any method to access the data from winCE data by windows application? or can i convert the sdf file to windows readable files? or any others?
2. Can i use a MDB to sync with SQL server CE?
can i synchronize the mobile device which has a SQL Server CE database with the Access database on the desktop?
last question,
3. is that windows CE .net 4.2 not support pocket access (cdb) anymore?
please help me out
I need detailed instructions on how to connect to a database from a Microsoft Access 2007 database to a Microsft Office Accounting 2007 database. The accounting database is an SQL 2005 datbase. It has an instance name of "MSSMLBIZ".
When I try I get an SQL error 53. Do not have permissions or database does not exist.
Thanks in advance for any help.,
MS Access database was one of the standard data connections in DTS. Excel is listed as a scourc/destination, but access is not. Question:
What is the best connection to use for MS-Access databases for output of data?
We generally process the ETL in SQL server then, export to Access database.
THANKS!!
Dave
Hello,
I need to create new MS Access databases on the fly from an ssis package, then add tables to these databases.
Any idea how I could do that?
Thanks
Dear Gurus,
I wanted to Synchronize the SQL Server (2005) Database to Ms-Access 2003. I want know how can I design the SSIS Package. Could anyone please advice me to design the package..?
Thanks
Krishna
I need to convert an access 2000 database to access 2013 and then load the data into a sql server 2012 database. Thus any urls (links) that will show me how to accomplish the following in an SSIS package:
1. Convert an access 2000 database to access 2013 database?
2. Load the converted Access 2013 database into sql server 2012?
We have been asked to look into using stored procedures with SQL Server 7.0 as a way to speed up a clients site. 99% of all the articles I have read along with all the books all say Stored Procedure should be used whenever possible as opposed to putting the SQL in your ASP script. However one of my colleagues has been speaking to Microsoft and they said that that they were surprised that our client wanted to use Stored Procedures as this was the old method of database access and that now he should really consider using COM objects for data access as itis much faster. Has anyone got any views on this or know of any good aticles regarding this matter ?
View 1 Replies View RelatedI have recently upgraded to SQL2014 on Win2012. The Access front end program works fine.
But, previously created Excel reports with built in MS Queries now fail with the above error for users with MS 2013. The queries still work for users still using MS 2007.
I also cannot create any new queries and get the same error message. If I log on as myself on the domain to another PC with 2007 installed it works fine, so I don't think it is anything to do with AD groups or permissions.
We have a SQL database that uses Active Directory with Windows Authentication. Can users that are members of the Active Directory group that has read/write access to the SQL database create ODBC connections to access the database directly and update the data? They dont have individual logins on the server. They are only members of the Active Directory group that has a login?
View 1 Replies View RelatedI'am doing functionality test on DTS packages and saving my DTS packages to meta data services instead of saving them as local packages. We would like to see what information would be provided by saving them this way, but when we try to open the meta data browser (the 3rd icon under DTS) we get the following error:
An error occurred while trying to access the database information. The msdb database could not be opened.
I've used the ADS sample program and it works well. I looked at the code and changed it to VB (sorry, I'm not biligual yet), and have tried to 'adjust' it so I can connect to a remote PC (XP running IIS) instead of the local PC using the workgroup information database (system.mdw). Any ideas of the connection string that could make the connection?..my intention is to RDA once a week between a mobile device (3g/gsm) and a 'poor man's' IIS web server.
I've tried everything I can think of, and I'm sure its possible since all I'm doing is changing the connection path.
Hello,
I have a quick question regarding getting data from a SQL database but I am slightly confused as to the best way to handle it.
Basically on of the projects I am working on I need to send data to another company, there are several calls required to the database to bring back various options for changing the questions asked on the front end.
Up to now all that has happened is there has been a mutual agreement between myself and this other company and they have just had access to the database to call a series of stored procs which I have written for them to access the data. Recently however the situation has changed and my client wants me stop them accessing the database however they still need to recieve the information from the database they recieve now.
What will be the best way to handle this? My knowledge of SQL is farily limited presently and I am only ust getting into learning a lot more about it.
Any help and advice would be greatly appreciated.
Kind regards,
Lee
I have MS-Access as data source for one of the reports. I can preview the report fine from BI studio however, it does not work when I deploy it on report server.
The error is :
An error has occurred during report processing.
Cannot create a connection to data source '<data source name>'.
The Microsoft Jet database engine cannot open the file '<UNC location of the MS-Access database>'. It is already opened exclusively by another user, or you need permission to view its data.
MS-Access database is located on a different server.
Any help to solve this? I understand it has something to do with permission both on server where reporting service is running as well as the server where MS-access database is located. Pls help.
Hi.
I have a stored procedurein my database and I want to access table in other server. can I do that in Stored procedure?
Hi, i want to know, is it possible to access a database that is not on the local machine ?what if i want to access a databse that resides on another of my websites (on a different server) ?can any one help ?
View 1 Replies View RelatedWhen I open a new table in Access trough the ODBC database, it doesn't read the tables already exist.
The ODBC is rightly configured. I configured my client in Control Panel, but I can't convert in Access the tables in SQL.
Hi guys,
I've been assigned the task of setting up access to our SQL Server 2005 box. A consultant developing for us has accessing to 2 databases and I've set this up fine. It appears however that one of these databases is re-copied over to the server every night to keep data reasonably current.
I'm not interesting in changing this method as I'm not the maintainer (as yet).
Basically I would like to know if I've setup access to this database (it works fine), when the database is updated (with an SSIS package) the account seems to get deleted. Do the original permissions from the source database overwrite those of its destination?
Cheers
I would like to start using SQL, how would I convert my data in MS Access over to an SQL Server Database?
View 2 Replies View RelatedI got thrown into a new project that is going to require me to update an SQL server database tables from an Access table on the backend of an Oracle database on another server. At the end of each day the Access dabase will be updated from the Oracle database.
What I need to do, is when the Access database is updated I need to have the table in the SQL database automaticaly updated. When a new record is added to the Access table I need the new record added to the SQL table. When a record is deleted in the Access table I need to keep that record in the SQL table and set a field to a value (such as 0). And when a record is updated in Access, have it updated in SQL.
Needless to say this is a bit out of my area and not sure how to accomplish this.
Any help is greatly appreciated.
Hi,
i am working with windows mobile Cf 2.0 and desktop. i got problem when i were trying to synd mobile database and ms-access database.
my requirement is online i want to transfar data records from mobile to desktop vice versa.
but how? i dont knwo any body would like to guide me.
i am ready to accepting yours valuable views.
waiting
bye
Rajat.
Hi,
When I try to access the database diagrams in AdventureWorks, I get the following message:
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.
------------------------------
BUTTONS:
OK
------------------------------
Why is this?
All advice / help apprecuated.
Thanks
I was checking this site:
http://www.aspfree.com/c/a/Microsoft-Access/Configuring-a-Linked-Microsoft-Access-Server-on-SQL-2005-Server/
and I do not know what parameters are neeed to do the following two.
Configuring a Linked Microsoft Access Server on SQL 2005 Server - Linked Servers on SQL 2005 Server
I would also like to know how to do it through this method as well.
Configuring a Linked Microsoft Access Server on SQL 2005 Server - Using the Management Studio to set up a Linked Server Sorry for the large typing I was using cut and paste to make sure I had everything correct.
Thank you
Dee
I have a sql server database and i need to convert to Access, how can i do this using sql server?
View 4 Replies View RelatedHi,
We are planning to migrate data from access to sqlserver. I have good knowledge on sql server...but never used access to migrate. Can anyone help me with the basics to be kept in mind and methods and errors you get in migrateing data.If possible explain in detail and what is to be done while migrating data.....thank you in advance.And its urgent please.
Hi,
Can anyone please tell me how to access a SQL server database remotely. I have
the IP address and login info. of the NT machine that is running SQL server
database, and I want to access the data remotely.
Thanks for any help.
Chetan
Hello,
Is it possible to configure the web server to execute XML queries without installing SQL Client?
Thanks
Sejal
Hello SQL guys,
If possible to connect our remote server from my end ?.what r the possiblities is there.tell me some ideas,i already tried it to register our remote server database thru ODBC but it not connected properly but i ve tried in our intranet/network it's working fine.
Nellai
HELLO,
We are specializing on Migrating, Replicating, Synchronizing data and databases on Windows, Windows NT, Unix, AS/400 and legacy.
We deliver our software to migrate any data to MS SQL Server.
We are specialized to deliver DataMarts for any databases with :
a novative script and visual language VEXScript that you can play with W95, W98, WNT stand alone or with your prefered query tools or PC language
Independant database software vendors
Compatible XML (Q1 99)
Messaging interface ( MS Exchange, Lotus, Mapi, ......)
If you want visit our web site on www.dataexchanger.com and e-mail us to marketing@dataexchanger.com if you want ask us.
We will be pleased to enter in agreement with you.
Best Regards
Denis Schirra
Vice President Technical
CrossDataBase Technology
Decision support,Datawarehouse,DataExchange, DataSynchronization
Data Surfing is our mission
is it possible to convert an Access database to SQL Server 2005 or 2000?
View 3 Replies View RelatedHello!
I have a Java application that gains access to a SQL database using:
connection="jdbc:jtds:sqlserver://localhost:1433/databasename;user="+user+";password="+password;
//Load and register SQL Server driver
Class.forName("net.sourceforge.jtds.jdbc.Driver");
//Establish the connection
conn=DriverManager.getConnection(temp);
When I distribute this application throughout the local network, what would the jdbc url be for the application to find the SQL server?
Should I replace "localhost:1433" with something else?
The instance of SQL server is called SQLExpress.
I have my computer name, computer domain, ip address etc.
Is the port 1433 still the same?
How could the SQL database be located throughout the network?
Any advice appreciated.
I'm taking over an SQL Serverdatabase which is often updatedwith data from an Access database.Knowing little about either, thissimple task has become a challenge.I'm told that the previous personused to type some simple SQLcommands and this would updatethe SQL server database but thecommands have been lost and theprevious person is unavailable.The Access database has exactlythe same column names as the SQL-server databaseand it is something simplelike:Control ID Phone Name Address1 Address2Does anyone know the SQL commandsto do this kind of SQL server database update from theabove mentioned Access database?The previous person left an app which connectsthe two databases and leaves a placewhere the SQL commands are to be typed.ThanksTAK
View 2 Replies View RelatedI know how to access different tables on the same server by prefixingthe table with the database name. Is there anyway to prefix theserver name to link two tables across servers? Thanks.
View 2 Replies View Related