Open project from SQL Server without DSN / ODBC

[ammar_fake]

Hi!
I need to open projects stored in "SQL Server" but the users should be
able to do that without having to create DSNs in ODBC. Is there a way I
can use VBA FileOpen command to access the SQL Server directly?

And another question: does MS Project come with SQL Server CAL or I
need to purchase a CAL for each user/device?

TIA

P.S. Vielleicht kann auch jemand aus deutsche Community helfen?

 

[Ed Morrison]

Are you using Project Server? If so, you do not need to create a dsn on the
client. You do need to create a Project Server Account in Project Pro to
connect to the server.

Use the prefix "<>\" to open an enterprise project using VBA with the
fileopen command.

You should call your Microsoft rep to get the official answer on the SQL
CAL's instead of our opinion.

 

[PeterNZ]

Sorry to jump in here, but I had the same issue. Can you please tell me how
to connect to the MSPS? What MSPS gets called if I use just "<>/"? The
default one? What if I want to call a different one? Or don't have a Default
one set up because I use the MS Project Object Model directly in a components
on the MSPS?

Cheers

Peter

PS: @[email protected] - Bin zwar nicht in der Deutschen MS Project
Developer community, trotzdem Hallo von einem Deutschen in Neuseeland.

 

[Ed Morrison]

If you are already connected to an enterprise account, you can use the VBA
command FileOpen("<>\Test.published").

If you are looking to automate the connection to a project server account,
you can use a command line or shell app to open Project Pro. The format is
winproj.exe /s serverurl /u projectuser /P password
where serverurl is the project server url (ex
http://myserver/projectserver). You only need projectuser and password if
you are trying to connect using a Project Authenticated User. Otherwise,
make sure the user that is running your app has the correct permissions.

--
Ed Morrison
msProjectExperts
"We wrote the books on Project Server"
http://www.msprojectexperts.com
FAQ - http://www.projectserverexperts.com

 

[PeterNZ]

Cool! Thanks for this.

Cheers

Peter

If you are already connected to an enterprise account, you can use the VBA
command FileOpen("<>\Test.published").

If you are looking to automate the connection to a project server account,
you can use a command line or shell app to open Project Pro. The format is
winproj.exe /s serverurl /u projectuser /P password
where serverurl is the project server url (ex
http://myserver/projectserver). You only need projectuser and password if
you are trying to connect using a Project Authenticated User. Otherwise,
make sure the user that is running your app has the correct permissions.

--
Ed Morrison
msProjectExperts
"We wrote the books on Project Server"
http://www.msprojectexperts.com
FAQ - http://www.projectserverexperts.com

 

[ammar_fake]

What is the enterprise account you're talking about? I'm talking about
"MS Project" and "SQL Server". So no "MS Project Server". Is it
possible you're talking about Project Server?

 

[Ed Morrison]

Yes, I am talking about Project Server. If you are using Project Pro
clients, you may consider using Project Server, even if it is only as a data
repository. You'll get a lot of advantages over simply saving project plans
into SQL.

 

[Marcel]

this is how you would do it with an ODBC connection

WINPROJ.EXE
"<TheNameofTheODBCConnection;uid=theusername;pwd=thepassword>\theProjectname"

so if the ODBC connection is called Projects and the SQL server username is
sa and the password is qwerty and the project plan you wanted to open is
called CoolProject, the shell connection would look like:

WINPROJ.EXE "<Projects;uid=sa;pwd=qwerty>\CoolProject"

regards

Marcel