
September 5th, 2003, 07:50 PM
|
|
Contributing User
|
|
Join Date: Jul 2003
Posts: 139
Time spent in forums: 1 Day 2 h 59 m 50 sec
Reputation Power: 5
|
|
|
MSDE question
I am just learning about MSDE so I apologize in advance if my terminology is not accurate in regards to my questions.
I've installed MSDE on my local PC (Win2000PRO) and want to build a database that I can upload to a remote web server and run it under SQL Server. If I understand correctly, this is completely compatible.
I can get the SQL Server Service Manager started on my PC and when I go to create the .adp file, I am presented with the SQL Server Database Wizard.
I see that I need to enter the remote server name, login ID and password. The setup information should be for the specific directory on the web server where the SQL Server databases are stored, is that correct? Is there a tutorial online or article that walks through the process of uploading the database to the remote web server? The information I have just shows how to set up the db locally on my PC.
Am I able to still use a DSN-less connection string with MSDE instead of Jet?
Hope that makes sense. Any help is appreciated. Thanks in advance.
-Dman100-
|