publish grid w/ different connection string from Project Named AlphaDAO connection

[KYBiggs]

How do you publish another grid with a different connection string from the Named AlphaDAO connection string in the project?

Error opening Grid table/view: Internal Error - Can't find named connection
'sqlSDSv4' - while converting named connection to connection string

This worked fine when I did live preview.

my connection string for grid is
{A5API='SQLServer',A5DBVersion=2008,Server='(local)',A5ANSINullPadWarn=Default,Trusted_connection=yes,Database='SDSv4'}

my project profile was created using Named AlphaDAO connection strings
{A5API=Access,FileName='C:\Local\CMA2010.mdb',UserName='Admin'}

How do you publish another grid with a different connection string from the Named AlphaDAO connection string in the project?

[iRadiate]

In the Query (alphaDAO), under Connection Type, you can choose specify connection string rather than Named Connection.
Your error states it cannot find sqlSDSv4 whereas your connection string lists just SDSv4. Is that a typo perhaps?

Stephen

[KYBiggs]

Thanks for the reply

sqlSDSv4 is the named connection string :{A5API='SQLServer',A5DBVersion=2008,Server='(local)',A5ANSINullPadWarn=Default,Trusted_connection=yes,Database='SDSv4'}

My project profile started with ALphaDAO on the name Connection String CMA which is an MS Access database.
SDSv4 is SQL Server 2008

Can you use both MS Access and SQL Server in the same Project Profile?

[iRadiate]

Sorry Ken, I misunderstood.
I just did a quick test and added a Northwinds Access table as a grid to my SQL project and it seems to work fine.
At least when published to localhost.

Stephen

[KYBiggs]

I appreciate that.

I went back and republished again.
I saw this from Frankbicknell

http://msgboard.alphasoftware.com/al...when-published

I followed this:
Re: connection not being stored in projects.settings file when published

" I had trouble with this for a long time. This works for me every time.

In your Web Project Profiles
Open Named Alpha DAO Connection Strings
Select the connection string then click edit connection string
Select Build Connection string
Re-build the connection string then save.
Publish your project
Stop and restart the server. "