Porting Access Database

Nov 21, 2006

I am still pursuing my studies. I have been recently assigned a project for building Database Application for my college's library. And there was no better option to implement it with VB.NET 2.0 & SQL Server 2005.
VB.NET 2005 & SQL Server Express 2005 are the resources at my disposal.

The problem is that the college already has a Library Management System in place, built in VB6.0 with Access. I have been asked to pepare the application from scratch. But the database obviously cannot be left out.

Now, can anyone suggest me an efficient way to port the Access database to SQL Server express. Also, the databse has been desinged poorly & is not properly normalized.
Can I port it to SQL Server Express with some slight modifications to its structure without any loss of data??????

View 8 Replies


ADVERTISEMENT

Porting An Access Db To SQL Server

Mar 6, 2004

I have a MS Access DB that needs to be moved to SQL Server. I have no clue how to do this or even what the issues and considerations are.

Can anyone provide a link to any resources where I can educate myself? Or offer any advice or "lessons learned".

I anticipate using the same Access DB as a front end since the forms are all set up as we like.

Thanks in advance

Don

View 5 Replies View Related

Porting Access To SQL Down The Line

Mar 17, 2004

I have started a new site using a CMS which can be either Access or MS SQL. For ease of install and cost factors the site is currently running as an Access dbase driven site. If traffic numbers and content grow and Access dbase blows out to, lets say 500meg will I see a major degradation in performance and will it be possible at a later data to somehow export the Access dbase data into MS SQL dbase format. I'm assuming I'd have to engage a fairly competent developer but before I get into the trap of growing a large site, I'd like confirmation that I'd be able to extract all of the data and get it into a more robust solution as and when required. phew!

View 8 Replies View Related

Porting An Existant Application From Ms Access To Sql Server

Jan 9, 2007

My database knowledge are with MySql and Oracle, but recently I was asked to evaluate the migration of an existing (and maybe more) from ms access to sql server. My question is simple, if all of the sql are hard coded into the code ... how well this sql will work, I mean is the sql between access and sql server are plug'n'play ? However in any case, I always rewiew all of the sql.

View 2 Replies View Related

Question About Porting Data Into A New Database.

Aug 2, 2007

We rewrote one of our legacy C#/asp.net applications that accesses a sql server 2000 database. The new database schema looks very similar to the old one. The major difference is that some of the atributes in the database tables are different. But pretty much we are using the same tables, plus or minus a few.
We need to import the old data into the new database. I have never had to undertake this type of thing before as I am not a DBA, but a developer. I feel a little scared about this whole process. My boss is open to us hiring a contractor to help with the process.
My biggest concern is the referential integrity of the database.
Can someone help me out. Does this sound like something that can be easily done or should I ask for some help.
Ralph

View 2 Replies View Related

Porting Database Object Changes From QA To Production

Mar 2, 2004

Can anyone help me in this issue:
How do we replicate database changes (like tables) from QA to production without losing Production data.
We already tried using the DTS export but it is dropping the destination tables before export which will result in data loss in the destination database.

View 3 Replies View Related

Porting Database Functions From WM 5 Pocket PC To WIN32

Apr 21, 2008

Hi all,

I'm working on porting a solution running under WM 5 Pocket PC to Win32 but I got some problems with type definitions like CEOID, CEGUID... I saw that these types are defined in windbase.h (EDB definition added to preprocessors) ) which includes types and definitions usefull for database managment. Anyway this header file is not present in C:Program FilesMicrosoft Platform SDK for Windows Server 2003 R2Include, so I was wondering which is the header file I can use instead of it. Thanks

View 5 Replies View Related

Porting Lab Question

Jul 15, 1998

Hello from Microsoft SQL Server 7.0 Porting Lab. Anyone have any 7.0 questions for the Microsoft people while I`m here?

View 1 Replies View Related

Porting From MSSQL 6.5 To 7

Nov 18, 1998

I's any problem with porting app. from 6.5 to 7?

The whole app is in MSSQL
& client made by ASP

Thanx

View 1 Replies View Related

Porting DTS Error - Urgent

Aug 15, 2000

Hey everyone - I get the following error when I try to open up a DTS package that I ported from one machine to another as a file. The error is:

Error Source: Microsoft Data Transformation Services (DTS) Package

Error Description: The parameter is incorrect.

Does anyone know what this error is and how to get the package to open? I really don't want to have to rewrite the package if I can avoid. Any help would be greatly appreciated.

View 1 Replies View Related

Porting From Oracle To SQL Server

Jul 23, 2005

Has any body done the porting from oracle to sql server, what were theissues in porting the data bases?Also suggest some resources which can be helpful in the porting projectTIAGolu

View 4 Replies View Related

Securing Databases From Porting

Jul 23, 2005

I have a situation where I have an app that uses a sql server (msde)database. The app will be used in environments where no one should beable to manipulate the data except the developers (app admins) - noteven site database admins. When the application and msde is installed,a default instance of the database gets attached to msde or built byscript. by default, a built in server acct and approle acct exist tosecure the data accordingly with passwords concealed. What can be doneto keep someone from copying the mdf and ldf files to another machinewhere they have admin rights and manipulating data?Thanks.

View 1 Replies View Related

More Questions About Porting From MySQL To MS SQL

Aug 2, 2006

1) In several tables, in my MySQL version, I created columns usingsomething like the following:`ab_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on updateCURRENT_TIMESTAMP,This allowed me to ensure that when a record is either added or edited,the value in the field is set to the current date and time. I.E.,ab_timestamp is given the current date and time when a record iscreated, and then it is updated to the date and time at which therecord is updated. I learned the hard way that MS SQL does not like"on update CURRENT_TIMESTAMP". So, it looks like MS SQL will allow meto initialize ab_timestamp to the current date and time, but notautomatically update it to the date and time at which the record isupdated. I have plenty of code to port that depends on the behavioursupported by MySQL. DO I have to modify all that code, or is there away to get MS SQL to provide it? (Yes, I know 'timestamp' isdeprecated in MS SQL and that I should use datetime instead, and infact have already done so.)2) I began with a single SQL script that creates all the tables, views,functions and triggers the database needs. On trying to get MS SQL toaccept it, I encountered a number of error messages saying that CREATEFUNCTION and CREATE VIEW need to be the first statement in a script.Why? I know I can work around this odd constraint by putting eachfunction and view (and IIRC trigger) into its own script, but thatseems like a make work effort imposed for some unknown reason by MSSQL, unless there is another way to get around it.3) I see, in the documentation for CREATE FUNCTION, functions are notallowed to use a timestamp for either a parameter or a return value.This is in reference to a pair of scalar functions I am using whichneed to manipulate date and time values. For the purpose ofclarification, is this documentation refering to all date/time datatypes, or only the deprecated timestamp type? As examples, considerone function that needs to return the most recent date in a date columnin a specific table, or another function that computes a date from adate and an offset (e.g. if called with the value returned by the firstfunction as the first argument and '-7' as the second, returns the dateof the day that is a week earlier than that date). These two functionsare frequently used in the SQL code I'm trying to port and I reallydon't want to complicate so many of those statements if I don't haveto.ThanksTed

View 2 Replies View Related

Porting Data To Another Sql Server

Jun 27, 2007

Hi,



Currently, I need to move the 2 database from a MSsql server to another new MSsql server.

How do I do it?

View 4 Replies View Related

Strange Error While Porting From Xp To 2003!

Mar 30, 2005

 hi,
     i got the application(from my first post) working in win2003. but this application was made in webmatrix, i.e it had only 2 files, the .aspx file and the web.config file. so i decided to convert this code to a vs.net web application project. i did that and got it working on my xp box.
i copied the app folder on 2003, made that folder as an app in iis 6 of win 2003 and tried to run it, and got the following error:-  
 
Server Error in '/emrtd' Application.


Cannot open database requested in login 'ASPState'. Login fails. Login failed for user 'HPSISandeshD'.
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 database requested in login 'ASPState'. Login fails. Login failed for user 'HPSISandeshD'.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. Stack Trace:



[SqlException: Cannot open database requested in login 'ASPState'. Login fails.
Login failed for user 'HPSISandeshD'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Web.SessionState.SqlStateConnection..ctor(String sqlconnectionstring) +92

[HttpException (0x80004005): Unable to connect to SQL Server session database.]
System.Web.SessionState.SqlStateConnection..ctor(String sqlconnectionstring) +191
System.Web.SessionState.SqlStateClientManager.GetConnection(Boolean& usePooling) +98
System.Web.SessionState.SqlStateClientManager.SetAsyncWorker(String id, SessionStateItem item, Byte[] buf, Int32 length, Boolean inStorage) +44
System.Web.SessionState.SqlStateClientManager.System.Web.SessionState.IStateClientManager.Set(String id, SessionStateItem item, Boolean inStorage) +147
System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs) +465
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87



Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032
 
 
please help on this, why is this happening?

View 2 Replies View Related

Configuration File For Porting From One Environment To Another

Oct 2, 2007



Hi,

I'm using connection managers for all the connections i have in my packages in one project. However, if i change from one environment to another, i have to go to each connection manager in each package just to set the connection.

is there a faster way to change them like a configuration file lookup or something?

cherriesh

View 4 Replies View Related

Database Access Via COM Objects - V- Database Access Via Stored Procedures

Aug 17, 2000

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 Related

Problem During Data Porting Using Linked Server

Feb 4, 2005

Hi All,

I have problems while using the Linked Server in MS SQL Server 2000 for data porting.

The Scenario :

I have about 900 hundred tables created in SQL Server database. These tables are freshly created and has no records.

I have created a Linked Server with a DSN connecting to a Sybase database from which the data has to be ported to the newly created tables in SQL Server.

The database creation as well as data porting is done by a Delphi application by executing the scripts in several .sql files.

I have shown an example script below which does the data porting.

INSERT INTO TEST_DATA (COL1,COL2,COL3)
SELECT COL1,COL2,COL3 FROM [LINK_SYBASEDB]..[DBA].[TEST_DATA]


The Issue :

I often get the below error which stops the data porting process ( the error is logged in the Errorlog by the Delphi application )


D:DBPortTEST_DATA.SQL
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed]


NOTE : This error is NOT COMING CONSISTENTLY.Often I get this error and sometimes all the data is ported without this error.

It will be great if any of you can help me to resolve this issue.

Thanks in advance !!!

regards,

Hari Haran Arulmozhi

View 1 Replies View Related

Questions About Keys - Porting Code From MySQL To MS-SQL

Aug 2, 2006

Understand, I have developed a number of applications using RDBMS,including MySQL, PostgreSQL and MS Access, but this is my firstexperience with MS SQL. I'd bet my bottom dollar that MS SQL supportswhat I need, but I just haven't found where it is explained in anydetail in the documentation I have. The pages I have found strike meas a little too terse for my needs.In MySQL, I used statements like:PRIMARY KEY (`ic_contact_id`),KEY `ic_planner_id_k_tmp` (`ic_rep_code`)at the end of the SQL statement that creates a table. The primary keyhad to be unique but the other did not. Defining the non-unique keypaid huge dividends in the performance of certain queries, sometimesleading to orders of magnitude improvement compared to when the KEY wasnot defined (a few seconds vs tens of minutes). In joins, these keysrelate to primary keys in other tables that function as lookup tables.Otherwise, their primary role is for aggregation functions (max, min,&c.) in relation to group by clauses. The performance improvementsfrom having the KEYs defined are greatest in the latter.I have learned the hard way that MS SQL seems to like my primary keyclauses but not my KEY clauses. I don't know, and at present don'tcare, if this is because MySQL supports my KEYs as an extension to thestandard, or if it is a matter of the two RDBMS interpreting thestandard differently, or something else. What I need to know right nowis how do I obtain in MS SQL the same benefit as the MySQL KEY providedto me.A second question is that, in studying the documentation for the createtable statement, I saw reference to clustered vs non-clustered keys (atleast I assume they relate to keys since they immediately follow, andare indented from, the primary key and unique keywords). What exactlyis clustered and why? BTW, my primary understanding of "clustering"derives from work with numerical taxonomy and biogeography, but I'dwager that is something completely different from any clustering donein an RDBMS.I'll appreciate any clarification you can provide.Thanks,Ted

View 4 Replies View Related

Trouble Porting A Trivially Simple Function - With Declared Variables

Aug 4, 2006

Here is one such function:CREATE FUNCTION my_max_market_date () RETURNS datetimeBEGINDECLARE @mmmd AS datetime;SELECT max(h_market_date) INTO @mmmd FROM holdings_tmp;RETURN @mmmd;ENDOne change I had to make, relative to what I had working in MySQL, wasto insert 'AS' between my variable and its type. Without 'AS', MS SQLinsisted in telling me that datetime is not valid for a cursor; and Iam not using a cursor here. The purpose of this function is tosimplify a number of SQL statements that depend on obtaining the mostrecent datetime value in column h_market_date in the holdings_tmptable.The present problem is that MS SQL doesn't seem to want to allow me toplace that value in my variable '@mmmd'. I could do this easily inMySQL. Why is MS SQL giving me grief over something that should be sosimple. I have not yet found anything in the documentation for SELECTthat could explain what's wrong here. :-(Any ideas?ThanksTed

View 6 Replies View Related

Data Access :: Server Rejected The Connection - Access To Selected Database Has Been Denied

Jun 10, 2015

I 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.

View 6 Replies View Related

Database Schemas And This Statement Has Attempted To Access Data Whose Access Is Restricted By The Assembly.

Jul 14, 2005

Hello.

View 5 Replies View Related

How To: Determine If Current Windows User Has Login Access, Database Access And If They Are A Member Of A Specific DB Role.

Mar 25, 2008


I need to determine the following about the current authenticated Windows domain user who is trying to access a SQL Server via a trusted connection.

1 Has the current user been granted login access to the trusted SQL Server?

2 Has the current user been granted access to a specific database?

3 Is the current user a member of a specific database role such as (DB_ROLE_ADMINISTRATORS)?

Thanks,
Sean

View 6 Replies View Related

Cannot Get Access To My Access 2003 Database Tables

Feb 5, 2007

I developed a database with Access 2003 and everything was working good until my tech came in and reformated my hard drive and install a new Ghost image that met our company standards.

Now I cannot go in and make any changes to any of the tables, queries and forms. All of this started when a new Ghost image was installed on my pc.

The message I get when I try to open my database is "You do not have permission to run "tblSwitchboard." I get the same error message when I try to do anything at all on the database.

I am at a loss as to what to do. Please help.



View 1 Replies View Related

Database Create ODBC Connections To Access Database Directly And Update Data?

Sep 10, 2012

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 Related

Question: Can I Synchronize The Mobile Device Which Has A SQL Server CE Database With The Access Database On The Desktop?

Sep 26, 2006

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

View 1 Replies View Related

ODBC Connection From Access 2007 Database To SQL Server 2005 Database

Feb 29, 2008

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.,

View 1 Replies View Related

An Error Occurred While Trying To Access The Database Information. The Msdb Database Could Not Be Opened.

Jun 21, 2007

I'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.

View 3 Replies View Related

Porting VB 6 Data Controls To Use SqlDatasource Controls - Please Help!!!!

May 9, 2007

Hi,  I am porting a massive VB6 project to ASP.net 2005.  Most of the code is fine, however because the original developers used lots of data controls and my own time restrictions I thought to replicate the functionality by using Sqldatasource controls instead. 
 These data controls are bound to DBtruegrids.   The project has has lots of code like...
 AdodcOrders.Recordset.RecordCount > 0 or  If AdodcOrders.Recordset.EOF  or  AdodcOrders.Recordset.MoveNext()  or
AdodcDetail.Recordset!FieldName
The problem is the sqldatasource control doesn't have a recordset/dataset property which I can access and manipulate, or does it?  What should I do to get round these?  The project has thousands of lines like this in so its not feasible to rewrite it (although if I could I would!).
 Any suggestions please gratefully appreciated.
many thanks
mike

View 1 Replies View Related

SSIS Synchroniseing Of A Access Database && Sql Server Database So They Both Run In Parrallel

Apr 19, 2008

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

View 4 Replies View Related

Could The ADS Access Database Sychronizer Wizard Accomodate A Remote Database?

Jan 4, 2008



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.

View 1 Replies View Related

Best Way To Return Data From SQL Database, Without Giving Access To Database

May 8, 2008

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

View 5 Replies View Related

The Microsoft Jet Database Engine Cannot Open MS-Access Database

Aug 18, 2007


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.

View 2 Replies View Related







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