I know that SQL Server cost plenty to license for internet use...per year. But is there the same costs for MSDE and/or Access? I was recently told that every internet user would have to have a license to use a site that had Access as the database. I'm really not sure how true that is or if its MS support fobbing me off. Anyone know?
View 4 RepliesHi all,
does someone know an Internet Provider for MSDE database?
Regards
Leonid Pavlov
I need to access my SQL server from another domain across the internet. How can I do this? Everything I have tried has been unsuccessful.
Chris Walcott
Is it possible to connect an Access Project (.adp) to SQL Server 2K via the Internet?
I've installed the Office 2K SR-1 and the Access/SQL 2K Compatibility update.
I can connect to SQL 2K from any computer that is on the same subnet, but not outside of that . . . or through the Internet.
Can this be done?
Pls. respond directly or forward a copy of your response to this thread to me at flanders@mbay.net, if possible.
Thanks.
Pat
I need to develop an application in vb.net that uses sql server database so that user can access the use the application over the inter net.
How Can I accomplish that ?
What are the options ?
Pls Help..
I was wondering if any body has used Internet as a WAN (Wide AreaNetwork) to provide database access. I know about web services but Ilike to experiment with using Internet as a extended network (webserver behind one router and database behind another). Any ideas onwhere to look for this?Thanks
View 3 Replies View RelatedHi.I would like to access my database outside of my company. I read manydocuments but they are all pertaining to accessing the database viaASP or some form of web application. Is there no single windows orlinux application tht runs natively to access a remote SQL data base?Any advise is appreciated. Thanks!!
View 5 Replies View RelatedWe are trying to restict internet access from certin computers but, it's still in place because we need to process credit cards. Is it possible to remove internet access and allow our SQL based program to still run credit cards because of the ODBC connection to the SQL server which has internet access?
View 4 Replies View RelatedHow can I access my Microsoft SQL Server 2005 through internet?
For example, I set up a Microsoft SQL Server in one of computers of my company, and every computer in my company has its own IP .They are in the same workgroup. Now, there is no problem with database access with another computer in my company.
Can anyone tell my how to access it through a computer out of my company?
Thanks
How can I store my database on the internet and then access it's data (from a Visual Basic Express Windows Application)?
Where on my server do I upload it to?
How do I keep it secure?
Can anyone reccomend any good articles, etc, please?
Thank you for your help.
Sam
hi,
i am new to sql server reporting 2005. i can able to create reports and i can able to access in web pages. But my problem is, my reports and database are in one server, and my web server is differnet. we cant view the reports from internet. How can we slove this. any one can help?
Thanks in advance.
sns
Could someone point me to an article that shows how to configure SQLServer express so I can connect to it over the lan and Internet?
Thanks
I have report server setup on the same machine where the sql server 2005 db is setup, as well as iis running the website. i simply need to get report server running to allow internet access. I have report server setup so that it is running locally (localhost), however, as soon as I change the iis site settings to a domain name, report server stops working properly. This looks like a permissions issue, Ive tried different combinations of settings, but nothing works. Any insight on how I can get report server setup for internet access (forms authentication), would be much appreciated.
thanks, lance
I have set up an MSDE SQL Server in my Win XP Pro PC and am able to connect to it on the host PC, and over my LAN. However, when I try to connect to it over the Internet my connection is refused with the following message:SQL server does not exist or access denied. ConnectionOpen (Connect())Some background:I have router/NAT firewall and have opened port 1433 (I have even tried a DMZ to the SQL Server machine). The Router is definitely going to the SQL Server PC! I am fairly certain that the connection string is correct.Any help would be most gratefully received.
View 7 Replies View Relateddoes anybody know why MS doesnt consider Basic Authentication a viable solution for Inter/Xtra net access to RS? I'm re reading the documentation at http://msdn2.microsoft.com/en-us/library/bb283249.aspx but so far am not getting what the Security Extension options accomplish that can't be accomplished with much less effort using some form of Basic Authentication.
View 25 Replies View RelatedI need to make a website with lots of datatables, ans connections bettween them.
who's better? MSDE or access? WHY? WHYNOT?
...thanks
Hi,
I don't have Visual Studio, so I'm using web matrix and MSDE. My question is, how do I get to MSDE? I don't have the enterprise manager that comes with SQL Server. Thanks
amit
HiI am just starting my first .NET project using the web matrix and an MSDE database. I am pretty much at the limit of my knowledge - all very interesting. I have some data in an Access spreadsheet (6 columns and 365 rows) which in the past I have copied and pasted into an Access database table. How do I get it into a MSDE database table? This process does not need to be automated/programmed as I will only have to do it once a year. Any ideas on the easiest way forward would be much appreciated.Thanks in advance.Mike
View 2 Replies View RelatedHi i am upsizing a db from access to msde. I provide it a username and password.
But when i try to connect to the db in Visual Studio i get this error
"Login failed for user 'user': Reason. not assocaited with a trusted SQL Server Connection"Thanks
Hi,
I have a customer with Office 2000 and uses Access 2000. I normally use SQL/7, but for this job would it be save to use MSDE on the web site so the customer can upload and download the MSDE file for product information? I use SQL/7 for the backend. Please advise.
Duane
hi,
I have a database in MSDE. Now if I create a database in Access, is it possible to import the msde tables into Access. probably not right?
Thanks
Does anyone know if it is possible to replicate a database from MSDE to Access 2002??
View 3 Replies View RelatedHi all
I have MSDE installed on my machine to support off-line use of a web application.
The database (MDF) file in question is stored on an encrypted area of my hard drive, which must be unlocked each time the machine starts up by the user entering a password.
Unfortunately, by this time the SQL Server service has already started, and although it still lists the database along with master, etc, it cannot access it. I believe the error mentions that some files are unavailable.
Stopping and restarting SQL Server using Service Manager fixes this problem. However, this can only be done when logged in as Administrator. I need to find a solution for normal users without Admin privileges.
Is there any other way of making the now-unlocked MDF file available to SQL Server? I thought about using SQLDMO to Refresh databases, but no joy.
This is a real show stopper for my application, which I've spent three years developing! It goes without saying that I'm writing this message with a long face. If anybody has any suggestions I would be very happy to hear from you!
Best wishes
Rob
Hi everyone,In using the SQL Server Database Wizard in Access 2000 to create a newaccess project, I get two consecutive error messages and then the wizardshuts down. The first, which apprears immediately after starting the wizardis a message box stating something like "the property value is too large".After clicking through and filling out the values in the connection anddatabase dialog, I get a second dialog box with the message "Overflow" andthe wizard terminates.My operating system is Windows 2000 Professional with Access 2000 and MSDE2000.Does anyone have any thoughts about what might be causing these errors?Thanks in advance.
View 3 Replies View RelatedI want to move my Access 2K database into MSDE. The Access UpsizingWizard crashes (a known bug wi A2K), so I'm using the followingsuggested method:Access --> New --> Project (Existing Database)This asks for the name of the .adp file to create and then launchesinto the Data Link Properties dialog box (so far so good) I select myMSDE server from the drop-down, enter the sa account & passwd, attacha database file and try to select the .adp file that was just created.Unfortunately, the "Select SQL Server Database File" dialog is lookingfor an .MDF file, not an .ADP file.If I try to kludge it and select the .adp file anyway, the TestConnection produces an error:"Test connection failed because of an error in initializingprovider. The header file "D: est.adp" is not a valid database fileheader. The FILE SIZE property is incorrect."Any suggestions on how to proceed?Note:I've got Access 2000 SP1, Visual Studio.Net 2002, MSDE and SQL WebAdministrator running on XP Prof SP2.
View 3 Replies View Relatedhi,
I need to choose a database based on the following criteria (using .NET app):
1) a light but fully functional database, preferably with the support of store proc and constraints, less than 8000 transaction a day.
2) portable or the database can be export/import very easily
3) reliable and stable
4) least maintenance
I have two db in my mind, Access and MSDE?
Does anyone have some hand-ons experience on the above two? Or any other better suggestions?
Any advice is appreciated.
thanks,
bryan
I have an mircosoft access database, but now i want to attach it to MSDE, how can i do impliment this????
i already try to use the following commands
exec sp_attach_db 'example','c:example.mdb'
but i got the following error message
The header of this file 'c:example.mdb' is not a valid database file header. The FILE SIZE property is incorrect.
I have a named instance of MSDE running on my windows 2k3 web server. I can connect just fine using ODBC to that DB whailst I am on the server.
I would like to be able to create an ODBC connection from my local machine (running Windows XP pro) to the MSDE database on my server but I can't get it going.
I have heard that I need to edit the registry but a Google search warns that this could be a vulnerability...
How do I do it without compromising the security of my web server?
TIA
I have a large VB 6.0 application running with Jet 4.0 Access DB. I am considering moving the DB to MSDE. For testing, I installed MSDE on another computer in a peer to peer network running XP sp1, loaded up the DB from Access to MSDE2000A -- all without problem. (I should add the obvious fact I am new to using SQL server.)
What I find is that with a relatively small test DB, running just a single instance of the application, query response from MSDE is taking several seconds (4-5 second lag) longer than response from the Access DB, which runs extremely fast. This is with the Access DB installed on the same network drive, running the same application and the same queries syntax -- only changing configuration of connection for each (SQL vs Jet 4).
Any clues as to what may be going on? The lag time is unacceptable. I am using SQL password instead of NT security. It seems the process is perhaps lagging in the process of authorization.
Thanks for any suggestions or ideas on this.
Yes I have the dreaded "SQL Server does not exist or access denied." error
when trying to connect to an MSDE database. I've tried many solutions
found across the net. I installed the latest sp3a version of MSDE,
granted the ASPNET worker process access to my database, opened port
1433 in the Windows XP firewall. I'm running Windows XP SP2.
The funny thing is that I can successfully connect using an ODBC DSN connection (OdbcConnection). No problems at all.
This works.
<code>
Dim strDSNString As String = "DSN=mike"
Dim objConn As New OdbcConnection(strDSNString)
Dim objCmd As New OdbcCommand("select * from table1", objConn)
Dim objReader As OdbcDataReader
Try
objConn.Open()
objReader = objCmd.ExecuteReader
While objReader.Read
Response.Write(objReader("column1"))
End While
objConn.Close()
Catch
Response.Write("fail")
End Try
</code>
But no luck when I try an SqlConnection.
This does not work.
<code>
db_connection = New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
db_connection.Open()
</code>
The connectionString = Integrated Security=SSPI;Initial
Catalog=miketest;Data Source=localhost;Network
Library=dbmssocn;Trusted_Connection=True;
So, why does the OdbcConnection work but the SqlConnection does not??
Thank you.
Hi. I'm coming from a background of developing mdbs and am trying to migrateour databases to adps running atop MSDE 2000. However, I've encountered aproblem while trying to do analogous things to what I've done before withmdbs...for example:-Linking to a csv file on another machine: I am able to establish a linkuning the 'Link Table Wizard' that shows up as a new view. However, uponopenning the view I see only a single column (left-most).What am I missing here?James
View 1 Replies View RelatedHi all,
I'm getting this error message when I try to connect my MSDE database from other machine using enterprise manager application. Both of the machines are WinXP SP2. I found some solution such as using 'SQLServer Network Utility' but didn't work out for me. I even can not connect my database on my computer using TCP/IP. When I connect with name, it worked fine. I already enable both TCP/IP and Named pipe protocol on the MSDE machine.
If someone has solution on that please let me know.
Thanks,
Myo
I am running the MSDE 2000 Setup off the SQL Server 2000 Developer Edition CD.
After installation is complete, there is a service under the Control Panel -> Services window
called MSSQL$GregInstance. I then start that service.
But now when I try to connect to the database using
osql -E -S GregInstance
I get told that the SQL Server does not exist or access denied. Even though the server is running. I have also tried
osql -E -S localhost
but no luck. Why can it not find the instance of SQL Server?
Note : SQL Server 2000 is not installed on the machine, only this MSDE instance.
Thanks
Greg