FP and MS SQL connection strring

[BZM]

Please help me.
I am not sure where to put the MS SQL connection string in the page coding
so the links will follow it to the clients server. Do I use the
insert/database/results wizard?
I tried, got an error: unable to connect...
thanks.

 

[David Berry]

In the Database Results Wizard did you choose Connect to an External
Database, then choose SQL Server, the server and database name and the user
name and password? When you do FP creates the connection string for you.

If you really want to enter your own connection string go to Tools, Site
Settings, Database. Click Add then Check "Custom Definition" then click
Advanced and you can enter it there.

 

[BZM]

Thank you for your quick reply.

I took the custom definition route, no go. for the connection string I
first put the ip address/port #, then tried the url for the server:
http://server1.indbkyequip.com/Inventory

also tried changing the cursor to server from client
nothing works,
page cannot be found error
I republished and refreshed page before viewing

 

[David Berry]

Are you sure you're using the correct connection string? Did you get it
from your web host? The connection string is located in the global.asa file
that gets created in your root folder. You can open that with Notepad and
change the connection string just becareful what you change in that file.

Also, do you have SQL Server Enterprise Manager? If you do you can test
your connection string there. If not, go to
http://www.standardreporting.net/1ClickDBPro/Connect.asp?datasource=sqlserver

1ClickDB is a product you can buy to connect to a database but they have a
live demo (URL Above) that you can use to connect to your database to see
how the program works. If you can't connect from their site then the
connection string is wrong.

 

[BZM]

Thank you David.

Are you sure you're using the correct connection string? >>> I think so
Did you get it from your web host? >>>Yes, and I modified it with their help for my clients info.

I found the global.asa in my clients web file. I tried adding the
connectoin string from my hosting co, no go.

I'm lost.