473,503 Members | 1,647 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

transferring?/

13 New Member
hi all,
i have been using MS Access for my database. and designing pages in asp.net also. I am using the OLEDB connection, but i have everywhere read that using SQL is best. I have got installed my SQL Server 2005. BUt don't know how to proceed. Do I have to make my database in SQL all over again?? or can it be transferred?
actually im a bit confused also, I have the SQL Server installed, so where should i write my database?? kindly help?
Nov 14 '06 #1
2 1364
NeoPa
32,557 Recognized Expert Moderator MVP
I would not personally recommend using SQL Server unless you are (very) experienced in either Microsoft back-end software or other back-end SQL servers.
The level of help you will need is more than I would expect you can find here.
When I say 'using' SQL Server, let me clarify - I mean maintain or look after. Using one maintained by your IT department is fine.

As for your question, unless you have experience working in MSSQL itself, I suggest you set up your tables and link to them remotely using an ODBC connection (linked tables etc).

Trying to maintain a MS SQL server is certainly not for the faint-hearted.
Nov 14 '06 #2
MMcCarthy
14,534 Recognized Expert Moderator MVP
I would not personally recommend using SQL Server unless you are (very) experienced in either Microsoft back-end software or other back-end SQL servers.
The level of help you will need is more than I would expect you can find here.
When I say 'using' SQL Server, let me clarify - I mean maintain or look after. Using one maintained by your IT department is fine.

As for your question, unless you have experience working in MSSQL itself, I suggest you set up your tables and link to them remotely using an ODBC connection (linked tables etc).

Trying to maintain a MS SQL server is certainly not for the faint-hearted.
You should know.

I must admit I have Microsofts free version but I only use it for customer dumped sql files when I have to work on enhancing and troubleshooting their frontends.
Nov 15 '06 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
1903
by: Abby | last post by:
I have an application that is written in php/mysql on a Linux platform and need to transfer hosts. This is a session based application and I don't know a lot about php/Linux/mysql, but can get by....
1
1599
by: r_burgess | last post by:
I am looking for some guidance on transferring data between two pages in my ASP.net Web app (intranet). I have a form that will have a button and a text box on it (among other controls of course)...
3
1801
by: phong.lee | last post by:
Hello all, i'm new at this. I need some assistant in transferring data from excel to access. I created a macro that basically gather all the necessary data that i need to bring into access. I...
2
1118
by: vamsikrishna_b | last post by:
Hello all,the following problem i encountered while transferring data(mail ids) from MS-outlook to one application.Some mail ids after came into the application looked as strange characters.Eg are...
24
2240
by: Joseph Geretz | last post by:
Up to this point, our application has been using Windows File Sharing to transfer files to and from our application document repository. This approach does not lend itself toward a secure...
1
4141
by: Michael Fitzpatrick | last post by:
Transferring arrays from C DLL's to VB.Net I have a DLL written in C. This DLL reads a text file and creates a several very large arrays, 500,000 points and even larger. I would like the get the...
1
1097
by: vikram | last post by:
What is the best way of transferring values from one aspx page to another when user click a button, except response.redirect and server.transfer.
2
1535
by: Rani | last post by:
hi guys I don't know if this is the right place for it but I created 2 pages in page one there is a text box in which the user enters his name, in page 2 there is a the same text box. I would...
15
5060
by: http://www.visual-basic-data-mining.net/forum | last post by:
Does anyone have any idea how to transferring data from TextBox1 in form1 to textBox2 in form2..... That means after i fill in any data in textBox1 and click Next button... It will bring me to...
1
2056
by: Asaf | last post by:
Hi, I am developing a windows forms client application that will send a large XML data to a web server using Web Services. I saw this article http://www.codeproject.com/soap/MTOMWebServices.asp...
0
7070
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
1
6976
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5566
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4666
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3160
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3148
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1495
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
729
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
372
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.