CAL Question

If I have 3 programs on my desktop that connect to two
different SQL Server databases (two to 1 and 1 to the
other) , yeah! looks funny, I know.
How many SQL Server CAL's do I need? Are these server CALs
or Device CALs or does it matter?
If I am using all three programs at the same time does it
make a difference? I would appreciate any input or even
clarifications on my question.
Ta!
A CAL (user or device, there is no such thing as a server CAL) allows you to
access any SQL Servers in your organisation. You still need licenses for
every server on which you install SQL Server of course.
Jacco Schalkwijk
SQL Server MVP
"dr. Fil" <anonymous@.discussions.microsoft.com> wrote in message
news:6cf401c475c9$5a3ed500$a601280a@.phx.gbl...
> If I have 3 programs on my desktop that connect to two
> different SQL Server databases (two to 1 and 1 to the
> other) , yeah! looks funny, I know.
> How many SQL Server CAL's do I need? Are these server CALs
> or Device CALs or does it matter?
> If I am using all three programs at the same time does it
> make a difference? I would appreciate any input or even
> clarifications on my question.
> Ta!

c# against ms sql express - multi user access

I have developed two programs that operates against the same database. One of the program is just a display program that displayes the data put into the other administation program where you put in the data to be displayed (an administration program).

Every time I access the db from the administration program, the display program stops and throws connection pool errors and other database errors. For me, it looks like it does′t do multi-access to a database.

I have tried putting user instance to off in both programs, but this didn′t help.

Connection string also points to same file database.

It sounds like you're trying to attach the same database file to two different SQL instances. Turning User Instances off isn't enough if you still have the database sitting detached in your user profile directory. You will actually need to move the file into the Data directory, attach it to the parent instance of SQL Express and then use a standard connection string from each application to point to it rather than trying to attach it on the fly in each application.

Mike

|||

Yes, you are correct on that. Two applications, one database.

Move it to the MS SQL Server′s datadir is OK. Then, I just remove the "attached-db" attribute from the connection string and only use servername=sqlexpress/localhost, correct? Or is it more I need to do?

|||

I just can′t seen to get around the file-mess. When I use the connection wizard in VS, I only get the option to attach-db file, and it will not let me continue before I have selected that. But I want to use more normal connections using server name so that I can connect to db from both programs.

I have tried to manually edit the connection string it makes: Data Source=XP1\SQLEXPRESS;Integrated Security=True;Connect Timeout=30; Then I get "Invalid object name tablename" etc. I′m using table adapter, but it doesn′t give me connection warnings, strange enough.. Is it something I need to change in tableadapter after changing the connection string in settings?

|||Never mind.. forgot the initial catalog...|||-|||

Looks like you got things going, just wanted to check back to be sure things were working.

Mike

C with ODBC

I am into a new project where I have to write C programs on UNIX
connecting to SQLServer through ODBC. I am not able to find sample
programs to learn about APIs. Can anyone point out to documentation
containing ODBC APIs for C.
TIA.Hi
You may find something in
http://www.microsoft.com/downloads/results.aspx?productID=&freetext=odbc&DisplayLang=en
or
http://msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28001860
For the API check out
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbcsql/od_6_0crtap_8my6.asp?frame=true
John
"Ravi Krishna" <rkdba@.sympatico.ca> wrote in message
news:CnMFb.4703$d%1.1051172@.news20.bellglobal.com...
> I am into a new project where I have to write C programs on UNIX
> connecting to SQLServer through ODBC. I am not able to find sample
> programs to learn about APIs. Can anyone point out to documentation
> containing ODBC APIs for C.
> TIA.
>
>

C with ODBC

I am into a new project where I have to write C programs on UNIX
connecting to SQLServer through ODBC. I am not able to find sample
programs to learn about APIs. Can anyone point out to documentation
containing ODBC APIs for C.

TIA.Hi

You may find something in
http://www.microsoft.com/downloads/...&DisplayLang=en
or
http://msdn.microsoft.com/library/d...tentid=28001860

For the API check out
http://msdn.microsoft.com/library/d...asp?frame=true

John

"Ravi Krishna" <rkdba@.sympatico.ca> wrote in message
news:CnMFb.4703$d%1.1051172@.news20.bellglobal.com. ..
> I am into a new project where I have to write C programs on UNIX
> connecting to SQLServer through ODBC. I am not able to find sample
> programs to learn about APIs. Can anyone point out to documentation
> containing ODBC APIs for C.
> TIA.|||I'm not sure you can use ODBC from Unix. If it was me, I would use
Java and JDBC. (Caveat: Awhile back I heard Microsoft came out
with a JDBC driver for SQL Server, but I haven't heard anything about
how good or bad it is.)

On Mon, 22 Dec 2003 19:51:10 -0500, "Ravi Krishna"
<rkdba@.sympatico.ca> wrote:

>I am into a new project where I have to write C programs on UNIX
>connecting to SQLServer through ODBC. I am not able to find sample
>programs to learn about APIs. Can anyone point out to documentation
>containing ODBC APIs for C.
>TIA.|||Ellen K. (72322.enno.esspeeayem.1016@.compuserve.com) writes:
> I'm not sure you can use ODBC from Unix. If it was me, I would use
> Java and JDBC. (Caveat: Awhile back I heard Microsoft came out
> with a JDBC driver for SQL Server, but I haven't heard anything about
> how good or bad it is.)

Yes, you can use ODBC on Unix. See
http://www.sommarskog.se/mssqlperl/unix.html for a couple of products.
The page also include JDBC stuff.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Good to have a definitive answer. Thanks. :)

On Mon, 29 Dec 2003 23:02:43 +0000 (UTC), Erland Sommarskog
<sommar@.algonet.se> wrote:

>Ellen K. (72322.enno.esspeeayem.1016@.compuserve.com) writes:
>> I'm not sure you can use ODBC from Unix. If it was me, I would use
>> Java and JDBC. (Caveat: Awhile back I heard Microsoft came out
>> with a JDBC driver for SQL Server, but I haven't heard anything about
>> how good or bad it is.)
>>
>Yes, you can use ODBC on Unix. See
>http://www.sommarskog.se/mssqlperl/unix.html for a couple of products.
>The page also include JDBC stuff.

Business Intelligence Development Studio Doesn''t Open

To start Business Intelligence Development Studio, We need to go to the Start menu > Programs > Microsoft SQL Server 2005 > Business Intelligence Development Studio.

But when I go thru the procedure mentioned above, it gives me the following message. "Missing ShortCut, Windows is searching for devenv.exe. Please locate if u know the location".

What should I do with this. Please help Asap!!

Question did you install Reporting Services and Integration services? if no then make sure IIS is installed and rerun setup and choose repair make sure you have copied all the install files to your C drive before running the installer. If you find VS2005 installed after you install SQL Server then that is your BI Managment Studio.